Territory:

• Remote

Location:  Remote (must be based out of US)

Travel:  Less than 5%

Manages Others: No

Education:  Bachelor’s Degree in a technical field

Experience: 3+ years of relevant experience in Data engineering, database engineering, business intelligence or business analytics 

The Opportunity:

The Data Engineer at BusPatrol will help to build and maintain our data infrastructure to support reporting, analytics, and data science. The right candidate will have strong data architecture, ETL, and SQL skills, and a proven track record partnering with both the business and data team colleagues to construct a framework which delivers on all our needs. The candidate will also have strong operational skills to drive efficiency and speed, expertise in building repeatable data engineering processes, strong project management skills, and a vision for how to deliver data products.

Position Responsibilities:

• Create and orchestrate data pipelines in state-of-the-art AWS environment (Redshift, EC2, EMR, S3, Lambda, etc. with AWS Glue)
• Manage all aspects of the data and analytics system from ingestion to ETL to aggregate tables for analytics and reporting needs
• Design and implement internal data pipeline jobs / process improvements using various modern techniques: automating manual processes, optimizing data delivery, re-designing infrastructure for scalability, etc.
• Write scripts to schedule data ingestion and syncing. Evaluate, lead and form backend logic to create data marts from requirements for the purposes of self-serving stakeholders
• Assist data architects to build the working framework to create metrics as code and optimize data search and retrieval
• Troubleshoot data jobs / processes in production to fix data quality bugs or pipeline performance issues
• Build and assemble large, complex data sets with multi-dimensional relationships that meet both functional and non-functional requirements from business stakeholders
• Build integrations between systems

What You Bring:

• Bachelor's degree or higher in a quantitative/technical field (e.g., Computer Science, Statistics, Engineering) or equivalent experience
• 3+ years of relevant experience in Data engineering, database engineering, business intelligence or business analytics
• 1+ years of SQL knowledge for various reporting and transformation needs (Redshift, MySQL, PostgreSQL, Snowflake, Databricks)
• 1+ years of experience in core languages such as Python (experience building classes preferred)
• 1+ years of experience with schema design and dimensional data modeling
• An interest in understanding the business and its strategy, not just the data architecture, and how our work contributes to meeting business goals
• Experience with Data Lake architectures, and with combining structured and unstructured data into unified representations.
• Experience with API design and development of RESTful web services
• Analytical mindset with the ability to structure and process qualitative data and draw insightful conclusions.
• Data science and machine learning experience a plus
• GIS experience a plus
• Data visualization experience with tools like Tableau a plus
• Experience with JIRA preferred
• Must be an intellectually curious self-starter and motivated to continually learn.

Who We Are:

Our mission is to create a culture of responsibility and awareness on the road. We are devoted to making the journey to and from school safer.  We develop partnerships, deploy safety tech and manage the entire program.  We have equipped thousands of busses across North America with our innovative technology and we continue to educate tens of thousands of drivers a month on safety.  BusPatrol America cares about student safety. We educate motorists every day by helping enforce the law and work with school officials to improve safety.

What we offer:

• An opportunity to help build a company dedicated to children’s safety
• The chance to join an innovative and dedicated team, focused on leading edge technology
• Competitive salary and benefits package

Note to applicants: We are looking for a valued member of the BusPatrol team to assist us in our quest to improve children’s safety. This is an important role for us and a great opportunity for the right candidate. Our environment is inclusive, diverse, ignited, built on integrity, and deeply committed. Join our safety mission to help keep children safe!