Data Engineer
New York City, United States
CLEAR
Make experiences effortless. See what CLEAR can do for you and for businesses.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
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs BigQuery Business Intelligence ELT ETL Looker Pipelines Python Redshift Snowflake SQL Tableau
Perks/benefits: Career development
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Product Data Analyst jobs
- Open Junior Data Scientist jobs
- Open Senior Data Architect jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Sr. Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Data Analyst Intern jobs
- Open Data Quality Analyst jobs
- Open Big Data Engineer jobs
- Open Business Data Analyst jobs
- Open Principal Data Scientist jobs
- Open ETL Developer jobs
- Open Junior Data Engineer jobs
- Open Research Scientist jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open GCP-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Java-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open APIs-related jobs
- Open Deep Learning-related jobs
- Open PyTorch-related jobs
- Open Consulting-related jobs
- Open TensorFlow-related jobs
- Open Snowflake-related jobs
- Open PhD-related jobs
- Open NLP-related jobs
- Open CI/CD-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open Data warehouse-related jobs