Business Intelligence Engineer

Job Title: Business Intelligence (BI) Engineer Location: Westlake, TX About the Role We are seeking a Business Intelligence (BI) Engineer to design, build, and optimize data models, dashboards, and analytical solutions using Power BI and advanced SQL. The ideal candidate will collaborate with business and IT teams to implement architecture recommendations, support developers/testers, and contribute to a dynamic, agile environment. Key Responsibilities 1. Dashboarding & Visualization • Design, develop, and maintain scalable, user-centric Power BI dashboards (semantic model alignment, row-level security, drill-down UX). • Ensure consistency, accessibility, and performance in all visualizations. 1. Data Modeling & Semantics • Build and optimize tabular and star-schema / snowflake data models for reporting efficiency. • Define and govern KPIs, calculated measures (DAX), hierarchies, and business logic. 1. Data Integration & SQL • Write performant SQL (ANSI + Oracle dialects) for transformations and aggregations. • Collaborate with data engineers on ETL/ELT pipelines (Snowflake). • Perform query tuning using execution plans, indexing strategies, and partitioning. 1. Governance, Quality & Performance • Implement version control (Git) and deployment workflows for BI assets. • Monitor data freshness, lineage, and quality (e.g., anomaly detection, reconciliation). • Enforce security policies such as row-level security, object-level policies, and data masking. 1. Stakeholder Collaboration • Translate ambiguous business questions into structured requirements. • Create functional specifications and wireframes to align business and technical teams. 1. Automation & Optimization • Implement incremental refresh and parameterized datasets. • Introduce monitoring tools (usage metrics, adoption heat maps). • Evaluate and recommend adoption of new BI platform features. Required Qualifications • 8+ years in BI Engineering / Analytics Engineering / Data Analytics roles. • Strong expertise in Power BI: DAX, Power Query (M), tabular modeling, composite models, deployment pipelines. • Advanced SQL (CTEs, window functions, performance tuning, explain plans). • Proficiency in dimensional modeling and semantic layer design. • Experience with Git and CI/CD for BI artifacts (YAML definitions, deployment pipelines). • Strong analytical reasoning and statistical thinking. • Excellent communication skills, both written and verbal. • Quality-first mindset with attention to detail. • Bias for automation and continuous improvement. Preferred / Nice to Have • Experience with Snowflake (data modeling and data warehouse). • Familiarity with Python for data processing or automation. • Exposure to API-based ingestion and REST integration. • Knowledge of performance optimization for large BI models. • Familiarity with data governance tools (Collibra, Alation).