Senior Database Developer (SQL) IRC298970

GlobalLogic; Buenos Aires; Presencial; ARS 89.531.000 - 134.296.000; Jornada completa

Descripción de la vacante

GlobalLogic is seeking a Senior Database Developer to lead data engineering for our Care Connect reporting data warehouse. You will own data mapping from source systems to the warehouse and implement warehouse tables while writing SSIS synchronization code.

You will work with on-premise SQL Server and SSIS, interfacing with product managers to translate requirements into robust ETL pipelines and daily batch integrations, while exploring more frequent schedules as data grows.

Formación

• 5+ years of relevant experience at Senior Engineer I or II level.
• Deep expertise in on-premise Microsoft SQL Server and SSIS.
• Experience building Data Warehouse structures and robust ETL pipelines.
• Experience extracting data from flat files and SQL Server.
• Strong ability to communicate with non-technical stakeholders and Product Managers.
• Comfort with AI developer tools (e.g., GitHub Copilot, Claude).

Responsabilidades

• Define data mapping rules with PMs and source teams.
• Design and implement CC Reporting data warehouse tables on-premise SQL Server.
• Build, optimize, and maintain SSIS ETL/synchronization pipelines.
• Manage 10–20 GB data scale with overnight batch sync; explore more frequent schedules.
• Troubleshoot data synchronization issues for CC Reporting.
• Document features and track tickets in Rally/Jira; participate in reviews and roadmaps.

Conocimientos

SQL Server

SSIS

Data Warehouse

ETL

Data Mapping

Batch Processing

Communication

AI tooling

Descripción del empleo

About the Role
We are looking for a Senior Database Developer to act as the primary execution-focused data engineer for our Care Connect (CC) Reporting data warehouse. This role is crucial for our upcoming Messenger product integration. You will be responsible for driving the data mapping from source systems to the Data Warehouse, implementing the warehouse tables, and writing the SSIS synchronization code. The environment relies on on-premise SQL Server and SSIS, and we are looking for a developer who excels in this specific tech stack to ensure seamless daily batch integrations.

Requirements

Qualifications & Requirements
Experience Level:5 or moreyears of relevant experience (Senior Engineer I or II).

Technical Expertise: Deep, execution-focused expertise in on-premise Microsoft SQL Server and SSIS.

Architecture & Design: Ability to implement Data Warehouse structures and robust ETL pipelines (no strict requirement for enterprise-level Star/Snowflake architecture design, but strong execution of DW principles is expected).

Source Integration: Experience extracting and synchronizing data from flat files and SQL Server databases.

Communication: Excellent ability to interface with non-technical stakeholders and Product Managers to define technical specifications and mapping rules from scratch.

AI Tooling: Openness to working in an environment that utilizes modern AI developer tools (e.g., GitHub Copilot, Claude).

Job responsibilities

Key Responsibilities
Data Mapping & Translation: Work directly with the Product Manager and source system development teams to define mapping rules, utilizing strong business acumen to translate operational data into reporting structures.

Warehouse Implementation: Design and implement the CC Reporting data warehouse tables within an on-premise SQL Server environment.

ETL/Synchronization Pipeline: Build, optimize, and maintain SSIS code for data synchronization between operational databases (SQL Server DBs and flat files) and the CC Reporting data warehouse.

Optimization: Manage a 10 to 20 GB data scale, currently running on a daily overnight batch sync, with the potential to explore and implement more frequent synchronization schedules.

Troubleshooting: Investigate and resolve customer issues related to existing CC Reporting data synchronization installs and execution.

Agile Workflow: Document features and track support tickets in Rally (moving to Jira), participating in weekly reviews and quarterly roadmap planning.

What we offer

Exciting Projects: Come take your place at the forefront of digital transformation! With clients across all industries and sectors, we offer an opportunity to work on market-defining products using the latest technologies.

Collaborative Environment:Expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!

Work-Life Balance:GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules.We offer you the best quality of work life so that you exceed the expectations of our clients, while achieving your professional and personal ambitions.

Professional Development:Our dedicated Learning & Development team regularly organizes English classes, professional certifications, and technical and soft skill trainings. We also offer the chance to travel internationally

Excellent Benefits:We provide our employees with competitive salaries, family medical insurance, extended paternity leave, annual performance bonuses, and referral bonuses.

About GlobalLogic

GlobalLogic, a Hitachi Group Company, is a trusted digital engineering partner to the world’s largest and most forward-thinking companies. Since 2000, we’ve been at the forefront of the digital revolution – helping create some of the most innovative and widely used digital products and experiences. Today we continue to collaborate with clients in transforming businesses and redefining industries through intelligent products, platforms, and services.