Job Information
Advantage Solutions Analyst II Business Intelligence - Remote in Lenexa, Kansas
Summary
Analyst II Business Intelligence
ATLAS Technology Group Inc. is located in Bentonville, Arkansas and is one of the fastest growing Business Intelligence software companies in the Region. ATLAS specializes in Retail Analytics, servicing more than 300 vendors in the Retail Industry. If you are self-motivated and looking for a position where you can make an immediate impact, ATLAS would be a great fit for you.
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.
Responsibilities
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
Collaborate with developers, stakeholders and subject-matter experts to establish technical vision and analyze trade-offs between usability and performance needs
Work with in-house and industry standard database tools to develop dashboard and reports
Qualifications
2-5 years experience with SQL Server 2008+ or Vertica 7+ 2-5 years writing T-SQL of a complex nature
Data Analysis
Experience working with large datasets (100,000,000 - 4,000,000,000 row range)
Experience with CTEs, windowing functions, and complex subquery logic
Has worked in a team-oriented enterprise environment
Can multi-task and prioritize requests
Very strong problem solving skills
Strong written and verbal communication skills
1 year experience with .Net or comparable language a plus
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.
Position Summary
ATLAS Technology Group Inc. is located in Bentonville, Arkansas and is one of the fastest growing Business Intelligence software companies in the Region. ATLAS specializes in Retail Analytics, servicing more than 300 vendors in the Retail Industry. If you are self-motivated and looking for a position where you can make an immediate impact, ATLAS would be a great fit for you.
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
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 an essential duty and function of this job. Driving is not an essential duty or function of this job.
Travel up to 10%
Minimum Qualifications
Education Level: (Required): Associate's Degree o r equivalent experience
(Preferred): Bachelor's Degreeor equivalent experience
Field of Study/Area of Experience: Business, Computer Science, or equivalent job-related experience
2-5 years of experience in with data mining and quantitative analysis 2+ 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
Expert 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 develop efficient and self- documenting solutions
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.
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.
Job Locations US-AR-Rogers | US-KS-Lenexa | US-TX-Dallas | US-GA-Atlanta | US-NC-Charlotte | US-FL-Tampa | US-TN-Brentwood
Primary Posting Location : City Rogers
Primary Posting Location : State/Province AR
Postal Code 66210
Primary Posting Location : Country US
Requisition ID 2022-420580
Position Type Full Time
Category Marketing (Corporate): Integrated Marketing, Experiential Marketing