Data Warehouse Engineer (Junior - Mid-level)

We're Synechron, a global consultancy Laser-focused on accelerating digital initiatives in financial services with over 14,500 members of staff across 19 countries and a unique mix of end-to-end digital, business and technology services, we help clients solve complex challenges with modern and innovative solutions.
Our clients come to us with problems that need genuine thought, intelligence and knowledge; we're not just putting bodies on seats.
We are seeking a junior to mid-level DWH Engineer
Overview: The Junior to Mid-Level Data Warehouse Engineer will be responsible for designing, building, and maintaining data warehousing solutions within the Google Cloud Platform (GCP). The role requires a blend of technical data warehousing skills along with cloud-based data services expertise. The ideal candidate will have a foundational understanding of data warehousing concepts and hands-on experience with GCP services.
Responsibilities:
Design, build, test and deploy Google Cloud data models and transformations in BigQuery, environment (e.g. SQL, stored procedures, indexes, clusters, partitions, triggers, etc.)
Deliver a data warehouse and pipelines which follow abstraction and ‘database refactoring’ best practice in order to support evolutionary development and continual change
Protect the solution with appropriate Authorization and Authentication models, data encryption and other security components – this will include consumer registration and storage of identification and change management considerations
-
Review and refine, interpret and implement business and technical requirements
Ensure you are part of the on-going productivity and priorities by refining User Stories, Epics and Backlogs in Jira
Manage code artefacts and CI/CD using tools like Git, Jenkins, Google Secrets Manager, etc.
Estimate, commit and deliver requirements to scope, quality, and time expectationsJob Requirements:
Experience in database design, development and administration – understanding of relational and dimensional data models (and preferably Data Vault)
Exposure withOn-prem or Cloud Databases, Warehouses and Lakes
A good understanding of GCP Architecting and solution design
Proven experience / solid knowledge in developing and optimization of SQL/T-SQL procedures in Traditional or Cloud Databases
Coding and development of DDL and DML database components
Excellent knowledge of devops tools like Ansible , Jenkins, Github ,Puppet, Chef etc.
IT methodology/procedural knowledge; Agile/Scrum, DevOps and ITIL principles.
BS/MS degree in Computer Science, Engineering or a related subject
Synechron's Diversity Statement
Synechron are proud to be an equal opportunity employer. Our Diversity, Equity, and Inclusion (DEI) initiative Same Difference' is committed to fostering an inclusive culture - promoting equality, diversity and an environment that is respectful to all. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We offer flexible workplace arrangements, mentoring, internal mobility, learning and development programmes to support our global workforce. Empowerment and collaboration are at the core of how we operate.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant's gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.
#J-18808-Ljbffr