Since 1933 Heath Consultants Incorporated is the leading provider of services and equipment to the natural gas and utility industry. Heath develops and manufactures its equipment in its own world-class facility located in Houston, TX. Heath Consultants Incorporated is currently looking for a service-minded team player to bring their skills to a stable industry. If you are looking for a long-term career with a great team, we want to talk to you.
The Junior Power BI Developer is dedicated to optimizing data transformation, building scalable and high-performance data models, and developing interactive Power BI dashboards that deliver actionable insights. The developer will collaborate with business analysts and data engineers to ensure data accuracy, efficiency, and usability, supporting data-driven decision-making across the organization. In this role you would be responsible for designing, developing, and optimizing data models to support business intelligence and reporting needs. This role requires understanding Power BI best practices, DAX calculations, and ETL processes to ensure efficient and scalable data solutions.
Candidates MUST be local to the Houston, TX area near Hobby Airport or be willing to relocate to Houston to be considered as this is a HYBRID ROLE.
Key Responsibilities:
1. Data Modeling & Transformation
•Design and implement optimized data models for efficient report generation.
•Create and manage relationships between tables, hierarchies, and calculated columns.
•Implement DAX measures and calculated tables to support business logic.
2. Data Extraction & Integration
•Connect to various data sources such as SQL Server, Excel, APIs, and cloud platforms.
•Implement ETL processes using Power Query and other transformation tools.
•Ensure data consistency, normalization, and quality before loading into Power BI.
3. Report Development & Visualization
•Develop interactive dashboards and reports using Power BI.
•Apply best practices in UI/UX for intuitive and insightful visualizations.
•Optimize report performance by reducing data load times and enhancing queries.
4. Maintenance & Support
•Monitor and troubleshoot data refresh failures, model performance issues, and report errors.
•Collaborate with stakeholders to understand business requirements and translate them into BI solutions.
•Maintain proper documentation of data models, transformations, and report logic.
Knowledge, Skills, and Experience:
•Applies expertise in principles, theories, and concepts
•Broad knowledge of business/function and development life cycle
•Prior Reporting Developer, or BI Developer experience
•Experience with Azure Synapse, Power Automate, or other Microsoft BI tools.
•Knowledge of performance tuning techniques for Power BI reports and data models.
•Familiarity with version control tools (e.g., Git, DevOps) and CI/CD pipelines for BI development.
•1+ year of experience in Power BI development.
•Solid understanding of data modeling concepts, including fact and dimension tables.
•Proficiency in DAX (Data Analysis Expressions) for measures and calculations.
•Experience with Power Query (M language) for data transformations.
•Basic knowledge of SQL for querying and data manipulation.
•Strong analytical skills with an ability to translate business needs into BI solutions.
•Excellent problem-solving skills and attention to detail.
Salary range: $75,000.00-$80,000.00