Loading...
Mid LevelFull-timeRailsGitAI
Salary Range
$102,000 - $138,000 /year
This salary is estimated based on similar roles. The actual salary may vary.
About the Role
We are seeking an SSRS/Power BI Engineer to support the modernization of enterprise reporting platforms for a large healthcare organization. This hands-on engineering role focuses on reverse-engineering a legacy SSRS reporting estate and translating it into modern Power BI solutions, including interactive dashboards and paginated reports with pixel-perfect formatting.
Key Responsibilities
- →Analyze and reverse engineer existing SSRS reporting estate including RDLs, shared datasets, data sources, subscriptions, and dependencies
- →Extract and document report logic from SSRS including parameters, expressions, grouping, drill-through behavior, and conditional formatting
- →Translate SSRS datasets and T-SQL logic into Power BI solutions using Power Query, DAX, and optimized data models
- →Rebuild SSRS pixel-perfect reports as Power BI reports, dashboards, or paginated reports where strict layout fidelity is required
- →Partner with GenAI engineering teams to refine prompts, retrieval context, and guardrails for accurate conversion of report definitions
- →Define and implement reporting governance standards including naming conventions, certified datasets, semantic models, and workspace structure
- →Implement security and access controls in Power BI including row-level security, workspace permissions, and data sensitivity labeling
- →Validate functional parity between SSRS and Power BI outputs through reconciliations, golden datasets, and automated checks
- →Optimize reporting performance through SQL tuning, data model optimization, aggregation strategies, and incremental refresh
- →Support UAT, training, and adoption through user enablement, report catalogs, and post-migration stabilization
Requirements
- ✓3+ years of hands-on experience developing SSRS reports in enterprise environments
- ✓Hands-on experience with Power BI including Power Query, DAX, data modeling, and workspace management
- ✓Strong proficiency in T-SQL including complex joins, window functions, CTEs, stored procedures, and performance considerations
- ✓Deep understanding of SSRS report design concepts including parameters, expressions, grouping, sorting, drilldown, and formatting
- ✓Experience working with SQL Server objects such as views, stored procedures, and indexing fundamentals
- ✓Familiarity with SSRS deployment and operations including Report Manager, shared data sources, shared datasets, and subscriptions
- ✓Strong debugging and validation skills to reconcile data, validate outputs, and resolve defects
- ✓Experience building Power BI paginated reports using Power BI Report Builder (preferred)
- ✓Exposure to SSAS (Tabular or Multidimensional) as part of a broader BI ecosystem (preferred)
- ✓Experience modernizing or migrating reporting platforms from legacy tools to Power BI (preferred)
- ✓Familiarity with data warehouse concepts such as facts, dimensions, and star schemas (preferred)
- ✓Exposure to SSIS or other ETL tools (preferred)
- ✓Experience with basic automation or scripting for deployments (preferred)
- ✓Familiarity with row-level security patterns and audit requirements (preferred)
