Data Engineer

ALTA IT Services - Hamilton, OH

Full-time

Remote - Hamilton, OH

Professional, Scientific, and Technical Services

About the position

The Data Engineer position at ALTA IT Services is a 6-month contract-to-hire role focused on building data pipelines that empower businesses to make informed decisions. The role is fully remote and requires expertise in developing ETL processes, ensuring data quality, and collaborating with business partners to analyze complex data. The ideal candidate will have a strong background in data engineering, with a focus on creating scalable and efficient data solutions.

Responsibilities

• Develop reliable, reusable, automated, and streamlined ETL code.
• Analyze and organize raw data from multiple sources to produce required data elements.
• Design table structures and ETL processes to build performant data solutions.
• Create reconciliation procedures and data checks to ensure data quality.
• Provide production support, including on-call rotation and technical assistance to end-users and IT staff.
• Lead user requirements gathering and documentation designs.
• Conduct data investigations and assist business partners with complex data analysis and ad-hoc queries.
• Lead application and technical architecture analysis, design, and implementation.
• Collaborate with data management and database specialists to troubleshoot and report issues.
• Design new reporting applications to support reporting requests.
• Adhere to metadata management and data quality standards by leading quality management reviews.
• Identify changes in scope or work effort that could impact budget or delivery dates and implement contingencies.
• Demonstrate expert problem-solving capabilities.

Requirements

• Proven experience in designing and implementing ETL processes (preferred tools: IBM's DataStage, SQL, SAS, Python).
• Experience distilling business requirements into data warehouse design artifacts such as Facts Qualifier Matrix (FQM), source to target maps, and star/snowflake schema data models.
• Five or more years of experience with SQL, Data Modeling, and Dimensional Modeling.
• Understanding of the enterprise technical landscape, preferably with a property and casualty insurance background.
• Knowledge of developing BI dashboards (preferred tools: IBM's Cognos, Microsoft's Power BI).
• Experience creating data quality scorecards and data lineage.
• Experience working with agile teams.
• Strong team working skills, analytical nature, self-motivated, and excellent written and oral communication skills.
• Ability to comprehend complex technical and logical concepts and adapt quickly to changes.
• Ability to maintain workflow and meet deadlines while managing parallel project deliverables with minimal direction.
• Ability to create effective visual models to enable collective understanding of processes, data flow, and user interaction.
• Prior reporting application support experience.
• Track record of successfully architecting small, medium, and enterprise-scale solutions.
• Three or more years of business requirements experience.

Nice-to-haves

• Experience with property and casualty insurance background.
• Experience mentoring development team members in design and development of BI solutions.