North America Surface Transportation is looking for an innovative, results-oriented and strategic Business Intelligence Engineer (BIE) individual who is comfortable diving into complex problems and can develop solutions to recommend business decisions. The person in this role will have an organization-wide view of analytical solutions and you consistently think in terms of automating or expanding the results company-wide. In this role, you will conduct analytics using SQL and Python, and build lightweight tools and methods for others to replicate and scale their work. In this role, you will deal with large and complex data sets, build self-service dashboards and use visualization tools especially QuickSight.Key job responsibilities
- Write high-quality SQL queries to retrieve and analyze data from database tables (ex. Redshift, MySQL, Oracle).- Recognize and adopt best practices in reporting/analysis: data integrity, test design, validation, and documentation while driving scalable solutions.- Understand data resources and know how, when, and which to use (and which not to use).- Continue to move forward in the face of ambiguity and imperfect data. Find a solution around the problem that still maintains a high analytical bar. You do not suffer from “analysis paralysis”.- Explain analysis results to the stakeholders through verbal and written communications.
- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience in Statistical Analysis packages such as R, SAS and Matlab
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Bachelor's degree in BI, finance, engineering, statistics, computer science, mathematics, finance or equivalent quantitative field
משרות נוספות שיכולות לעניין אותך