Analytical Engineer

Analytical Engineer

Location: Reading/Paddington (Hybrid 2 days a week)

Skill Set : GCP, BigQuery, SQL, DBT candidate must have very strong SQL experience support with DBT for data modelling and transformation. Detailed JD attached, we need profiles mostly aligned with GCP.

1. AE Community Engagement Skill Description: Proactively shares knowledge, mentors others, and contributes to the wider analytics community.

2. Coding Maintenance & Improvements Skill Description: Identifies and implements opportunities to refactor and improve the existing codebase for better performance, readability, and efficiency.

3. Coding Standards Skill Description: Champions and enforces coding standards, ensuring the entire team produces consistent, high-quality, and well-documented code.

4. Communication Skill Description: Effectively communicates complex technical concepts to both technical and non-technical audiences.

5. Critical Thinking Skill Description: Goes beyond the immediate request to understand the underlying business problem and challenges assumptions.

6. Data Exploration Skill Description: Independently explores new datasets to validate quality, understand their structure, and identify potential uses.

7. Data Modelling Techniques and Architecture Skill Description: Designs and implements robust, scalable, and efficient data models and architectures.

8. Development Lifecycle Skill Description: Understands and follows the full software development lifecycle, including requirements gathering, development, testing, and deployment.

9. Environment Configuration Skill Description: Understands the development and production environments, and the configs within them, on the analytics platform.

10. Impact Awareness Skill Description: Understands the downstream impact of their work on other teams, systems, and business processes.

11. Independent Working Skill Description: Can take a high-level objective and break it down into smaller tasks, working autonomously to deliver the outcome.

12. Industry Knowledge and Best Practice Skill Description: Stays up-to-date with the latest trends, tools, and best practices in the data industry.

13. Optimisation Skill Description: Identifies and resolves performance bottlenecks in queries and data models.

14. Quality Control & PII Skill Description: Implements robust data quality testing and ensures the security and privacy of sensitive data.

15. Resolving Issues Skill Description: Independently and effectively troubleshoots and resolves complex technical issues.

16. SQL Skills Skill Description: Demonstrates advanced SQL skills, including complex joins, window functions, and performance tuning.

17 Scheduling of Transformations Skill Description: Manages and optimizes the scheduling and orchestration of data transformation jobs.

1. Source Control Skill Description: Uses Git and source control effectively for collaboration, versioning, and code management.

2. Technical Debt Skill Description: Identifies and prioritizes the reduction of technical debt in the analytics codebase.