Data Engineer

Role Overview

As a Data Engineer on the Finance team, you will lead the end-to-end design, implementation, and maintenance of Bloomerang’s enterprise data warehouse. The role combines data engineering and warehouse development, with ownership of data structure, governance, and delivery.

Responsibilities

• Lead end-to-end design and delivery of enterprise data warehouse solutions for corporate analytics.
• Own the migration and refactor of the data warehouse from Google BigQuery to Databricks.
• Establish and maintain data warehouse standards, guidelines, and best practices across the organization.
• Design and build scalable ETL/ELT pipelines ingesting and integrating data from internal systems, including MySQL, PostgreSQL, and Salesforce.
• Work with analytics engineers to create dimensional data models and enterprise data architecture for reporting and BI.
• Partner with cross-functional stakeholders (Finance, Sales, Marketing, Customer Success, People) to translate business questions into reliable, governed data solutions.
• Build automated data quality monitoring/validation and governance processes.
• Optimize data warehouse performance, reliability, and cost across cloud environments.
• Maintain documentation for data architecture, pipelines, and standards.
• Mentor team members and collaborate on data warehouse best practices.

Requirements

• 3–5 years of data engineering / data warehouse development experience, ideally leading enterprise warehouse implementations.
• Hands-on experience migrating/working with modern cloud data warehouses (e.g., BigQuery, Snowflake, Redshift); Databricks preferred.
• Expert SQL skills and strong data modeling ability for complex enterprise reporting.
• Experience with ETL/ELT tools and practices.
• Strong knowledge of dimensional modeling and warehouse design patterns (e.g., star/snowflake schema), plus enterprise data architecture.
• Experience establishing data governance and organizational standards.
• Proficiency in Python (or similar) for data pipeline development.
• Experience integrating with business systems/APIs including Salesforce, MySQL, PostgreSQL.
• Familiarity with cloud platforms (preferably Google Cloud Platform) and modern data stack tooling.

Nice-to-haves (implied)

• Version control and CI/CD practices (text indicates this requirement but is cut off).