Job Description
We are seeking a Data Engineer to join our growing team at ProdataKey (PDK) and help us develop our data infrastructure. In this role, you will design, build, and maintain scalable systems that transform raw, disparate data into clean, reliable, and well-structured datasets.
You will work closely with our Data Analyst, ensuring they have access to high-quality data for reporting and analytics. You will also partner with the Engineering team to design and optimize data ingestion pipelines that bring in information from both internal systems and external sources. You will also collaborate frequently with stakeholders across the organization to gather requirements and deliver data-driven solutions.
As the Data Engineer, you will be responsible for data modeling, pipeline development, and warehouse architecture. Your work will enable self-service analytics, uphold data integrity, and define long-term standards and best practices that will shape our entire data ecosystem. This role requires hands-on expertise with a modern data stack, including Google Cloud Platform (GCP), Snowflake, Airflow, dbt, and GitHub, as well as experience integrating data from heterogeneous sources such as relational databases, NoSQL systems, APIs, and proprietary tools. The ideal candidate is comfortable making architectural decisions, setting technical direction, and ensuring the reliability, performance, and scalability of our Snowflake data warehouse.
Key Responsibilities
● Define and implement the architecture, schemas, and models for our Snowflake data warehouse.
● Ensure best practices in data modeling, scalability, and performance optimization.
● Develop, schedule, and monitor data pipelines using Airflow DAGs and Python.
● load and transform data from GCP/object storage by implementing efficient ETL/ELT processes.
● Perform ongoing maintenance, tuning, and administration of Snowflake environments.
● Monitor data lake and data warehouse health, ensuring high availability and data integrity.
● Partner with the Data Analyst to ensure reliable access to structured, high-quality datasets for reporting and analysis.
● Collaborate with engineering teams to design data specifications, integrate new data sources, and maintain consistent standards.
● Implement and enforce data governance, security, and compliance best practices.
● Create and maintain detailed documentation for data requirements, specifications, pipelines, schemas, and processes.
● Explore new tools, frameworks, and approaches to improve data engineering workflows.
● Troubleshoot issues related to pipeline failures, data quality, and system performance.
Basic Qualifications
● Bachelor's Degree in Data Science, Computer Science, Statistics, or related field.
● 5+ years experience as a Data Engineer or related role.
● Strong expertise working with Snowflake (data modeling, performance tuning, and administration).
● Strong expertise in SQL, Python, and common data libraries (NumPy, Pandas, matplotlib, polars, pytest, pydantic, etc.).
● Proficiency in Airflow for orchestration and pipeline management.
● Hands-on experience with GCP (BigQuery, Cloud Storage, Pub/Sub, or related services).
● Experience with message brokers such as RabbitMQ, AMQP, and distributed/de-coupled systems.
● A Testing Mindset. Strong focus on building reliable, well-tested data pipelines and systems, with experience writing tests to validate data quality, transformations, and performance.
● Commitment to creating and maintaining clear, thorough documentation for data pipelines, warehouse structures, and related processes.
● Effective communicator and collaborator across technical and non-technical teams.
● Comfortable working in a fast-paced, small-company environment.
Preferred Qualifications
● Proficiency in JavaScript/TypeScript.
● Experience using business intelligence tools (e.g. Grow, Domo, Tableau, PowerBI, etc.).
● Experience using Jira and Confluence, or similar tools.
Benefits
● PTO, holiday, and sick leave
● 401(k) with match
● Child care assistance
● Health Insurance
● Life Insurance
● Vision Insurance
● Dental Insurance
● Disability Insurance
● Health Saving Account
About ProdataKey
ProdataKey is a leading innovator of cloud-based access control products and services. At ProdataKey, we are passionate about creating technology to enhance the security, safety, and experience of the professionals who install electronic access control and the businesses who rely on ProdataKey each day as a mission-critical security system.
PDK is ranked among the 100 fastest-growing companies in Utah by MountainWest Capital Network. We have been in business for over ten years and are growing rapidly. We are looking for leaders to grow with us. Do you act like an owner, obsess over customers, and thrive when self-directed–PDK’s a great fit. ProdataKey offers a fun and challenging work environment where teamwork, leadership, and employee success are critical. Unlike our competitors, our customers love us because of how easy our products are to use. We are a profitable company with competitive pay and benefits in an industry with high resiliency to economic downturns.
Job Type: Full-time
Pay: $90,000.00 - $110,000.00 per year
Work Location: In person
