What are the responsibilities and job description for the Data Engineer position at MPOWERHealth?
Overview
Role and Responsibilities
The Data Engineer will focus on loading data from various sources into the Data Lake and/or Data Warehouse as well as building and maintaining data pipelines.
Responsibilities
PRIMARY DUTIES
- Profile and analyze data from multiple sources and data types
- Build ETL/ELT pipelines to ingest and load data
- Maintain and monitor data pipelines and schedules
- Triage and troubleshoot data quality issues and implement corrective actions
- Build and maintain data transformations
- Build and standardize reporting objects, data, and logic at the database layer
- Follow best practices for development, QA, deployment, source code management
- Ensure proper documentation is maintained, and provide walk-through of definitions and metrics
- Coordinate closely with other developers to streamline processes and optimize
- Gain strong knowledge of underlying data and business rules, and assist other teams
- Adopt agile methodology, and assist in tracking and communicating progress of deliverables
- Identify improvement opportunities (proactive and reactive)
- Build and maintain strong relationships with business and IT users, both, onshore and offshore
Qualifications
Minimum Qualifications and Requirements
- 4 years working as a data engineer or data analyst
- 4 years working with SQL Server or other relational databases, building data pipelines using ETL tools like ADF, Airbyte, Informatica, etc.
- 4 years building objects in a SQL database, including tables, stored procedures, and views
- Expertise in SQL and data analysis
- Experience with Healthcare or Financial data preferred
- Strong ability to quickly understand data relationships and analyze
- Demonstrated ability in meeting deadlines and communicating progress across projects
- Ability to coordinate and collaborate with other team members and business owners
- Excellent communication, organization and time management skills
- Bachelor’s degree or higher
Preferred Experience
- Exposure to cloud data systems (Snowflake) and modern ELT tools (DBT) preferred
