- Company Name
- ST Global Tech LLC
- Job Title
- Data Engineer (SSIS)
- Job Description
-
Job Title: Data Engineer (SSIS)
Role Summary: Design, develop, and maintain end‑to‑end data pipelines, data modelling, and data warehousing solutions for Private Client Transactional and Lending teams. Deliver self‑service data products using Azure services and on‑prem SQL Server, preparing a cloud‑only architecture for future migration.
Expactations:
- Immediate availability, short‑term contract (6 months), 3‑day onsite hybrid schedule.
- High‑quality, scalable ETL solutions; ownership from ingestion to consumption.
- Collaboration with Architects, Engineering leads, Analytics, DevOps, DBAs, and application teams.
- Clear communication with stakeholders, documentation, and knowledge transfer.
Key Responsibilities:
- Build and manage SSIS packages, Azure Data Factory pipelines, and Synapse workflows.
- Develop T‑SQL scripts, stored procedures, functions, and performance‑tuned queries.
- Design dimensional and Data Vault 2.0 models; create data marts and Analysis Services cubes.
- Maintain on‑prem SQL Server environments and plan phased migration to Azure (ADLS Gen2, Databricks, Synapse).
- Implement CI/CD using Azure DevOps, Git, and source control.
- Monitor, troubleshoot, and optimize ETL performance; ensure data quality and integrity.
- Produce documentation, run‑books, and deliverables for business and technical stakeholders.
- Participate in data governance, security, and regulatory compliance activities.
Required Skills:
- Strong T‑SQL and SQL programming (SQL Server, SSMS).
- Extensive SSIS development experience.
- Data warehouse modelling (Kimball, dimensional, Data Vault 2.0).
- Azure services: Data Factory, Databricks, Synapse Analytics, ADLS Gen2.
- Analysis Services (multidimensional & tabular) development.
- Source control (Git), Azure DevOps pipelines, release management.
- Analytical thinking, problem‑solving, and strategic decision‑making.
- Excellent written and verbal communication; stakeholder engagement.
- Self‑motivation, ownership, and delivery focus under pressure.
Required Education & Certifications:
- Bachelor’s degree in Computer Science, Information Systems, or related field.
- Microsoft Certified: Azure Data Engineer Associate or equivalent SSIS certification preferred.