Data Engineer

Location: In one of NAC's 4 offices (Columbus, Los Angeles, Seattle, or Spokane)

Department: Information Technology

Reports To: Data Leader

Position Overview

NAC is looking for an experienced Data Engineer to join our delivery team, with a specific focus on designing, building, and optimizing data solutions on Microsoft Azure and Microsoft Fabric. This role is critical to helping NAC unlock the full value of our data assets, supporting advanced analytics, reporting, and digital transformation across the firm.

The ideal candidate is confident working with a modern data stack, automating data pipelines, and delivering reliable, scalable, high-quality data solutions in enterprise environments. The day-to-day work ranges from ingesting data out of firm business systems into a governed lakehouse to tuning the models and datasets that our reporting depends on, with an emphasis on solutions that keep working without constant attention.

This position reports to our Data Leader and will work closely with IT leadership and the data team, as well as resources supporting data architecture and data governance.

Key Responsibilities:

Data Pipeline Development & Integration

· Design, build, and maintain scalable data pipelines and data integration workflows using Microsoft Azure services such as Data Factory, Synapse Analytics, Azure Databricks, and related technologies.

· Develop and maintain ETL/ELT processes that support business reporting, analytics, and machine learning.

· Build ingestion patterns for a range of sources, including business applications, APIs, relational databases, and file-based feeds.

· Implement scheduling, orchestration, automation, and error handling so recurring data loads run reliably with minimal manual intervention.

Microsoft Fabric & Analytics Platform

· Implement and support Microsoft Fabric solutions, including dataflows, lakehouses, data warehouses, and real-time analytics features.

· Organize data in OneLake using a layered approach that keeps raw, enriched, and curated data clearly separated and traceable.

· Develop and maintain curated datasets and semantic models that support Power BI reporting and self-service analysis.

· Monitor capacity, refresh schedules, and job performance, and tune them as adoption and data volumes grow.

Data Modeling & Optimization

· Optimize data architectures for performance, reliability, and cost efficiency in cloud environments.

· Apply dimensional modeling and other established modeling patterns so data is understandable, reusable, and consistent across reporting.

· Write and tune advanced SQL, along with Python or PySpark notebooks, for complex transformation work.

· Monitor, troubleshoot, and improve data workflows, resolving failures and performance bottlenecks at the source rather than working around them.

Data Quality, Security & Governance

· Ensure high-quality, secure, and compliant data management practices in line with firm policy, client contractual obligations, and applicable data protection regulations.

· Implement data quality rules, validation, and monitoring so issues are caught before they reach reporting or decision-making.

· Apply access controls, sensitivity handling, and lineage practices in partnership with the resources supporting data governance.

Collaboration, Migration & Documentation

· Collaborate with data architects, analysts, and business stakeholders to gather requirements and deliver data solutions aligned with business goals.

· Support the migration and modernization of legacy data systems into Azure and Microsoft Fabric environments.

· Translate technical options and trade-offs into terms business stakeholders can act on.

· Produce and maintain technical documentation for data pipelines, architecture, and engineering best practices.

· Follow source control and deployment practices, including Git-based development and structured promotion across environments.