SSRS / Power BI Engineer supporting reporting modernization for a large healthcare organization. Reverse-engineering SSRS to Power BI solutions focusing on dashboards and reports.
Responsibilities
Analyze and reverse engineer an 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, subreports, conditional formatting, and embedded code.
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 and dashboards or as Power BI paginated reports where strict layout fidelity is required.
Partner with GenAI engineering teams to refine prompts, retrieval context, and guardrails that support accurate conversion of report definitions and business rules.
Define and implement reporting governance standards, including naming conventions, certified datasets, semantic models, workspace structure, and documentation.
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, automated checks, and stakeholder sign-offs.
Optimize reporting performance through SQL tuning, data model optimization, aggregation strategies, incremental refresh, and capacity planning.
Support UAT, training, and adoption through user enablement, report catalogs, release notes, 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 or Web Portal, 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.
Exposure to SSAS (Tabular or Multidimensional) as part of a broader BI ecosystem.
Experience modernizing or migrating reporting platforms from legacy tools to Power BI.
Familiarity with data warehouse concepts such as facts, dimensions, and star schemas.
Exposure to SSIS or other ETL tools.
Experience with basic automation or scripting for deployments.
Familiarity with row-level security patterns and audit requirements.
Benefits
Health insurance
Professional development opportunities
Job title
SSRS / Power BI Engineer – Reporting Modernization
Data Engineer III at Simplot utilizing advanced data engineering principles and cloud data tools. Collaborating in a team to support data solutions for food and agriculture industry.
Business Intelligence Analyst designing and implementing scalable BI solutions at Morrison Express. Collaborating with stakeholders for data automation and visualization, leveraging AI tools responsibly.
Data Engineer at Adelaide building clean, reliable data systems for analytics. Join a rapidly growing company revolutionizing attention measurement in advertising.
Business Intelligence Engineer developing and maintaining Power BI reports for CenterWell’s Primary Care Analytics Team. Collaborating with various teams to understand their reporting needs and foster positive relationships.
BI Report Developer responsible for Power BI reporting solutions at Customers Bank. Supporting data - driven analytics and business intelligence across the organization.
Power BI Engineer designing and developing business intelligence solutions for data - driven decision - making. Responsible for creating dashboards, reports, and data models in Power BI.
Senior BI Analyst analyzing data from all business units at EveryMatrix, a leading iGaming software provider. Empowering decision - making through data analysis and reporting.
Analista de BI developing and improving dashboards and reports for financial services company Rodobens. Ensuring data quality and providing analytics insights to support decision - making.
Specialist Power BI Developer delivering high quality analytics solutions for Bauer Media Outdoor. Empowering teams with insights through the Power BI ecosystem.
BI Analyst at CIEE developing Power BI dashboards and reports for business needs. Collaborating with stakeholders to gather requirements and validate data.