Awardco is reimagining the workplace to be more rewarding, supportive, and fun for everyone. As one of the fastest-growing companies in the employee experience industry, our mission is to help employees love what they do, love where they work, and get recognized for their efforts—especially our own employees! And as winners of Glassdoor’s Best Places to Work, Best in Brightest in the Nation, and Great Place to Work, we do much more than talk the talk.
Awardco is seeking a driven and team-oriented individual to join our Data Operations team as a Data Architect. In this position, you will play a crucial role in the design, development, and maintenance of our data infrastructure and pipelines, ensuring that our organization has access to high-quality, reliable, and timely data for informed decision-making.
What you will do:
- Data Pipeline Development: Design, develop, and maintain robust and scalable data pipelines to collect, process, and transform data from various sources into a unified data warehouse in Snowflake.
- Data Modeling: Using the Kimball methodology, create and optimize data models to support reporting and analytics needs, ensuring data accuracy and efficiency.
- Data Integration: Collaborate with cross-functional teams to integrate data from multiple systems and sources, including APIs, databases, and third-party data providers.
- ELT/ETL: Develop and manage ELT processes to extract data, load it into Snowflake, and apply necessary transformations using Coalesce.
- Data Quality Assurance: Implement data quality checks and validation processes to ensure the accuracy and completeness of data stored in the data warehouse.
- Performance Optimization: Continuously monitor and optimize data pipelines and queries for improved performance and efficiency.
- Security and Compliance: Implement and maintain data security protocols and compliance standards to protect sensitive data and ensure adherence to regulations (e.g., GDPR, China data privacy laws, etc.).
- Documentation: Create and maintain comprehensive documentation for data pipelines, data models, and ETL processes.
- Troubleshooting and Support: Identify and resolve data-related issues, provide technical support to end-users, and collaborate with the IT team as needed.
- Team Collaboration: Work closely with data analysts, report writers, data scientists, and business stakeholders to understand data requirements and deliver solutions that meet their needs.
What you will bring:
- Experience with data warehousing in Snowflake, including data loading, modeling, and optimization. Data architecture will follow the Kimball methodology.
- Proficiency in Coalesce and/or dbt for data transformation and modeling within a Snowflake environment.
- Highly skilled and experienced in writing advanced SQL and using database technologies, including ETL tools.
- Experience using FiveTran is a plus.
- 7+ years of professional experience in data engineering, preferably within a BI/Analytics environment.
- Bachelor's or Master's degree in Information Technology, Computer Science, or a related field is preferred.
- Proficiency in data warehousing concepts, ETL/ELT processes, and data modeling following the Kimball Methodology.
- Strong programming skills in Python is highly preferred.
- Experience with data integration tools and technologies.
- Knowledge of data governance, security, and compliance best practices.
- Excellent problem-solving skills and attention to detail.
- Strong communication and collaboration skills, with the ability to work effectively in a cross-functional team environment.
- Experience with version control systems (e.g., Github) is a plus.
Why Awardco:
- We have a revolutionary, client-approved product.
- One of the fastest growing companies in the nation: 3x Inc. 500, 2x Deloitte Technology Fast 500, 2x Mountain West Capital Network Fast 100, 3x Fast 50 (Utah Business), and 3x UV50 Fastest Growing Companies (BusinessQ), to name just a few.
- Great Place to Work certified, ranked in Inc. Best Workplaces, one of the Best and Brightest companies to work for, and ranked on the Salt Lake Tribune's Top Workplaces.
- Backed by renowned investors, both local and national.
Awardco is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.
Disclaimer: Please be aware that all official communication regarding your application will only come from an email address ending in @awardco.com. If you receive any communication from a different domain, it may be fraudulent, and we encourage you to report it.
Top Skills
What We Do
Everything you love about Amazon is now available for rewards and recognition. Awardco has partnered with Amazon Business to bring millions of reward choices, lower vendor fees and dollar-for-dollar recognition spend to your organization. More choice, more capability, and less spend—all in one simple platform.
