Microsoft SQL Server / Tableau Developer

Vector Consulting - Hartford, CT

Full-time - Senior

Hartford, CT

Professional, Scientific, and Technical Services

About the position

The Microsoft SQL Server / Tableau Developer position is a senior-level role focused on leading the development and maintenance of data solutions for a government client. The candidate will participate in the software development life cycle (SDLC), supporting existing .NET applications and contributing to the new SACWIS system. Key responsibilities include creating and maintaining SSRS reports, developing ETL packages, and ensuring effective data integration and analytics practices.

Responsibilities

• Develop Tableau Reports based on user requirements.
• Assist in designing and developing database architecture including relational data structures and data models.
• Develop strategies for data acquisition, quality, and discrepancy resolution.
• Assist in migrating and integrating data from legacy systems to new applications.
• Develop and maintain custom SQL scripts, stored procedures, and triggers using Microsoft T-SQL.
• Access data from various database management systems such as DB2 and SQL Server.
• Design and implement ETL/ELT solutions for data ingestion and cleansing.
• Coordinate with Business Analysts to validate requirements.
• Implement solutions to integrate external and in-house data.
• Perform tests and validate data flows according to business requirements.
• Design and implement data conversion strategies from legacy to new platforms.
• Optimize SSIS package execution and SQL performance.
• Design SSIS packages for data exchange tasks and file transfers.
• Involve in all stages of data processing including requirements gathering, data mapping, and performance optimization.
• Develop various reports using Tableau and deploy them to report servers.

Requirements

• 10+ years of experience in IT with a focus on data solutions.
• 5+ years of experience with Tableau.
• 5+ years of experience writing complex SQL queries.
• 5+ years of expertise with TSQL, SSRS, SSIS, or Talend.
• Experience debugging and improving query performance.
• Experience deploying SSIS packages using git and SQL Agent.
• Experience with Transact-SQL and stored procedures.
• Experience creating and maintaining Talend reports.
• Experience with code control/versioning using Team Foundation.
• Strong problem-solving and analytical skills.
• Flexibility to adapt to changing situations and meet tight deadlines.

Nice-to-haves

• Experience with Salesforce.
• Experience with MuleSoft.

Benefits

• Hybrid work environment
• Renewable contract opportunity
• Opportunity to work with government clients
• Professional development opportunities