Business Intelligence Developer working on reporting and dashboard solutions for 32BJ Benefit Funds. Collaborating with senior developers to advance business insights through data analytics.
About the role
- 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
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Intern supporting Business Intelligence Developer tasks while collaborating with professionals at Uline's corporate headquarters. Focusing on data integrations and analytics for business solutions.
BI Developer reviewing data and metrics on insider and cyber risks for SMBC at a hybrid workplace. Building visualizations and reports to foster security within the organization.
Senior Manager driving business intelligence initiatives for Snap’s Small & Mid - sized Clients business. Leading analytics team to transform insights into data - driven actions across Go - To - Market and Sales strategies.
Lead PowerBI Developer managing analytics solutions for People Analytics unit at Novo Nordisk. Collaborate across teams to drive data quality and decision - making through insights.
Mid - Level Business Intelligence Analyst transforming data into actionable insights at Boeing. Collaborating with teams to improve business performance and validate data accuracy.
Business Intelligence Analyst creating strategic reports for a leading technology company. Collaborating cross - functionally to enhance business decision - making and performance metrics.
Power BI Consultant focused on designing and developing reports and dashboards. Collaborating with clients to transform data sets for business insights.
(Senior) BI Consultant leading and implementing advanced BI projects for diverse clients in Switzerland. Focusing on Microsoft technologies and cloud solutions with teamwork and problem - solving.
Business Intelligence Developer designing and implementing BI solutions for energy management provider in Bulgaria. Collaborating with stakeholders to shape architecture and support project lifecycles.