Lead Developer (SSRS/SSIS)

$118,560 - $118,560/Yr

Calance - Hartford, CT

Full-time - Mid Level

Remote - Hartford, CT

Professional, Scientific, and Technical Services

About the position

The Lead Developer (SSRS/SSIS) will play a crucial role in leading development efforts within the agency, focusing on supporting existing .NET applications and participating in the SDLC process for a new SACWIS system. This position involves creating and maintaining SSRS reports and SSIS ETL packages, ensuring effective data integration, and collaborating with various stakeholders to validate requirements and deliverables.

Responsibilities

• Develops Tableau Reports.
• Assist in the design and development of the database architecture including relational data structures, data marts, data dictionaries and logical and physical data models.
• Develop strategies for data acquisitions, data quality and data discrepancy.
• Assist in migration and integration of data and processes from legacy systems to new applications and new technologies.
• Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development.
• Access data stored in various database management systems such as DB2, SQL Server and others.
• Design, develop and implement ETL/ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution.
• Implement Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions.
• Coordinate with Business Analyst and users to validate requirements.
• Implement solutions to integrate external data with in-house data.
• Perform tests and validate data flows and prepare ETL processes according to business requirements.
• Design and implement a data conversion strategy from legacy to new platforms.
• Perform design validation, reconciliation and error handling in data load processes.
• Optimize SSIS Package execution and SQL execution to enhance data load performance.
• Design SSIS packages using data exchange tasks such as File transfer and Secured File transfer.
• Involvement in all stages like Requirements gathering, Data mapping, Data extraction, Data loading, Data testing, Troubleshooting, documentation, performance optimization and maintenance.
• Development of various reports using Tableau as per user requirements and deploying to report server/ integrated SharePoint report server.

Requirements

• 10+ years of experience creating/maintaining SSRS reports and SSIS ETL packages.
• 5+ years of experience creating Tableau reports.
• 5+ years of experience writing complex SQL queries.
• 5 years of expertise with T-SQL, SSRS, SSIS and/or Talend.
• Experience with debugging and improving query performance.
• Experience with deploying SSIS packages using GiT check-in, setting up environmental variables and creating respective jobs in SQL Agent.
• Experience with creating, deploying and maintaining Talend reports.
• Experience with code control/version Team Foundation.
• Strong problem solving, cross-functional analysis and forward-thinking abilities.
• Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines.
• Very organized, pro-active and self-directed.
• Strong abstract thinking and problem-solving skills.
• Solid/Excellent verbal and written communication skills.

Nice-to-haves

• Experience with Salesforce OR MuleSoft.
• Experience with Transact-SQL and stored procedures.

Benefits

• EPO/PPO Medical Plan (Cigna)
• HMO/PPO Dental programs (Cigna)
• Vision - VSP (Vision Plan Summary)
• 401K Retirement vesting program
• Paid Bi-Weekly/Direct Deposit
• Flex Spending Plan
• Voluntary Life, AD&D, STD or LTD plans