Senior Data Engineer

SSB Consulting Group LLC; Lincoln (NE); Remote; USD 120,000 - 135,000; Full time

Job summary

A leading company is seeking a Data Engineer to join their Product Engineering team. This role involves working with the Client Data Platform and analytics platform, applying software engineering practices to enhance data solutions. The ideal candidate will have a robust software engineering background, experience with Python, Snowflake, and data manipulation techniques, and a collaborative approach to problem-solving. This position offers the flexibility of remote work or a hybrid office setup.

Qualifications

• 5+ years of professional experience with advanced data manipulation.
• 3+ years of Python experience, with familiarity in Pandas, DBT, and Airflow.
• Experience in building and maintaining data pipelines.

Responsibilities

• Utilize Airflow for workflow automation and orchestration of data pipelines.
• Perform data warehousing functions within Snowflake and transform data using dbt.
• Collaborate effectively with software engineers and data scientists.

Skills

Python

Data Manipulation

Collaboration

Education

Bachelor's degree in computer science

Tools

Snowflake

Airflow

dbt

Tableau

Job description

Affinaquest empowers colleges and universities to unlock their data potential. Offering unparalleled business intelligence, advanced data analytics, and innovative CRM software native to the Salesforce platform, Affinaquest equips clients to be the architects of their success - surfacing opportunities for increased and more personal engagement, resulting in meaningful revenue growth. Our approach to innovation is not about reinventing the wheel - it's about transforming it. Together, we drive the quest for affinity and create lasting relationships that shape our clients' futures.

KEY FACTS :

• Market-leading Salesforce ISV for Institutional Advancement and Collegiate Athletics
• The preferred next-gen Advancement solution of the "Top 300" fundraising institutions
• Serving over 50% of the Power-5 athletic programs
• 10+ years in data warehousing, data quality, lifecycle hygiene, analytics, and CRM

POSITION DESCRIPTION SUMMARY

Affinaquest seeks a data engineer to join our Product Engineering team. In this role, you'll work on our Client Data Platform (CDP) and analytics platform, applying software engineering practices to empower institutions in fundraising and athletic operations. Affinaquest analyzes client data to uncover actionable insights that drive our clients' missions forward. You'll work with Snowflake, dbt, Python, and Airflow to enhance and evolve our data stack.

Affinaquest is looking for someone with a strong software engineering background, fluent in modern tooling and open frameworks, who will collaborate with Product Engineering peers and client innovation partners to shape our platform's evolution and deliver value to clients. In this role, you'll be a strong contributor to architecture, design, and implementation for all phases of our data pipelines.

You will collaborate with software engineers and data scientists to assure data availability and correctness, contributing to a unified approach in delivering solutions. If you're passionate about writing code, have a pragmatic problem-solving approach, love learning new technologies, and meet our mandatory requirements, we want you on board!

KEY RELATIONSHIPS

Reports to : Sr Manager of Product Engineering

Other key relationships : Product Leaders, and the Product Delivery Team

Requirements

MANDATORY REQUIREMENTS TO APPLY

• A Bachelor's degree in computer science, engineering, or relevant equivalent experience.
• Experience in software development best practices, including rigorous unit testing and code review processes.
• 5+ years of professional experience with advanced data manipulation, including expertise in window functions, common table expressions, and similar techniques.
• 3+ years of Python. Experience in Pandas, DBT, and Airflow preferred.
• 3+ years of hands-on experience with data warehousing, ideally Snowflake relational data tables, and working with data from diverse sources.
• 3+ years of experience in building and maintaining data pipelines between SQL databases, API calls, flat files, and external sources.
• US-Based

KEY RESPONSIBILITIES

• Utilize Airflow for workflow automation and orchestration of data pipelines.
• Perform data warehousing functions within Snowflake and transform data using dbt.
• Ability to collaborate effectively with software engineers and data scientists, ensuring data accuracy and availability.
• Strong comprehension of the complete lifecycle of data engineering, from development through maintenance and monitoring, particularly with DBT, Snowflake, and Airflow
• Hands-on experience with optimizing, and configuring data engineering environments, Kubernetes hosted preferred.
• Knowledge or experience in ticketing data, the sports domain, or retail analytics, adding valuable insights to data processes.
• System-level design and implementation of ETL / ELT pipelines, feature engineering, and effective data management.
• Data visuatation with Tableau dashboards and a strong aptitude for tracking key performance indicators (KPIs).
• Drive innovation and contribute to our client's success with impactful data solutions.
• Integrate and optimize data engineering workflows with Azure AI services to enhance data-driven decision-making and machine learning model performance.

IDEAL ATTRIBUTES AND PROVEN CAPIBILITIES

• Snowflake, dbt, airflow, Azure DevOps, and Github
• Experience with advancement / fundrasining, ticketing data, the sports domain, or retail analytics
• Technical curiosity for uncovering hidden metrics and statistical insights. You enjoy understanding the data and finding meaningful related untapped value from the data.
• Tableau dashboards and KPI tracking

POSITION LOCATION

• Remote or Corporate Headquarters ( ASU SkySong, Scottsdale, AZ ) or Reston, VA Office Hybrid Office Policy : Employees near an office must be there on Tuesday, Wednesday, and Thursday to foster community and engagement.

Affinaquest is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status.

Salary Description

120,000- $135,000

Create a job alert for this search

Senior Data Engineer • Scottsdale, AZ, US