Azure data engineer

Software Mind; United States; Remote; USD 120,000 - 170,000; Full time

Benefits offered by this job

Private healthcare and life insurance

Knowledge-sharing initiatives

Multisport card

Language classes

Access to international projects

Job summary

Software Mind ищет специалиста по миграции данных, который возьмется за проект по переносу данных и разработке ETL-решений. В обязанности войдет проектирование и запуск конвейеров миграции, обеспечение согласованности данных и участие в планировании изменений совместно с бизнес-аналитиком.

Требуется 3+ лет опыта в миграции данных, знание T-SQL и SQL Server, а также опыт работы с Azure Data Factory и Azure DevOps. У кандидата должен быть опыт работы с JSON/XML и уверенный уровень английского (C1).

Qualifications

• Опыт не менее 3 лет в миграции данных или ETL на крупных системах.
• Глубокие знания SQL Server и SSIS; умение работать с Azure SQL Database и сопутствующими сервисами (Data Factory, Azure DevOps).
• Умение объяснить проверку корректности миграции, а не только её выполнение.

Responsibilities

• Проектирование и сборка ETL-конвейеров для миграции из устаревших баз в Azure SQL.
• Разработка логики валидации и сверки для миграций и дельта-загрузок.
• Совместная работа с бизнес-аналитиком по маппингу данных и правилам преобразования.

Skills

Data migration

ETL development

T-SQL

Data validation

Data profiling

English (C1)

Tools

SQL Server

SSIS

Azure Data Factory

Azure SQL Database

Azure DevOps

JSON/XML handling

Job description

Описание:

Software Mind develops solutions that make an impact for companies around the globe. Tech giants & unicorns, transformative projects, emerging technologies and limitless opportunities – these are a few words that describe an average day for us. Building cross-functional engineering teams that take ownership and crave more means we’re always on the lookout for talented people who bring passion and creativity to every project. Our culture embraces openness, acts with respect, shows grit & guts and combines cooperation with enjoyment.

Задачи:

• Design, build and run ETL pipelines migrating data from legacy SQL Server databases into Azure SQL Profile and reverse-engineer source schemas where documentation is incomplete, and document the model you reconstruct
• Build validation and reconciliation logic that proves completeness and correctness ahead of the initial load and every delta load
• Work with the Business Analyst on data mapping, transformation rules and the agreed data dictionary
• Execute migration rehearsal runs and support the cutover
• Follow ITIL-aligned change and release management for every production change
• Diagnose and resolve production data incidents, and contribute to root cause analysis and permanent fixes
• Maintain technical documentation for the migration components and hand it over at the end of the engagement

Требования:

• 3+ years delivering data migration or ETL development on enterprise or high-stakes systems
• Strong T-SQL and hands-on experience with Microsoft SQL Server, including SSIS
• Practical experience with Azure SQL Database and the surrounding Azure data services (Data Factory, Azure DevOps)
• Demonstrable data validation and reconciliation work: you can explain how you proved a migration was correct, not just that it ran
• Comfort working from incomplete documentation, using schema discovery and data profiling as a first step
• Experience handling JSON and XML payloads held inside relational structures
• English at C1 or above, with daily contact with international stakeholders

Будет плюсом:

• Microsoft certification, ideally DP-203 Azure Data Engineer Associate; ITIL Foundation v4, or willingness to certify (at our cost)
• Experience in a regulated, audited sector such as financial services, public sector or healthcare
• Experience with change data capture and keeping systems in sync during a parallel-run period
• Exposure to Databricks, Snowflake or dbt

Условия:

• Flexible and remote cooperation options
• International projects with leading global clients
• Travels related to international projects
• Non-corporate atmosphere
• Access* to language classes
• Access* to knowledge-sharing initiatives
• Access* to private healthcare and life insurance
• Access* to multisport card
• The availability and terms of individual benefits may vary depending on the chosen form of cooperation.