Senior Database Developer (SQL) IRC298970

GlobalLogic; Argentina; Presencial; ARS 300.000 - 600.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Competitive salary

Family medical insurance

Paternity leave

Bonuses

Referral bonuses

Descripción de la vacante

GlobalLogic seeks a Senior Database Developer to lead data engineering for the Care Connect Reporting data warehouse, driving data mapping from source systems to the warehouse and implementing warehouse tables in an on-premise SQL Server environment.

You will write SSIS synchronization code, optimize batch integrations, and collaborate with Product Managers to translate requirements into robust DW solutions. This role emphasizes execution excellence and hands-on DW implementation.

Formación

• 5+ years of relevant experience as Senior Engineer I or II.
• Deep execution-focused expertise in on-premise Microsoft SQL Server and SSIS.
• Ability to implement Data Warehouse structures and robust ETL pipelines.
• Experience extracting and synchronizing data from flat files and SQL Server databases.
• Excellent interface with non-technical stakeholders and Product Managers to define technical specifications and mapping rules.

Responsabilidades

• Define mapping rules with Product Manager and source system teams to translate operational data into reporting structures.
• Design and implement the CC Reporting data warehouse tables in an on-premise SQL Server environment.
• Build, optimize, and maintain SSIS code for data synchronization between operational DBs and the data warehouse.
• Manage data scale from 10 to 20 GB with daily overnight batch sync and potential for more frequent schedules.
• Troubleshoot customer issues related to existing data synchronization installs and executions.
• Document features and track support tickets in Rally (moving to Jira) and participate in weekly reviews and quarterly roadmap planning.

Conocimientos

SQL Server

SSIS

ETL

Data mapping

Stakeholder comms

Agile

AI tooling

Herramientas

SQL Server

SSIS

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.