Events  Classes  Jobs 
    Sign in  
CLEAR // biometric identity platform
Engineering, Full Time    New York City, United States    Posted: Wednesday, October 02, 2019
Apply To Job

CLEARs mission is to strengthen security & create frictionless experiences for consumers. We believe you are you & by using your biometrics - your fingerprints, eyes, & face - we keep you moving. Imagine a world where you can do virtually everything you need to breeze through the airport, buy a beer at the game, check-in at the doctors office, access your office building, & more without ever pulling out your wallet or phone. Now in 60+ airports & other venues nationwide, you are your ID, credit card, ticket, reservation & more with CLEAR.

Were defining & leading an entirely new industry, obsessing over our customers, & investing in great people to lead the way. Recently named on CNBCs Disruptor 50 List & winner of the SXSW Interactive Innovation Award, we're working tirelessly to create frictionless customer experiences for our 4+ million members across the country.

We are looking for a talented & motivated Data Warehouse Developer to join our technology team to develop, maintain, & grow our Data Warehouse & 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, & SQL, & will utilize their drive & skills to make significant improvements to our overall data systems.


What You Will Do:

  • Integrate data into our Data Warehouse from multiple sources at various time intervals to support the companys Business Intelligence & Reporting/Analytic requirements

  • Help build & maintain our data model in the Data Warehouse, the Business Intelligence Platform, & integrations with source systems

  • Work closely with both technical & non-technical/business teams to understand their data needs, & develop solutions to meet them

  • Help evolve the implementation of the data warehouse & data integrations as requirements change

  • Perform data validity, accuracy, & integrity tests across different components of the Data Platform to ensure high quality data

  • Part of your role will involve Database Administration, including creating schemas, managing accounts & permissions, performance tuning/optimization, troubleshooting, & support


Who You Are:

  • You have 7+ years of demonstrated experience as a Data Warehouse Developer in a Business Intelligence/Analytics environment

  • You have outstanding SQL skills, & are well-versed in stored procedures, analytic/window functions, views, indexing, & other database features

  • You have strong experience with various Database platforms including Microsoft SQL Server (preferred), PostgreSQL, & MySQL. Experience with cloud based data platforms such as Redshift & Snowflake is a huge plus

  • You have experience with ETL/ELT processes & integrations with internal & external source & target systems. Experience with cloud based data integration platforms is a big plus

  • You have a strong understanding of data warehouse concepts & architecture, such as star/snowflake schema design; dimension & 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) & Tableau

  • Strong business acumen, with the ability to understand the data in a business context

  • Excellent analytic, process flow, problem solving, troubleshooting, & communication skills

  • Scripting, automation, & integrations against APIs a strong plus, along with experience with Salesforce data integration

Apply To Job
© 2020 GarysGuide      Terms