Power BI Developer

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

📋 Description

• Create and implement Power BI semantic models, dashboards, and paginated reports that meet client specifications.

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

• Collaborate with stakeholders to collect requirements and convert functional needs into technical specifications and scalable data models.

• Develop SSRS reports and assist in the development of SSAS tabular models as part of comprehensive BI architectures.

• Design and sustain ETL processes using SSIS, Power Query, Azure Data Factory, or similar tools, including data profiling and quality assurance.

• Create KPIs and performance metrics to facilitate operational and strategic decision-making.

• Conduct testing, validation, performance tuning, and support user acceptance testing (UAT).

• Oversee assigned tasks and workstreams across multiple client engagements, proactively updating on progress, risks, and obstacles.

• Exhibit ownership of assigned deliverables, ensuring they meet quality, timelines, and client expectations.

• Engage in client-facing meetings, demos, and walkthroughs, effectively presenting solutions in a clear and professional manner.

• Generate clear and organized documentation including data dictionaries, technical designs, and user guides.

• Contribute to the development of internal best practices, reusable assets, and initiatives for continuous improvement.

⛳️ Requirements

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

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

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

• Strong understanding of star schema and tabular modeling concepts.

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

• Familiarity with ETL tools such as SSIS or other data integration technologies.

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

• Experience in working with large datasets and diverse data sources.

• Excellent analytical and problem-solving abilities.

• Strong 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).

• Knowledge of Azure data services (Azure SQL, Synapse, Data Lake).

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

• Familiarity with additional BI tools (e.g., Tableau, Qlik, Oracle BI Publisher).

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

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

• Familiarity with capital project, construction, or asset lifecycle data is advantageous.

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

🏝️ Benefits

• Comprehensive health coverage (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, 3% safe harbor, and an additional up to 2.5% company match.

• Generous time off: 10 paid holidays and PTO beginning at 15 days, increasing up to 25.

• Access to Consertus Academy for ongoing learning and development.