Strong SQL skills for analytical and data warehouse queries
Experience with Google BigQuery and data pipeline tools like Apache Airflow
Ability to load and model data for cloud-based warehouses, familiar with dbt or Dataform
Understanding of data engineering principles, including quality and performance
Experience with Git for source control in collaborative environments
Knowledge of CI/CD processes and development standards
Background in agile methodologies and technical discussions
Aptitude for using AI tools in development activities
Responsibilities
Develop and maintain data pipelines from the data lake to the EDW
Build and support loading of fact and dimension tables
Write efficient SQL and transformation logic following best practices
Collaborate in a shared repository, contributing to peer reviews and CI/CD
Investigate and resolve data quality issues and enhance automation
Work with engineers and stakeholders in an agile setting
Use AI tools responsibly for development and documentation
Benefits
Collaborative work environment with talented teammates
Opportunities for continuous improvement and learning
Exposure to advanced cloud technologies and machine learning
Involvement in agile project management and technical discussions
Focus on data integrity and performance optimization
Full Job Description
Job Description
Our AI & Automation department transforms complex data into intelligent, scalable solutions. Operating across an expansive technical landscape, the team builds robust infrastructure that supports regulatory compliance and drives process efficiency. By leveraging advanced cloud technologies and machine learning, the department maintains data integrity while exploring new ways to optimize performance across our global platforms.
In this role, you'll help build and maintain data pipelines that move data from our data lake into a new cloud-based Enterprise Data Warehouse (EDW). With the core architecture and data models established, you'll focus on developing and enhancing pipelines that load fact and dimension tables, while contributing to automation and data quality improvements alongside talented teammates.
The listed salary for this position is $90,000-$120,000 annually.
Qualifications
Strong SQL skills, with experience developing efficient and maintainable queries for analytical and data warehouse use cases
Practical experience with cloud data platforms, particularly Google BigQuery, alongside building, maintaining, and troubleshooting data pipelines using Apache Airflow or similar tools
Proven ability to load, transform, and model data for cloud-based data warehouses, including fact and dimension tables, with exposure to dbt or Dataform
Solid understanding of data engineering principles, including data quality, testing, monitoring, performance, and reliability
Demonstrated experience using Git for source control and collaborating in a shared repository with multiple developers
Applied understanding of CI/CD processes, peer reviews, and development standards for controlled testing and deployment
Background working in an agile environment, contributing to technical discussions, planning, and delivery
Aptitude for using AI tools responsibly to support development activities, including code generation, refinement, troubleshooting, and documentation
Additional Information
Develop, maintain, and enhance reliable data pipelines that ingest data from the data lake into the cloud-based Enterprise Data Warehouse (EDW)
Build and support the loading of fact and dimension tables, applying established architecture, data models, and development standards
Write efficient SQL and transformation logic while applying best practices for data quality, testing, performance, monitoring, error handling, and reliability
Work collaboratively in a shared source-controlled repository with a team of developers, contributing to peer reviews, CI/CD processes, and the controlled deployment of data solutions
Investigate and resolve pipeline and data quality issues, contributing to automation, technical documentation, and continuous EDW improvements
Collaborate with engineers, analysts, and stakeholders in an agile environment, using AI tools responsibly to support development, troubleshooting, documentation, and solution design