Sr Data Engineer

We are seeking a Senior Data Engineer with the technical expertise, architectural insight, and problem-solving skills to design, build, and maintain our modern data platform. The ideal candidate will be a hands-on engineer who can deliver at scale, ensure data quality, and work across teams to support both operational and analytical workloads.

Onsite Scottsdale Arizona

Hybrid role

Citizen or GC Holders

Responsibilities

• Design, build, and maintain scalable data pipelines (ETL/ELT) for both batch and streaming use cases.
• Implement data validation and integrity frameworks, ensuring accuracy, completeness, and reconciliation across systems.
• Administer and optimize cloud-based data services (AWS, Snowflake, Databricks, etc.).
• Ensure compliance with data governance and regulations (PCI-DSS, GDPR, CPRA, SOX, etc.).
• Deliver proof of concepts and lightweight prototypes to validate architectural improvements.
• Collaborate with business units, audit teams, and stakeholders to align data architecture with organizational needs.
• Support reporting and analytics teams by enabling Tableau (or future-state tools) through well-structured data models and governance.
• Seek out new work proactively and mentor other team members.
• Own projects end-to-end and deliver measurable results.
• Diagnose and resolve complex data issues quickly.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or equivalent experience.
• 10+ years of experience in data engineering.
• Mastery of complicated SQL for loading data, including complex joins, subqueries, windowing functions, and common table expressions.
• Advanced proficiency in Python, developing and supporting robust pipelines, frameworks, and automation solutions.
• Proven history designing and managing Data Warehousing solutions including proper loading techniques, star schema modeling, slowly changing dimensions, and aggregate strategies.
• Strong understanding of OLTP modeling (3NF) and how to denormalize for performance or downstream use.
• Production experience with unstructured and semi-structured data (e.g., JSON, MongoDB, APIs) and integrating it into enterprise data ecosystems.
• Practical expertise implementing and optimizing pipeline orchestration with tools such as Airflow or Prefect.
• Experience implementing and optimizing 3rd party transformation tools such as dbt, Talend, or FiveTran.
• Demonstrated success in delivering scalable solutions using cloud-based data platforms like Snowflake or Databricks.
• Applied experience leveraging AWS data services (S3, Glue, Redshift, Lambda, Secrets Manager, etc.) in secure and cost-effective ways.