NMK Global Inc. is a global IT Services & Solutions company specializing in IT Staffing, Technology Consulting, Workforce Solutions, and Application Development Services. We help organizations build high-performing technology teams by connecting them with exceptional talent across a wide range of industries. Our expertise, industry knowledge, and consultative approach enable clients to achieve successful business outcomes while helping professionals advance their careers.
Role: Lead Tableau Reports Developer/ETL
Location: Hartford, Connecticut 06106
Work Arrangement: Hybrid
Work Address: 505 Hudson Street, Hartford, CT 06106
Duration: 12+ Months
Job Type: Contract
Work Schedule: Monday–Friday, 8:00 AM–5:00 PM (40 hours/week)
Candidate Location: Local candidates from Connecticut are required.
Job Description:
The Connecticut Department of Children and Families (DCF) is seeking an experienced Lead Tableau Reports Developer/ETL to support existing .NET applications and participate in the Software Development Life Cycle (SDLC) for the next-generation Comprehensive Child Welfare Information System (CCWIS).
The candidate will work with agency management, business analysts, end users, and the system integrator to support application development, reporting, data integration, data migration, and ongoing system maintenance.
The role involves developing and maintaining Tableau reports, SSRS reports, SSIS ETL packages, complex SQL queries, and data integration solutions. The candidate will also participate in requirements verification, solution design, development, testing, deployment, troubleshooting, performance optimization, documentation, and maintenance.
Roles and Responsibilities:
- Develop, deploy, and maintain Tableau reports based on business and user requirements.
- Create and maintain SSRS reports and SSIS ETL packages.
- Design and support database architecture, including relational data structures, data marts, data dictionaries, and logical and physical data models.
- Develop and maintain complex Microsoft T-SQL queries, stored procedures, triggers, and SQL scripts.
- Design, develop, and implement ETL/ELT solutions for data ingestion, cleansing, transformation, business rule execution, and data distribution.
- Develop data acquisition strategies and implement data quality and discrepancy management processes.
- Support data migration and integration from legacy systems to new applications and technologies.
- Design and implement data conversion strategies for migration from legacy platforms to new systems.
- Integrate external data sources with internal systems.
- Access and work with data stored in DB2, Microsoft SQL Server, and other database management systems.
- Validate data flows, perform data reconciliation, and implement error-handling procedures.
- Optimize SQL queries, SSIS packages, and data-loading processes for improved performance.
- Develop SSIS packages for file transfers, including secure FTP/SFTP operations.
- Deploy SSIS packages using version control, configure environment variables, and create corresponding SQL Server Agent jobs.
- Develop Tableau reports with dynamic grouping and sorting, drill-down functionality, summary reports, cross-tab reports, and on-demand subreports.
- Deploy reports to report servers and integrated SharePoint report servers.
- Collaborate with business analysts and end users to gather and validate requirements.
- Participate in requirements gathering, data mapping, extraction, loading, testing, troubleshooting, documentation, and ongoing maintenance.
- Work with the system integrator to review and validate requirements, design documents, testing deliverables, and environment configurations.
- Support Service-Oriented Architecture (SOA) integration initiatives and existing .NET applications.
- Demonstrate strong problem-solving skills, initiative, organization, and the ability to drive work from requirements through implementation.
Required Skills and Experience:
- 10+ years of overall relevant professional experience.
- 5+ years of experience developing Tableau reports and dashboards.
- 5+ years of experience writing complex SQL queries.
- 5+ years of experience with T-SQL, SSRS, SSIS, or Talend.
- Strong experience with Microsoft SQL Server, Transact-SQL, and stored procedures.
- Experience debugging and optimizing SQL queries and database performance.
- Experience deploying SSIS packages using Git check-ins or version control, configuring environment variables, and scheduling jobs through SQL Server Agent.
- Experience with Team Foundation Server (TFS) or equivalent version control tools.
- Experience creating, deploying, and maintaining Talend-based solutions and reports.
- Experience with data modeling, data integration, data migration, and ETL pipeline development.
- Experience working with DB2 and SQL Server databases.
- Strong analytical, problem-solving, and cross-functional collaboration skills.
- Excellent verbal and written communication skills.
- Ability to manage multiple tasks, adapt to changing requirements, and meet tight deadlines.
- Ability to work independently and proactively throughout the development lifecycle.
Preferred Skills:
- Salesforce.
- MuleSoft.
- Experience supporting legacy system modernization and enterprise application integration.
- Experience with child welfare, government, or public-sector information systems.
Work Schedule and Compliance:
- Full-time contract engagement: 40 hours per week.
- Monday through Friday, 8:00 AM–5:00 PM.
- Hybrid work arrangement in Hartford, Connecticut.
- Must comply with the DCF Child Protection Background Check requirements.
- Must sign and comply with the DCF Non-Disclosure Agreement.
- Subject to applicable vendor qualification and State of Connecticut IT professional services requirements.
NMK Global Inc. is an Equal Opportunity Employer. We are committed to creating an inclusive workplace and consider all qualified applicants without regard to age, race, color, religion, sex, national origin, disability, protected veteran status, sexual orientation, gender identity, or any other characteristic protected by applicable law.
