Job description
The Data Analyst will be responsible to develop reports with a specialty in SAP BW (Business Warehouse) development and support using Microsoft SQL. SQL programming skill is a must. Database management skill is also essential for success. You will perform all development tasks for reports, including gathering reports requirements; design table structure, using SQL to create reports and final trial run. You will also work with IT team on any alignment projects related to SAP BW implementation and configuration.
ESSENTIAL DUTIES and RESPONSIBILITIES:
- Work directly with business stakeholders (mainly sales and marketing groups) and other IT members, to create/gather business reports requirements and identify solutions
- Create and modify BW reporting by utilizing SQL
- Manage BW database and tables in an effective, logical, and systematic way. Design, create and change database and tables to meet business needs from a dynamic and long-term perspective
- Support live BW reports, including: a) creating/changing BW process schedules, and b) monitoring and troubleshooting BW processes, such as data loads, transformations, rollups, and reorganizations.
- Work with IT members for reporting and configure requirement at back end
- Perform monthly business tasks (such as sales commission calculation, dealer special discount, 3rd party dealer data loads) by utilizing BW and SQL; Clean up/ load and check business data; Load and maintain database
- Coordinate with functional leaders on forecast and budget activities to ensure accomplishment before deadlines
- Ability to effectively manage BW reports assorted with multiple projects going on in parallel, including working with many individuals in both varying technical and business roles; strong ability to work productively in a global company setting
MINIMUM QUALIFICATIONS:
Education: Bachelor's Degree in accounting, finance, computer science or management information system or related fields
Experience and/or Training
- Minimum 2 years industry experience in BW reporting
- 2 years reporting experience by using SQL programing
- Great communication and interpersonal skills (verbal, non-verbal, written), with the ability to build relationships at all levels, both internally and externally.
- Possesses a high level of critical thinking. Operates with a high-level of professionalism and integrity, including dealing with confidential information.
- High energy with a "can-do" attitude when challenges occur. Naturally takes on challenging assignments.
- Attention to detail, ability to audit work to identify issues and provide practical solutions for business issues.
- Strong work ethic and accountability.
BENEFITS & PERKS:
- Hybrid remote work position
- 401(k) through Fidelity and company matching 10%
- Dental insurance with Delta Dental PPO
- Health insurance BCBS Illinois PPO
- Employee Assistance Program
- Health Savings Account
- Company Paid Life Insurance (two times annual salary)
- Paid time off including an extra paid week off the week between Christmas and New Year.
- Tuition Reimbursement
- Vision insurance through EyeMed
- 10 paid holidays
- Free lunch
Job Type: Full-time
Pay: From $65,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Tuition reimbursement
- Vision insurance
Experience level:
- 2 years
Schedule:
- 8 hour shift
Application Question(s):
- Will you be able to show proof of vaccination as a condition of employment?
- What is your salary expectation?
- Please list your top 3 strengths
- Will you now, or in the future, require sponsorship for employment visa status (e.g. H-1B visa status)?
- We are not offering relocation assistance at this time. Are you located in the Alsip, Illinois area?
Education:
- Bachelor's (Required)
Experience:
- Business Warehouse reporting: 2 years (Required)
- SQL programming: 2 years (Required)
Work Location: In person
offroadmanagementgroup.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, offroadmanagementgroup.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, offroadmanagementgroup.com is the ideal place to find your next job.