Kelly Services Lead SSRS/SSIS Developer in Cedar Rapids, Iowa

Title: Lead SSRS/SSIS Developer

Location: Cedar Rapids, IA

Client: Insurance/Financial Services

Contract, around 8 months

The Lead SSRS/SSIS Developer will provide Solution Design for Reporting and ETL processes, analysis of best practices and technologies. Will lead a team of three developers and a Business Analyst in converting manual business processes into automated processes. This could be achieved through some of the tools above like Alteryx, SQL Server, Informatica, etc.

  • Analyze, develop, test, maintain and support complex data/process models, reports and processes in an ETL environment using SSIS and SSRS

  • Drive the technical design of SSRS/ETL architecture to ensure high data quality, data integration performance and error recovery/handling.

  • Review and assess existing SSRS/ETL applications, to support new features, performance improvements, upgrades, and ongoing sustainment

  • Conduct design reviews, code reviews, performance tuning

  • Research and recommend future improvements in the Reporting operational environments

  • Deliver Best practice documentation


  • 8+ years of experience with MS SQL Server and expertise in SQL, SSRS, creating/monitoring SSIS packages, developing stored procedures and validating data sources

  • Expert skill in data integration, data modeling and data architecture skills

  • Experience with data modeling technologies (such as SSAS) required

  • ETL development (could be in Informatica, SSIS, Alteryx or similar too)

  • Able to communicate and summarize work stream status effectively

  • Able to map user stories-design and design-code traceability

  • Hands-on with PowerShell or JavaScript, or similar

  • Nice to have: Microsoft Office development tools (Excel and Access)

Interested in this role? Have Questions? Please feel free to reach out directly or 720-863-7863

Why Kelly ® ?

With Kelly, you’ll have direct connections to leading IT organizations in the best companies around the globe—offering you the chance to work on some of today’s most intriguing, innovative and high-visibility projects. In a field where change is the only constant, our connections and opportunities will help you take your career exactly where you want to go. We work with 95 of the Fortune 100™ companies, and more than 9,000 IT hiring managers turn to us each year to access the best talent: people like you.

Last year we found 10,000 opportunities for IT professionals. Let us help advance your career today.

AboutKelly Services ®

As a workforce advocate for over 70 years, we are proud to have a role in managing employment opportunities for more than one million workers around the globe. We employ 550,000 of these individuals directly with the remaining workers engaged through our talent supply chain network of supplier partners. Revenue in 2015 was $5.5 billion. Visit and connect with us on Facebook , LinkedIn and Twitter .

Kelly Services is an equal opportunity employer including, but not limited to, Minorities, Females, Individuals with Disabilities, Protected Veterans, Sexual Orientation, Gender Identity and is committed to employing a diverse workforce. Equal Employment Opportunity is The Law. at