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 www.affinitysolutions.com to discover how we're shaping the future of consumer purchase insights.
About Your Role:
We are seeking an experienced big data engineer to work on a variety of projects. The ideal candidate will have at least six years of data software engineering experience in a big data environment dealing with complex systems. Excellent communication skills are required, as is an ability to learn quickly.
Your Contributions
- Work with clients and prospective customers to deliver solution demonstrations, white boarding, and presentations to showcase the advantages of Data Clean Room throughout the sales cycle.
- 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.
- 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
- 6 or more years of experience as a back-end data/software engineer working on various data technologies with proficiency in Python and/or Javascript (Node.js)
- Must have 3-6 years hand-on experience with Snowflake ecosystem including expert knowledge of SnowPipes, Streams, Views, performance tuning, data modeling, ELT pipelines, data visualizations, and implementing complex SQL stored procedures and standard DWH concepts.
- Minimum 4 years’ experience with various AWS cloud technologies and data lake management - S3, Lambda, Airflow, Redshift, Athena, Glue
- Able to demonstrate working knowledge of data clean-room technologies including creating secure data shares using RBAC. Knowledge of Snowflake Native apps (v6+) preferred.
- Knowledge of all aspects of the SDLC, experience with Jenkins and setting up CI/CD processes.
- Bachelor's degree in computer science or related field. SnowPro core or advanced certification is strongly preferred.
Salary: $100,000 – $165,000
Affinity Working Hours: 9AM-5:30PM
Benefits:
As a full-time member of Affinity Solutions’ team, your benefits will begin on the first of the month following your date of employment, with a generous Affinity Solutions 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 Affinity-paid life insurance and have the option to enroll into an Affinity-matched 401K Plan. We strongly encourage work/life balance by providing unlimited vacation days, available after 90 days from your first day as a team member.
