Job description

Taxwell helps everyday Americans get every tax advantage they deserve by finding credits and deductions they never even knew existed. Our tax preparation software offers easy guidance and ensures your maximum tax refund. We strive to build a team of like-minded experts in both tax and technology who align with our brand purpose, are advocates for our customers and have a fresh, non-traditional approach to the tax industry. Taxwell is a leading digital tax filing platform formed in 2022 from the combination of Drake Software® and TaxAct®. These two longstanding organizations offer customers professional and do-it-yourself digital and downloadable products that are easy-to-use, best-in-class technology, and provide unparalleled customer support. Taxwell brands are a trusted solution for all users including those with complex tax returns. We strive to attract and retain candidates who exemplify our values: performance, perseverance, progress and partnership. Taxwell is an organization of forward thinkers looking to add industry experts to our growing team. Job Description We are seeking a detail-oriented and results-driven Analytics Engineer II to join our Data Analytics Engineering team. You will build and maintain reliable, scalable, and well-documented data models that support reporting, self-service analytics, and business decision-making across the organization. In this role, you’ll collaborate with data engineers, analysts, data scientists, and business stakeholders to transform raw data into clean, reusable datasets and consistent metrics. You will independently deliver well-defined analytics solutions within established architectural patterns while partnering with senior engineers on more complex technical decisions. Our team uses modern cloud data technologies and AI-assisted development tools to improve efficiency and quality across development, testing, troubleshooting, and documentation. Responsibilities Design, build, and maintain data models and transformation pipelines using dbt and Snowflake within established architectural patterns. Develop and optimize SQL queries and transformations to support reporting, analytics, and operational needs. Own assigned work from requirements gathering through development, validation, deployment, and ongoing support. Collaborate with business stakeholders to clarify requirements and translate analytical needs into accurate, well-structured datasets and metrics. Partner with data engineers to integrate new data sources and troubleshoot upstream dependencies. Develop and maintain dbt models, macros, automated tests, and documentation using modular, reusable development practices. Investigate and resolve data quality issues, troubleshoot transformation failures, and improve query and model performance. Contribute to shared metric definitions and semantic layers to support consistent reporting across business units and analytics tools. Maintain data definitions, documentation, and lineage to support governance and self-service analytics. Participate in code reviews and knowledge-sharing, applying team standards and providing constructive feedback. Use AI-assisted development tools to support SQL development, troubleshooting, testing, and documentation, validating generated code and results before use. Communicate progress, dependencies, and risks clearly, seeking guidance when complexity or ambiguity requires additional support. Qualifications 3–5 years of experience in analytics engineering, data modeling, business intelligence, or a related data role. Strong SQL skills, including complex joins, window functions, aggregations, and query troubleshooting and optimization. Hands-on experience with dbt, including modular models, testing, documentation, and basic Jinja. Experience with Snowflake or a comparable cloud data warehouse. Working knowledge of dimensional modeling, dataset grain, and table relationships. Experience using Git, pull requests, and collaborative code review workflows. Understanding of data quality, automated testing, documentation, governance, and data lineage principles. Ability to independently deliver well-defined work, clarify ambiguous requirements, and troubleshoot data issues. Experience using AI-assisted development tools such as Cursor, Claude Code, GitHub Copilot, or similar technologies. Ability to communicate technical concepts effectively to both technical and non-technical audiences. Attention to detail, curiosity, and a proactive approach to problem-solving. Preferred Qualifications Experience with semantic layers, shared metric definitions, or data contracts. Experience with modern BI tools such as Sigma, Omni, Tableau, Power BI, or Looker. Familiarity with data ingestion and integration tools such as Fivetran or Matia. Familiarity with CI/CD workflows and automated deployment of analytics code. Experience with Python for scripting or automation. Familiarity with AWS services used for data integration and processing. At Taxwell, we believe our work benefits from the diverse perspectives of our employees. As such, Taxwell welcomes and celebrates diversity and inclusion and is committed to equal opportunity employment. At Taxwell, you can expect a supportive, open, and inclusive atmosphere and a team that values your contributions. Taxwell is committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants without regard to race, color, religion, sex, national origin, age, disability, marital status, sexual orientation, gender identity, veteran status, and any other status protected under applicable law. Taxwell considers information gathered in the hiring process, including information on this application, confidential, and only shares it on a need-to-know basis or as required by law. If you need assistance or accommodation due to a disability, you may contact us at HR Taxwell.com or by calling 828-349-5887 to speak with a member of the HR Talent Acquisition team.

Requirements

Must-haves

Our team uses modern cloud data technologies and AI-assisted development tools to improve efficiency and quality across development, testing, troubleshooting, and documentation.
Design, build, and maintain data models and transformation pipelines using dbt and Snowflake within established architectural patterns.
Develop and optimize SQL queries and transformations to support reporting, analytics, and operational needs.
Own assigned work from requirements gathering through development, validation, deployment, and ongoing support.
Collaborate with business stakeholders to clarify requirements and translate analytical needs into accurate, well-structured datasets and metrics.
Partner with data engineers to integrate new data sources and troubleshoot upstream dependencies.
Develop and maintain dbt models, macros, automated tests, and documentation using modular, reusable development practices.
Investigate and resolve data quality issues, troubleshoot transformation failures, and improve query and model performance.
Contribute to shared metric definitions and semantic layers to support consistent reporting across business units and analytics tools.
Maintain data definitions, documentation, and lineage to support governance and self-service analytics.
Participate in code reviews and knowledge-sharing, applying team standards and providing constructive feedback.
Use AI-assisted development tools to support SQL development, troubleshooting, testing, and documentation, validating generated code and results before use.
Communicate progress, dependencies, and risks clearly, seeking guidance when complexity or ambiguity requires additional support.
3–5 years of experience in analytics engineering, data modeling, business intelligence, or a related data role.
Strong SQL skills, including complex joins, window functions, aggregations, and query troubleshooting and optimization.
Hands-on experience with dbt, including modular models, testing, documentation, and basic Jinja.
Experience with Snowflake or a comparable cloud data warehouse.

Nice-to-haves

Experience with semantic layers, shared metric definitions, or data contracts.
Experience with modern BI tools such as Sigma, Omni, Tableau, Power BI, or Looker.
Familiarity with data ingestion and integration tools such as Fivetran or Matia.
Familiarity with CI/CD workflows and automated deployment of analytics code.
Experience with Python for scripting or automation.
Familiarity with AWS services used for data integration and processing.
If you need assistance or accommodation due to a disability, you may contact us at HR Taxwell.com or by calling 828-349-5887 to speak with a member of the HR Talent Acquisition team.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aisqlci/cdpythonaws

Platform: workday
Effort: long