Data Engineer
 

Motivate International, the parent company of NYC's Citi Bike, is the global bike share leader and a partner to governments and nonprofits in some of the largest cities in the world. We have unparalleled expertise in building and operating large, complex bike share systems. 

Led by a group of seasoned urban visionaries, creative leaders and technology innovators, our mission is to revolutionize the landscape of our cities. In an effort to completely transform the urban experience, Motivate is leading the way in making cities more accessible, healthier and sustainable. We create safe and dependable systems that help make cities great by connecting individuals to the people and places they love. 

At Motivate we bring this ethos to the workplace. We encourage and value diversity, creativity, open communication, and a shared sense of responsibility all while having fun.

Motivate LLC is looking for a detail-oriented and resourceful Data Engineer to join the Business Operations team. In this role, you will be designing and developing a data warehouse solution for all aspects of our business to discover insights and develop data-driven resources to guide key decisions.

About Motivate

Motivate is a best-in-class service operation and logistics company, delivering bikeshare services to some of the largest urban environments in the U.S. We operate in 8 markets across the U.S. including New York, San Francisco, Chicago, and Washington D.C. and will serve over 1.5 million customers this year alone. Led by a group of urban visionaries and seasoned operations experts, our mission is to revolutionize the landscape of our cities. In an effort to completely transform the urban experience, Motivate is leading the way in making cities more accessible, healthier and sustainable. We operate and maintain safe and dependable systems that help make cities great by connecting individuals to the people and places they love. We’re offering an opportunity to work with the most passionate, creative and proven team in this emerging, dynamic industry that is transforming cities around the globe.

About the Role:

• Collecting data from a wide range of sources: AWS S3, Redshift, and various APIs

• Working closely with the Business Operations team members and our business partners to design and implement a scalable data warehouse from disparate and transitioning data sources

• Working in tandem with data analysts to establish ETL pipelines for efficient and reliable analysis and reporting  

• Developing a system to monitor data quality, ensuring the accuracy and availability of data used in daily operations. 

• Collaborating with Business and Field Operations, as well as our business partners, in order to collect the right data to help understand performance, efficiency, productivity, and profitability

About You:

• You are a team player, thrive in growth environments, and are excited to tackle the unique challenges facing growing transportation and logistics solutions  

• You have an undergraduate or graduate background in an analytical field (mathematics, computer science, or similar)  

• You have worked for 1+ years experience building and maintaining data warehouses as well as constructing ETL data pipelines at scale

• You have development experience with warehousing tools, including but not limited to Redshift, BigQuery, or Snowflake

• You have a strong understanding of Python and SQL  

• You have worked with analysts to provide them with both the data they need as well as helping them to arrive at a better understanding of any relevant nuances

• You enjoy taking deep dives to reconcile discrepancies between expected and actual results and take pride in building processes to avoid such issues in the future

• You have experience translating business needs into technical requirements and then communicating those requirements to consumers at different levels of proficiency

• You have a firm understanding of how to optimize and stabilize the flow of data ingestion to ETL to presentation to consumers   

Bonus points

Experience with:

• Dimensional modeling

• Airflow/ Luigi, DBT, AWS S3

• Panoply

• R

• Tableau / Domo / Looker 

• GitHub  

The above description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the job. From time to time, and related to the nature of work performed to accomplish Motivate’s Mission, employees may be required to perform duties outside of their normal responsibilities.

Motivate is an Equal Opportunity Employer. Applicants are considered for positions and are evaluated without regard to mental or physical disability, race, color, creed, religion, sex, gender, national origin, ancestry, age, genetic information, military or veteran status, sexual orientation, gender identity or expression, marital status, pregnancy or any other legally protected status under applicable law. We also provide reasonable accommodation to qualified individuals with disabilities in accordance with the Americans With Disabilities Act and applicable state and local law, as well as individuals who need accommodation because of pregnancy. If you require assistance or reasonable accommodation during any aspect of the application process, please contact [the Human Resources Department or the hiring manager].

We thank all applicants in advance for their interest in this position, however, only those selected for an interview will be contacted.
 
Motivate LLC., does not offer sponsorship of any kind for this position.