Data Analysis Group - Strategic Business Analyst

SMC Corporation; Noblesville (IN); Hybrid; USD 60,000 - 85,000; Full time

Job summary

SMC Corporation in Noblesville, IN seeks a BI Analyst to work with analysts and business teams, developing reporting solutions and dashboards. You will investigate issues, implement BI solutions, and ensure dashboards are accurate and timely.

The role emphasizes data analysis, data modeling, and collaboration across IT and business units with opportunities to optimize deployment processes and improve data quality.

Qualifications

• Experience developing BI solutions and dashboards.
• GUI-focused design for interactive BI dashboards.
• Basic data integration and scripting skills.
• Strong data analysis background with some data modeling.

Responsibilities

• Develops, implements, and maintains reporting solutions with dashboards.
• Assists with ad hoc queries and analyses.
• Ensures completeness and timeliness of dashboards and reports through data validation.
• Troubleshoots and drives resolutions to development issues.

Skills

BI software

GUI design

Data analysis

Data modeling

SQL

Scripting

Communication

Multitasking

Attention to detail

English proficiency

Education

Bachelor's degree in CS/Math/Business or equivalent

3 years related work experience

Job description

Purpose

The Business Intelligence (BI) Analyst work directly with analysts and business team members to understand the analytical needs of the organization and develop reporting solutions to serve those needs. The role will investigate, analyze, and fix issues in all areas of the environment and assist in implementing new Business Intelligence solutions.

Essential Duties

• Develops, implements, and maintains reporting solutions for monitoring and analyzing business performance with an emphasis on interactive dashboards.
• Assists with the development of ad hoc queries and analyses
• Ensures completeness, correctness, and timeliness of all published dashboards and reports through rigorous monitoring and data validation.
• Troubleshoots and drives successful resolutions to all development related issues
• Assists in conducting peer reviews of BI applications and ensures recommended changes are made
• Assists in creating and maintains documentation on BI applications and source extraction applications
• Assists with the planning and continued refinement of the BI application deployment processes.
• Assists with the troubleshooting and makes recommendations to correct deployment related issues.
• Other duties as assigned

Physical Demands/Work Environment

• Working conditions are typical for an office environment
• Work requires extensive work using a computer
• Maintain seated posture/position for eight of more hours per day
• Responsibilities may require evening and weekend work in response to needs of the systems being supported

Minimum Requirements

• Experienced in developing solutions using BI software
• Knowledgeable in the design of GUI (graphical user interface) for interactive BI dashboards
• Basic level skill in integrating data using BI software
• Basic level skill in scripting
• Candidate should possess strong background in Data Analysis and have some data modeling experience
• Basic level skill in using SQL
• Experience in a Data Warehouse environment reporting on dimensions/hierarchies
• Bachelor's degree in Computer Science, Math or Business or equivalent plus three (3) years related work experience
• Strong organizational skills, excellent communication and presentation skills
• Strong knowledge of the SDLC (Software Development Life Cycle) process is preferred
• Strong knowledge and understanding of databases and applications development concepts
• Proficient in Word, Excel, Windows-based applications
• Capable of multitasking & prioritizing in a fast paced and agile work environment
• Attention to detail, consistency, and a passion to produce a quality product
• Must be able to read/write/speak and understand English

For internal use only: StratAnalysis001

Req id: 4629