New

SSRS Developer

TEKsystems
$25.00 - $45.00 / hr
life insurance, sick time, 401(k), retirement plan
United States, Texas, Galveston
Jan 29, 2025
This is a remote contract but candidates must reside in one of the following states and be able to work on a W2 contract: Alabama, Alaska, Arkansas, Florida, Georgia, Idaho, Indiana, Iowa, Louisiana, Mississippi, Ohio, South Carolina, South Dakota, Texas or West Virginia Description Our client is working through a migration from Crystal Reports to SSRS for their Pharmacy (PRS) application. Job Overview: 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: * Migrate Crystal Reports to SSRS, ensuring all features, formulas, and business rules are accurately replicated. * Implement SSRS-specific features (e.g., parameters, sub-reports, drill-downs) to improve report usability and functionality. * Design, develop, and deploy reports using SSRS, ensuring high-quality, visually appealing, and interactive reports tailored to business requirements. * Work with stakeholders to define report requirements, scope, and user specifications. * SQL Querying & Data Integration: * Write efficient SQL queries to retrieve data from databases, ensuring accuracy and performance optimization. * Design and implement complex datasets, stored procedures, and views to support report generation. * Perform data validation and reconciliation to ensure reports reflect the most accurate and up-to-date information. * Report Optimization & Performance Tuning: * Analyze report performance and make recommendations for improvements. * Optimize queries and data processing logic to reduce report generation time and enhance user experience. * Monitor report execution, troubleshoot performance issues, and apply necessary fixes. * Report Scheduling & Security: * Set up and maintain report subscriptions, scheduling, and security access to ensure timely and secure delivery of reports to users. * Implement role-based access control to restrict access to sensitive data. Additional Skills & Qualifications * Technical Skills: * Strong experience with SSRS and SAP Crystal Reports. * Proficient in SQL for writing complex queries, stored procedures, and views. * Knowledge of data visualization best practices and report design standards. * Familiarity with SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) is a plus. * Ability to integrate SSRS with other tools like Power BI and SharePoint is a plus. * Experience: * 5+ years of experience in SSRS report development. * 3+ years of hands-on experience in Crystal Reports development. * 5+ years of experience in Oracle-based database solutions, including query, stored procedures, triggers and PL/SQL packages development. * Previous experience in handling large datasets and optimizing performance for report execution. * Analytical Skills: * Strong problem-solving and troubleshooting skills. * Ability to analyze complex business problems and design effective reporting solutions. * Communication Skills: * Strong written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders. * Ability to collaborate with cross-functional teams to gather reporting requirements and provide status updates. ________________________________________ Preferred Qualifications: Experience with Power BI or other business intelligence tools. Experience with data modeling, ETL processes, and database performance tuning. ________________________________________ 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 $25.00 - $45.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 Jan 31, 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.