Job Description

Job Location: Brazil - State/Province

Please submit a resume in English and respond to application questions to be considered.
The Senior Data Engineer delivers the data strategy that powers analytics at Acadia, developing and implementing solutions that support data analysis, machine learning, and other advanced analytics techniques.
They are responsible for building and maintaining ETL/ELT processes and data warehouses to ensure data is accurate, performant, and reliable for client projects and analyses. The role also includes automating procedures for client reporting and data exports, as well as extracting, transforming, and loading datasets from various sources.
The Senior Data Engineer works closely with Senior, Mid, and Associate Engineers/Developers, as well as Business Intelligence and Data Science teams.
Responsibilities:
- Building and maintaining client data warehouses - within cloud-based environments
- Develop, optimize, and maintain ETL/ELT pipelines (e.g., dbt, Azure DevOps)
- Maintains company procedures for change control and database project tracking and reporting
- Develop, implement and maintain application layer data protection solutions to ensure the security and privacy of Acadia’s confidential data
- Functions as a data owner and assigns database level access privileges
- Supporting analytics and modeling with Business Intelligence and Data Science teams
- Developing automated procedures to support overall analytics projects
- Researching potential solutions for future implementations
- Staying up to date on the latest cyber security threats through company provided training
- Review queries and/or database updates for quality assurance
- Database documentation (e.g., data dictionaries, ETL/ELT documentation)

QualificationsRequirements:
- 5–8 years of experience in database development or data engineering
- Hands-on experience with Snowflake and dbt
- Advanced proficiency in SQL language and solid experience with Python
- Demonstrated experience in database and ETL/ELT design and implementation
- Experience working in AWS environments; Airflow experience preferred
- Strong attention to detail and commitment to data quality
- Excellent problem-solving and critical thinking skills
- Knowledge of media/marketing data (e.g., ad platforms, impressions, clicks, conversions) and how it flows into reporting and analytics is preferred
- Fluency in English is a must
Please submit a resume in English and respond to application questions to be considered.