Careers

Looking for more than just another assignment? We're looking for you.

This is more than a contract opportunity. It's a chance to join a team supporting critical business intelligence and data integration initiatives while making a meaningful impact across the organization.

LRS Consulting Services is seeking 2 experienced SSRS / SSIS Developer for a 12-month contract opportunity with our client in Central Illinois.

Since 1979, LRS Consulting Services has delivered high-quality technical consultants to leading organizations across the country. We have built our reputation on honesty, integrity, and respect for our clients and consultants alike. We are looking for professionals who share those values and are passionate about delivering exceptional results.

Position Overview

We are seeking an experienced SSRS / SSIS Developer to support the design, development, enhancement, and maintenance of enterprise reporting and data integration solutions. This individual will play a key role in delivering business intelligence capabilities, data movement processes, and reporting solutions that support operational and strategic decision-making.

The ideal candidate will possess strong expertise in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL development, and data warehousing concepts. This role will work closely with business stakeholders, analysts, and technical teams to develop scalable reporting solutions, optimize ETL processes, and ensure data accuracy and reliability across the organization.

Key Responsibilities

• Design, develop, maintain, and support SSRS reports, dashboards, and analytical reporting solutions.
• Develop and support SSIS packages for data extraction, transformation, and loading (ETL) processes.
• Gather reporting requirements and translate business needs into technical solutions.
• Create and optimize complex SQL queries, stored procedures, functions, and views.
• Design and maintain data integration solutions between internal and external systems.
• Troubleshoot and resolve report performance issues, ETL failures, and data quality concerns.
• Monitor scheduled jobs, ETL processes, and reporting environments to ensure reliability and performance.
• Collaborate with business users, analysts, and technical teams to identify reporting and data integration opportunities.
• Develop and maintain documentation for ETL workflows, report specifications, data mappings, and support procedures.
• Participate in testing, deployment, and production support activities.
• Perform root cause analysis and implement corrective actions for recurring reporting and integration issues.
• Ensure compliance with data governance, security, and auditing requirements.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent professional experience.
• 5+ years of experience developing and supporting Microsoft SQL Server solutions.
• Strong hands-on experience with SQL Server Reporting Services (SSRS).
• Strong hands-on experience with SQL Server Integration Services (SSIS).
• Advanced T-SQL development skills, including stored procedures, views, functions, and performance tuning.
• Experience designing and supporting ETL processes and data integration solutions.
• Experience working with relational database systems and data warehousing concepts.
• Knowledge of database performance optimization and query tuning techniques.
• Experience supporting reporting environments within enterprise organizations.
• Excellent analytical, troubleshooting, and problem-solving skills.

Preferred Qualifications

• Experience with Power BI reporting and dashboard development.
• Experience with SQL Server Analysis Services (SSAS).
• Knowledge of data warehouse design methodologies, including star and snowflake schemas.
• Experience integrating data from ERP, CRM, financial, or operational systems.
• Familiarity with Azure Data Factory, Azure SQL, or cloud-based data solutions.
• Experience working within Agile development environments.
• Experience with source control and DevOps best practices.
• Exposure to enterprise data governance and master data management initiatives.

Technical Skills

• Microsoft SQL Server Technologies
• SQL Server
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• SQL Server Management Studio (SSMS)
• SQL Server Agent
• Database Development
• T-SQL
• Stored Procedures
• Functions
• Views
• Query Optimization
• Performance Tuning
• Data Integration & Warehousing
• ETL Development
• Data Mapping
• Data Validation
• Data Cleansing
• Data Warehousing
• Dimensional Modeling

Reporting & Analytics

• SSRS Reports
• Report Builder
• Dashboard Development
• KPI Reporting
• Operational Reporting
• Business Intelligence Solutions
• Preferred Tools
• Power BI
• SSAS
• Azure Data Factory
• Azure SQL
• Azure DevOps
• Git

Preferred Competencies

• Strong communication skills with both technical and business stakeholders.
• Ability to translate business requirements into scalable reporting and data solutions.
• Strong analytical and problem-solving abilities.
• Experience leading reporting and data integration initiatives.
• Ability to manage multiple priorities in a fast-paced environment.
• Self-motivated with the ability to work independently and collaboratively within cross-functional teams.

Compensation

The pay range for this contract position is $55.00 to $75.00 per hour, depending on experience, skills, education, and location. Compensation decisions are based on several factors, including relevant experience, technical expertise, and market considerations.

Additional Requirements

• Candidate must be able to effectively communicate in English, both verbally and in writing.
• Candidate must have permanent authorization to work in the United States for any employer. Sponsorship is not available for this position.

LRS is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information, citizenship status, protected veteran status, or any other characteristic protected by applicable law.

In some cases, LRS Consulting uses generative artificial intelligence (“AI”) in support of our hiring processes. LRS takes steps to ensure the use of AI does not result in discrimination based on protected class(es). AI may be used in the hiring process solely in support of the assessment of candidate qualifications. All decisions in the hiring process are made by LRS employees. If AI will be used in the hiring process for the position for which you are applying, you will be notified and will have the opportunity to opt out. Please contact AI.Questions@lrs.com with any questions.

Colorado Pay Range:
55.00 - 75.00/per Hour