Data Engineer II

Data Engineer II Location: Miami, FL (Hybrid) or Dallas Reports to/Team Dynamic: Data & Analytics Team Rate: $55/hr-$60/hr About the Role Brooksource 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 Do 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 What You Bring 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 Nice to Have 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 Why Join Us? 401(k) Matching Plan Medical, Dental, & Vision Plans Relationship Driven Process to Find Your Best Fit 6 Paid Holidays Regular Meetings to Ensure Quality in Your Engagement About Us At 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. EEO Statement 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. Benefits & Perks 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. Pay Disclaimer 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. #J-18808-Ljbffr Eightelevengroup