Associate Principal, Data Analytics Engineering
Office of the Comptroller of the Currency2 months ago
Base Salary
$124k - $141k/yr
Responsibilities
- Design and build OCC’s internal analytics data warehouse and maintain its extract, load, and transform processes.
- Develop batch data ingestion frameworks, SQL ETL pipelines, and data models for accurate business-oriented datasets.
- Design and provision AWS cloud data warehouse infrastructure using Terraform and Ansible.
- Tune warehouse performance and storage processes and collaborate with DBAs on access controls and governance.
- Implement containerization and continuous integration practices using Docker, Jenkins, and JFrog Artifactory.
- Manage secrets with HashiCorp Vault and orchestrate data-intensive applications with Automic UC4 and Apache Airflow.
- Create documentation, testing, training presentations, and other resources to support data accuracy, data literacy, and self-service analytics.
- Lead requirements gathering and solution design while assisting analysts and collaborating with the Data Platform and other teams.
- Evaluate and share data and analytics engineering best practices to improve maintainability and reliability.
Requirements
- Master’s degree in data science, analytics, or a related field.
- Two years of experience as a data analyst, data analytics associate, or in a related role.
- Work experience provisioning AWS cloud hardware and software with Terraform and Ansible.
- Work experience using Python frameworks, data modeling, shell programming, and configuration as code to build SQL ETL pipelines.
- Work experience containerizing application code with Docker and building continuous integration pipelines with Jenkins and JFrog Artifactory.
- Work experience integrating HashiCorp Vault for secure secret management and orchestrating applications with Automic UC4 and Apache Airflow.
Benefits
- Hybrid work environment with up to two days per week of remote work, or up to 40% telecommuting permitted.
- Standard benefits package including medical, dental, and vision coverage.
- Tuition reimbursement and student loan repayment assistance.
- Technology stipend for remote work.
- Generous paid time off, parental leave, and 401(k) employer match.
- Potential discretionary bonus and employee wellness and work-life balance programs.