Access to affordable, reliable transportation through advanced analytics and technology to provide more people with an affordable auto financing option for their next vehicle.
Requirements
- Minimum of three (3) years’ experience in designing, developing, and building ETL/ELT pipelines, procedures on MPP platforms
- Minimum of three (3) years’ experience in building data graphs and charts to communicate useful insights in the data
- Experience in designing and building metadata driven data ingestion frameworks and event-driven data processing jobs
- Must be proficient in SQL including joins, inserts, updates, deletes, conditional logic, subqueries, temp tables, and complex data transformation functions
- Experience with data integration tools like Airflow, Prefect or a similar tool is required
- Experience with programming languages i.e. Python or R is required
- Experience with Power BI, SSRS, or similar tools is required
- Experience reviewing datasets for data quality required
- Experience with unstructured or semi-structured data (ex. XML, JSON) required
Responsibilities
- Design, build, enhance, and maintain reusable and fault-tolerant ELT/ETL pipelines
- Design, build, enhance, and maintain both historical and real-time interactive dashboards and reports
- Achieve strong proficiency in the DW data integration stack (Snowflake, Prefect, etc.) with the ability to evaluate multiple solutions for a given problem
- Automate manual data processes, optimize user queries, and facilitate data research and understanding
- Set-up secure data exchanges using industry standard encryption techniques
- Integrate processes and tools to monitor and improve data quality and system stability as prescribed by the data governance team
- Participate in making architectural decisions for the data team
Other
- Minimum of bachelor’s degree required
- Must be able to work at a desk/in a seated position up to 100% of the workday
- Must be able to constantly operate a computer and other standard office equipment
- Must be able to talk and hear to exchange accurate information
- Must have close visual acuity to perform activities such as: preparing and analyzing data and figures; viewing a computer terminal; extensive reading
