Senior Power BI Developer

Jobtailor; Chantilly (VA); On-site; USD 120,000 - 150,000; Full time

Job summary

Jobtailor in Chantilly, VA, is seeking a senior BI professional to design, develop, and support enterprise BI solutions using Power BI, SSAS Tabular, and SSRS. You will lead architecture, requirements, and governance while mentoring analysts and delivering scalable analytics across the organization.

You will collaborate with DBAs, data engineers, and stakeholders to optimize data models, implement advanced DAX, and deliver executive dashboards.

Qualifications

• Bachelor's degree in Computer Science, Computer Information Systems, or a related field required; equivalent combination may be considered.
• Minimum of five (5) years of experience developing solutions with Microsoft Power BI.
• Minimum of ten (10) years of experience supporting enterprise data warehouse and BI environments.
• Minimum of five (5) years of experience with SSRS.
• Minimum of five (5) years of experience with SSAS.
• Experience deploying, supporting, and administering large-scale BI solutions.
• Strong Power BI administration including security, governance, and user management.
• Extensive experience developing complex Power BI reports, dashboards, semantic models, and DAX.
• Experience developing and supporting SSAS Tabular models.
• Excellent understanding of data analysis, dimensional modeling, and relational databases.

Responsibilities

• Design, develop, maintain, and support enterprise BI solutions using Power BI, SSAS Tabular, SSRS.
• Lead requirements gathering, architecture, system design, estimation, development, testing, deployment, and support.
• Design and govern enterprise semantic models with KPIs and RLS.
• Develop advanced DAX, optimize data models, SQL queries, and reporting for performance and usability.
• Create executive dashboards and reports using Power BI best practices.
• Integrate data from data warehouses, Azure Data Lakes, and Power BI Dataflows.
• Support tenant migrations, including analysis, refactoring, validation, and governance.
• Collaborate with DBAs, ETL developers, data engineers, vendors, and stakeholders.
• Define BI strategy, architecture standards, governance frameworks, and best practices.
• Architect and support enterprise data marts and SSAS Tabular models.

Skills

Power BI

DAX calculations

SSAS Tabular

SSRS

SQL queries

Data models

Data governance

Data warehousing

BI architecture

Performance tuning

Education

Bachelor's degree in Computer Science/IS or related field

Tools

SSRS

SSAS

Power BI Admin

Azure Data Lakes

Job description

Responsibilities

• Design, develop, maintain, and support enterprise business intelligence solutions utilizing Power BI, SSAS Tabular, SSRS, and related reporting technologies
• Lead requirements gathering, solution architecture, system design, estimation, development, testing, deployment, training, and ongoing support activities
• Design and govern enterprise semantic models, including reusable measures, hierarchies, standardized calculations, KPIs, and Row-Level Security (RLS)
• Develop advanced DAX calculations and optimize data models, SQL queries, and reporting solutions for performance, scalability, and usability
• Design and deliver executive dashboards and interactive reports utilizing Power BI best practices for visualization, accessibility, and data storytelling
• Integrate and analyze data from enterprise data warehouses, Azure Data Lakes, Power BI Dataflows, and other enterprise data sources
• Support Power BI tenant-to-tenant migrations, including dependency analysis, artifact refactoring, validation, and governance compliance
• Collaborate with DBAs, ETL developers, data engineers, vendors, and business stakeholders to deliver integrated BI and analytics solutions
• Define and promote BI strategy, architecture standards, governance frameworks, and best practices
• Architect and support enterprise data marts, SSAS Tabular models, and business intelligence environments in partnership with data platform teams
• Administer reporting environments, including platform configuration, security, installation, patching, and user support
• Monitor, troubleshoot, and resolve production issues while performing root cause analysis and implementing long-term solutions
• Develop and maintain technical documentation, including architecture diagrams, data models, standards, and operational procedures
• Lead quality assurance activities across solution design, development, testing, and deployment processes
• Mentor developers and analysts while contributing to workload planning, project estimates, and delivery timelines
• Provide training, end-user support, and guidance to business stakeholders to promote adoption and effective use of BI solutions
• Drive continuous improvement initiatives that enhance reporting capabilities, data accessibility, governance, and user experience

Requirements

• Bachelor’s degree in Computer Science, Computer Information Systems, or a related field required; equivalent combination of education and experience may be considered
• Minimum of five (5) years of experience developing solutions with Microsoft Power BI
• Minimum of ten (10) years of experience supporting enterprise data warehouse and business intelligence environments
• Minimum of five (5) years of experience working with SQL Server Reporting Services (SSRS)
• Minimum of five (5) years of experience working with SQL Server Analysis Services (SSAS)
• Experience deploying, supporting, and administering large-scale business intelligence solutions
• Strong experience with Power BI administration, including configuration, security, governance, and user management
• Extensive experience developing complex Power BI reports, dashboards, semantic models, and advanced DAX calculations
• Extensive experience developing and supporting SSAS Tabular models
• Strong understanding of data analysis, dimensional modeling, data architecture, and relational database concepts
• Experience designing and supporting enterprise data marts and business intelligence architectures
• Experience leveraging Azure Data Lakes, lakehouse architectures, Power BI Dataflows, and modern analytics platforms
• Experience performing migrations across BI environments and platforms

Core Competencies

Demonstrates expertise in designing and developing enterprise business intelligence solutions using Power BI, SSAS, and SSRS, with a strong focus on data analysis, governance, and user support. Proven ability to lead BI strategy, architecture, and continuous improvement initiatives while mentoring teams and ensuring effective use of BI tools.