Business Intelligence & Data Engineer

Southern Dock Products of Charlotte, a Division of DuraServ•Coppell, TX

2d•Onsite

About The Position

DuraServ is seeking an experienced Business Intelligence & Data Engineer to own enterprise data and analytics architecture. The role designs, builds, documents, and supports enterprise data and analytics solutions, including scalable data pipelines, data warehouse models, and executive dashboards that provide actionable insights across the organization. The position partners with business leaders and technical teams to transform operational data into meaningful business intelligence using technologies including Microsoft Fabric, Azure Data Factory, Azure SQL, Microsoft Dynamics 365 Field Service, Business Central, Dataverse, Power BI, SQL, and DAX. The role owns enterprise data integration architecture, medallion architecture, data-quality frameworks, engineering standards, semantic modeling, Power BI and Fabric governance, platform performance and capacity management, and technical escalation for significant platform incidents. It also advises leaders on enterprise data initiatives and provides technical leadership through architecture reviews, code reviews, design guidance, knowledge sharing, and mentoring. This position has no supervisory responsibilities.

Requirements

Strong expertise developing complex DAX measures and calculations and enterprise ETL processes.
Experience with Fabric notebooks, Spark, and Python for data engineering workloads.
Experience with Azure Data Factory or Microsoft Fabric Data Factory.
Experience with Azure SQL or SQL Server, Dataverse, and designing Star Schema data warehouse models.
Strong understanding of data warehousing concepts, dimensional modeling, data observability, lineage, cataloging, and metadata management.
Experience with data security, classification, access control, RLS, OLS, and auditing.
Experience with SQL performance tuning and query optimization.
Excellent troubleshooting, communication, and problem-solving skills.
Bachelor’s degree in computer science, Information Systems, Engineering, or Data Analytics, or equivalent experience may be considered.
7+ years of progressive experience in data engineering, business intelligence, data warehousing, analytics engineering, or related disciplines.
5+ years of experience designing and delivering enterprise data and analytics solutions using SQL, dimensional modeling, and Power BI.
3+ years of experience with cloud data platforms such as Microsoft Fabric, Azure Data Factory, Azure SQL, Data Lake, Lakehouse, or comparable technologies.

Nice To Haves

Experience with Microsoft Dynamics 365 Field Service and Business Central.
Experience with Dynamics 365, Business Central, Dataverse, ERP, field service, or operational business data.
Demonstrated experience defining technical standards, leading architecture or design reviews, optimizing cloud data workloads, and delivering analytics solutions across multiple business functions.

Responsibilities

Own the design and evolution of enterprise data integration architecture across Microsoft Fabric, Azure Data Factory, Dynamics 365, Dataverse, Business Central, and other enterprise platforms.
Establish reusable ingestion, orchestration, observability, error-handling, and recovery patterns for batch and near-real-time workloads.
Define and govern enterprise medallion architecture standards for ingestion, transformation, lineage, retention, reconciliation, quality, and publication across bronze, silver, and gold data products.
Establish an enterprise data-quality framework with measurable rules, ownership, monitoring, exception management, root-cause analysis, and remediation processes for critical data domains.
Partner with business and technology leaders to translate strategic objectives into a prioritized enterprise data and analytics roadmap, target-state architecture, and scalable data products.
Define and enforce engineering standards for source control, CI/CD, automated testing, release management, infrastructure configuration, documentation, observability, and production support.
Own the enterprise semantic-modeling strategy and establish certified, reusable data models with consistent dimensions, calculations, KPIs, and business definitions across Finance, Operations, Service, and executive reporting.
Establish dimensional-modeling, Direct Lake, Import, Direct Query, composite-model, calculation-group, aggregation, and DAX performance standards based on workload requirements.
Lead platform performance and capacity management, including workload monitoring, refresh optimization, query tuning, storage strategy, capacity planning, licensing analysis, and cloud cost optimization.
Define and govern Power BI and Microsoft Fabric workspace architecture, deployment patterns, access models, Row-Level Security, Object-Level Security, endorsement, certification, release controls, and environment segregation.
Serve as the senior technical advisor for enterprise data and analytics initiatives, facilitating architecture decisions, KPI-definition workshops, data-design reviews, and prioritization discussions with business and technology leaders.
Provide advanced technical escalation and root-cause leadership for high-impact data-platform incidents, and establish monitoring, support documentation, service expectations, and preventive controls.
Provide technical leadership through architecture reviews, engineering standards, code reviews, design guidance, knowledge sharing, and mentoring of data, BI, application, and consulting resources.