Business Analyst l

Business Analyst I MarketSource, an Allegis Group company, delivers integrated sales solutions by hiring, training and managing industry-specific professionals that are empowered to create extraordinary customer experiences for many of the world’s most iconic brands. We design and execute sales and training solutions for small and large companies in the B2B and retail space. MarketSource is headquartered in Alpharetta, GA.
Summary
The 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.

 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

 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

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. 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. If you would like to request a 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.