EngineerJobs.io
← Back to all jobs

Job Description

The Associate Data Engineer role focuses on designing, building, and optimizing modern data solutions for mid-market and enterprise clients. Work is primarily centered on the Microsoft data ecosystem, transforming raw data into analytics-ready assets using Azure, Synapse, and Microsoft Fabric.

Responsibilities

  • Develop scalable, well-documented ETL/ELT pipelines using T-SQL, Python, Azure Data Factory/Fabric Data Pipelines, and Databricks, applying best-practice patterns for performance, security, and cost control.
  • Design relational and lakehouse models, including creation of Fabric OneLake shortcuts, medallion-style layers, and dimensional/semantic models for Power BI.
  • Build automated data-quality checks, lineage, and observability metrics, and contribute to CI/CD workflows using Azure DevOps or GitHub.
  • Collect and refine requirements, demo iterative deliverables, document technical designs, and translate complex concepts to non-technical audiences.
  • Research new capabilities, share learnings within internal communities of practice, and contribute to reusable accelerators; collaborate with clients and internal stakeholders to design and implement scalable data engineering solutions.

Requirements

  • Bachelor’s in Computer Science, Information Systems, Engineering, or related field (or equivalent experience).
  • 2–3 years delivering production data solutions, preferably in a consulting or client-facing role.
  • Strong T-SQL skills for data transformation and performance tuning.
  • Proficiency in Python for data wrangling, orchestration, or notebook-based development.
  • Hands-on ETL/ELT experience using at least one Microsoft service, such as Azure Data Factory, Synapse Pipelines, or Fabric Data Pipelines.

Technology Stack

  • T-SQL, Python
  • Azure, Azure Data Factory, Synapse Pipelines
  • Microsoft Fabric, Fabric Data Pipelines
  • Databricks, Delta Lake
  • Fabric OneLake, Fabric OneLake shortcuts, lakehouses
  • Medallion-style layers, dimensional/semantic models, Power BI
  • Power BI DirectLake
  • Azure DevOps, GitHub, CI/CD, CI/CD workflows
  • YAML pipelines, Notebooks, Warehouse
  • Terraform, Bicep

Role Details

  • Title: Associate Data Engineer
  • Location: Frisco, TX (onsite)
  • Salary Range: USD 85,910 to 162,890 per year
  • Experience Level: 2+ years

Similar Jobs