Job Description
Description Job Purpose: Provide Business Intelligence insights to enhance strategic decisions as well as ensure SQL backend maintenance and integrity.
Job Summary The Junior Business Intelligence Analyst is responsible for reporting, data requests, ETL development and database maintenance.
Duties: (Additional Duties May Be Added as Needed)
- Collaborate with key Buffini and Company stakeholders to determine reporting/data needs
- Gain deep understanding of Buffini’s data to create reports that will help drive business decisions
- MS SQL Query Composition (or equivalent querying language)
- Help improve query performance through indexing and refining query composition
- Develop Tableau Reports
- Develop and Deploy SSIS packages (ETL) to SQL Integration Services Catalog and create the respective SQL Job
- Troubleshooting SQL job failures
- Occasionally Develop SSRS Reports as well as troubleshoot existing SSRS reports
- Ensure data quality/integrity
- Knowledge of Google Analytics is a plus
- Ensure server backups meet the Recovery Point Objectives (RPO)
- Periodically test the backups
- Document “larger” changes such as ETL deployment that replaces legacy processes such as linked server jobs
Qualifications Qualifications: - To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
- Bachelor's degree from four-year college or university, preferably in Computer Science, Statistics or related discipline
- Minimum of 1 years’ experience working with databases
- Query composition and refinement
- Table creation including constraints (primary and foreign keys)
- Understanding of data warehouse concepts (Star vs Snowflake schemas)
- Understanding of backup software and best practices
- Minimum of 1 years’ experience working with Excel
- Exposure to Business Intelligence visualization software such as SSRS, Tableau or Power BI
- Advanced problem-solving skills
- Ability to shift between large scale projects and ad-hoc requests
- Self-starter who takes pride in the ownership of robust software solutions that meet specific, well-understood business needs
- Experience working directly with internal clients, departmental managers, and executive leadership
- High degree of professionalism and strong written and oral communication skills
- Strong business acumen
- Basic understanding of relational database concepts and best practices
- Desire to constantly improve in various professional facets through assisted and unassisted means
- Ability to learn quickly and to creatively solve new problems.
- Ability to negotiate and settle differences quickly and peacefully.
- Ability to act as a team player.
Education And/or Experience - 1+ year’s experience working with Microsoft SQL Server
- Experience with BI visualization software such as Tableau, Power BI or SSRS
- Bachelor's degree in Computer Science or related field
- Experience with Salesforce and/or Marketo a plus
Physical Demands - The physical demands described here are representative of those that must be met by a servant leader to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Regularly required to sit and talk or hear while performing duties.
- Frequently required to use hands to finger, handle, or feel and reach with hands or arms.
- Occasionally required to stand and walk.
- Occasionally lift and/or move up to 20 pounds.
Work Environment - The work environment characteristics here are representative of those a servant leader encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- The servant leader is subject to inside environmental conditions, such as in a typical office, with no hazardous or significantly unpleasant conditions.
Job Tags
Work at office, Shift work,