Power BI Data Engineer

Posted 4hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Power BI Data Engineer building Azure data pipelines, dimensional models, and executive dashboards for Legence. Transforming complex data into actionable business intelligence across the full BI lifecycle.

Responsibilities:

  • Create sophisticated Power BI dashboards and reports that drive business decisions
  • Develop advanced DAX calculations, measures, and calculated columns
  • Design user-friendly interfaces with custom visuals, drill-through capabilities, and interactive features
  • Implement bookmarks, parameters, field parameters, and dynamic formatting
  • Build composite models using aggregations, incremental refresh, and query folding
  • Design, build, and maintain scalable data pipelines and ETL/ELT processes using Power Query, Dataflows, and Azure Data Factory
  • Develop and optimize star-schema, snowflake-schema, and other dimensional data models
  • Implement and manage data warehouses and data lakes using Azure Synapse Analytics, SQL Server, or similar platforms
  • Write and optimize complex SQL queries, stored procedures, and database functions
  • Establish data governance frameworks, data quality checks, validation rules, and documentation standards
  • Configure and manage Power BI/Fabric workspaces, deployment pipelines, and version control
  • Implement row-level security and object-level security
  • Optimize report performance through query optimization, data model refinement, and DAX tuning
  • Integrate Power BI with SQL databases, APIs, SharePoint, Excel, and cloud platforms
  • Automate data refresh schedules and monitor gateway configurations
  • Interact directly with end users regarding requirements, testing, and implementation
  • Build solutions from the ground up and own the full BI development lifecycle

Requirements:

  • 3+ 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 tuning
  • Solid understanding of data warehousing concepts, dimensional modeling, and ETL principles
  • Experience with data visualization best practices and UI/UX design principles
  • Proficiency in Azure data services (Azure SQL Database, Synapse Analytics, Data Factory, or Fabric)
  • Deep understanding of data modeling techniques and relationships, including one-to-many, many-to-many, and bi-directional relationships
  • Strong grasp of statistical concepts and analytical methodologies
  • Ability to translate complex business requirements into technical data solutions
  • Experience with data quality assessment and data profiling
  • Proven ability to create visually compelling, executive-level dashboards and reports
  • Strong problem-solving skills with a hands-on, solution-oriented approach
  • Excellent communication skills to explain technical concepts to non-technical stakeholders
  • Detail-oriented with commitment to code quality and documentation
  • Demonstrated ability to use AI and automation in software engineering
  • Bachelor's degree in Computer Science or Computer Information Systems is preferred
  • Microsoft certifications PL-300, DP-203, or DP-500 are preferred
  • Experience with Python or R for advanced analytics integration is preferred
  • Familiarity with Git/Azure DevOps for version control and CI/CD pipelines is preferred
  • Knowledge of DAX Studio and other Power BI development tools is preferred
  • Experience with Power BI Embedded or custom API development is preferred
  • Understanding of data science concepts and predictive analytics is preferred
  • Portfolio of impressive Power BI dashboards demonstrating design excellence and technical complexity
  • Track record of optimizing poorly performing reports and data models
  • Experience mentoring others in Power BI development and best practices
  • Contributions to the Power BI community, such as blog posts, speaking engagements, or open-source projects

Benefits:

  • Potential eligibility for participation in a discretionary bonus plan based on company and individual performance