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.
Required Expereince
- 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.
Preferred Experience
- 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.
Similar Jobs
What We Do
Doran Jones Inc. (DJI) is the leading financial services Data Engineering and Application Development firm, specializing in Capital Markets, Risk, and Regulatory Compliance. We are US-based, helping our clients fill gaps in capacity and expertise, reduce risk, and accelerate change. Our leaders average over 25 years of experience in Financial Services and Technology. DJI is repeatedly engaged by the largest and most complex clients for our Agile transformation expertise and practical understanding of the critical relationship between data, architecture, and application development. DJI has a mission to place more people from non-traditional backgrounds into sustainable technology careers. Through partnerships with non-profit technology programs in underserved communities and Veteran organizations, candidates transition from tech training programs into real IT careers at DJI. Our unique recruitment policy allows us to create exceptional teams, bringing a broad spectrum of experience to our company and creating anything but a traditional consulting firm. DJI is a wholly-owned subsidiary of McLaren Strategic Ventures, a private equity firm, that invests in start-ups and scale-ups. They provide a full range of highly trusted domain consulting, advisory services, and innovative technologies globally. Doran Jones is able to offer a broad range of technology, deeper AI and machine learning tools, data intelligence, alternative resourcing capabilities, and capital access to invest and digitize at scale. Our clients benefit from this unique portfolio allowing them to accelerate the pace of their own digital transformations through innovative products and services designed around industry-wide issues.
