Position: Lead Data Engineer

Location: Cleveland, OH – 3 days in office, 2 remote

• Relocation package available

Openings: 3

Shifts/Schedule: 8am-5pm

Duration: Permanent

Salary: $113,000-146,000 – depending on experience

Lead engineers should have expert level experience in at least 3 out of the 4 gap areas (IDMC, Github, Azure, Snowflake) and at least intermediate level in the 4th.

Must Haves:

• Bachelor’s degree in Computer Science or related field
• 10 years of professional IT experience
• 8 years of experience building applications, system integrations, and web services
• Experience utilizing ETL tools, specifically Informatica ( IDMC/IICS )
• Strong Snowflake experience (Snowflake is the client’s main data warehouse)
• Experience with Github Actions on the data side – ability to build CI/CD pipelines
• Hands-on experience with data integration tools ( FiveTran and HVR )
• Heavy experience with Microsoft Azure
• Strong organizational and communication skills

Preferred Qualifications:

• Experience with Azure Data Factory
• Experience with Oracle Cloud Integration
• Working functional knowledge of ERP business processes (SAP/Oracle etc.) such as Order to Cash, Purchase to Procure, Record to Report etc.

Day-To-Day:

Insight Global is seeking a Lead Data Engineer for one of our largest clients in Downtown Cleveland, Ohio. This individual will be a part of the centralized Data Engineering team, where all data needs go through across the entire organization. This team supports all data warehousing and analytics needs, working closely with the Enterprise Data & Insights team who builds visualizations and analytics off the data that the data engineering team has built. This individual will contribute to development across the full software development lifecycle – from requirements gathering through deployment in all aspects of Data Warehousing, including ETL, data modeling, analytics, and reporting. They will design components for Data Warehouse technologies both on-prem and cloud environments, troubleshoot and support code deployment, and resolve code concerns for best practices, security, and code styles. Current technical gaps in the team include capabilities around Azure, Informatica, Snowflake and DevOps Automation, therefore this individual will have to serve as a mentor if needed in these areas. The Lead Engineer will need to have the ability to break down a large project into meaningful phases and delegate work throughout the team. They should be able to handle the technical direction that the project is taking, in addition to blueprinting, solutioning, and coordinating closely with architects.