Data Engineer

NAC Architecture • Grandview Heights, OH

17d • $110,000 - $135,000 • Onsite

About The Position

NAC is seeking an experienced Data Engineer for its delivery team, focused on designing, building, and optimizing data solutions using Microsoft Azure and Microsoft Fabric. The role supports the use of firm data for advanced analytics, reporting, and digital transformation by building reliable, scalable, high-quality solutions in enterprise environments. Work includes ingesting data from business systems into a governed lakehouse and tuning the models and datasets that support reporting. The Data Engineer works with IT leadership, the data team, and resources supporting data architecture and governance.

Requirements

• At least 3 years of experience as a Data Engineer; professional services or large enterprise experience is desirable.
• Demonstrable expertise building data pipelines and cloud data solutions on Azure.
• Strong hands-on experience with Azure data services such as Data Factory, Synapse Analytics, Data Lake, and Databricks.
• Advanced SQL skills and experience with data modeling, transformation, and integration.
• Excellent communication skills and ability to translate technical solutions into business value.
• Ability to work independently and collaboratively in a fast-paced, client-facing environment.
• Comfort working across teams and explaining technical concepts to non-technical audiences.
• Proactive, resourceful, and adaptable, with commitment to continuous improvement, automation, and reducing manual effort.
• Collaborative, service-oriented mindset and ability to work across teams.
• Strong analytical, organizational, and problem-solving abilities; empathy and customer orientation.
• Ability to meet deadlines, manage priorities, and deliver initiatives successfully.

Nice To Haves

• Bachelor's degree in computer science, Data Engineering, Information Systems, or a related field, or equivalent experience.
• Experience with Microsoft Fabric is strongly preferred.
• Knowledge of Python or other scripting languages.
• Familiarity with data governance, data quality, and compliance frameworks.
• Certification in Microsoft Azure data engineering or Microsoft Fabric.
• Experience in professional services or large enterprise environments.

Responsibilities

• Design, build, and maintain scalable data pipelines and integration workflows using Azure services such as Data Factory, Synapse Analytics, and Azure Databricks.
• Develop and maintain ETL/ELT processes for business reporting, analytics, and machine learning.
• Build ingestion patterns for business applications, APIs, relational databases, and file-based feeds.
• Implement scheduling, orchestration, automation, and error handling to ensure recurring data loads run reliably with minimal manual intervention.
• 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 separates and tracks raw, enriched, and curated data.
• Develop and maintain curated datasets and semantic models for Power BI reporting and self-service analysis.
• Monitor capacity, refresh schedules, and job performance, and tune them as adoption and data volumes grow.
• Optimize data architectures for cloud performance, reliability, and cost efficiency.
• Apply dimensional modeling and other established modeling patterns to make data understandable, reusable, and consistent across reporting.
• Write and tune advanced SQL and Python or PySpark notebooks for complex transformations.
• Monitor, troubleshoot, and improve workflows, addressing failures and performance bottlenecks at their source.
• Ensure data management practices are high-quality, secure, and compliant with firm policy, client contractual obligations, and applicable data protection regulations.
• Implement data quality rules, validation, and monitoring to detect issues before they affect reporting or decision-making.
• Apply access controls, sensitivity handling, and lineage practices in partnership with resources supporting data governance.
• Collaborate with data architects, analysts, and business stakeholders to gather requirements and deliver solutions aligned with business goals.
• Support migration and modernization of legacy data systems into Azure and Microsoft Fabric environments.
• Explain technical options and trade-offs in terms business stakeholders can act on.
• Produce and maintain technical documentation for pipelines, architecture, and engineering best practices.
• Follow source control and deployment practices, including Git-based development and structured promotion across environments.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level