BI Analyst

S

Span Construction & Engineering, Inc.

BI Analyst

Madera, CA
Full Time
Paid
  • Responsibilities

    About Us : Span Construction & Engineering, Inc. is a pioneer in state-of-the-art prefab steel construction, proudly operating as a 100% Employee-Owned Company (ESOP) in the building industry. Since our inception in 1980 we've fostered enduring relationships as trusted advisors with our valued clients. We are the number one builder in our field. We are dedicated to providing exceptional engineering and construction services, having successfully completed over 214 million square feet of buildings to date, with ongoing projects 24/6 throughout the year. Setting the industry standard, we prioritize safety, quality, and integrity in all our endeavors. We are inspired, challenged, and empowered to be and give our best every day, not only because we are each exceptional at what we do, but also because we are surrounded by hungry, humble and smart people.

    Benefits:

    • ESOP participation
    • Competitive entry-level salary and benefits
    • Opportunities for growth and professional development within the company
    • Engaging and collaborative work environment

    Position Status: Full-Time

    Location: In person at Span HQ Office in Madera, CA

    Position Summary

    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.

    Essential Functions

    Safety Responsibilities

    • Prioritizes safety as the utmost importance, even before production, and promotes a team culture that makes safety the primary focus for all employees at all times.
    • Adheres to safety procedures in accordance with Cal/OSHA and OSHA safety policies and regulations.

    Strategic Responsibilities :

    • Fully understands and shares a passion for the Company's core values, vision, mission, and objectives.
    • Builds and maintains strong relationships as trusted advisors to our clients.

    Smartsheet 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.

    BI Analyst Responsibilities:

    • 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.
    • Create efficient and accurate DAX measures, calculated columns, and KPIs.
    • Implement data modeling best practices (star schema, facts/dimensions, performance optimization).
    • Manage Power BI data refreshes, workspace organization, and report security (RLS).
    • Connect PowerBi to multiple data sources (SQL databases, Smartsheet, Excel, APIs, and other operational systems).
    • Validate data accuracy and investigate discrepancies across source systems.
    • Work with stakeholders to define meaningful metrics, KPIs, and standard reporting
    • Support ad-hoc analysis requests and root-cause investigations.

    Other Responsibilities:

    • Stays up to date with emerging technologies, integrating them to optimize data processes.
    • Performs other related duties as assigned.

    Position 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

    Education : Bachelor's degree in Business, Finance, IT, or related field preferred, or equivalent experience, skills, and/or abilities.

    Experience :

    • Demonstrated experience in creating sophisticated Excel, Smartsheet or Power BI 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.

    Computer Skills : Microsoft Office products, such as Word, Excel, PowerPoint, Outlook, Teams, and Power BI, SQL, Smartsheet (or advanced Excel or Google Sheets), and basic computer skills

    Certification & Licenses: 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.

    Other Requirements :

    • 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.