At a Glance
- Tasks: Join us as a GCP Data Analyst to modernise legacy data systems and design enterprise-grade data products.
- Company: Be part of a global consulting firm leading the way in cloud data solutions.
- Benefits: Enjoy hybrid work flexibility, with 2-3 days onsite per week and potential contract extension.
- Why this job: This role offers hands-on experience with cutting-edge technology and collaboration with talented teams.
- Qualifications: You need advanced skills in SQL, Python, and experience with Google Cloud Platform components.
- Other info: Start ASAP and make a real impact in the world of data migration!
The predicted salary is between 48000 - 72000 £ per year.
A global consulting firm is looking for an experienced Data Analyst with strong expertise in cloud data platforms to support the migration and modernisation of legacy data systems onto Google Cloud Platform (GCP). You’ll work closely with data modellers to design and implement enterprise-grade data products.
Responsibilities:
- Analyse legacy database or data warehouse processes and produce detailed Source-to-Target Mapping (STTM) documentation
- Identify source systems and downstream dependencies for applications within the migration scope
- Understand current data flow patterns and define target state ingestion and consumption models
- Collaborate with data modelling teams to develop scalable, well-structured enterprise data products
- Interpret and work with different layers of data modelling: conceptual, logical, and physical
- Apply data modelling techniques such as star and snowflake schemas, as well as data normalization and denormalization
Required Skills and Experience:
- Advanced proficiency in SQL, Python, SSIS, and shell scripting
- Familiarity with data modelling tools like ER/Studio
- Experience working with Google Cloud Platform components (e.g., BigQuery, GCS, Kafka)
- Knowledge of agile development practices
- Comfortable engaging with clients and working collaboratively within cross-functional teams
GCP Data Analyst employer: Cognitive Group | Part of the Focus Cloud Group
Contact Detail:
Cognitive Group | Part of the Focus Cloud Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land GCP Data Analyst
✨Tip Number 1
Familiarise yourself with Google Cloud Platform (GCP) components, especially BigQuery and GCS. Understanding these tools will not only help you in interviews but also demonstrate your commitment to the role.
✨Tip Number 2
Brush up on your SQL and Python skills, as these are crucial for the role. Consider working on small projects or exercises that showcase your ability to manipulate and analyse data effectively.
✨Tip Number 3
Network with professionals in the data analytics field, particularly those who have experience with GCP. Engaging in discussions can provide insights into the role and may even lead to referrals.
✨Tip Number 4
Prepare to discuss your experience with data modelling techniques during the interview. Be ready to explain how you've applied concepts like star and snowflake schemas in past projects.
We think you need these skills to ace GCP Data Analyst
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your experience with cloud data platforms, particularly Google Cloud Platform. Emphasise your proficiency in SQL, Python, and any relevant data modelling tools like ER/Studio.
Craft a Strong Cover Letter: In your cover letter, explain why you're the perfect fit for the GCP Data Analyst role. Mention specific projects where you've successfully migrated or modernised data systems, and how your skills align with the responsibilities outlined in the job description.
Showcase Relevant Experience: When detailing your work history, focus on experiences that demonstrate your ability to analyse legacy systems and produce Source-to-Target Mapping documentation. Highlight any collaborative projects with data modelling teams.
Prepare for Technical Questions: Be ready to discuss your technical skills in detail, especially your experience with data modelling techniques and Google Cloud Platform components. Prepare examples of how you've applied these skills in previous roles.
How to prepare for a job interview at Cognitive Group | Part of the Focus Cloud Group
✨Showcase Your Technical Skills
Make sure to highlight your advanced proficiency in SQL, Python, and any relevant tools like SSIS during the interview. Be prepared to discuss specific projects where you've successfully applied these skills, especially in relation to GCP components like BigQuery.
✨Understand Data Modelling Techniques
Familiarise yourself with data modelling techniques such as star and snowflake schemas. Be ready to explain how you've used these methods in past projects, as this will demonstrate your expertise and understanding of the role's requirements.
✨Prepare for Scenario-Based Questions
Expect scenario-based questions that assess your problem-solving abilities. Think about how you would approach analysing legacy systems and producing Source-to-Target Mapping documentation, as well as how you would identify dependencies in a migration project.
✨Emphasise Collaboration Skills
Since the role involves working closely with data modelling teams and engaging with clients, be sure to share examples of how you've successfully collaborated in cross-functional teams. Highlight your communication skills and ability to work in an agile environment.