Job Title: Senior Tableau Report Developer / Etl
Location: Hartford, CT (Hybrid)
Duration: 1 Year
Project Overview
The organization relies on mission-critical applications that support child welfare operations. These applications are extensively used by case managers and social workers and have been continuously enhanced to address evolving business, compliance, and regulatory requirements.
The organization is currently investing in a next-generation Child Welfare Information System and is seeking experienced technical professionals to support existing applications while contributing to modernization initiatives.
Position Summary
The organization is seeking a Senior Tableau Report Developer / ETL Developer to support reporting, data integration, and application development initiatives. The selected consultant will participate in all phases of the Software Development Life Cycle (SDLC), including requirements analysis, solution design, development, testing, deployment, production support, and documentation.
Scope of Work
The consultant will be responsible for:
Developing and maintaining Tableau reports and dashboards
Designing, developing, and supporting SSIS ETL packages
Supporting SOA integration initiatives
Participating in requirements reviews, design validation, testing, and deployment activities
Collaborating with business and technical teams throughout the SDLC
Providing maintenance, production support, knowledge transfer, and documentation
Key Responsibilities
General Expectations
Highly organized, proactive, and self-directed
Strong self-starter with the ability to drive work from requirements through implementation
Excellent analytical and problem-solving skills
Strong verbal and written communication abilities
Technical Responsibilities
Develop Tableau reports and dashboards
Assist with database architecture design, including relational databases, data marts, data dictionaries, and logical/physical data models
Develop strategies for data acquisition, data quality management, and data discrepancy resolution
Support data migration and integration initiatives from legacy systems to modern platforms
Develop and maintain SQL scripts, stored procedures, triggers, and database objects using Microsoft T-SQL
Access and manage data across multiple database platforms, including SQL Server and DB2
Design, develop, and implement ETL/ELT solutions for data ingestion, transformation, cleansing, and distribution
Apply data analytics and data modeling best practices in ETL pipeline development
Collaborate with Business Analysts and end users to validate requirements
Develop solutions to integrate internal and external data sources
Perform ETL testing, validation, troubleshooting, and support
Develop data conversion strategies for legacy platforms
Conduct data reconciliation, validation, and error handling activities
Optimize ETL processes and SQL performance for scalability and efficiency
Design SSIS packages, including FTP/SFTP file transfer processes
Participate in requirements gathering, data mapping, extraction, transformation, loading, testing, troubleshooting, documentation, optimization, and maintenance activities
Develop Tableau reports and deploy reporting solutions to production environments
Create advanced Tableau reporting solutions, including:
Dynamic grouping
Dynamic sorting
Drill-down reporting
Summary reporting
Cross-tab reporting
On-demand reporting
Required Skills & Experience
Professional Experience
10+ years of professional IT experience
5+ years of Tableau development experience
5+ years of experience writing complex SQL queries
5+ years of hands-on experience with:
T-SQL
SSRS
SSIS
Talend
Technical Skills
Query tuning and performance optimization
SSIS package deployment and maintenance
Git-based source control and deployment processes
SQL Agent job creation and scheduling
Transact-SQL (T-SQL) development
Stored procedure development
Talend development and maintenance
Version control systems, including TFS (Team Foundation Server)
Soft Skills
Strong problem-solving capabilities
Experience collaborating with cross-functional teams
Forward-thinking and solution-oriented mindset
Ability to manage multiple priorities effectively
Adaptability in fast-paced environments
Ability to meet aggressive deadlines
Preferred Qualifications
Experience with Salesforce
Experience with MuleSoft
Medical, dental, and vision insurance are available to qualified candidates who meet eligibility requirements.