Title: Data Engineer

Reports to: Sr Vice President, Technology

Location: Remote- Anywhere, U.S.A.

While remote, the interview process will have an in-person interview component in one of our physical locations in Texas, Oklahoma, Kansas, or Missouri.

ABOUT THE ROLE

At PaulHood, we are transforming the mid-market CPA industry with an entirely new model. Our year-round membership model provides clients with expert tax and financial guidance, helping them feel more secure and realize their long-term financial goals. Founded 30 years ago by Paul Hood, our company has grown rapidly and now serves over 15,000 customers nationwide. To support our continued growth, we have completely modernized our business with technology and processes more akin to a SaaS company than a CPA firm.

As our first full-time Data Engineer, you will be instrumental in building our data infrastructure from the ground up. This is a unique opportunity to lay the foundation for our data warehouse, integrations, queries, views, and features required for reports, dashboards, and data analysis. You will be leading the development of our data strategy while ensuring data integrity, accessibility, and usability across the company.

This role will work directly with senior leadership (SLT) and executive leadership (ELT) to support data-driven decision-making, proactively uncover insights, and identify opportunities for leveraging data to create business value. In the long run, this role could evolve into a key driver in determining how we can integrate AI and advanced analytics to further enhance our business operations. While initially a team of one, this role will shape the future of our data team.

WHAT YOU WILL DO AND OWN

Help Lead and Develop Our Data Strategy: Define and implement a long-term data strategy that aligns with business goals and objectives.

Build and Maintain Our Data Infrastructure: Architect and develop our data warehouse, set up integrations, and ensure efficient data flows.

Clean and Structure the Database: Organize, optimize, and maintain data integrity while ensuring scalability for future growth.

Develop Queries, Views, Pipelines, and Models: Create and optimize SQL queries, views, pipelines, and data models to support reporting and analysis.

Work with Senior Leadership (SLT & ELT): Collaborate directly with executives to extract, analyze, and present meaningful data insights.

Proactively Identify Insights & Opportunities: Scan and analyze data trends to uncover business opportunities and recommend strategic actions.

Implement Data Quality Governance & Monitoring: Ensure data accuracy, consistency, and reliability through robust monitoring and error-handling processes.

Optimize Performance & Efficiency: Continuously improve data processing and query performance for scalability and speed.

Explore AI & Advanced Analytics: Identify opportunities to leverage AI and advanced data analytics to drive business value in the long term.

Engage with the following technologies, and more:

Snowflake Data Warehouse

Fivetran

MSSQL Server (legacy data)

Microsoft Excel and Office tools

Microsoft Teams

Atlassian Jira

EXPERIENCE YOU WILL NEED (REQUIRED)

3+ years relevant experience in data engineering or related field

Motivated self-starter and problem-solver with a strong work ethic

Strong proficiency in SQL (Postgres/Snowflake preferred), including techniques like unions, window functions, and UDF/CTEs

Expertise in entity-relationship modeling and dimensional modeling for enabling data analyst reporting

Familiarity with automated ETL tools (Fivetran, Airbyte, Stitch) and data warehousing (Snowflake, Redshift, BigQuery)

Experience with data quality governance, monitoring, and error handling

Familiar with using project management tools for task tracking and collaboration

PREFERRED QUALIFICATIONS

Proficiency with Snowflake-specific SQL functions and differences (e.g., QUALIFY, TIME_SLICE, ARRAY_AGG) and platform features (e.g., Snowpipe, dynamic tables, resource monitors).

Strong understanding of query optimization and EXPLAIN plans

Python and Jupyter Notebook experience

Proficiency with data visualization tools (Tableau, PowerBI, Looker) and collaboration tools (dbt or Dataform)

Familiarity with MSSQL for interfacing with legacy data

Data-related background in a startup environment

WHO YOU ARE

You have excellent communication skills with the ability to translate technical information into user-friendly language

You’ve got strong problem-solving aptitude, attention to detail, and the ability to manage multiple tasks simultaneously

You display a high degree of professionalism, confidentiality, and integrity in handling sensitive data

You are excited about data analysis, data trends, and where data can help the business.

WHAT YOU WILL GET

You’ll become a welcome member of a supportive and collaborative team and corporate culture, with ample opportunities for professional growth. You’ll enjoy the opportunity to work with a diverse set of technologies, and to continuously enhance your IT skill set. You’ll have a sense of satisfaction knowing that the work you do matters, because we help our clients optimize their financial health. This enables them to keep more, save more, and protect more of their money so they can use it for the things they care about most. You'll be joining a team that prioritizes your well-being, too; which is why, while we believe that intrinsic rewards motivate employees sustainably, we also respect the need for extrinsic rewards which would include:

+Competitive Compensation

+Generous Paid Time Off Benefits + 19 Company Holidays

+ Bonus Opportunity

+ Stock Options

+ Comprehensive Employee Benefits Package

+ 401k Program with Company Matching

+Paid Volunteer Days

+ Educational/Personal Growth Reimbursement

This is an opportunity to take full ownership of our data ecosystem, build a strong foundation, and drive strategic decision-making at a high level. If you are passionate about data and want to shape the future of how we leverage it, we’d love to hear from you!

EEO and Diversity Statement

PaulHood is an equal opportunity employer. We recruit, employ, compensate, develop, and promote without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, pregnancy, marital status, gender identity or expression, status as a veteran, or any other legally protected characteristic or activity in accordance with applicable federal, state, and local laws. If you need reasonable accommodation in the application or interview process, please tell us.

At PaulHood, we champion a vibrant workplace culture that thrives on diversity, and we do not tolerate discrimination or harassment. We are one team from many backgrounds, innovating through diversity of individuals, who are driven by a passion for creating an inclusive space for all. Believing a culture of equality creates a stronger work environment for all employees and that we are all accountable for encouraging and celebrating diverse voices, PaulHood will continue to champion a workplace culture that prizes diversity and inclusivity.

About PaulHood

Joining PaulHood is more than just accepting a job offer—it’s joining a team that prioritizes your well-being and personal growth. Enjoy a great work environment, engage in events and training programs, and advance your career. But don’t just take our word for it, see for yourself.

PaulHood jobs

Data Engineer