ETL Developer (Data Engineer Focus) at Access Development

West Valley City, Utah, United States -

Full Time

Start Date

Immediate

Expiry Date

23 Mar, 26

Salary

0.0

Posted On

23 Dec, 25

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Python, SQL, ETL, Data Pipelines, Database Administration, PostgreSQL, Amazon Redshift, Data Modeling, Data Warehousing, Apache Airflow, Data Quality, Data Governance, Problem-Solving, Collaboration, Scripting, Orchestration Tools

Industry

Travel Arrangements

Description

Company Description At Access, we believe great things happen when people come together. Our discount and rewards solutions are designed to connect three very important groups: organizations, their members, and the merchant community. The result? Everyone wins. Merchants tap into the affinity members share with their organizations. Organizationscreate loyalty and generate revenue. And members are happy because they save money. 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. Job Description We are 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. FULL-TIME opportunity available. A successful candidate will be data driven, proactive, and enjoy producing creative solutions to complex data problems. Full-time opportunity in office. Work is currently under a Hybrid model working a minimum of Tuesdays and Thrusdays in our Salt Lake City office with optional 3 days/week remote work. Starting pay is dependent on experience, plus full employee benefits, including employee discounts nationwide. 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 Qualifications Reuired Skills and Job Qualifications: · Bachelor degree in a quantitative science; masters degree is a plus 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! Additional Information 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. We recognize people as our most valuable asset. Your contributions will be valued and celebrated by a closely-knit team that is committed to excellence. We offer competitive wages, and benefits package includes medical insurance, prescription drug coverage, a lifestyle discount program for personal/family use, a 401k and profit sharing plan, paid holidays and personal time. To apply for this position, please complete an Initial on-line Job Application and attach your resume and cover letter expressing why you are a great fit for this position at http://www.accessdevelopment.com/careers/ 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. All your information will be kept confidential according to EEO guidelines. 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.

Responsibilities

The ETL Developer will design, develop, and optimize ETL/ELT processes and data pipelines to efficiently ingest, transform, and load data. They will also collaborate with data analysts and engineers to ensure data quality and integrity.