Business Intelligence Analyst
Chicago, IL, United States
Advantage Solutions
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 needsPerform 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 Degree or 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 analysis1+ year experience with C# .NET or equivalent Object-Oriented language3+ years of experience writing complex SQL against large relational database systems, preferably Microsoft SQL Server 2008 or aboveAdvanced 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 TablesAbility to maintain and establish positive working relationshipsStrong communication skills, both written and spokenAbility to set priorities and organize work to meet deadlinesExperience in consumer packaged goods industry a plus
Skills, Knowledge and Abilities
- Excellent written communication and verbal communication skills
- Good interpersonal skills
- Decision making skills
- Analytical and research Skills
- Ability to exercise sound judgment
- Ability to make oral presentations
- Ability to gather data, to compile information, and prepare reports
- Ability to ensure a high level of service and quality is maintained
- Ability to work effectively with management
- Ability to research and analyze data effectively
- Well-organized, detail-oriented, and able to handle a fast-paced work environment
- Flexible and adaptable, able to change and alter according to changes in projects or business environment
- Ability to work independently and prioritize duties with minimal supervision, in order to meet deadlines
Environmental & Physical Requirements
Office / Sedentary Requirements
Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.
Additional Information Regarding ASM Job Duties and Job Descriptions
Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. ASM reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. ASM shall provide reasonable accommodations of known disabilities to enable a qualified 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.
Job Will Remain Open Until Filled
Responsibilities
The Company is one of North America’s leading sales and marketing agencies specializing in outsourced sales, merchandising, category management and marketing services to manufacturers, suppliers and producers of food products and consumer packaged goods. The Company services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today.
Essential Job Duties and Responsibilities
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.
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 Degree or 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 skills
- Analytical and research Skills
- Ability to exercise sound judgment
- Ability to make oral presentations
- Ability to gather data, to compile information, and prepare reports
- Ability to ensure a high level of service and quality is maintained
- Ability to work effectively with management
- Ability to research and analyze data effectively
- Well-organized, detail-oriented, and able to handle a fast-paced work environment
- Flexible and adaptable, able to change and alter according to changes in projects or business environment
- Ability to work independently and prioritize duties with minimal supervision, in order to meet deadlines
Environmental & Physical Requirements
Office / Sedentary Requirements
Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically requires the ability to sit for extended periods of time (66%+ each day), ability to hear the telephone, ability to enter data on a computer and may also require the ability to lift up to 10 pounds.
Additional Information Regarding The Company Job Duties and Job Descriptions
Job duties include additional responsibilities as assigned by one’s supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties and skills required for the position. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job position or assign additional job responsibilities, subject to applicable law. The Company shall provide reasonable accommodations of known disabilities to enable a qualified 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.
Any estimate, schedule, or guideline provided to associates in this job description or elsewhere in connection with their jobs is only intended to help describe job duties and for planning purposes. Regardless of any such estimate, schedule, or guideline, associates must always record all time worked for our company (which includes but is not limited to on-site work time in an assigned store, office, or other work location; required waiting time; administrative time; and work-related travel time).
Important Information
The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties and skills required of associates so classified.
The Company 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, the Company 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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Business Intelligence Computer Science Consulting Data Mining Excel R RDBMS Research SQL Statistics T-SQL
Perks/benefits: Flex hours
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open MLOps Engineer jobs
- Open Data Analytics Engineer jobs
- Open Data Scientist II jobs
- Open Power BI Developer jobs
- Open Junior Data Scientist jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Research Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open Data visualization-related jobs
- Open NLP-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open DevOps-related jobs