Test-Imp Business Analyst l

Overview

Business Analyst I 

MarketSource is a sales acceleration company focused on delivering better outcomes for many of the world’s most iconic brands. We design, operationalize, and execute managed sales and customer experience solutions for companies in B2B and B2C environments.

Our solutions are purpose-built and tech-enabled to deliver measurable improvements in business outcomes. We live by a set of people-focused values that guide our relationships with each other and with our clients. By putting people first, working together to make others successful, and establishing a rich and empowered work culture, we create opportunities for our people and the businesses we serve to be successful.

SummaryThe role of the Business Analyst I (BA I) is to support self-service reporting and analytics initiatives across the business unit. This includes designing best-practice solutions that can lead to smarter, data-driven decision-making and rapid understanding of business processes and process performance. The BA I will understand the technical aspects of databases and data warehouses, data infrastructure frameworks, data mining tools, data integration and collection, and appropriate analytic and visualization approaches. Responsibility will include delivering high-quality, complex, and timely reports and presentations to support various initiatives and working closely with the Program Managers to proactively identify and resolve potential issues for the client.

Responsibilities

 Essential Job Functions:

• Design, develop and test reporting solutions using various tools and platforms, with a primary emphasis on Salesforce (both Classic and Lightning versions)
• Consolidate data reports and deliver to help drive data-based strategic decision making
• Validate data, daily, through cooperation from team members and regular spot checks
• Guide the business- serving as subject matter expert and thought leader- through the resolution of complex reporting and analysis problems
• Partner with other technology teams to influence, maintain and effect changes to existing reporting systems and applications and act as key liaison between the business unit and software development teams
• Develop optimal business intelligence strategies to satisfy short- and long-term business needs
• Leverage an analytic mindset to develop visualization of key trends and insights for decision making
• Identify issues, analyze available data and information to recommend changes to management
• Provide analytical support of actual results against budget and feasibility of proposed business strategies
• Create and maintain documentation for training purposes as required

Qualifications

 Required Knowledge, Skills, and Abilities: Handbook Classification:

• Requires a passion for using data to effectively support business needs by analyzing existing reports and making changes as requested by users
• Must have working knowledge of Tableau, Power BI or similar self-service BI products
• Must have knowledge of sales methodology and reporting as it pertains to sales activities is a definite plus
• Requires the ability to juggle and prioritize multiple projects simultaneously and be comfortable dealing with changing priorities and timelines
• Must be able to understand data and transform it into analytics, often in the absence of documentation, through data profiling, interviews, and reverse-engineering
• Must be a motivated self-starter who can work independently, but also seek out opportunities to work collaboratively with others
• Must have hands-on experience coding and designing new reports, maintaining and enhancing existing reports, and designing dashboards on scalable intelligence platforms
• Must have excellent written and verbal communication skills and experience working directly with senior business leaders to understand objectives and articulate the value of business intelligence solutions
• Requires ability to interact with User Community to gather requirements and transform it into requirement document

Job Requirements:

• Bachelor's degree in computer sciences or equivalent work experience in lieu of degree
• Proficiency with MS Excel including sorting, filtering, pivot tables, power pivots, charting, analytical formulas, and macros
• Good understanding of MS SQL queries, including multi-table joins and data aggregation
• 2-4 years of experience querying large scale Data Warehouse Environments, in addition to uploading data via an ETL process, and experience automating and managing reports, dashboards, and supporting self-service tools
• 2-4 years of Salesforce experience
• Four (4) in-office workdays per week and the option to work remote OR in office on fifth (5th) day

Additional Information

MarketSource is an Equal Opportunity Employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law. If you would like to request reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please call 877-883-4575 or email [email protected].

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms.  This role may be eligible for the following:

• Medical, dental & vision
• 401(k)/Roth
• Insurance (Basic/Supplemental Life & AD&D)
• Short and long-term disability
• Health & Dependent Care Spending Accounts (HSA & DCFSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

San Fran Candidates only: Pursuant to the San Francisco Fair Chance Ordinance, we will consider for employment qualified applicants with arrest and conviction records.

Los Angeles Candidates only: We will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles' Fair Chance Initiative for Hiring Ordinance.

Unincorporated Los Angeles County Candidates Only: Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act. Where applicable, in accordance with the Los Angeles County Fair Chance Ordinance for Employers, Candidates must satisfy all pre-employment screening criteria and may be disqualified due to criminal history because the requirements of this position, as outlined above, may include: access to valuable company assets; exercise of good judgment and performance of duties safely under work conditions that may be stressful including under supervision of client; access to sensitive personal or financial information; and/or access to objects that may be used to inflict injury or harm to others.