SSIS Developer

GeekSoft Consulting is seeking an experienced SSIS Developer to support a high-impact project with the Govt Client. This role is part of a broader effort to transition legacy systems into centralized, cloud-based data platforms. The consultant will play a vital role in database design, integration, automation, and visualization efforts across a complex data environment.


Requirements

Assist in the design and migration of legacy systems to centralized cloud infrastructure.
Develop and maintain complex SQL Server databases and ensure optimal performance.
Create ETL workflows and automate data movement using SSIS.
Design logical and physical data models to support scalable solutions.
Develop dashboards and reports using Power BI and SSRS.
Optimize SQL queries and database performance.
Create detailed technical documentation for all work performed.
Work closely with cross-functional teams, both technical and non-technical, to ensure data integrity and availability.

Mandatory Skills:
SQL Server Integration Services (SSIS)
Data Modeling
Database Design

Preferred/Additional Skills:
Query Optimization
SQL Server Reporting Services (SSRS)
Power BI
Informatica
Experience with Microsoft DevOps



Benefits

Opportunities to work on public sector, enterprise-scale projects
Consistent long-term engagements with potential for extension
Direct collaboration with technical leadership and government stakeholders
Exposure to modern cloud migration initiatives
Clear deliverables and milestone-based outcomes
Supportive coordination from the GeekSoft delivery team
Flexible work environments depending on client need (remote/hybrid possible)