Senior Power BI & SSAS BI Developer

CYFR Technology; Northern (KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

CYFR Technology is seeking a Power BI & SSRS BI Developer to build executive dashboards, reseller performance reports, and financial analytics. You will implement star schemas, write DAX measures, and design SSAS tabular models to support time intelligence and cross-filtering.

Responsibilities include maintaining SSRS paginated reports, building ETL pipelines with SSIS or Azure Data Factory, and documenting data lineage and report specifications for change management.

Qualifications

• 5+ years of Power BI development, including Power BI Service administration.
• Expert-level DAX — you understand filter context, context transition, and can debug with DAX Studio
• Experience designing SSAS tabular models and managing partitions and processing strategies
• Strong T-SQL — complex joins, CTEs, window functions, query optimization
• Experience with SSRS report design: parameters, subreports, drill-through, expressions

Responsibilities

• Build and maintain Power BI reports and dashboards for finance, sales, operations, and compliance teams
• Design and develop SSAS tabular models (compatibility level 1600) — partitions, calculated tables, calculation groups
• Write complex DAX measures: time intelligence, semi-additive measures, row-level security patterns
• Maintain SSRS paginated reports for regulatory filings, customer statements, and operational checklists
• Build and maintain ETL pipelines (SSIS and/or Azure Data Factory) populating the enterprise data warehouse
• Document data lineage, calculation logic, and report specifications for change management

Skills

Power BI development

DAX expertise

Data modeling

T-SQL

SSRS reporting

Tools

SSAS

SSIS

Azure Data Factory

Power BI Service

Azure Analysis Services

Microsoft Fabric

Job description

CYFR Technology is seeking a Power BI & SSRS BI Developer to build executive dashboards, reseller performance reports, and financial analytics. You will implement star schemas, write DAX measures, and design SSAS tabular models to support time intelligence and cross-filtering.

Responsibilities include maintaining SSRS paginated reports, building ETL pipelines with SSIS or Azure Data Factory, and documenting data lineage and report specifications for change management.