Business Intelligence Analyst
RouteOne, Farmington HIlls, MI, United States
The Business Intelligence Analyst will be responsible for identifying 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 a Business 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.
- Highly focused 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 experience with analytical tools like Tableau.