Data Engineer II

Responsibilities

• Design, build, and maintain dbt data models in Snowflake, organizing them into clear layers (staging, intermediate, and business-ready marts)
• Build new data models to support Finance and Land, including financial transaction and cash flow data
• Write clean, performant SQL and use Python for automation and transformation logic that SQL can't handle cleanly
• Implement data quality checks, testing, and documentation so business users can trust the numbers
• Partner with analysts and business stakeholders to translate reporting needs into well-designed data models
• Support Power BI reporting by delivering models that are easy to report from
• Help build and test AI agents as the team expands its agentic framework
• Work across multiple concurrent projects with a distributed team spanning Miami, Dallas, and remote

Preferred

• Experience with financial data (banking, credit card transactions, cash flow, reconciliation, month-end reporting)
• Power BI experience
• Exposure to AI/LLM tools or agentic frameworks
• Experience with Git-based workflows and CI/CD for data projects

Benefits

• 401(k) matching plan
• Medical, dental, and vision plans
• 6 paid holidays
• Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee’s needs.
• A 401k plan that includes a company match and is fully vested after you become eligible
• Paid time off and sick time
• Paid company holidays
• An Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, and life coaching
• Hybrid work arrangement in Miami, FL
• Glassdoor
• 4.0
• Brooksource is a single source for project and supplemental support through contract employment, contract-to-hire labor employment.
• Indianapolis, Indiana, USA
• http://www.brooksource.com
• Distribution of Different Job Fields Receiving Sponsorship
• Represents job field similar to this job
• Engineering and Development
• Customer Service and Support
• Trends of Total Sponsorships
• *2020
• (10)
• Late Stage
• Recent News
• Technically Media
• This Week in Jobs: Pour yourself some Java and check out these 20 tech career opportunities
• 2025-05-27
• This Week in Jobs: 25 out-of-this-world tech career opportunities
• 2025-05-17
• This Week in Jobs: The mother of all career roundups with 26 tech opportunities

Qualifications

• 2-3 years of experience in data engineering, analytics engineering, or a related role
• Hands-on dbt experience, writing and maintaining your own models rather than only running existing ones
• Strong SQL skills, including complex queries, CTEs, window functions, and performance tuning
• Solid understanding of data modeling concepts, such as fact and dimension tables, star schema, and grain
• Experience with Snowflake and working knowledge of AWS
• Working proficiency in Python
• Strong communication skills and the ability to explain data to non-technical partners
• Adaptability and a team-first mindset; you're comfortable juggling multiple projects and helping wherever work lands
• Experience with financial data (banking, credit card transactions, cash flow, reconciliation, month-end reporting)
• Power BI experience
• Exposure to AI/LLM tools or agentic frameworks
• Experience with Git-based workflows and CI/CD for data projects

Required skills

• dbt, SQL, Data Modeling, Snowflake, AWS, Python, Financial Data, Power BI, AI Agent Frameworks, Git, CI/CD

Preferred skills

• Power BI experience, Exposure to AI/LLM tools or agentic frameworks

Experience

• 2+ years