Data Engineer

Job Summary

The Data Engineer is responsible for designing and maintaining scalable data infrastructure that enables Midco to derive actionable insights and make informed business decisions. This role builds and optimizes SQL data warehouses, ETL pipelines, and analytic datasets to support both immediate and long-term analytical goals.

Responsibilities

• Build, design and implement SQL data warehouse to support Midco’s analytic needs.
• Build, design and implement data solutions that support short and long-term information & analysis goals.
• Train and mentor team members and assist with identifying development needs across the team, work with manager to coordinate additional training as needed.
• Design, develop and implement ETL procedures for optimal processing of data from a wide variety of data sources. Ensure data is verified and quality is checked
• Build analytic data sets to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Work with various Midco stakeholders to assist with data-related technical issues and support their data infrastructure needs.
• Ensure data integrity through regular communications with IT Developers, Analysts and SMEs
• Performing root cause analysis on internal and external data and processes to ensure proper data design.
• Consolidate and optimize existing data warehouse infrastructure
• Write and maintain comprehensive documentation, including data standards, metadata definitions, and process workflows.
• Model Midco’s mission, vision, values, ethos, and Leadership Success Drivers, and inspire others to do the same.
• Ensure customer privacy by adhering to Midco’s privacy guidelines while actively following Midco policies and procedures.
• Maintain reliable and predictable attendance as required by the position.
• Perform other duties as assigned.
  
  

Note: Management reserves the right to assign or reassign functions and responsibilities to this job description at any time.

Required Qualifications

• Associates degree in relevant field and/or an equivalent level of education or work experience.
• Minimum six years experience as a Database Administrator, Developer or Data Analyst.
• Experience with developing SQL server scripts, stored procedures, and utilizing Power BI.
• Possess a full understanding of building and designing dimensional modelling.
  
  

Preferred Qualifications

• Bachelor’s degree in relevant field.
• Experience working with application developers or business analysts.
• Experience with one or more of the following languages SQL, Python, PowerShell, C#, RPG, CL.
  
  

Work Environment

• May need to sit or remain stationary extended periods of time. 
• Extremely time-sensitive deadlines to meet customer demand. 
• Employees may be required to work more than 40 hours per week.  
  
  

Physical Demands

• May occasionally be required to reach with hands and arms, stoop, kneel, or crouch.
• Heavy keyboard/mouse usage required with repetitive movements.  
• Must remain at your desk or workstation for long periods of time.  
  
  

Mental Demands

• Ability to break down complex problems, evaluate multiple solutions, and make data-informed decisions.
• Empathy to understand user needs and design solutions.
• Collaboration to work with cross functional teams and explain technical concepts to non-technical users.