Software Development Advisor

Job Summary

We are seeking a Senior Data Engineer (G10) with strong expertise in ETL development, Microsoft Azure, and SSIS, to join as an individual contributor.

This role focuses on designing, developing, and maintaining robust data pipelines and platforms, while also taking ownership of the data environment, ensuring stability, performance, and scalability.

The ideal candidate is a hands-on engineer with deep ETL experience, capable of working independently and ensuring the smooth operation of data systems in production.

Key Responsibilities

ETL Development & Data Engineering

• Design, develop, and maintain ETL/ELT pipelines using SSIS, Azure Data Factory, and related tools.
• Build and optimize data integration workflows across multiple data sources.
• Develop and maintain data models and transformations to support analytics and reporting.
• Write and optimize complex SQL queries for large datasets.

Azure Data Platform

• Work with Microsoft Azure services (Data Factory, Azure SQL, storage, etc.) to build scalable data solutions.
• Support migration and modernization of on-premise ETL solutions (SSIS) to Azure where applicable.
• Utilize Azure Databricks (nice to have) for advanced data processing.

Environment Ownership & Operations

• Take ownership of the data platform environment, ensuring availability, performance, and reliability.
• Monitor, troubleshoot, and resolve data pipeline and system issues in production.
• Implement and maintain scheduling, logging, and alerting mechanisms.
• Ensure data quality, consistency, and integrity across systems.

Governance & Best Practices

• Apply data governance, security, and compliance standards.
• Follow and promote best practices in ETL development, version control, and deployment.
• Contribute to documentation and standardization of data processes.

Collaboration

• Work closely with data architects, analysts, and business stakeholders to deliver data solutions.
• Support integration of data systems with downstream applications and reporting tools.

Required Skills & Experience

Mandatory

• 7-10 years of experience in data engineering and ETL development.
• Strong hands-on experience with SSIS (must-have).
• Proven experience with Microsoft Azure (Data Factory, Azure SQL, storage services).
• Strong expertise in SQL (performance tuning, optimization).
• Experience building and maintaining end-to-end ETL pipelines.
• Solid understanding of data warehousing and data modeling concepts.

Technical Skills

• Experience managing and supporting production data environments.
• Familiarity with job scheduling, monitoring, and troubleshooting tools.
• Exposure to Azure Databricks or PySpark (preferred).

Nice to Have

• Experience with Node.js for building lightweight services or integrations.
• Exposure to cloud migration projects (on-prem to Azure).
• Experience with CI/CD pipelines for data solutions.
• Familiarity with Power BI or reporting tools.

Key Competencies

• Strong ownership mindset and accountability for systems.
• Ability to work independently in an IC role.
• Excellent problem-solving and troubleshooting skills.
• Good communication and collaboration abilities.

This version positions the role as:

• Senior IC (not a manager)
• Strong ETL + SSIS backbone
• Azure-focused with modernization angle
• Accountable for environment stability (Dev + Ops blend)