MarketSource Inc., an Allegis Group Company, develops and delivers innovative managed sales solutions for enterprise customers. MarketSource provides the unique skills and expertise to integrate brand-centric managed sales programs in the Automotive, Information Technology, Telecommunications, and Manufacturing industries in Business-to-Business (B2B) and Retail models. 
Founded in 1975, MarketSource, Inc. became a subsidiary of Allegis Group, Inc. in 2004. Our Company’s culture centers on our core values: Open Communication, Relationships, Serving Others, and Work Ethic.
MarketSource clients rely on the innovative managed sales solutions that our vertical-specific, subject matter experts develop and deliver. Our team members thrive in a welcoming atmosphere of diversity, inclusion, and exemplary corporate practices. 
Summary
The role of the Business Analyst 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 Business Analyst I will understand 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
· Collaborate with senior business leaders to understand objectives and articulate the value of business intelligence solutions 
 
Required Knowledge, Skills, and Abilities:
· Ability to effectively use data to support business needs by analyzing existing reports and making changes as requested by users
· Proven working knowledge of Tableau, Power BI, WebFocus or similar self-service BI products
· Knowledgeable of sales methodology and reporting as it pertains to sales activities is a definite plus
· Ability to juggle and prioritize multiple projects simultaneously and be comfortable dealing with changing priorities and timelines
· Ability to understand data and transform it into analytics, often in the absence of documentation, through data profiling, interviews, and reverse-engineering 
· Motivated self-starter who can work independently, but also seek out opportunities to work collaboratively with others
· Proven hands-on experience coding and designing new reports, maintaining and enhancing existing reports, and designing dashboards on scalable intelligence platforms
· Excellent written and verbal communication skills 
· Ability to interact with User Community to gather requirements and transform it into requirement document
· Proficient with MS Excel including sorting, filtering, pivot tables, power pivots, charting, analytical formulas and macros
· Proven working knowledge of MS SQL queries, including multi-table joins and data aggregation 
 
Job Requirements:
Bachelor’s degree in Computer Sciences or related field, or equivalent work experience in lieu of degree
5-10 years’ experience as a business analyst or a related field 
5-10 years’ experience querying large scale Data Warehouse Environments, uploading data via an ETL process, automating and managing reports, dashboards, and supporting self-service tools
5-10 years’ experience utilizing SalesForce 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.