Analytical Engineer
Posted 2 days ago by Ubique Systems
Negotiable
Undetermined
Hybrid
Reading, England, United Kingdom
Summary: The Analytical Engineer role focuses on leveraging GCP, BigQuery, SQL, and DBT to enhance data modeling and transformation processes. The position requires strong SQL expertise and involves engaging with the analytics community, maintaining coding standards, and optimizing data workflows. Candidates must demonstrate critical thinking and effective communication skills to address complex technical challenges. The role is hybrid, requiring in-office presence two days a week in Reading or Paddington.
Key Responsibilities:
- Proactively shares knowledge and mentors others in the analytics community.
- Identifies and implements opportunities to refactor and improve the existing codebase.
- Champions and enforces coding standards for consistent, high-quality code.
- Effectively communicates complex technical concepts to diverse audiences.
- Explores new datasets to validate quality and identify potential uses.
- Designs and implements robust, scalable data models and architectures.
- Follows the full software development lifecycle, including testing and deployment.
- Understands development and production environments and their configurations.
- Recognizes the downstream impact of work on other teams and processes.
- Breaks down high-level objectives into smaller tasks for autonomous delivery.
- Stays updated with trends and best practices in the data industry.
- Identifies and resolves performance bottlenecks in queries and data models.
- Implements data quality testing and ensures data security and privacy.
- Troubleshoots and resolves complex technical issues independently.
- Demonstrates advanced SQL skills, including performance tuning.
- Manages and optimizes scheduling of data transformation jobs.
- Uses Git for collaboration, versioning, and code management.
- Identifies and prioritizes the reduction of technical debt.
Key Skills:
- Strong SQL experience.
- Proficiency in GCP, BigQuery, and DBT.
- Ability to mentor and engage with the analytics community.
- Experience in coding maintenance and improvements.
- Knowledge of coding standards and best practices.
- Effective communication skills for technical concepts.
- Critical thinking and problem-solving abilities.
- Experience in data exploration and validation.
- Understanding of data modeling techniques and architecture.
- Familiarity with the software development lifecycle.
- Knowledge of environment configuration for analytics platforms.
- Impact awareness on downstream systems and processes.
- Ability to work independently and manage tasks autonomously.
- Up-to-date with industry knowledge and best practices.
- Skills in optimization and performance tuning.
- Experience in quality control and data privacy measures.
- Ability to troubleshoot complex technical issues.
- Advanced SQL skills, including complex joins and window functions.
- Experience in scheduling and orchestrating data transformations.
- Proficiency in using Git for source control.
- Ability to identify and manage technical debt.
Salary (Rate): undetermined
City: Reading
Country: United Kingdom
Working Arrangements: hybrid
IR35 Status: undetermined
Seniority Level: undetermined
Industry: IT
Detailed Description From Employer:
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.
- 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.