Senior Data Engineer

About the role: 

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)