Data Engineer II

Data Engineer IIBrooksource is seeking a Data Engineer II / Analytics Engineer to join a growing Data & Analytics team at a leading homebuilding organization. The team recently rebuilt its AWS data lake and now owns everything downstream of it: transforming raw data into trusted, business-ready models and delivering it through reporting and emerging AI capabilities.You'll work on the modeling and analytics side, building dbt models on Snowflake that turn landed data into clean, well-structured tables the business relies on. A major near-term focus is bringing in financial data, including banking, credit card transactions, and cash flow, and building the data models that Finance will build on. The team is also developing an agentic AI framework, and you'll have the chance to grow into that work.This is a high-variety role on a collaborative, low-ego team. Work comes in across many projects, and everyone jumps in wherever it's needed.What You'll DoDesign, 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 dataWrite clean, performant SQL and use Python for automation and transformation logic that SQL can't handle cleanlyImplement data quality checks, testing, and documentation so business users can trust the numbersPartner with analysts and business stakeholders to translate reporting needs into well-designed data modelsSupport Power BI reporting by delivering models that are easy to report fromHelp build and test AI agents as the team expands its agentic frameworkWork across multiple concurrent projects with a distributed team spanning Miami, Dallas, and remoteWhat You Bring2-3 years of experience in data engineering, analytics engineering, or a related roleHands-on dbt experience, writing and maintaining your own models rather than only running existing onesStrong SQL skills, including complex queries, CTEs, window functions, and performance tuningSolid understanding of data modeling concepts, such as fact and dimension tables, star schema, and grainExperience with Snowflake and working knowledge of AWSWorking proficiency in PythonStrong communication skills and the ability to explain data to non-technical partnersAdaptability and a team-first mindset; you're comfortable juggling multiple projects and helping wherever work landsNice to HaveExperience with financial data (banking, credit card transactions, cash flow, reconciliation, month-end reporting)Power BI experienceExposure to AI/LLM tools or agentic frameworksExperience with Git-based workflows and CI/CD for data projectsWhy Join Us?401(k) Matching PlanMedical, Dental, & Vision PlansRelationship Driven Process to Find Your Best Fit6 Paid HolidaysRegular Meetings to Ensure Quality in Your EngagementInterested in learning more about this opportunity? Apply today and a Brooksource recruiter will connect with you to discuss the role, team, and next steps. We will be reviewing candidates until 10/21/2026At Brooksource, relationships are the foundation of everything we do. Since 2000, we've built lasting partnerships with clients, consultants, and internal teams to deliver an exceptional experience across every engagement. As a trusted IT and Engineering services provider, Brooksource supports Fortune 500 organizations through Experience-Driven Staffing, Professional Services, and Elevate, our proprietary Workforce Transformation program.Whether you're hiring for software development, cloud computing, cybersecurity, data analytics, or enterprise IT, our customized staffing solutions are designed to align with your company's unique goals, culture, and technology stack. We offer flexible hiring models, including contract, contract-to-hire, and direct placement to meet your evolving business needs.We are a certified partner of leading platforms, including Salesforce, AWS, Microsoft, and Google Cloud, enabling us to deliver scalable, end-to-end technology solutions. With a growing national footprint, Brooksource is redefining expectations in IT consulting, engineering services, and technology workforce solutions.Brooksource is a top consulting and professional services provider specializing in IT and Engineering solutions for Fortune 500 companies and the public sector. It utilizes a national network of over 25,000 consultants, local and national delivery engines, as well as strategic partnerships with industry-leading technology providers to support its customers' high-impact initiatives.Brooksource is an equal opportunity employer that does not discriminate on the basis of actual or perceived race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth, lactation and related medical conditions), gender identity or gender expression, sexual orientation, marital status, military service and veteran status, physical or mental disability, protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances.Brooksource offers competitive medical, dental, vision, Health Savings Account, Dependent Care FSA, and supplemental coverage with plans that can fit each employee's needs. We offer a 401k plan that includes a company match and is fully vested after you become eligible, paid time off, sick time, and paid company holidays. We also offer an Employee Assistance Program (EAP) that provides services like virtual counseling, financial services, legal services, life coaching, etc.The pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.