Senior Software Engineer – Data / ELT (Contract)

About This Role

Job Purpose

The role is responsible for developing and maintaining scalable data integration pipelines, APIs, and ELT workflows. It ensures reliable data movement, high‑quality transformations, and optimized data models to support analytics, reporting, and business decision‑making.

Key Responsibilities

1. Data Integration & ELT Development

• Design, build, and maintain ELT pipelines for ingestion, transformation, and processing of structured/unstructured data.
• Ensure data quality, performance, and reliability across data workflows.
• Automate and schedule data jobs using orchestration tools.

2. API Development (Mandatory)

• Develop, maintain, and optimize APIs for data access, integration, and system interoperability.
• Implement secure, scalable, and high‑performance API endpoints.

3. Data Modeling & Warehousing

• Build and optimize data models, star schemas, and data marts.
• Work on performance tuning, partitioning, and distribution strategies.

4. Snowflake Development (Mandatory)

• Build Snowflake pipelines, transformations, stored procedures, and tasks.
• Manage Snowflake performance optimization and cost‑efficient architecture.

5. Dashboard & Reporting Support

• Enable analytics and reporting teams with clean, validated, well‑structured data.
• Support creation of semantic layers and optimized data sets.

6. Operational Support

• Monitor data pipelines, troubleshoot failures, and manage system performance.
• Ensure security, governance, documentation, and compliance.

Required Skills (Mandatory)

• API development experience (RESTful APIs, integrations).
• Strong Snowflake development skills (SQL, ELT, tasks, streams, stored procedures).
• SQL expertise and strong understanding of data modeling.
• Experience with ETL/ELT tools or custom pipeline development.
• Knowledge of orchestration tools (Airflow, DBT, etc.).

Good to Have

• Experience with DPT Stream / StreamSets / Kafka or similar data pipeline tools.
• Background in data visualization tools (Tableau, Power BI).
• Experience with cloud platforms (AWS, Azure, GCP).