Hi,
SSRS Developer
Experience Level: Senior (7+ Years) (Only W2 No C2C)
Engagement Type: Contract/Temporary
Project Duration: Short - Mid Term (Report Migration Initiative)
Work Model: Hybrid (NJ)
Project Overview
We are undertaking a reporting modernization initiative to sunset a legacy data warehouse and reporting platform built on Oracle Business Intelligence Enterprise Edition (OBIEE) 10g running on Microsoft SQL Server 2008.
The objective is to migrate and modernize existing reports into SQL Server Reporting Services (SSRS), ensuring continuity, accuracy, and improved maintainability within the new reporting environment.
This is a structured, execution-focused migration project involving report conversion, query translation, and validation activities.
Key Responsibilities
- Migrate legacy reports from OBIEE to SSRS
- Convert and adapt exported OBIEE report queries for SSRS compatibility
- Recreate report layouts, datasets, parameters, and visualizations in SSRS
- Modify and optimize SQL queries to align with SSRS syntax and performance standards
- Validate report outputs to ensure accuracy and consistency with legacy reports
- Work through a prioritized inventory of ~100 reports, varying in complexity
- Collaborate with internal SMEs and OBIEE specialists for query translation and logic clarification
- Follow established migration workflows and reporting standards
Required Skills & Experience
Core Technical Skills
- Strong hands-on experience with SQL Server Reporting Services (SSRS)
- Proficiency in T-SQL and query performance tuning
- Experience migrating or converting reports from legacy BI/reporting platforms
- Solid understanding of relational databases and data warehouse concepts
Preferred Experience
- Experience with Oracle Business Intelligence Enterprise Edition (OBIEE)
- Familiarity with SQL Server legacy environments (e.g., SQL Server 2008)
- Report modernization and BI platform migration experience
Nice to Have
- Experience working on large-scale report migration initiatives
- Exposure to enterprise reporting standards and governance
- Ability to handle varying report complexity levels