Affinity Solutions, Inc.
Senior Software and Data Engineer – Clean Rooms (5_2024.1)
Affinity Solutions, Inc., Jackson, Mississippi, United States,
Senior Software and Data Engineer – Clean Rooms (5_2024.1)
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:Must have 3-6 years hands-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.Affinity Working Hours:
9AM-5:30PMAs 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.
#J-18808-Ljbffr
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:Must have 3-6 years hands-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.Affinity Working Hours:
9AM-5:30PMAs 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.
#J-18808-Ljbffr