Data Engineer – BI

This is a fully remote position, open to applicants in United States.

📋 Description

• Create and uphold semantic data models, metrics layers, and certified datasets for reporting and self-service analytics.

• Establish, standardize, and govern KPIs, calculation logic, and a common metric glossary.

• Develop, maintain, and enhance dashboards and reports in Sigma, along with some Power BI and native Databricks dashboards/AI-BI Genie.

• Define and uphold Sigma workspace standards, which include workbook templates, certified datasets, RLS configuration, and naming/governance conventions.

• Work in collaboration with Architecture on data quality, testing, and observability; manage triage and resolution of BI-layer and dashboard issues.

• Promote BI adoption by training and assisting business users, tracking dashboard usage, and pinpointing assets for redesign, training, or retirement.

• Ensure data security and compliance through role-based access controls, encryption, masking, and governance protocols.

• Collect reporting and analytics requirements, establish success metrics, and convert them into technical specifications and data products.

• Enable analytics, reporting, and AI/ML use cases through user-friendly data models, feature availability, and platform integrations such as Databricks Vector Search and Model Serving.

• Collaborate within an Agile-Scrum framework and create technical design documentation.

• Construct and maintain production dashboards and workbooks in Sigma.

• Implement row-level security and Entra ID-based access controls.

• Partner with engineering, analytics, and business stakeholders to ensure alignment.

⛳️ Requirements

• Minimum of 3 years of practical experience in data engineering and/or business intelligence is required.

• Proficiency in Databricks, including DAB and Materialized Views.

• At least 3 years of experience in designing semantic/dimensional data models and creating dashboards and reports in a modern BI platform, with hands-on experience in a metrics or semantic layer.

• Over 3 years of experience with analytical SQL (ANSI SQL/T-SQL/Spark SQL) and Python for data engineering, encompassing pipeline construction, transformation logic, and automation.

• Familiarity with Azure DevOps.

• Bachelor's degree in Computer Science, Information Technology, or a related discipline.

• Experience with HIPAA compliant data sets is advantageous.

• Knowledge of GitHub CoPilot is a plus.

• A Master's degree is preferred.

🏝️ Benefits

• Remote position.

• Occasional travel.