ETL Developer (Data Engineer Focus) – based in Salt Lake City-Hybrid Position
Access is seeking an experienced ETL Developer to join our data engineering team. You will design, build, and maintain robust data pipelines that extract, transform, and load data from various sources into our data warehouse and analytical systems. This role is critical in ensuring high-quality, reliable data flows to support business intelligence, analytics, and decision-making.
The ideal candidate is a hands-on developer with deep expertise in Python and SQL, combined with practical experience in building scalable data pipelines and managing databases. This position is in office (hybrid) based in Salt Lake City, Utah.
Access Development holds the distinction of being the Wasatch Front’s best-kept software secret. We champion the OKR approach to achieving our goals. Every software project commences with an idea, sourced from any member of our team. Our Product team meticulously validates concepts through user testing, customer interviews, and risk assessments, ensuring that each product is well-conceived before a single line of code is written.
Key Responsibilities:
- Design, develop, and optimize ETL/ELT processes and data pipelines to ingest, transform, and load data efficiently.
- Write complex SQL queries for data extraction, transformation, and validation.
- Implement and maintain data pipelines using scripting and orchestration tools.
- Perform database administration tasks, including performance tuning, schema design, backup/recovery, and security management.
- Collaborate with data analysts, engineers, and stakeholders to understand data requirements and ensure data quality and integrity.
- Monitor, troubleshoot, and optimize existing pipelines for performance and reliability.
- Document data processes, pipelines, and architectures.
- Optimize Redshift data warehouse schema
Required Skills and Qualifications:
- Expert-level proficiency in Python for data processing, scripting, and automation (e.g., Pandas, NumPy, custom ETL scripts).
- Expert-level SQL skills, including advanced query writing, optimization, and experience with relational databases.
- Proven experience building and maintaining data pipelines; strong preference for hands-on experience with Apache Airflow (especially in managed environments like Astronomer).
- Hands-on database administration experience with PostgreSQL and Amazon Redshift (or similar data warehousing solutions).
- Strong understanding of data modeling, warehousing concepts, and best practices for data quality and governance.
- Excellent problem-solving skills and ability to work independently or in a team.
Nice-to-Have
- Experience with cloud platforms (e.g., AWS) and related services (e.g., S3).
- Experience with Apache Airflow
- Knowledge of version control (Git) and CI/CD practices for data pipelines.
What We Offer:
- Competitive salary and benefits package.
- Opportunity to work on impactful data projects in a collaborative environment.
- Professional growth and learning opportunities in a modern data stack.
If you are passionate about building reliable data infrastructure and have the expertise we’re looking for, we’d love to hear from you!
Our Team:
At Access, we’re about more than just making a buck. We believe in making the world a better place with discount and loyalty products that add value for the people and organizations we serve. We live to be happy — because life is short enough as it is. With a family-first mentality, confidence in our cause and integrity in all we do, we work hard to bring value to our community.
This position is based at our Salt Lake City office and offers remote work up to 3 days per week.
While this job description attempts to describe the essential functions of the position, it does not prescribe or restrict the tasks that may be assigned. It does not restrict management’s right to assign or reassign duties or responsibilities to this job at any time.
Access Development is an equal opportunity employer committed to hiring a diverse workforce and sustaining an inclusive culture. Access Development does not discriminate on the basis of disability, veteran status or any other basis protected class under federal, state or local laws.
Access has been a leading provider of loyalty programs worldwide since 1984. We leverage the world’s largest private savings discount network to drive customers to retailers, create loyalty for organizations, and help their members and customers save money every day. Our employees enjoy a flexible, friendly work environment, competitive wages, excellent benefits, and employee discounts nationwide.
Work hard,
play hard
Access employees enjoy a flexible, friendly, people-oriented work environment with all-employee parties, activities that include family and friends, employee recognition, a fantastic nationwide employee discount program, and a strong focus on career development.
Recent jobs
