[Remote] Power BI Data Engineer

Note: The job is a remote job and is open to candidates in USA. Legence is a leading provider of engineering, consulting, installation, and maintenance services for mission-critical systems in buildings. They are seeking a highly skilled Power BI Data Engineer who will architect robust data solutions and create compelling dashboards that transform complex data into actionable intelligence. This role involves direct interaction with end users and requires expertise in data engineering and visualization.ResponsibilitiesCreate sophisticated, visually stunning Power BI dashboards and reports that drive business decisionsDevelop advanced DAX calculations, measures, and calculated columns to support complex analytical requirementsDesign intuitive, user-friendly interfaces with custom visuals, drill-through capabilities, and interactive featuresImplement dynamic report features including bookmarks, parameters, field parameters, and dynamic formattingBuild composite models and leverage advanced features like aggregations, incremental refresh, and query foldingDesign, build, and maintain scalable data pipelines and ETL/ELT processes using Power Query, Dataflows, and Azure Data FactoryDevelop and optimize data models using star schema, snowflake schema, and other dimensional modeling techniquesImplement and manage data warehouses and data lakes using Azure Synapse Analytics, SQL Server, or similar platformsWrite and optimize complex SQL queries, stored procedures, and database functions for performance and efficiencyEstablish data governance frameworks, including data quality checks, validation rules, and documentation standardsConfigure and manage Power BI/Fabric workspaces, deployment pipelines, and version controlImplement row-level security (RLS) and object-level security (OLS) for data protectionOptimize report performance through query optimization, data model refinement, and DAX tuningIntegrate Power BI with various data sources including SQL databases, APIs, SharePoint, Excel, and cloud platformsAutomate data refresh schedules and monitor gateway configurationsSkills3+ years of hands-on experience with Power BI development (Desktop, Service, and Report Server)Expert-level proficiency in DAX (Data Analysis Expressions) and Power Query (M language)Strong SQL skills with experience in database design, query optimization, and performance tuningSolid understanding of data warehousing concepts, dimensional modeling, and ETL principlesExperience with data visualization best practices and UI/UX design principlesProficiency in Azure data services (Azure SQL Database, Synapse Analytics, Data Factory, or Fabric)Deep understanding of data modeling techniques and relationships (one-to-many, many-to-many, bi-directional)Strong grasp of statistical concepts and analytical methodologiesAbility to translate complex business requirements into technical data solutionsExperience with data quality assessment and data profilingProven ability to create visually compelling, executive-level dashboards and reportsStrong problem-solving skills with a hands-on, solution-oriented approachExcellent communication skills to explain technical concepts to non-technical stakeholdersDetail-oriented with commitment to code quality and documentationDemonstrated ability to use AI and automation in software engineeringCS or CIS bachelor's degreeMicrosoft certifications: PL-300 (Power BI Data Analyst), DP-203 (Data Engineer), or DP-500 (Enterprise Data Analyst)Experience with Python or R for advanced analytics integrationFamiliarity with Git/Azure DevOps for version control and CI/CD pipelinesKnowledge of DAX Studio, and other Power BI development toolsExperience with Power BI Embedded or custom API developmentUnderstanding of data science concepts and predictive analyticsBenefits401(k) Plan with Company Match: Currently match contributions dollar-for-dollar up to 4% of eligible pay; immediate vesting.Health & Welfare Benefits: Employer provided medical, dental, vision, prescription drug, Employee Assistance Program and accident & illness coverage.Life and Disability Insurance: Employer provided basic life insurance and AD&D valued at 50K coverage amount with the option for voluntary buy up for additional coverage.Time Off: Flexible non-accrual vacation; company holidays per policy. *(For California employees, this is separate from California paid sick leave, if applicable.)*Expenses: Business travel and related expenses reimbursed per company policy.Company OverviewLegence provides a comprehensive mechanical, electrical, plumbing, and maintenance services to improve building performance. It was founded in 1963, and is headquartered in San Jose, California, USA, with a workforce of 10001+ employees. Its website is https://www.wearelegence.com.