logo inner

Business Intelligence Analyst

RouteOneFarmington Hills, Michigan, United States | Philadelphia, Pennsylvania, United States | Dallas, Texas, United StatesOnsite

The Business Intelligence 
Analyst will be responsible foridentifying trends, analyzing data, and preparing analytical and graphical reports for executive management.  This person must have strong analytical skills, understand query logic, and be effective at organizing, interpreting, and reporting data to management-level staff.  The Business Intelligence Analyst will be required to create and produce daily, monthly, and ad-hoc reports, as well as have the ability to validate the integrity of the data.Reports and analysis may be required in Excel spreadsheets and graphs. As aBusiness Intelligence Analyst, mathematical, written, and verbal analysis of the data will be essential to the position, especially for communicating to the executive management team. This position may also include day-to-day communication with Finance Source customers to understand, procure, and provide data.

 The Business Intelligence Analyst must be able to interpret requests from outside sources and create reports as needed.  Job Responsibilities 

  • Create and interpret results of analyses from a business perspective.
  • Summarize reasonable conclusions and give written and verbal summaries at team and executive meetings. 
  • Create ad-hoc reports as requested. This may include extracting, manipulating and analyzing data to provide critical insight to meet the needs of business customers.
  • Create and maintain daily, monthly, and annual reports.
  • Identify better business practices and processes.
  • Support the development of data driven and actionable analytical solutions.
  • Participate in identifying and resolving issues with data, analysis, charts, and graphs.
  • Maintain safety, security, and privacy standards throughout all areas of responsibility.

Knowledge

  • Good understanding of data warehousing concepts, OLTP and OLAP data models, data flows, and basic transformations. 

Skills

  • Proficient in Microsoft Office products, including but not limited to: Word, PowerPoint, Excel, Outlook, and Visio.
  • Experience and strong aptitude in SQL, databases, programming languages and analytical tools.
  • Analytical tool knowledge using Excel/Tableau/PowerBI or other business intelligence toolsets.
  • Strong skill in one or more of the following languages:SQL, Python, R.
  • Must be an expert in both Excel and Access. 
  • Strong data analysis and presentation skills.
  • Tableau experience preferred.
  • Statistical background and Salesforce experience a plus. 

Abilities

  • The ability to communicate information and ideas, both verbally and in writing, so others will understand.
  • Outstanding customer service and communication skills.
  • Intellectual curiosity. 
  • Ability to anticipate problems and solutions while maintaining a long-term, big-picture view.
  • Ability to listen to and understand information and ideas presented while asking the appropriate probing questions to better understand the situation.
  • Ability to apply general rules to specific problems to produce answers that make sense.
  • Ability to identify creative solutions to address business needs based on the facts and issues presented. 
  • Highlyfocused in thought and behavior.
  • Ability to thrive in dynamic, fast-paced software development environment.
  • Proactive, detail-oriented professional.
  • Strong analytical and technical skills. 
  • Ability to be a team player.
  • Ability to comfortably and quickly deal with business issues.
  • Characterized by integrity and high professional ethics.
  • Focused on the results while maintaining a sense of urgency.

Other Essential Requirements

  • Bachelor’s degree from an accredited university in Computer Science or other related field. 
  • 2+ years of proven development experiencewith analytical tools like Tableau

Life at RouteOne

RouteOne was formed in 2002 by Ally Financial, Ford Motor Credit Company, TD Auto Finance, and Toyota Financial Services to improve the F&I process for automobile dealers and their customers. We're the F&I connection between dealerships and finance sources and integrated with hundreds of dealer service providers, loan origination systems, and other critical industry partners like OEMs and FinTechs. RouteOne's relationships and integrations provide dealers with straightforward solutions for credit applications, digital retail, eContracting, menu presentation, and compliance tools.
Thrive Here & What We ValueWe work hard and play hard at RouteOne. We thrive on healthy competition and collaboration and celebrate our efforts and successes as a team. We strive to be inclusive and aim for every employee to feel valued.
Your tracker settings

We use cookies and similar methods to recognize visitors and remember their preferences. We also use them to measure ad campaign effectiveness, target ads and analyze site traffic. To learn more about these methods, including how to disable them, view our Cookie Policy or Privacy Policy.

By tapping `Accept`, you consent to the use of these methods by us and third parties. You can always change your tracker preferences by visiting our Cookie Policy.

logo innerThatStartupJob
Discover the best startup and their job positions, all in one place.
Copyright © 2024