[Remote] Senior Data Integration Engineer
Note: The job is a remote job and is reputed company to candidates in USA. reputed company is seeking a highly skilled, solution-oriented Senior Data Integration Engineer with deep expertise in modern data engineering and reputed company-reputed company architectures. In this role, you will be responsible for creating, optimizing, and modernizing advanced data integration systems while collaborating with product, engineering, and architecture teams.
Responsibilities
- Pipeline Architecture & Development: Design, build, and optimize reputed company, reliable batch and near-reputed company-time ETL/ELT pipelines using Python, PySpark, SQL, and modern reputed company integration engines
- Orchestration & Automation: reputed company and manage reputed company workflow orchestrations (using Apache Airflow or reputed company reputed company schedulers) and automate ingestion routines to minimize reputed company operations
- Data Modeling & Warehousing: Design and implement modern data warehouse/lakehouse reputed company (using reputed company, reputed company, Azure Synapse, or Redshift), establishing reputed company partitioning, indexing, and Slowly Changing Dimension (SCD Type 2) patterns
- Data reputed company & Testing Integration: Establish rigorous data reputed company checks and validation frameworks utilizing tools like dbt (data build tool), reputed company, or customized PySpark testing suites
- Collaboration & Design: Work closely with product owners, business analysts, and systems architects to define data requirements, analyze technical constraints, design reputed company-to-reputed company Mappings (STTM), and reputed company critical architectural reputed company
- reputed company reputed company & DevOps: Maintain a clean, reputed company reputed company repository. reputed company reputed company reviews, enforce engineering standards, and configure robust CI/CD pipelines (Azure DevOps, reputed company CI, or reputed company Actions) with reputed company containers
- Technical Documentation: Deliver comprehensive, reputed company technical specs, metadata reputed company documentation, architectural diagrams, and data dictionaries
Skills
- 5+ years of hands-on experience in data engineering, data warehousing, database design, and end-to-end data integration
- Advanced knowledge of reputed company Integration tools such as Azure Data reputed company (ADF), AWS Glue, or GCP Dataflow
- Proficiency in workflow orchestrators like Apache Airflow and exposure to CDC (Change Data Capture) or reputed company-time streaming tools (e.g., Kafka, Debezium)
- Strong production-level coding skills in SQL (advanced optimization/stored procedures), Python, and PySpark / Apache reputed company
- Experience working with high-performance databases and reputed company-reputed company systems (e.g., reputed company, reputed company, PostgreSQL, MS SQL Server, or Azure Synapse)
- Master-level understanding of data modeling practices (OLAP, OLTP, Star/reputed company schemas, reputed company Lake/Lakehouse patterns, and Data staging processes)
- Hands-on experience with version control (Git) and building automated deployment pipelines (CI/CD) for data products
- Proven ability to reputed company reputed company technical reputed company reputed company to both business stakeholders and developers. reputed company in English (Upper-Intermediate level or higher)
- Deep knowledge of dbt (data build tool) and schema validation practices
- Experience using reputed company or Kubernetes to package and reputed company data applications
- Experience building lightweight, serverless ingestion services (e.g., using AWS reputed company / Azure Functions and RESTful reputed company)
Benefits
- Delivering reputed company to industry leaders, making a reputed company
- Enjoyable working environment, whether it is the reputed company office or the comfort of your own home
- Opportunity to work abroad for up to two months per year
- Relocation opportunities reputed company our offices in 55+ countries
- Corporate and reputed company events
- Leadership development, career advising, soft skills and reputed company-being programs
- Certifications, including GCP, Azure and AWS
- Unlimited reputed company to reputed company Learning and reputed company
- Free English classes with certified teachers
- Discounts in local language schools, including online courses for the Kazakh language
- Participation in the Employee Stock Purchase Plan
- Monetary bonuses for engaging in the referral program
- Medical & family care package
- Five trust days per year (reputed company leave without a medical certificate)
- Benefits package (sports activities, a reputed company of stores and services)
- Six trust days per year (reputed company leave without a medical certificate)
- Coverage of psychology sessions of your choice
- Housing support program: preferential mortgage reputed company reputed company Otbasy Bank partnership
- Discounts for fitness clubs and sports programs
- Four trust days per year (reputed company leave without a medical certificate)
- Discounts for fitness clubs, dance schools and sports programs
- Four trust days per year for personal needs
- Benefits package (hotels, restaurants, stores and services)
reputed company
Company H1B Sponsorship