Data Engineer

Hood & Associates CPAs, PC

Hood & Associates CPAs, PC is revolutionizing the mid-market CPA industry with an innovative membership model that offers expert tax and financial guidance all year round. With over 15,000 clients nationwide, the firm operates more like a SaaS company, leveraging technology to modernize services and expand rapidly. As a Data Engineer, you'll play a vital role in developing and maintaining the data warehouse, ensuring accurate and accessible data for the entire organization.

In this role you can expect to have the responsibilities:

• Develop and maintain queries, views, pipelines, and models using Snowflake.
• Maintain documentation for data structures and models.
• Collaborate with data team and leadership to meet data requirements.
• Optimize query performance and efficiency.
• Implement data quality checks and monitoring.
• Analyze historical data for insights and trends.
• Use technologies like Snowflake Data Warehouse, Fivetran MSSQL Server, Microsoft Excel, Atlassian Jira, and more.

This role comes with the following benefits:

• Competitive compensation.
• Generous paid time off plus 19 company holidays.
• Bonus opportunities.
• Stock options.
• Comprehensive employee benefits package.
• 401k program with company matching.
• Paid volunteer days.
• Educational and personal growth reimbursement.

This role requires you to have:

• Over 3 years of experience in data engineering or a similar field.
• Proficient in SQL, including advanced techniques like unions and UDF/CTEs.
• Expertise in entity-relationship and dimensional modeling.
• Familiar with automated ETL tools and data warehousing technologies like Snowflake.
• Experience in data quality governance and monitoring.
• Skilled in using project management tools for task tracking and collaboration.

You would benefit from having:

• Proficiency with specific Snowflake SQL functions and platform features.
• Strong understanding of query optimization and EXPLAIN plans.
• Experience with Python and Jupyter Notebooks.
• Proficient in data visualization tools like Tableau and PowerBI.
• Familiarity with MSSQL for legacy data integration.

PaulHood values diversity and offers an inclusive workplace environment. It is an equal opportunity employer, committed to recruiting and developing talent without discrimination. The company emphasizes the importance of a vibrant, diverse culture that values all backgrounds and encourages equality.