Senior Data Engineer: Pipelines, Azure Synapse & Mentoring

Service Express; Highland Heights, Northern (OH, KY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Service Express is seeking a Senior Data Engineer to design and implement complex data pipelines, enabling data-driven decisions across teams. You will mentor junior engineers and ensure alignment with data warehouse and lakehouse architectures, using Spark, Python, SQL and C# within Azure Synapse.

The role emphasizes data quality, collaboration with analysts, and adherence to the full SDLC, while advancing ML/AI capabilities and maintaining strong data analytics foundations.

Qualifications

• 4+ years of Python development related to data engineering (spark, pandas, etc.).
• 4+ years of SQL related to data engineering.
• Experience in designing and implementing complex data pipelines ensuring data quality & consistency.
• Solid understanding of data warehouse and delta lake design concepts.
• Solid data analytics background.
• Solid understanding of the Software Development Life Cycle.

Responsibilities

• Implementing pipelines to move raw data in Azure Synapse using spark, python, SQL and C# in line with established architectural standards related to Data Warehouse and Data Lakehouse modeling standards.
• Developing machine learning and regression analysis skills in spark-python-pandas, openai and Azure ML.
• Mentoring other members of the Data Engineering team, specifically those in a junior role
• Work closely with Data Analysts and Business Analysts to clarify their requirements and provide clear guidance on the execution process.
• Providing peer review support to work produced by others, confirming use of relevant coding standards.
• Demonstrate mastery of the Software Development Life Cycle.

Skills

Python development

SQL for data engineering

Data pipelines design

Data analytics

Software Development Life Cycle

Education

Bachelor's Degree or Certifications

Tools

Azure Synapse

Spark

Pandas

OpenAI

Azure ML

C#

Job description

Service Express is seeking a Senior Data Engineer to design and implement complex data pipelines, enabling data-driven decisions across teams. You will mentor junior engineers and ensure alignment with data warehouse and lakehouse architectures, using Spark, Python, SQL and C# within Azure Synapse.

The role emphasizes data quality, collaboration with analysts, and adherence to the full SDLC, while advancing ML/AI capabilities and maintaining strong data analytics foundations.