Data Engineer

Peter Millar

$95K — $115K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field (or equivalent experience)
  • 3-5 years of hands-on experience in data engineering or a related technical role
  • Strong SQL skills, including query optimization and performance tuning
  • Proficiency in Python and/or PowerShell for data transformation
  • Hands-on experience with Azure data services, including Data Factory and Synapse Analytics
  • Familiarity with source control tools such as Git/GitHub and CI/CD practices

Responsibilities

  • Design, build, and maintain ETL/ELT pipelines using Azure Data Factory and Microsoft Fabric
  • Develop and optimize data ingestion workflows for structured and semi-structured data
  • Troubleshoot pipeline failures and data issues to ensure reliable data delivery
  • Support and maintain data platform components within Microsoft Fabric
  • Contribute to Spark and notebook-based data processing for large-scale transformations
  • Collaborate with analysts and data scientists to support reporting and downstream use cases
  • Perform data validation and cleansing to ensure high-quality data

Benefits

  • Opportunity to work with cutting-edge Microsoft technology stack
  • Collaborative environment with cross-functional teams
  • Focus on continuous learning and development in the field of data engineering
  • Participation in code reviews and CI/CD practices encourages professional growth
  • Engagement with data governance and best practices enhances job satisfaction
Full Job Description
We are seeking a Data Engineer to design, build, and support modern data pipelines and data platform solutions using Microsoft and cloud-based technologies. This role will be responsible for developing and optimizing scalable data pipelines, supporting the Microsoft Fabric platform, and ensuring high-quality, reliable data is available for reporting, analytics, and business operations.

The ideal candidate has strong experience with SQL, Azure data services, and ETL/ELT development, and is comfortable working across both pipeline development and data platform responsibilities.

ESSENTIAL FUNCTIONS:
  • Design, build, and maintain ETL/ELT pipelines using Azure Data Factory, Microsoft Fabric Data Factory, and Dataflows.
  • Develop and optimize data ingestion workflows across structured and semi-structured data sources.
  • Troubleshoot pipeline failures, data issues, and performance bottlenecks to ensure reliable data delivery.
  • Support and maintain data platform components within Microsoft Fabric, including Lakehouse, Warehouse, and OneLake.
  • Work with medallion architecture (bronze, silver, gold) to structure and manage data transformations.
  • Contribute to Spark and notebook-based data processing for large-scale data transformation.
  • Monitor data pipelines and platform health, and support alerting and incident response processes.
  • Perform data validation, profiling, and cleansing to ensure high-quality and accurate data.
  • Work with business stakeholders to gather data requirements and translate them into technical solutions.
  • Collaborate with analysts, data scientists, and application teams to support reporting and downstream use cases.
  • Write and maintain documentation for data pipelines, transformations, and workflows.
  • Participate in code reviews and contribute to CI/CD and DevOps practices using Git/GitHub.
  • Follow and help enforce data governance, security, and best practices across the data platform.


COMPETENCIES / EDUCATION / EXPERIENCE:
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field (or equivalent experience).
  • 3-5 years of hands-on experience in data engineering or a related technical role.
  • Strong SQL skills, including query optimization, indexing, and performance tuning.
  • Proficiency in Python and/or PowerShell for data transformation and automation.
  • Hands-on experience with Azure data services, including Data Factory, Synapse Analytics, Azure SQL, and Data Lake Storage.
  • Working experience with Microsoft Fabric, including Lakehouse, Dataflows, and pipelines.
  • Solid understanding of ETL/ELT design patterns and data pipeline best practices.
  • Experience working with structured and semi-structured data formats (JSON, XML, etc.).
  • Familiarity with source control tools such as Git/GitHub and CI/CD practices.
  • Strong analytical, problem-solving, and communication skills.


PREFERRED SKILLS:
  • Experience with Spark (PySpark) for large-scale data processing.
  • Familiarity with Delta Lake and Parquet data formats.
  • Exposure to Power BI or other data visualization tools.
  • Experience with APIs, including development and integration.
  • Microsoft Fabric certification (DP-600) or interest in pursuing certification.

Similar Jobs

More Jobs at Peter Millar

  • Integration Engineer
    $95K — $115K *
    Research Triangle Park, NC 27709 (Durham County)
    Information Technology
    In-Person
  • Data Engineer
    $95K — $115K *
    Research Triangle Park, NC 27709 (Durham County)
    Information Technology
    In-Person
  • Supply Planning Manager
    $95K — $115K *
    Research Triangle Park, NC 27709 (Durham County)
    Retail & Consumer Goods
    In-Person
  • Senior Data Scientist
    $110K — $140K *
    Research Triangle Park, NC 27709 (Durham County)
    Information Technology
    In-Person
  • Costing Engineer
    $70K — $95K *
    Research Triangle Park, NC 27709 (Durham County)
    Manufacturing & Automotive
    In-Person

More Information Technology Jobs

Find similar Data Engineer jobs: