Business Intelligence Analyst

at Advantage Sales & Marketing in Chicago, Illinois, United States

Job Description

Business Intelligence Analyst
Job Locations

US-IL-Chicago

 Primary Posting Location : City  
Chicago  

 Primary Posting Location : State/Province  
IL  

 Primary Posting Location : Postal Code  
60601  

 Primary Posting Location : Country  
US  

Requisition ID 
2023-430288  

Position Type 
Full Time  

Category 
Professional: (IT, Finance, Legal, HR, Talent Acquisition, Administrative, Customer Service)  

Minimum 
USD $65,000.00/Yr.  

Maximum 
USD $80,000.00/Yr.
Summary

Position Summary
You will be part of a high performance team responsible for delivering customized reporting solutions and providing business intelligence insights. The primary purpose of this position is to design and develop customized analytics solutions to fit the specifications of each customer. This requires consulting with clients to understand their needs and deliver high quality solutions within agreed upon timelines. This person will work within a team but will be responsible for servicing and managing the needs of their assigned clients.

Essential Job Duties and Responsibilities (Describe the major duties of the job. List the Essential Duties and Responsibilities in order of most time spent to least. To the right under the % column, include the % for each item or group of items that are to total 100%)Job Duty %
- Create analytics reports to provide valuable, relevant business insights for clients

- Write ad-hoc T-SQL of a complex nature to support reporting needs

- Identify, define, and prioritize customer requirements

- Create indexes, tables, columns, and stored procedures as needed in our database environment

- Provide customer service to new and existing clients

- Maintain professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies

- Collaborate with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs

Perform statistical analysis against data to develop models and identify trends in support of the business.

Implement and work with Microsoft Business Intelligence tools (SQL and Excel) and dashboard reports. 25%

25%

10%

2%

10%

3%

10%

10%

5%
100%

Supervisory Responsibilities

Direct Reports
- This position does not have supervisory responsibilities for direct reports

Indirect Reports
- May delegate work of others and provide guidance, direction and mentoring to indirect reports

Travel and/or Driving Requirements
- Travel is not an essential duty and function of this job. Driving is an essential duty or function of this job.
- Travel up to 10%

Minimum Qualifications The following are the minimum job-related qualifications which an individual needs in order to successfully perform the essential duties and responsibilities of the job
Education Level: (Required): Associate's Degreeor equivalent experience

(Preferred): Bachelor's Degree or equivalent experience

Field of Study/Area of Experience:Business, Computer Science, or equivalent job-related experience

1-3 years of experience in with data mining and quantitative analysis

1+ year experience with C# .NET or equivalent Object-Oriented language

3+ years of experience writing complex SQL against large relational database systems, preferably Microsoft SQL Server 2008 or above

Advanced skills with Microsoft Excel; ability to create pivot tables, charts, and graphs; formatting documents, formatting cells, entering and modifying complex formulas, creating and modifying basic charts and graphs, and creating and modifying Pivot Tables

Ability to maintain and establish positive working relationships

Strong communication skills, both written and spoken

Ability to set priorities and organize work to meet deadlines

Experience in consumer packaged goods industry a plus

Skills, Knowledge and Abilities
- Excellent written communication and verbal communication skills
- Good interpersonal skills
- Decision making... For full info follow application link.

Advantage Sales & Marketing LLC dba Advantage Solutions ("Advantage Solutions") is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, Advantage Solutions shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law. Should you believe you need an accommodation in connection with the application process, please contact Advantage Solutions Workplace Accommodation’s Dept. at 949-214-2525 or workplaceaccommodations@advantagesolutions.net.