Data Engineer with Snowflake

Artificial Intelligence Technologies LLC; Austin (TX); On-site; USD 120,000 - 170,000; Full time

Job summary

Artifintech is seeking a data engineer to design scalable data models and pipelines using DBT and Snowflake. You will translate complex requirements into robust technical solutions and optimize performance while ensuring data quality and lineage across production systems.

The role requires a strong SQL foundation, Python familiarity, and real-world Snowflake experience, with collaboration across teams to deliver end-to-end analytics capabilities in a fast-growing environment.

Qualifications

• SQL: Highly skilled and fluent with advanced queries.
• Familiar with CTEs, complex joins, analytic/window functions.
• Python: some experience; intermediate or higher preferred.
• Snowflake: real-world experience preferred.
• Data profiling: identify keys, cardinality, data types, skew.
• Strong communication within teams and across groups.
• Understanding of product scope and QA to drive results.

Responsibilities

• Design scalable data models and pipelines aligned with business goals.
• Develop complex DBT models with macros and custom materializations.
• Collaborate with leaders to translate requirements into technical solutions.
• Identify and resolve Snowflake query and DBT model bottlenecks.
• Optimize Snowflake configurations and query performance.
• Design data quality frameworks and testing strategies.
• Create reusable DBT packages and macros for the team.
• Review PRs from junior engineers; troubleshoot production issues.
• Document architectural decisions and data lineage.

Skills

SQL proficiency

CTEs and windowing

Python

Snowflake experience

Data profiling

Communication

Product and QA understanding

Tools

DBT

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

Work Authorization

US Citizen, Green Card, OPT-EAD, CPT, H-1B, H4-EAD, Other

Responsibilities

• Design and implement scalable data models and pipelines that align with business objectives.
• Develop complex DBT models using advanced features (macros, packages, custom materializations).
• Collaborate with business leaders to translate complex requirements into technical solutions Identify and resolve performance bottlenecks in Snowflake queries and DBT models.
• Optimize Snowflake warehouse configurations and query performance Design and implement data quality frameworks and testing strategies.
• Create reusable DBT packages and macros for team-wide use.
• Review and approve pull requests from junior team members.
• Troubleshoot production issues and implement long-term solutions.
• Document architectural decisions and data lineage.

Mandatory skills

• SQL: Highly Skilled.
• Must be familiar with common table elements (CTEs), complex joins, and analytic & windowing functions.
• Python: Some experience is required. We prefer Intermediate or higher skill.
• Snowflake: Prefer candidates with real-world experience using Snowflake.
• Data Profiling: Must be able to identify unique and primary keys and determine cardinality, data type, precision, and scale, and skew.
• Effective communication skills to communicate internally within our team and externally across other teams, notably.
• Product and QA Understands the scope and context of the work and takes initiative to achieve the goals, rather than waiting to take specific direction.

Good to have skills

• Healthcare Industry Experience: Some experience is desired, preferably Payer experience.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.