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.

• AE Community Engagement

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

• Coding Maintenance & Improvements

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

• Coding Standards

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

• Communication

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

• Critical Thinking

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

• Data Exploration

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

• Data Modelling Techniques and Architecture

Skill Description: Designs and implements robust, scalable, and efficient data models and architectures.

• Development Lifecycle

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

• Environment Configuration

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

• Impact Awareness

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

• Independent Working

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

• Industry Knowledge and Best Practice

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

• Optimisation

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

• Quality Control & PII

Skill Description: Implements robust data quality testing and ensures the security and privacy of sensitive data.

• Resolving Issues

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

• 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.

• Source Control

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

• Technical Debt

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