Crystal Report Developer

Position Title: Crystal Reports to SSRS Report Write Location: Kansas City, MO Duration: 06 months Contract on W2 (Possible extension) Position Description: • The Crystal Reports to SSRS Report Writer is responsible for developing, maintaining, and migrating reports between Crystal Reports and SSRS platforms. • This role requires expertise in both reporting tools, strong SQL skills, and the ability to collaborate with stakeholders to understand and fulfill reporting needs. • This role focuses on the design, development, and migration of reports using both Crystal Reports and SQL Server Reporting Services (SSRS). Key Responsibilities: • Report Development: Design, develop, and modify reports using Crystal Reports and SQL Server Reporting Services (SSRS), adhering to existing standards and documentation. • Report Migration: Plan and execute the migration of Crystal Reports to SSRS, which may involve analyzing existing reports, recreating datasets and data sources in SSRS, and building the report layouts. • SQL Development: Write and optimize SQL queries, stored procedures, and functions to extract and manipulate data for reporting purposes. • Report Optimization: Identify opportunities to enhance report performance and efficiency, potentially by analyzing data, optimizing queries, and leveraging features within both tools. • Testing and Quality Assurance: Perform testing of developed reports to ensure accuracy, data integrity, and compliance with specifications and the established branding guidelines for the Missouri. • Troubleshooting and Support: Troubleshoot and resolve issues related to existing reports and report delivery. • Documentation: Maintain documentation related to report structures, data sources, processes, and any modifications or changes. Technical Skills: • Crystal Reports: Expertise in developing reports, including creating complex reports, utilizing data structures, and applying reporting principles. • SSRS: Strong knowledge and experience with SSRS, including creating reports, charts, and graphs. • SQL: Proficiency in writing complex SQL queries, stored procedures, and functions; experience with query optimization is beneficial. • Database Knowledge: Strong understanding of relational database concepts, design, and data modeling. • Data Analysis: Strong analytical skills for interpreting data and translating business needs into effective reports. Soft Skills: • Communication: Excellent verbal and written communication skills for collaborating with stakeholders and documenting report details. • Problem-Solving: Ability to identify and resolve issues related to data and report development. • Attention to Detail: Meticulous attention to detail to ensure accuracy and data integrity in reports. • Teamwork and Collaboration: Ability to work effectively within a team environment and collaborate with others. Experience Required: • Proven work experience (typically 2-5 years or more) in report development, with significant experience in both Crystal Reports and SSRS. Education Required: • Bachelor's degree in computer science, Information Systems, or a related field, or equivalent work experience. Additional Information: • We are in the process of converting 375 of our Crystal report to SSRS reports. on site work only