Job Summary
We are seeking a skilled Data Engineer to join our dynamic team. Responsible for maintenance of Data Warehouse and ETL processes. Handles routine tasks associated with ensuring data in the Data warehouse is current, complete and accurate. Works closely with data analysts to identify and collect data required to support operational and strategic initiatives. Makes sure data is consistently accessible to users and in the desired format.
Duties
- Creates and maintains data dictionary and data model for the Data Warehouse.
- Designs, develops, and supports ETL mappings and workflows for loading data into the Data Warehouse.
- Performs data quality and validation checks on a daily basis to ensure the Data Warehouse is being updated properly.
- Identifies, reports and corrects any data quality issues found in transactional databases or the Data Warehouse.
- Tunes databases, ETL workflows and queries using proven database optimization techniques.
- Supports, monitors, tests and troubleshoots hardware and software pertaining to the Data Warehouse and Business Intelligence applications.
- Collaborates with stakeholders on new data requirements.
- Researches and understands new sources of data and determines how to integrate in the Data Warehouse.
- Works with Application Developers and Business Analysts to assist with data requests, troubleshoot queries and optimize their processes.
- Enforces company information security initiatives. Reports unauthorized data usage and security problems.
- Ensures that access to databases or its components is granted only to authorized personnel and that access logs are maintained and reviewed.
- Performs all other duties as assigned.
Qualifications
- Bachelor’s degree in Computer Science or related field from an accredited college or other approved educational institution preferred.
- Five years minimum related experience and/or training or equivalent combination of education and experience in data warehousing or data engineering.
- Must have excellent organizational and planning skills, complex problem solving skills, solid analytical skills, and strong communication skills.
- Must be able to sit, stand, lift, carry weight, kneel, bend, and grip tools during a full 8-hour shift.
- Must be able to work all shifts, and weekends/holidays as required. Must be able to communicate effectively in English, both verbally and through written communications.
Job Type: Full-time
Pay: $82,684.48 - $99,577.02 per year
Ability to Commute:
- Bensalem, PA 19020 (Required)
Ability to Relocate:
- Bensalem, PA 19020: Relocate before starting work (Required)
Work Location: In person
