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
Skills Required
- Bachelor's degree in Computer Science, Mathematics, Business, or equivalent education
- Three years of related work experience
- Experience developing solutions using business intelligence software
- Knowledge of GUI design for interactive BI dashboards
- Basic skill integrating data using BI software
- Basic scripting skills
- Background in data analysis and data modeling experience
- Basic SQL skills
- Experience reporting on dimensions and hierarchies in a data warehouse environment
- Strong organizational, communication, and presentation skills
- Strong knowledge of databases and application development concepts
- Proficiency with Microsoft Word, Excel, and Windows-based applications
- Ability to multitask and prioritize in a fast-paced, agile environment
- Ability to read, write, speak, and understand English
- Strong knowledge of the Software Development Life Cycle process
What We Do
SMC Corporation of America is the North American arm of SMC Corporation, a global manufacturer of pneumatic, control, and process components used in industrial automation. Its product portfolio includes air cylinders and solenoid valves, while its sales and engineering organization supports automation, controls, and process applications. The company serves industrial customers through manufacturing, technical expertise, and sales operations across the United States and Canada.
.png)

.png)






