Data Engineer Senior

Job Summary

Data Engineers work collaboratively with architects, business intelligence developers, data analysts and data scientists to build and maintain analytic solutions utilizing both traditional on-premisises and cloud-based platforms. The Senior Data Engineer is an experienced data pipeline builder and data wrangler with an aptitude for identifying nuances and patterns within complex datasets with the goal of transforming raw data into timely, reliable data sets. This role is responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection to support business needs.

Essential Functions

• Develops, tests, and deploys ELT / ETL processes across multiple sources, targets and tools with no supervision.
• Provides support and recommendations to intermediary level engineers to enhance their technical skills.
• Collaborates with data consumers of varying skill levels on available data sources and potential biases within datasets.
• Provides operational and ad-hoc support for systems and applications troubleshooting and maintenance for incidents related to data warehouses, datasets, and data pipelines.
• Participates in the design, development, and implementation of conceptual, logical, and physical data models.
• Adheres to the team’s application of best practices and organizational standards of the Software Development Lifecycle to ensure high quality and reliable data assets.
• Follows the organizational standards and laws governing use of sensitive data relating to Protected Health Information (PHI) and Personally Identifiable Information (PII).
• Develops Continuous Integration and Continuous Development (CI/CD) processes focused on acceleration of value delivery and minimizing manual touchpoints.
• Participates in enterprise-wide Agile ceremonies determining and recommending technical programming approaches and solutions to complex applications.
• Works independently or collaboratively to capture, document, and groom features and stories for planning and execution.
• Actively pursues opportunities to grow their business acumen and skills from more experienced team members.
• Provides coaching to less experienced team members.
• Actively participates in Data Engineering Community of Practice, develops standard processes for the department and helps roll them out.
• Actively participates in safety initiatives and risk mitigating measures where appropriate and completes all position and unit safety related competencies and requirements on a timely basis.
• Performs other duties as assigned.

Qualifications

Required

• Bachelor's Degree or equivalent in computer science, application programming, software development, information systems, database administration, mathematics, engineering, or relevant experience in related field
• At least 5 years of relevant experience
• Experience modeling and transforming data in modern cloud platforms (Snowflake preferred)
• Proficient in Python for ETL/ELT development, testing, and automation
• Advanced SQL experience building data models and complex transformations
• Ability to document data workflows, communicate effectively, and collaborate with others
• Ability to capture, document, and groom features and stories for planning and execution

Required

• Experience modeling and transforming data in modern cloud platforms (Snowflake preferred)
• Proficient in Python for ETL/ELT development, testing, and automation
• Advanced SQL experience building data models and complex transformations
• Ability to document data workflows, communicate effectively, and collaborate with others

Primary Location

SITE - Corewell Health Place - 100 Corewell Drive NW - Grand Rapids

Department Name

Data and Analytics - Data Engineering

Employment Type

Full time

Shift

Day (United States of America)

Weekly Scheduled Hours

40

Hours of Work

8:00 a.m. to 5:00 p.m.

Days Worked

Monday to Friday

Weekend Frequency

N/A