[Hiring] SSRS/SSIS Engineer @L R S

Role Description

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.

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.

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.