Transformation Engineer | 6 Month Contract (Inside IR35) Hybrid Working | SHEFFIELD
Synechron is a global consultancy 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.
We are seeking a mid level Transformation Engineer with specific and strong database design experience (4-5 years)
The Role:
- The crux of the job is to design, build, test and deploy data APIs for downstream consumers to access the data on Google BigQuery Warehouse.
- The Data Engineer will also optimise data and API granularity, flexibility and autonomy with the use of materialised views, query parameters, schema design partitions, indexes, down-sampling, etc.
- To manage trade-offs between data volumes, scope, timing and performance.
- Design, build, test and deploy Google Cloud data models and transformations in BigQuery, Datafusion environment (eg SQL, stored procedures, indexes, clusters, partitions, triggers, etc.)
- Optimize data views for specific visualization use cases making use of schema design partitions, indexes, down-sampling, archiving, etc. to manage trade-offs such as performance and flexibility
- Protect the solution with appropriate Authorization and Authentication models, data encryption and other security components
- 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 expectation
Job requirements
- Expert in database design - both relational and dimensional data models (and preferably Data Vault) in Google BigQuery or similar Cloud technology
- 1+ years of proven recent experience developing, refactoring, optimization of SQL/T-SQL
- Expertise in Administration and Development of On-prem or Cloud Databases, Warehouses and Lakes
- Data preparation, wrangling and refactoring skills, for example as part of a Data Science pipelines
- Expert in the preparation, usage, visualization and editing of data in web, dashboard or other user interfaces (3-tier architecture, CRUD procedures, etc.)
- Excellent understanding of GCP Architecting and solution design
Immediate start available
Requiring 3 days in Sheffield
Applicants must be eligible to work in the UK
Synechron is a global consultancy, Laser-focused on accelerating digital initiatives in financial services. With over 14,500 members of staff across 17 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.
We're big enough to be taken seriously, yet small enough to operate with an agile, open, relationship-driven approach. Our clients come to us with problems that need genuine thought, intelligence and knowledge; we're not just putting bodies on seats.
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.
Posted Date: 08 May 2024
Reference: JSRB_PMPIPE_080524
Company: Synechron
Contact: Synechron