REEF transforms urban spaces into community hubs that create jobs and bring new goods, services and experiences to the neighborhood. With an ecosystem of 5,000 locations and a team that’s over 18,000 strong, REEF is the largest operator of parking real estate and delivery restaurants in America, Canada and the UK with a growing presence across Europe. By connecting the world to your block, we’re making the place you live, the place you love to be.
• Use your expert SQL, data modeling and design skills to build REEF’s dashboards and reporting tools end-to-end to help inform business decisions, and strategies. • Work closely with engineers to ensure data quality and to maintain high-level of data accuracy (e.g., unit, implementation, and functional testing). • Simplify, optimize, and document new and existing code. • Create technical and user documentation for Dashboards and reporting tools. • Orchestrate ETL Pipelines using Airflow to transform data coming from a variety of systems and files into data warehouse. • Be part of the team responsible for the data architecture and design of the schemas in the data warehouse. • Monitor daily data loads and fix the ones that aren’t working. The ability to track down data problems to their source is critical. • Query data and merge data tables from multiple sources and partner with other departments to identify data needs, new data sources, and analyst training. • Respond to time critical questions from multiple functional and business teams. • Conduct analysis and prototype new metrics that will be shared with the business and executive stakeholders. • Manage numerous requests concurrently and strategically, prioritizing when necessary. • Support cross-functional teams on the day-to-day execution of projects and initiatives.
• Master’s degree in relevant field. • 3+ years of experience working in business intelligence on an enterprise data warehouse team. • Ability to write robust, maintainable, and extendable code in Python. • Knowledge of data warehouse principles and methodologies • Experience on ETL, data modeling, query optimization and SQL with large-scale, complex datasets. • Experience with version control platforms; we use Bitbucket. • Experience in cloud environments; we use AWS. • Experience developing containerized applications and services, as well as scale, schedule and monitor those containers (e.g., Docker, Kubernetes). • Experience running programmatic operations that can be individually monitored and collectively orchestrated; we use Airflow. • Experience building/working with APIs. Experience with Apigee is a big plus. • Strong ability to collaborate in matrix organization and make the whole better than the sum of the parts. • Experience in Tableau is an asset. • Strong communication skills and experience in gathering requirements and formulating business metrics for reporting.
REEF Technology is an equal opportunity employer, and we value diversity at our company. REEF does not discriminate on the basis of race, religion, color, sex, national origin, gender identity, gender expression, sexual orientation, age, marital status, veteran status, or disability status. REEF complies with all applicable equal employment opportunity legislation in each jurisdiction in which it operates.