What are the responsibilities and job description for the Data Engineer position at CLEAR - Corporate?
Founded in 2010, CLEAR’s mission is to create frictionless experiences. With more than 10 million members and hundreds of partners across the world, CLEAR’s identity platform is transforming the way people live, work, and travel. Whether it’s at the airport, stadium, or right on your phone, CLEAR connects you to the things that make you, you - making everyday experiences easier, more secure, and more seamless. Since day one, CLEAR has been committed to privacy done right. Members are always in control of their own information, and we never sell member data.
We are looking for a talented and motivated Data Engineer to join our technology team to develop, maintain, and grow our Data Warehouse and Business Intelligence platform. Being a strongly data driven company, the continued effort to refine our understanding of our business is core to what we do. Our ideal candidate is passionate about data, databases, and SQL, and will utilize their drive and skills to make significant improvements to our overall data systems.
What You Will Do:
- Build out our data pipeline architecture, and optimize data flow and collection for cross functional teams. This includes designing and implementing a new scalable Data Platform and pipelines using modern data technologies
- Integrate data into our Data Warehouse from multiple sources at various time intervals to support the company’s Business Intelligence and Reporting/Analytic requirements
- Help build and maintain our data model in the Data Warehouse, the Business Intelligence Platform, and integrations with source systems
- Work closely with both technical and non-technical/business teams to understand their data needs, and develop solutions to meet them
- Help evolve the implementation of the data warehouse and data integrations as requirements change
- Perform data validity, accuracy, and integrity tests across different components of the Data Platform to ensure high quality data
- Performance tuning/optimization, troubleshooting, and production support
Who You Are:
- You have 5 years of demonstrated experience as a Data Engineer in a Business Intelligence/Analytics environment
- You have outstanding SQL skills, and are well-versed in stored procedures, analytic/window functions, views, indexing, and other database features
- You have strong experience with various Database platforms including SQL Server, Redshift, BigQuery and Snowflake
- You have experience with ETL/ELT processes and integrations with internal and external source and target systems.
- You have a strong understanding of data warehouse concepts and architecture, such as star/snowflake schema design; dimension and fact tables
- You can effectively balance short-term work (ad-hoc requests, system maintenance, tuning/optimization), with longer-term projects
- Experience working with Business Intelligence tools such as Looker (preferred) and Tableau
- Strong business acumen, with the ability to understand the data in a business context
- Excellent analytic, process flow, problem solving, troubleshooting, and communication skills
- Scripting, automation, and integrations against APIs using languages such as python
#LI-Hybrid
