Data and Software Engineer

Affinity Solutions (Affinity) is the leading consumer purchase insights company.? We provide a complete view of U.S. and U.K. consumer spending, across and between brands, via exclusive access to fully permissioned data from over 140 million debit and credit cards. This data is transformed into privacy-compliant, actionable intelligence for marketers, consultancies, and financial services companies to drive strategic growth and lasting customer relationships. Visit us at to discover how we're shaping the future of consumer purchase insights.?

About Your Role:

We are seeking a highly skilled and experienced Senior Data and Software Engineer to join our team. In this role, you will be responsible for designing, implementing, and maintaining robust data structures and controls for privacy features and services, enabling secure multi-party collaboration. You will ensure compliance with data governance standards, implement strong data security measures, and leverage your expertise in SQL and Python to manage large data volumes. This position requires a deep understanding of various data technologies, cloud environments, data clean rooms, and AI concepts.

Your Responsibilities:

• Design and implement data privacy features and services to enable secure multi-party collaboration, including query constraints, data clean room construction, deployment, and monitoring at scale
• Uphold data governance standards and practices, ensuring compliance with data quality standards
• Implement and enforce data security measures to protect sensitive data, including personally identifiable information (PII) and financial data
• Leverage SQL and Python programming proficiency to extract, transform, clean, and interpret large data volumes (200BIL+ records)
• Design highly performant data structures to ensure optimal storage and retrieval of data
• Utilize advanced database technologies to enhance data storage and processing capabilities
• Participate in code reviews to maintain code quality and consistency; collaborate with the infrastructure team to plan and execute deployments

Your Qualifications:

• Bachelor's degree in Computer Science, Engineering, Data Science, or related field/experience; advanced degree preferred
• 6 or more years of experience as a back-end data/software engineer working on various data technologies, with proficiency in SQL, Python, and Javascript )
• 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
• Demonstratable 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 processesExperience with data 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, Tableau; detailed knowledge of AI concepts such as Generative AI chatbots, cortex analyst, agent training, various LLMs, and prompt engineering
• Experience in modeling: Snowpark ML, TensorFlow.
• Expertise building and maintaining APIs; Swagger/OpenAPI spec, Node, and a plus.

Salary Range: $150,000 - $175,000

Office Hours: 9am – 5:30pm

Benefits:

As a full-time member of our team, your benefits will include generous company contributions for medical, dental, and vision. In addition to company-paid holidays, wellness time off, and other wellness benefits, you will also receive company-paid life insurance and the option to enroll in a 401K Plan with employer match. We encourage work/life balance with unlimited vacation days, available after 90 days of employment, as well as employee discounts and professional development opportunities.