DuraServ is seeking an experienced Business Intelligence & Data Engineer to own enterprise data and analytics architecture. This role is responsible for design, build, document and support enterprise data, analytics solutions, developing scalable data pipelines, data warehouse models, and executive dashboards that provide actionable insights across the organization. The ideal candidate has strong expertise in Microsoft Fabric, Azure Data Factory, Azure SQL, Microsoft Dynamics 365 Field Service, Business Central, Dataverse, Power BI, SQL, and DAX. This individual will partner with business leaders and technical teams to transform operational data into meaningful business intelligence.
ESSENTIAL JOB FUNCTIONS
- 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 the enterprise medallion architecture, including standards for data 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 convert 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 across the data platform.
- Own the enterprise semantic-modeling strategy and establish certified, reusable data models that provide 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 while establishing monitoring, support documentation, service expectations, and preventive controls that reduce recurring issues.
- Provide technical leadership through architecture reviews, engineering standards, code reviews, design guidance, knowledge-sharing, and mentoring of data, BI, application, and consulting resources.
This job description is not designed to cover or contain a comprehensive listing of the required activities, duties, or responsibilities of the team member. Duties, obligations, and activities may change, or new ones may be assigned at any time with or without notice.
Reasonable accommodation may be made to enable individuals with disabilities to perform these essential functions.
LEADERSHIP COMPETENCY MODEL
This role requires the demonstration of the following competencies:
Instills Trust | Communicates Effectively | Demonstrates Customer Focus | Takes Initiative | Makes Quality Decisions | Drives Growth | Ensures Accountability | Drives Results
KNOWLEDGE, SKILLS, AND ABILITIES
- Strong expertise developing complex DAX measures and calculations, enterprise ETL processes.
- Experience with fabric notebooks, sparks, Python for data engineering workloads.
- Experience with Azure Data Factory (ADF) or Microsoft Fabric Data Factory.
- Experience with Azure SQL or SQL Server and Dataverse and designing Star Schema data warehouse models.
- Experience with Microsoft Dynamics 365 Field Service and Business Central.
- 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.
SUPERVISORY RESPONSIBILITIES
- This position has no supervisory responsibilities.
WORK ENVIRONMENT AND PHYSICAL DEMANDS
- In office environment
- Prolonged periods sitting at a desk and working on a computer
- Must be able to lift up to 15 pounds at times
PLANNED BUSINESS TRAVEL
- This job requires no planned business travel.
EDUCATION AND EXPERIENCE
- Bachelor’s degree in computer science, Information Systems, Engineering, 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.
- Experience with Dynamics 365, Business Central, Dataverse, ERP, field service, or operational business data is preferred
- Demonstrated experience defining technical standards, leading architecture or design reviews, optimizing cloud data workloads, and delivering analytics solutions across multiple business functions.
EEO STATEMENT
DuraServ is an equal-opportunity employer. We prohibit discrimination and afford equal employment opportunities to team members and applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law. Our EEO policy applies to all aspects of the relationship between DuraServ and its team members, including recruitment, employment, promotion, transfer, training, working conditions, compensation, benefits, and application of policies.