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.
18. Source Control
Skill Description: Uses Git and source control effectively for collaboration, versioning, and code management.
19. Technical Debt
Skill Description: Identifies and prioritizes the reduction of technical debt in the analytics codebase.