BI Analyst

Span Construction & Engineering, Inc.•Madera, CA

4d•Onsite

About The Position

The BI Analyst creates and optimizes advanced Smartsheet-based solution for business needs. This position is responsible for leading the development of Smartsheet solutions for the Company, advancing the effectiveness of our performance internally and for the clients we serve. The incumbent will marshal and transform vast amounts of data and build architectures that deliver insights at scale. This position gathers, analyzes, and compiles data needed to identify trends and patterns, and makes recommendations for business actions. The BI Analyst collaborates with global teams, setting standards for big data initiatives. Additionally, the BI Analyst works in a dynamic, ever-changing, fast-paced environment and provides a high level of internal customer service to all the ESOP’s Teams.

Requirements

Accountability – Ability to accept responsibility and account for his/her actions
Accuracy - Ability to perform work accurately and thoroughly
Active Listening - Ability to actively attend to, convey, and understand the comments and questions of others
Analytical Skills - Ability to use thinking and reasoning to solve a problem
Applied Learning - Ability to participate in needed learning activities in a way that makes the most of the learning experience
Autonomy - Ability to work independently with minimal supervision
Business Acumen - Ability to grasp and understand business concepts and issues
Communication - Must be an effective communicator, generating professional written material and delivering effective verbal presentations
Customer Oriented - Ability to take care of the others’ needs while following company procedures
Detail Oriented - Ability to pay attention to the minute details of a project or task
Energetic - Ability to work at a sustained pace and produce quality work
Ethical - Ability to demonstrate conduct conforming to a set of values and accepted standards
Friendly – Ability to exhibit a cheerful demeanor towards others
Honesty / Integrity - Ability to be truthful and be seen as credible in the workplace
Initiative – Ability to make decisions or take actions to solve a problem or reach a goal
Organizational Skills – Possessing the trait of being organized or following a systematic method of performing a task
Patience – Ability to act calmly under stress and strain, and not being hasty or impetuous
Reliability – Possessing the trait of being dependable and trustworthy
Research Skills - Ability to design and conduct a systematic, objective, and critical investigation
Self-Motivated - Ability to be internally inspired to perform a task to the best of one’s ability using his or her own drive or initiative
Bachelor’s Degree in Business, Finance, IT, or related field preferred, or equivalent experience, skills, and/or abilities.
Microsoft Office products, such as Word, Excel, PowerPoint, Outlook, Teams, and Power BI, Smartsheet (or advanced Excel or Google Sheets), and basic computer skills
Ability and willingness to obtain the following Smartsheet certifications within three years of start of employment (training and testing fees paid for by SPAN):
Intro to Smartsheet Certification.
Core Product Certification.
System Administrator Certification; and
Project Management Certification.
Must be able to receive instruction and supervision
Strong proficiency in advanced Smartsheet functionalities, including (but not limited to) complex formulas, DataMesh, DataShuttle, Blueprints, Dynamic View, and WorkApps.
Solid understanding of data analysis and visualization principles.
Ability to troubleshoot and debut Smartsheet issues efficiently.
Strong attention to detail with a focus on data accuracy.
Good understanding of data management and database principles.
Excellent interpersonal and communication skills, with the ability to explain complex data insights in a clear manner.
Ability to put real solutions in place that maximize the end user experience.
Ability to collect and compile relevant data.
Extremely organized with great attention to detail.
Excellent ability to analyze information and think systemically.
Strong business analysis skills.
Works well independently and as part of a team.
Thorough understanding of the Company’s business processes and the industry at large.

Nice To Haves

Demonstrated experience in creating sophisticated Excel- or Smartsheet-based tools and dashboards preferred.
Familiarity with Smartsheet integration with databases and other systems preferred.
Experience in automating repetitive tasks using Smartsheet database principles preferred.

Responsibilities

Develops advanced Smartsheet-based applications and tools.
Designs and implements complex Smartsheet formulas.
Develops ad-hoc reports and dashboards to maintain and analyzes the data as needed to continue providing necessary solutions.
Designs, develops, modifies, tests, documents, trains, and provides on-going support of business reporting solutions as well as helping to address key operational challenges and concerns.
Collaborates with stakeholders to understand platform, data, and reporting needs.
Optimizes Smartsheet performance and ensures data integrity.
Troubleshoots and resolves Smartsheet application bugs.
Trains end-users on the efficient use of Smartsheet tools.
Ensures all Smartsheet-based tools are user-friendly and meets business requirements.
Develops reporting solutions to help our ESOP make better decisions, extracts key data from business applications, and creates and manages operational dashboards.
Designs blueprints through Control Center in an optimal and effective manner that minimizes manual touchpoints in the system.
Develops Dynamic Views and Pivot Tables.
Creates metrics through Smartsheet through the utilization of Dashboards and advanced formula creation.
Is responsible for the overall end user experience and tracking efficiency gains through the use of Smartsheet applications.
Reviews all new Smartsheet feature releases and analyzes how the Company can leverage new releases, and hosts end user engagement sessions to train and advertise new features.
Gathers business intelligence from a variety of sources, including company data, industry and field reports, public information, or purchased sources.
Compiles business intelligence or trends to support actionable recommendations.
Summarizes financial, economic, statistical, and other KPI- or metric-based reports for review by executives, managers, clients, and stakeholders.
Stays up to date with emerging technologies, integrating them to optimize data processes.
Performs other related duties as assigned.