Client Services Junior Business Analyst

Job Description - Client Services Junior Business Analyst (MER0003HET)
Description
About Us:
Who is Mercedes-Benz Financial Services?
Mercedes-Benz Financial Services, part of the global company Mercedes-Benz Mobility AG is the captive financing and mobility solutions company of the global luxury automobile manufacturer, Mercedes-Benz AG. We offer a comprehensive range of automotive financial and insurance products that make it easy for our customers to drive their dream Mercedes-Benz vehicle.

Why work at Mercedes-Benz Financial Services?
Working at Mercedes-Benz Financial Services is more than a job – it's an opportunity to join an innovative team where you are valued for your contributions. As an employee, you will experience career development in a positive, employee-centric environment. We're a global company that not only offers best-in-class products to our customers but also best-in-class benefits to our employees. Our employees experience a comfortable, friendly environment and relaxed, inclusive culture.
When working at Mercedes-Benz Financial Services, you will enjoy a comprehensive and amenity-rich benefits package offering something for every employee at each stage of their life.

As a new employee, you will have the opportunity to take advantage of the following benefits that go beyond – beginning day one:
Get Rewarded! Competitive salary plus an annual bonus based on company performance and/or personal yearly performanceNeed a vacation? How about just some time for YOU! In addition to our vacation time, you'll receive nine (9) additional corporate holidays and six (6) Personal days, which will allow you to celebrate religious holidays or escape to the spa! Designed to be flexible, we let you decide which days are most important to you!Ride in Style - All employees are eligible to participate in the Mercedes-Benz Employee Lease ProgramWe want you to be healthy! Outstanding medical, dental, and vision insurance, employer-paid short and long term disability plus on-site exercise facilitiesIs your family growing? Enjoy generous paid Family Leave Programs - Six Weeks for New Parents; Two Days for New Grandparents; as well as Adoption Expense Reimbursement Programs - up to $6k per childWant to go back to school? Tuition Assistance Scholar Program - receive up to $5,250/year in vouchers to complete business-related courseworkIt's all about balance – Our hybrid work environment encourages employees to utilize the flexibility of working from home, as well as the benefits of in-person collaboration that our offices provideJob Overview:
The Junior Business Analyst will be responsible for supporting the Business Analyst in the Client Services department. Will support all functional areas within Client Services. Responsibilities also include interacting with key users to support the analysis and reporting needs within Mercedes-Benz Financial Services including production, ad-hoc, and manual reporting. Responsible for assisting the Business Analyst with analyzing supported department's information needs and making recommendations to management regarding solutions to business problems and areas where efficiency can be increased. Responsible for working with the Business Analyst and Data Steward for identifying enhancements to the reporting environment (MORIS Data Mart, Remarketing Data Mart, Data Warehouse) by following formal system development methods.
Responsibilities:
Quality Control: Review daily, weekly, and monthly manual reports produced by DIAA Reporting Analysts and Business Analyst Team for accuracy and resolve issues as needed. Publish the reports to customers based on the distribution lists. (5%)Scope: Work with Business Analyst to review customers' reporting requests and determine how to translate the requested report into a physical form, which includes defining the measures, dimensions, and layout of the report. (15%)Customer Support: Provide ad hoc reports and report development in a timely manner. Work with Business Analyst to assess the correct priority for requested items. Attend project meetings at a customer's request providing any analysis or other information required by the customer. (25%)Ad hoc Reports and Analytical Efforts: Assess customers' requests and provide ad hoc reporting (using BI tools, which includes Cognos, Power Play, Access, SQL, and Excel) and analysis based on those requests. Work with Business Analyst to determine priority. Troubleshoot issues with report and data integrity as needed. (25%)Support Data Insights & Advanced Analytics Team: Assist with special initiatives/projects specific to related MBFS initiatives. Represent reporting during participation on key project initiatives. Work with Business Analyst to identify data gaps and utilize the Data Analyst team to incorporate needed information into the data warehouse during quarterly IT updates. (15%)Business Analysis and Consulting: Work with Business Analyst to provide analytical and consulting engagements within the functional areas of reporting responsibility (e.g. MB ART, Titles, Dealer Services, etc.). Work with Business Analyst to identify key areas of opportunity through process mapping or data analysis that would reduce or eliminate redundant reporting processes. Reduce the number of manually generated reports through automation. (15%)Qualifications:
Applicants must be legally authorized to work in the U.S. at the time of application. Relocation assistance will not be provided for this position.
This position requires a minimum of 2 years of overall work experience. Preferred experience includes:
Business-General: 2 yearsCustomer Service: 1 yearEducation:
High School Diploma/(GED) is required, Bachelor's Degree is preferred. Recommended majors include:
Business AdministrationComputer/Information ScienceEconomicsFinanceInformation TechnologyMathematicsStatisticsAccountingAdditional Knowledge:
1 year level of experience required in the following: Knowledge of ANSI and/or DB2 SQL (ability to write a simple query/understand parts/functions of queries) Intermediate knowledge of MS Excel (create/use pivot tables, create charts/graphs, and write formulas) Basic knowledge of MS Access (create queries and reports without using wizards)1 Year of experience preferred in the following: Intermediate understanding of ANSI/DB2 SQL Experience using MS Office Suite (intermediate skill with Excel) Basic understanding of Cognos BI Suite Basic understanding of Visual Basic for ApplicationsSkills:
Analytical skills:Ability to collect data and establish facts and identify trends and variancesAbility to integrate information from a variety of sources with varied levels of complexityAbility to review and interpret and evaluate statistical informationAbility to formulate and test hypotheses for the purpose of forecasting outcomesPC SkillsMicrosoft OfficePresentation SkillsProblem Solving SkillsAdditional Skills:
Demonstrated ability in customer service skillsDemonstrated ability in logical thinkingDemonstrated business acumenAbility to derive insights from simple data for presentation and decision makingBasic root cause analysis skillsDemonstrated ability in planning, organizing work and time managementBasic understanding of data validationBasic consulting and negotiating skillsRecommended Prerequisites:
OrganizationPrimary LocationOrganization: Mercedes-Benz Financial Services USA LLC
Primary Location: United States of America-Texas-Fort Worth
Work Locations: 14372 Heritage Parkway, Fort Worth 76177

#J-18808-Ljbffr