Senior Data and Software Engineer (Integrations) (36_2026.1)

Job Summary

Required Qualifications

• 6 or more years of experience as a back-end data/software engineer utilizing various data technologies, with proficiency in SQL, Python, and Javascript (Node.js)
• 2 or more years of hands-on experience with Snowflake ecosystem, including expert knowledge of SnowPipes, Streams, Views, performance tuning, data modeling, ELT pipelines, data visualizations, and standard DWH concepts, and experience implementing complex SQL stored procedures
• Minimum 3 years' experience with various AWS cloud technologies and data lake management, such as S3, Lambda, Airflow, Redshift, Athena, and Glue
• Demonstrated knowledge of data clean room technologies, such as creating secure data shares using RBAC. Knowledge of Snowflake Native apps (v6+) preferred
• Knowledge of all aspects of the SDLC as well as experience with Jenkins and setting up CI/CD processes
• Experience with security concepts such as CCPA, GDPR, SSO, and JWT
• Proficiency in data access controls, including aggregation constraints, projection policies, row access policies, column masking, and differential privacy; knowledge of data controls including semantic models, dbt, Honeydew, Iceberg tables, various catalogs (Glue, REST, Nessie, Hadoop, etc.), and catalog syncing concepts
• Experience with cloud environments such as Snowflake, AWS, Databricks, LiveRamp, and GCP
• Familiarity with BI tools such as Thoughtspot, Sigma, Domo, Looker, Quicksights, and Tableau; detailed knowledge of AI concepts such as Generative AI chatbots, Cortex Analyst, agent training, LLMs, and prompt engineering
• Experience in modeling: e.g., Snowpark ML, TensorFlow
• Expertise building and maintaining APIs; Swagger/OpenAPI spec, Node, and Next.js a plus
• Salary Range: $145,000 – $160,000
• Office hours: 9am – 5:30pm
• Benefits for full-time employees of Affinity Solutions begin on the first of the month following your date of hire with a generous employer contribution for medical, dental, and vision. In addition to company paid holidays, wellness time off, other wellness benefits, and employee discounts, you will also get employer paid life insurance and have the option to enroll into an employer-matched 401K Plan. We strongly encourage work/life balance by providing unlimited vacation days, available starting 90 days from your hire date as a team member.