Senior Power BI & Fabric Analytics Architect

All Roads; Dundalk (MD); Hybrid; USD 110,000 - 135,000; Full time

Benefits offered by this job

Medical, dental, vision, disability &

401(k) with company match

Paid time off & holidays

Tuition reimbursement

Employee referral bonus

Opportunity to shape enterprise data

Job summary

All Roads in Maryland is seeking a Senior Power BI Developer to lead the enterprise reporting lifecycle, enabling leaders to run the business with trusted data. You will design semantic models, build dashboards, implement security, and optimize performance using Power BI, Microsoft Fabric, and analytics tools.

This hybrid position prioritizes candidates residing in Maryland. Salary range is $110k–$135k with no H1-B sponsorship.

Qualifications

• 5+ years of experience developing and supporting Power BI solutions in an enterprise environment.
• Advanced proficiency with DAX, including time intelligence and performance optimization.
• Proficiency with Fabric Notebooks and Python for data transformation and analytics workflows.
• Proficiency with Power Query and M for data transformation.
• Experience designing semantic models using dimensional modeling and star schemas.
• Experience with Fabric, Lakehouse, Data Warehouse, OneLake, and dataflows.
• Experience administering Power BI apps, workspaces, and governance.
• Strong SQL skills and ability to validate data from multiple sources.
• Experience using Git for source control.

Responsibilities

• Develop and maintain executive, operational, and analytical Power BI dashboards and reports.
• Build enterprise semantic models with sound dimensional modeling practices.
• Create advanced DAX measures and calculations for complex scenarios.
• Use Fabric Notebooks to shape and prepare data for reporting.
• Manage Power BI services, workspaces, permissions, and deployment pipelines.
• Collaborate with business leaders to translate questions into analytics solutions.
• Ensure reporting assets are governed, described, and reusable.

Skills

Power BI

DAX

Fabric Notebooks

Python

SQL

Data Modeling

Security & Governance

Git

Communication

Education

Bachelor's degree in Computer Science / Information Systems / BI / Data Analytics

Tools

Fabric

Power BI REST APIs

Power BI Report Builder/SSRS

Job description

Senior Power BI Developer

Department: IT

Employment Type: Full Time

Location: All Roads Corporate

Description

All Roads is a growing, multi-business organization headquartered in Maryland, with operations across multiple locations and industries that depend on timely, trusted information every day. We are making a serious investment in Microsoft Fabric, Power BI, and governed analytics, and this role will help shape how leaders across the company use data to run the business, improve operations, and find new opportunities. Priority will be given to those who currently reside in Maryland. We are unable to provide H1-B Sponsorship.

This is a hybrid opportunity located in Maryland. Salary range is $110k - $135k

All Roads is seeking an experienced Senior Power BI Developer to contribute to the development, improvement, and support of enterprise reporting and analytics solutions. This role will work across the Power BI reporting lifecycle, including requirements, semantic models, report development, deployment, governance, security, performance optimization, and user support.

The right candidate will combine advanced Power BI development skills with a strong understanding of Microsoft Fabric, enterprise content distribution, and secure self-service analytics. The developer will also help structure reporting assets and data models so they are well governed, clearly described, and ready to support natural-language exploration, intelligent insights, automation, and future AI-enabled business applications.

Key Responsibilities

• Develop, enhance, and maintain executive, operational, and analytical Power BI dashboards and reports that are accurate, intuitive, and visually clear.

• Build and optimize enterprise semantic models using sound dimensional modeling practices, reusable measures, consistent business definitions, and appropriate storage modes.

• Develop advanced DAX measures and calculations, including time intelligence, complex filtering, dynamic calculations, and multi-table business logic.

• Use Fabric Notebooks and related platform capabilities to shape, validate, and prepare data for reporting and analysis.

• Build Power BI solutions that use Microsoft Fabric, OneLake, Lakehouse, Data Warehouse, dataflows, and related services as appropriate to the solution.

• Support organizational Power BI apps, audience structures, workspace organization, and content distribution methods for different divisions, departments, roles, and user groups.

• Implement and maintain row-level security and, where appropriate, object-level security using scalable role and user mapping approaches.

• Manage Power BI Service administration activities, including workspaces, gateways, refresh schedules, deployment pipelines, medallion architecture, permissions, endorsement, and release processes.

• Improve model and report performance through query diagnostics, model optimization, incremental refresh, aggregation strategies, and effective capacity use.

• Partner directly with business leaders and subject matter experts to translate business questions and operational requirements into practical analytics solutions.

• Establish and maintain standards for report design, naming, documentation, testing, deployment, data definitions, and ongoing support.

• Create trusted, reusable reporting assets that support governed self-service analytics across the organization.

• Prepare semantic models and supporting metadata for emerging AI-enabled analytics by applying clear naming, descriptions, business definitions, relationships, security, and governance.

• Use modern AI-assisted development tools responsibly to accelerate development, troubleshoot issues, improve documentation, test solutions, and increase overall productivity while maintaining accuracy, security, and quality.

• Stay current with Microsoft Power BI, Fabric, and analytics platform capabilities, and recommend practical improvements that create measurable business value.

Qualifications

REQUIRED QUALIFICATIONS
• 5+ years of professional experience developing and supportingPower BI solutions in a business or enterprise analytics environment.

• Advanced proficiency with DAX, including evaluation context, calculation patterns, virtual tables, time intelligence, and performance optimization.

• Strongproficiency with Fabric Notebooks and Python for data transformation, validation, and reusable analytics workflows.

• Proficiency with Power Query and M for data transformation, shaping, and reusable query design.

• Demonstrated experience designing semantic models using dimensional modeling, star schemas, relationships, calculation groups, and appropriate storage modes.

• Hands-on experience with Microsoft Fabric and an understanding of how Lakehouse, Data Warehouse, OneLake, dataflows, and Direct Lake semantic models work together.

• Experience designing and administering organizational Power BI apps, audiences, workspaces, and enterprise content distribution.

• Demonstrated experience implementing and maintaining row-level security in complex organizational environments.

• Experience with Fabric administration, deployment pipelines, medallion architecture, data gateways, refresh management, permissions, and governed release processes.

• Strong SQL skills and the ability to understand, validate, and troubleshoot data from multiple business systems.

• Experience contributing across the development lifecycle, including requirements gathering, solution development, testing, deployment, documentation, support, and user adoption.

• Ability to communicate effectively with technical and non-technical stakeholders and convert ambiguous business needs into clear, maintainable solutions.

• Demonstrated judgment in using AI-assisted development tools productively and securely without sacrificing validation, maintainability, or data protection.

• Experience using Git for source control and version management.

PREFERRED QUALIFICATIONS
• 7+ years of professional business intelligence or analytics development experience.

• Experience developing paginated reports using Power BI Report Builder or SSRS.

• Experience with source control, versioning, Tabular Model Definition Language, Tabular Editor, or application lifecycle management for Power BI assets.

• Experience with Power BI REST APIs, embedded analytics, automation, or programmatic administration.

• Experience supporting enterprise adoption through certified semantic models, documentation, training, and structured self-service reporting.

• Experience preparing governed business data and semantic models for natural-language querying, intelligent discovery, automation, or other AI-enabled analytics use cases.

• Experience working with automotive, commercial vehicle, equipment, dealership, distribution, service, parts, rental, or other multi-location operational data.

• Bachelor's degree in Computer Science, Information Systems, Business Intelligence, Data Analytics, or a related field, or equivalent practical experience.

Benefits

• Medical, dental, vision, disability, life, and supplemental insurance offerings on the first of the month after 30 days of employment

• 401(k) with company match.

• Paid Time Off and paid company holidays.

• Tuition reimbursement program.

• Employee referral bonus program.

• Opportunity to help shape the next stage of enterprise analytics at a growing, multi-business organization.

AAP/EEO Statement
All Roads Company and its subsidiaries are committed to equal opportunity for all, without regard to race, religion, color, national origin, citizenship, sex, sexual orientation, gender identity, age, veteran status, disability, genetic information, or any other protected characteristic. All Roads will make reasonable accommodations for known physical or mental limitations of otherwise qualified employees and applicants with disabilities unless the accommodation would impose an undue hardship on the operation of our business.