Data Engineer

Role: Data Engineer

Location: Okemos, MI Hybrid

Duration: Long term
Rate: Market

Description:

We are looking for a Data Engineer to join our Data Engineering Team. The ideal candidate should have a minimum of 3 years of experience with excellent analytical reasoning and critical thinking skills. The candidate will be a part of a team that does Enterprise Data Warehousing (EDW) work, general extract, transform, and load (ETL) work, along with creating data pipelines that use change data capture (CDC) mechanisms to move data to a cloud provider.

Responsibilities:

• Participates in the analysis and development of technical specifications, programming, and testing of Data Engineering components.
• Participates creating data pipelines and ETL workflows to ensure that design and enterprise programming standards and guidelines are followed. Assist with updating the enterprise standards when gaps are identified.
• Follows technology best practices and standards and escalates any issues as deemed appropriate. Follows architecture and design best practices (as guided by the Lead Data Engineer, BI Architect, and Architectural team).
• Responsible for assisting in configuration and scripting to implement fully automated data pipelines, stored procedures and functions, and ETL workflows.
• Follows standard change control and configuration management practices.
• Participates in 24-hour on-call rotation in support of the platform.

Required Skills/Qualifications

• Drive and desire to automate repeatable processes
• Excellent interpersonal skills and communication, as well as the willingness to collaborate with teams across the organization
• Database Platforms: Oracle, EDB PostgreSQL, Snowflake, and SQL Server
• OS Platforms: Windows Server and Linux OS
• Languages: PL/SQL, Python, and T-SQL
• Informatica PowerCenter and StreamSets

Desired Skills/Qualifications

Experience working with near-realtime data pipelines and traditional EDW workflows