Our client is working through a migration from Crystal Reports to SSRS for their Pharmacy application. We are seeking an experienced SSRS Developer to collaborate in the migration of existing Crystal Reports to Microsoft SQL Server Reporting Services (SSRS 2022). This role involves analyzing current Crystal Reports, developing SSRS reports, ensuring data accuracy, and optimizing reports for performance and usability in SSRS. The ideal candidate will possess strong skills in both Crystal Reports and SSRS, with a deep understanding of SQL Server and Oracle databases and reporting best practices. Key Responsibilities: Report Development and Conversion: o Migrate Crystal Reports to SSRS, ensuring all features, formulas, and business rules are accurately replicated. o Implement SSRS-specific features (e.g., parameters, sub-reports, drill-downs) to improve report usability and functionality. o Design, develop, and deploy reports using SSRS, ensuring high-quality, visually appealing, and interactive reports tailored to business requirements. o Work with stakeholders to define report requirements, scope, and user specifications. SQL Querying & Data Integration: o Write efficient SQL queries to retrieve data from databases, ensuring accuracy and performance optimization. o Design and implement complex datasets, stored procedures, and views to support report generation. o Perform data validation and reconciliation to ensure reports reflect the most accurate and up-to-date information. • Report Optimization & Performance Tuning: o Analyze report performance and make recommendations for improvements. o Optimize queries and data processing logic to reduce report generation time and enhance user experience. o Monitor report execution, troubleshoot performance issues, and apply necessary fixes. • Report Scheduling & Security: o Set up and maintain report subscriptions, scheduling, and security access to ensure timely and secure delivery of reports to users. o Implement role-based access control to restrict access to sensitive data. Education & Certifications: • Bachelor’s Degree in Computer Science, Information Technology, or a related field, or equivalent work experience. Pay and Benefits The pay range for this position is $18.00 - $25.00/hr. Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following: • Medical, dental & vision• Critical Illness, Accident, and Hospital• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available• Life Insurance (Voluntary Life & AD&D for the employee and dependents)• Short and long-term disability• Health Spending Account (HSA)• Transportation benefits• Employee Assistance Program• Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type This is a fully remote position. Application Deadline This position is anticipated to close on Feb 21, 2025. About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.