Power BI Developer
Consertus-US•Austin, TX
•Onsite
About The Position
As a Power BI Developer, you will be part of a consulting team delivering data and analytics solutions across client engagements. You will design, develop, and maintain business intelligence solutions that transform complex data into actionable insights. Working closely with project teams and client stakeholders, you will gather requirements, develop data models, and deliver dashboards that support broader analytics and digital transformation initiatives. The role requires strong technical expertise, attention to detail, and the ability to operate effectively in a fast-paced, client-facing environment. This is a full-time, on-site position.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, Business, or a related field.
- 2–4 years of experience developing Power BI dashboards and reports.
- At least 2 years of experience supporting capital programs, construction projects, or project management initiatives, including analysis of project performance, schedules, costs, risks, and key project metrics.
- At least 2 years of experience working with project controls data, including cost management, scheduling, forecasting, budgeting, resource planning, earned value management (EVM), or project performance reporting within Power BI or similar business intelligence platforms.
- Previous experience designing and developing Power BI semantic models, dashboards, and paginated reports aligned to client needs.
- Strong experience with DAX, Power Query (M), and semantic data modeling.
- Solid understanding of star schema and tabular modeling principles.
- Hands-on experience with SQL Server Reporting Services (SSRS).
- Experience with ETL tools such as SSIS or equivalent data integration technologies.
- Strong SQL/T-SQL skills, including joins, aggregations, and performance tuning.
- Experience working with large datasets and multiple data sources.
- Strong analytical and problem-solving skills.
- Effective written and verbal communication skills.
- Ability to manage multiple priorities and work effectively in a consulting environment.
Nice To Haves
- Microsoft certifications such as PL-300, or progress toward DP-500 / DP-600.
- Experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake).
- Familiarity with Azure data services, including Azure SQL, Synapse, and Data Lake.
- Experience with Git-based version control and deployment pipelines.
- Exposure to additional BI tools such as Tableau, Qlik, or Oracle BI Publisher.
- Experience working with APIs (REST/SOAP) and handling JSON/XML data structures.
- Exposure to data warehousing concepts, including staging, data marts, and dimensional modelling.
- Understanding of capital project, construction, or asset lifecycle data.
Responsibilities
- Design and develop Power BI semantic models, dashboards, and paginated reports aligned to client requirements.
- Build and optimize DAX measures, Power Query (M) transformations, and row-level security.
- Engage with stakeholders to gather requirements and translate functional needs into technical specifications and scalable data models.
- Build SSRS reports and contribute to SSAS tabular model development as part of broader BI architectures.
- Develop and maintain ETL processes using SSIS, Power Query, Azure Data Factory, or similar tools, including data profiling and quality validation.
- Develop KPIs and performance metrics to support operational and strategic decision-making.
- Perform testing, validation, performance tuning, and support user acceptance testing (UAT).
- Manage assigned tasks and workstreams across concurrent client engagements, proactively communicating progress, risks, and blockers.
- Take ownership of assigned deliverables, ensuring quality, timeliness, and alignment with client expectations.
- Participate in client-facing meetings, demos, and walkthroughs, presenting solutions clearly and professionally.
- Produce clear, well-structured documentation, including data dictionaries, technical designs, and user guides.
- Contribute to internal best practices, reusable assets, and continuous improvement initiatives.
Benefits
- Comprehensive medical, dental, and vision coverage.
- Company-paid life and disability insurance.
- Optional pet insurance, legal, and supplemental health plans.
- 401(k) with day-one eligibility, 3% safe harbor, and up to 2.5% company match.
- 10 paid holidays.
- PTO starting at 15 days and growing up to 25 days.
- Access to Consertus Academy for continuous learning and development.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
