etldata warehousingci cdazure devopst sqlssisazure data factorysql serverazure synapseazure data lake storage
Вакансия из Hirify Global, списка международных tech-компаний Для мэтча и отклика нужен Plus
Пожаловаться
Зарплата и рынок
Средняяразвернуть
$155к-160к/год
$130к$160кмедиана$170к
По похожим ролям (49) ~ $160к/год
На СНГ рынке: $3.8к/мес ($3к - $4.3к)
84
Хорошая вакансия
развернуть
Обязанности описаны четко, а работа охватывает серьезные задачи по инженерии данных в Azure для крупной компании. При этом требование от 10 лет опыта и гибридный формат в конкретных офисах США ограничивают доступность вакансии.
Актуальные технологии
Четкие задачи
Развитые льготы
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Подключить Plus
Описание вакансии
Текст:
Hirify AI/Оригинал
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.
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, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →