Hybrid Data Engineer II — Snowflake, dbt, AI-ready

Brooksource; Miami (FL); Hybrid; USD 157,046,000 - 171,924,000; Full time

Benefits offered by this job

401(k) Matching Plan

Medical, Dental, Vision plans

Job summary

Brooksource is seeking a Data Engineer II / Analytics Engineer to join its Data & Analytics team. You will build dbt models on Snowflake to transform landed data into clean, business-ready tables and support Finance with cash flow data.

The role includes collaborating with analytics partners and enabling Power BI reporting in a hybrid setup across Miami, FL and Dallas, TX. You will work on data quality, AI framework efforts, and multiple concurrent projects with a distributed team, delivering

Qualifications

• 2–3 years of experience in data engineering or analytics engineering.
• Hands-on dbt experience with own models, not just running existing ones.
• Strong SQL skills with complex queries, CTEs, window functions, and tuning.
• Solid data modeling knowledge (fact/dimension, star schema, grain).
• Experience with Snowflake and working knowledge of AWS.
• Proficiency in Python and ability to explain data to non-technical partners.
• Comfortable juggling multiple projects within a distributed team.

Responsibilities

• Design, build, and maintain dbt data models in Snowflake across staging, intermediate, and marts.
• Develop new models for Finance and Land, including transaction and cash flow data.
• Write clean SQL and use Python for automation and transformations.
• Implement data quality checks, testing, and documentation for trusted numbers.
• Collaborate with analysts and stakeholders to translate reporting needs into data models.
• Support Power BI reporting by delivering easily reportable models.
• Contribute to AI agent work as the team expands its agentic framework.
• Work on multiple projects with teammates in Miami, Dallas, and remote.

Job description

Brooksource is seeking a Data Engineer II / Analytics Engineer to join its Data & Analytics team. You will build dbt models on Snowflake to transform landed data into clean, business-ready tables and support Finance with cash flow data.

The role includes collaborating with analytics partners and enabling Power BI reporting in a hybrid setup across Miami, FL and Dallas, TX. You will work on data quality, AI framework efforts, and multiple concurrent projects with a distributed team, delivering