Analytics Engineer – Mid-level
Dadosfera
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇧🇷 Brazil
Visit company websiteJob Level
JuniorMid-Level
Tech Stack
AirflowApacheBigQuerySparkSQL
About the role
- Develop, optimize and maintain data pipelines for ingestion, transformation and integration of data from multiple sources.
- Build and maintain analytical models in BigQuery, applying dimensional modeling (facts and dimensions) to support analyses and dashboards.
- Implement data transformations using SQL and dbt, following best practices for version control, documentation and testing.
- Orchestrate and automate data workflows with Apache Airflow, ensuring reliability, monitoring and scalability of processes.
- Use Spark for processing large volumes of data and for more complex transformations when necessary.
- Work in partnership with analytics and business teams to understand requests, translate requirements into data models and deliver efficient analytical solutions.
- Ensure data quality, consistency and governance by implementing controls, validations and best practices across pipelines.
Requirements
- Minimum of 2 years' prior experience in data engineering, analytics engineering, or similar roles.
- Strong knowledge of SQL and data modeling, particularly dimensional modeling.
- Hands-on experience with dbt for transforming and versioning analytical models.
- Experience with BigQuery or other cloud data warehouses.
- Knowledge of data orchestration with Apache Airflow.
- Experience with Spark for distributed data processing.
- Ability to work collaboratively with analytics, engineering and business teams.
Benefits
- Inclusive and diverse work environment
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
SQLdbtBigQuerydimensional modelingApache AirflowSparkdata pipelinesdata transformationsdata modelingdata governance
Soft skills
collaborationcommunicationproblem-solvinganalytical thinkingattention to detail