Назад
Company hidden
6 дней назад

Senior Data Engineer (SSIS & Azure Synapse)

155 000 - 160 000$
Формат работы
hybrid
Тип работы
fulltime
Грейд
senior
Английский
b2
Страна
US
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Senior Data Engineer (SSIS & Azure Synapse): Building and optimizing enterprise data integration, warehousing, and analytics solutions with an accent on Azure pipelines, cloud migration, data modeling, and production reliability. Focus on designing scalable ETL/ELT architectures, optimizing Synapse and SQL workloads, implementing data quality and monitoring frameworks, and troubleshooting complex production data issues.

Location: Hybrid position based out of offices in Conshohocken, PA; Purchase, NY; Charlotte, NC; or Morristown, NJ.

Salary: $155,000–$160,000 annually, with actual compensation based on work location, qualifications, skills, competencies, and experience.

Company

hirify.global is a global insurance organization focused on creating value for clients and communities through accountability, agility, collaboration, development, and integrity.

What you will do

  • Design, develop, maintain, and optimize enterprise ETL/ELT pipelines using SSIS, Azure Data Factory, and Synapse Pipelines for batch and near-real-time ingestion.
  • Migrate legacy SSIS workloads to scalable, cloud-native Azure solutions and develop data platforms using Azure Synapse Analytics and Azure Data Lake Storage Gen2.
  • Design and maintain dimensional and relational data warehouse models, including fact and dimension tables, Star/Snowflake schemas, data marts, stored procedures, views, and functions.
  • Build governed data solutions supporting enterprise reporting, business intelligence, analytics, and downstream consumption.
  • Implement data quality validation, reconciliation, exception handling, logging, monitoring, alerting, metadata, lineage, and governance practices.
  • Optimize SQL, indexes, models, partitions, pipelines, and warehouse workloads; troubleshoot production failures, perform root cause analysis, and support CI/CD and release activities.

Requirements

  • 10+ years of experience in data engineering, ETL/ELT development, and enterprise data warehousing, including Microsoft SQL Server, advanced T-SQL, SSIS, Azure Data Factory, Synapse Pipelines, performance tuning, indexing, and production troubleshooting.
  • Experience designing, developing, optimizing, and supporting Azure data platforms with Azure Synapse Analytics, dedicated and serverless SQL workloads, Azure Data Lake Storage Gen2, cloud ingestion, orchestration, and legacy workload migration.
  • Strong dimensional and relational data modeling experience with Star and Snowflake schemas, fact and dimension tables, data marts, stored procedures, views, functions, SQL scripts, and enterprise reporting, BI, and analytics solutions.
  • Experience building reliable production pipelines with data quality checks, validation, reconciliation, exception handling, logging, monitoring, alerting, root cause analysis, and operational support.
  • Experience with Azure DevOps or Git, source control, branching, release management, CI/CD, environment migrations, documentation, metadata management, data governance, and data lineage.
  • Strong analytical, problem-solving, communication, stakeholder management, collaboration, prioritization, and independent working skills.
  • Ability to translate business requirements into scalable technical solutions and partner with technical teams, business stakeholders, and leadership.

Nice to have

  • Experience in the insurance industry, preferably Property & Casualty or commercial lines.
  • Python, PySpark, Azure Databricks, Delta Lake, Power BI semantic models, Microsoft Fabric, Synapse Spark Pools, REST API integrations, event-driven architectures, Master Data Management, or Microsoft Azure Data Engineer certification such as DP-203.

Culture & Benefits

  • Hybrid work environment designed to support collaboration and long-term careers.
  • Medical, pharmacy, dental, vision, Health Savings Account, and flexible spending account benefits.
  • Company-paid life, AD&D, disability, parental leave, adoption assistance, and employee assistance benefits.
  • 401(k) retirement savings plan with employer contributions, paid time off, holidays, and tax-free commuter benefits.
  • Tuition reimbursement and professional qualification benefits.
  • Inclusive workplace guided by accountability, agility, collaboration, development, integrity, and equal opportunity.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →