Description
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 more years 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.
