Hybrid/Local (Hartford ONLY) SSIS/SSRS/Talend/Tableau Developer

Other Jobs To Apply

About the position

The Department of Children and Families is seeking a senior-level Lead Full Stack Developer to support existing .NET applications and participate in the software development lifecycle for Connecticut’s next-generation Comprehensive Child Welfare Information System (CCWIS). The developer will work with the System Integrator to support knowledge transfer and ongoing maintenance for an assigned module. The role includes requirements verification, design, development, testing, maintenance, and support, under agency management direction. The developer will create and maintain SSRS reports and SSIS ETL packages, develop Tableau reports, support SOA integration initiatives, and participate in reviews of System Integrator deliverables, including requirements, design, testing, and environment configuration. The role also contributes to database architecture, data modeling, data quality, data migration and integration, ETL/ELT solutions, analytics practices, and data conversion from legacy systems. The position is hybrid in Hartford, Connecticut, and requires the candidate to be local and able to work in the office two days every two weeks or one day per week.

Responsibilities

  • Drive work from requirements through implementation and participate in requirements verification, design, development, testing, maintenance, and support.
  • Support existing .NET applications and participate in the SDLC for the new SACWIS system, working with the System Integrator on knowledge transfer and ongoing module maintenance.
  • Create and maintain SSRS reports and SSIS ETL packages, and develop Tableau reports.
  • Support SOA integration initiatives and participate in meetings with the System Integrator to verify requirements, design, testing, and environment-configuration deliverables.
  • Assist in designing and developing database architecture, including relational structures, data marts, data dictionaries, and logical and physical data models.
  • Develop strategies for data acquisition, data quality, and data discrepancy management.
  • Assist with migration and integration of data and processes from legacy systems to new applications and technologies.
  • Develop and maintain documented T-SQL scripts, stored procedures, and triggers in accordance with business rules and requirements.
  • Design, develop, and implement ETL/ELT solutions for data ingestion, cleansing, business-rule execution, and data distribution.
  • Apply data analytics practices to data modeling, ETL pipelines, and near-time data solutions.
  • Coordinate with business analysts and users to validate requirements and integrate external data with in-house data.
  • Test and validate data flows; prepare ETL processes according to business requirements.
  • Design and implement data-conversion strategies from legacy systems to new platforms, including design validation, reconciliation, and error handling.
  • Optimize SSIS package and SQL execution for data-load performance.
  • Design SSIS packages using file-transfer and secured-file-transfer tasks; import and export files using FTP/SFTP.
  • Participate in requirements gathering, data mapping, extraction, loading, testing, troubleshooting, documentation, performance optimization, and maintenance.
  • Develop Tableau reports and deploy reports to a report server or integrated SharePoint report server.
  • Create reports using dynamic grouping and sorting, on-demand subreports, drill-down and summary reporting, and cross-tab reports.
  • Deploy SSIS packages using Git check-in, configure environmental variables, and create corresponding SQL Agent jobs.
  • Create, deploy, and maintain Talend reports.

Requirements

  • At least 10 years of prior experience demonstrating the required knowledge and skills; the job posting also lists database data modeling and Microsoft SQL Server expertise at 10+ years.
  • More than 5 years of Tableau experience.
  • More than 5 years of experience writing complex SQL queries.
  • More than 5 years of expertise with T-SQL, SSRS, SSIS, or Talend.
  • Experience debugging queries and improving query performance.
  • Experience deploying SSIS packages using Git check-in, setting up environmental variables, and creating corresponding SQL Agent jobs.
  • Strong problem-solving, cross-functional analysis, and forward-thinking abilities.
  • Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines.
  • Strong verbal and written communication skills; ability to work in an organized, proactive, self-directed manner and drive work from requirements through implementation.
  • Local to Hartford, Connecticut, and able to work in the office two days every two weeks or one day per week.
  • Ability to access data in database management systems such as DB2 and SQL Server.

Nice-to-haves

  • Experience with Salesforce and MuleSoft.
  • Experience with Transact-SQL and stored procedures.
  • Experience creating, deploying, and maintaining Talend reports.
Back to blog

Other Jobs To Apply

Remote Commercial Product Manager – Banking & Data

1:1 Virtual Art Instructor

Certified Health Coach - Remote

Licensing Royalty Associate - Global Product Licensing (GPL) Remote

Senior Director, Associate Staff Counsel at GEICO: 100% Remote (New York City, NY, Bethesda, MD, Chicago, IL)

Remote 2D Animator for Cinematic Anime Teaser Job at Twine in Indiana

Technology Trainer at Ampcus: 100% Remote (Pasadena, CA)

Remote Social Media Copywriter – Part-Time Contract

Strategic Account Director

Crypto Twitter Content Lead: Real-Time & Witty

[PART_TIME Remote] Online Jobs For Teens-

Solutions Engineer, Wireless at T-Mobile: 100% Remote (Las Vegas, NV, Denver, CO)

Scrum Master of Application Development (Fully Remote)

Executive Assistant at QVC: 100% Remote (OH)

Hiring SAP EAM Asset Manager - Remote (W2 Contract Job)

Overnight Positions Near Me Online – Non-Phone Digital Chat Role | $25–$35/hr

Embedded ROI Processor at Datavant: 100% Remote (SC, GA, NC, MS)

Manager, Global Brand Media Ad Operations

Video Content Moderator - Remote

Care Management Support Coordinator II at Centene Corporation: 100% Remote (PA)

Remote Appointment Setter | Commission-Based - Casa de Oro-Mount Helix

Online Amazon Customer Service Representative Jobs /REMOTE/ – Part-Time – Job ID- 455 Job ID- 2633

Remote Sr. Engineer, Infrastructure Security

Supervisor, Reporting and Financial Data Governance

Remote Software Engineer in Test

Sterile Processing Instrument Coord

Seasonal Healthcare Trainer-Remote

Chief AI & Product Strategy Officer - Remote

Account Manager, Indirect Tax

Salesforce Administrator – Remote

Remote Tutoring Jobs in San Diego, CA | Wiingy Careers

Talent Acquisition Specialist II # 26-27602

17 Ways to Make Money From Home -- Side Hustles and Gig Jobs Available

Senior In-House Clinical Research Associate at Emmes Company: 100% Remote (Rockville, MD)

AI Creative Assistant (Pinterest & ChatGPT)

Tennessee Tele-Neurology Position

Inpatient Rehabilitation SME – Remote

Billing Correspondence Coordinator I (Correspondence Billing Specialist REMOTE)

On Call -Interpreter at International Institute of New England: 100% Remote (Manchester, NH)

Hobby Lobby New Job Openings $30/Hour

Remote Staff Backend Product Software Engineer, Commerce Platform

Cloudflare Architect

Basecamp Coach - Remote

Remote Facilities Manager: Lead 150 Stores & Sustainability

Work at home Customer Service Opportunity

amazon work from home $15+/ Hour (Sign on Bonus!)!

Registered Nurse (RN) - Part Time Remote Care Manager

Stay-at-Home Moms 21–42: Help bless a family - Prior Birth Required Paid$65K-$100K+

Remote 2D Background Artist — Freelance YouTube Animation

Product Engineer (Remote - US CT/ET)

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...