Power BI Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design and create Power BI semantic models, dashboards, and paginated reports that meet client specifications.

• Construct and enhance DAX measures, Power Query (M) transformations, and row-level security.

• Collect stakeholder requirements and convert functional needs into technical specifications and scalable data models.

• Develop SSRS reports and assist in the creation of SSAS tabular models.

• Create and sustain ETL processes using SSIS, Power Query, Azure Data Factory, or similar tools.

• Conduct data profiling and quality assurance validation.

• Establish KPIs and performance metrics to support both operational and strategic decision-making.

• Execute testing, validation, performance tuning, and facilitate user acceptance testing.

• Oversee assigned tasks and workstreams across multiple client engagements concurrently.

• Communicate updates, risks, and challenges effectively.

• Take ownership of assigned deliverables, ensuring they meet quality standards, deadlines, and align with client expectations.

• Engage in client-facing meetings, demonstrations, and walkthroughs.

• Clearly and professionally present solutions.

• Produce documentation such as data dictionaries, technical designs, and user guides.

• Contribute to internal best practices, reusable assets, and initiatives aimed at continuous improvement.

⛳️ Requirements

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, Business, or a related field.

• Over 3 years of experience in developing Power BI dashboards and reports.

• Strong proficiency in DAX, Power Query (M), and semantic data modeling.

• Solid grasp of star schema and tabular modeling principles.

• Practical experience with SQL Server Reporting Services (SSRS).

• Familiarity with ETL tools like SSIS or similar data integration technologies.

• Strong SQL / T-SQL skills, including joins, aggregations, and performance optimization.

• Experience with large datasets and various data sources.

• Excellent analytical and problem-solving capabilities.

• Proficient written and verbal communication skills.

• 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 (Azure SQL, Synapse, Data Lake).

• Experience with Git-based version control and deployment pipelines.

• Exposure to additional BI tools (e.g., Tableau, Qlik, Oracle BI Publisher).

• Experience working with APIs (REST/SOAP) and managing JSON/XML data structures is a plus.

• Knowledge of data warehousing concepts, including staging, data marts, and dimensional modeling.

• Understanding of capital project, construction, or asset lifecycle data is a plus.

• Ability to handle multiple priorities and work efficiently in a consulting environment.

🏝️ Benefits

• Comprehensive health coverage including medical, dental, and vision.

• Company-paid life and disability insurance.

• Optional benefits such as pet insurance, legal assistance, and supplemental health plans.

• 401(k) with day-one eligibility, offering a 3% safe harbor, plus up to 2.5% company match.

• 10 paid holidays per year.

• Paid time off starting at 15 days, increasing up to 25 days.

• Access to Consertus Academy for ongoing learning and development opportunities.

• Flexible work arrangements available.