At a Glance
- Tasks: Lead MySQL schema governance and collaborate with data teams to enhance data quality.
- Company: Join a forward-thinking company focused on data excellence and innovation.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Why this job: Make a significant impact on data governance and work with cutting-edge technologies.
- Qualifications: 5 years of experience in relational schema design and SQL optimisation.
- Other info: Dynamic team environment with a focus on collaboration and career advancement.
The predicted salary is between 36000 - 60000 Β£ per year.
Responsibilities
- Lead MySQL / Aurora schema governance, including standards for table design, column definitions, naming, indexing, and documentation.
- Collaborate closely with Data BPs, Data Engineers, and Application Developers to drive data governance from source systems and improve upstream data quality.
- Operate the DDL / Schema Review workflow to ensure all schema changes align with standards and support downstream data platform requirements.
- Identify and remediate common structural issues (e.g., improper data types, inconsistent naming, schema mismatches between test and production).
- Provide guidance to application developers and assist in SQL analysis and optimization to resolve common performance issues in business queries.
- Promote schema and environment consistency across test and production systems.
- Support security, compliance, and audit needs (access control, privilege management, sensitive data identification).
- No infrastructure-level DBA duties (no deployment, HA operations, or backup management).
Requirements
- 5 years relevant working experience.
- Strong understanding of relational schema design, data types, indexing strategy, and data modeling principles.
- Ability to analyze and optimize business SQL queries using tools like EXPLAIN / execution plans, indexing strategies, etc.
- Experience working with data teams (Data BPs / Data Engineers) and application developers on data quality and governance initiatives.
- Familiar with Linux/Unix fundamentals.
- Experience in data governance or data platform projects is a plus.
- Financial or transactional system experience preferred.
- Able to use Chinese and English as daily working language to align with Chinese speaking stakeholders.
Data Platform Engineer(Architect) in London employer: DUOTECH PTE. LTD.
Contact Detail:
DUOTECH PTE. LTD. Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land Data Platform Engineer(Architect) in London
β¨Tip Number 1
Network like a pro! Reach out to your connections in the data field, especially those who work with MySQL or Aurora. A friendly chat can lead to insider info about job openings that aren't even advertised yet.
β¨Tip Number 2
Show off your skills! Prepare a portfolio or a case study showcasing your experience with schema governance and SQL optimisation. This will give you an edge during interviews and help us see your practical knowledge in action.
β¨Tip Number 3
Practice makes perfect! Brush up on your SQL analysis skills and be ready to tackle some real-world problems during interviews. We love seeing candidates who can think on their feet and solve issues related to data quality and governance.
β¨Tip Number 4
Apply through our website! Itβs the best way to ensure your application gets noticed. Plus, weβre always on the lookout for passionate individuals who can contribute to our data platform projects.
We think you need these skills to ace Data Platform Engineer(Architect) in London
Some tips for your application π«‘
Tailor Your CV: Make sure your CV is tailored to the Data Platform Engineer role. Highlight your experience with MySQL, schema governance, and any relevant projects you've worked on. We want to see how your skills align with our needs!
Showcase Your Collaboration Skills: Since this role involves working closely with Data BPs, Data Engineers, and Application Developers, be sure to mention any collaborative projects you've been part of. We love seeing teamwork in action!
Highlight Your Problem-Solving Abilities: Weβre looking for someone who can identify and fix structural issues in data schemas. Share examples of how you've tackled similar challenges in the past. Itβll show us youβre the right fit for the job!
Apply Through Our Website: Donβt forget to apply through our website! Itβs the best way for us to receive your application and get to know you better. We canβt wait to see what you bring to the table!
How to prepare for a job interview at DUOTECH PTE. LTD.
β¨Know Your Data Inside Out
Make sure you brush up on your MySQL and Aurora schema governance knowledge. Be ready to discuss table design, indexing strategies, and how youβve tackled data quality issues in the past. This will show that youβre not just familiar with the concepts but can apply them effectively.
β¨Collaborate Like a Pro
Since this role involves working closely with Data BPs, Data Engineers, and Application Developers, think of examples where you've successfully collaborated with different teams. Highlight your communication skills and how youβve driven data governance initiatives in previous roles.
β¨Show Off Your SQL Skills
Prepare to dive deep into SQL analysis during the interview. Familiarise yourself with tools like EXPLAIN and execution plans, and be ready to discuss how youβve optimised queries in the past. This will demonstrate your technical prowess and problem-solving abilities.
β¨Be Ready for Real-World Scenarios
Expect scenario-based questions that test your understanding of schema governance and data quality. Think about common structural issues youβve encountered and how you resolved them. This will help you showcase your practical experience and critical thinking skills.