Business Intelligence & Data Engineer

DuraServ Corp
Coppell, TX, United States
11 days ago
Apply on www.indeed.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Working hours
Regular working hours
Job source

Tech stack

Business Analytics Applications Data Analysis Application Integration Architecture Automation of Tests Code Review Information Systems System Configuration Continuous Integration Information Engineering Data Hub Data Infrastructure Extract Transform Load (ETL)
+27 more
Data Security Data Warehousing Dimensional Modeling Meta-Data Management Microsoft Dynamics Microsoft SQL Server SQL Azure Operational Data Store Query Optimization Release Management Power BI Cloud Services DataOps SQL Databases Enterprise Data Management Data Ingestion Azure Data Factory Microsoft Fabric Data Lakes Information Technology Microsoft Business Central Data Analytics Star Schema Cloud Optimization Software Version Control Data Pipelines Sql Tuning

Job description

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., * 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.

Requirements

  • 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, * 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.

About the company

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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com
Prepare application

Good distractions

Loading talks and stories from around this role…