Business Reporting Analyst Jobs

Business Analyst

MarketSource Inc. Alpharetta, Georgia, United States (Hybrid)

MarketSource Inc., an Allegis Group Company, designs and delivers innovative and proven marketing and sales-team solutions for companies of all sizes. MarketSource provides the unique skills and expertise to integrate brand-centric marketing and sales programs in the Automotive, Consumer Electronics, Information Technology and Telecom industries and relevant routes to market including Retail and B2B.

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 is looking for a Business Analyst to join our team.

This is an in office position at our corporate HQ in Alpharetta GA. There is flexibility each Friday to wok remote.

Position Overview

The role of the Business Analyst 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 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 identify and resolve potential issues for the client, before they become problems.

Key Responsibilities:

• Provides analytical support of actual results against budget and feasibility of proposed business strategies
• Identifies issues, analyzes available data and information and recommends changes to management
• Validates data, daily, through cooperation from team members and regular spot checks
• Consolidates data reports and delivers to help drive data-based strategic decision making
• Create and maintain documentation for training purposes
• Design, develop and test reporting solutions using various tools and platforms, with a primary emphasis on Salesforce (both Classic and Lightning versions)
• 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
• Guide the business, serving as subject matter expert and thought leader, through the resolution of complex reporting and analysis problems
• Develop optimal business intelligence strategies to satisfy short and long term business needs
• Perform additional job duties as required, which may include bending, stooping, reaching, twisting, pushing, pulling, walking, standing and lifting items up to 30 pounds independently
• Leverage an analytic mindset to develop visualization of key trends and insights for decision making

Candidate Requirements:

• A good business acumen with a knowledge of sales methodology and reporting as it pertains to sales activities
• Have a passion for using data to effectively support business needs by analyzing existing reports and making changes as requested by users
• A Bachelor’s Degree is required
• Ability to proactively interact with the user community (managers and team members) to gather requirements and transform them into a Requirements Document
• 2-4 years of Salesforce experience with emphasis on report and dashboard development
• Must be able to understand data and transform it into analytics, often in the absence of documentation, through data profiling, interviews, and reverse-engineering
• 2-4 years of experience automating and managing reports, dashboards, and supporting self-service tools
• Must have written and verbal communication skills and experience working directly with senior business leaders to understand objectives and articulate the value of business intelligence solutions
• Must have hands-on experience coding and designing new reports, maintaining and enhancing existing reports, and designing dashboards on scalable intelligence platforms
• A working knowledge of MS SQL is a plus
• 2-4 years of experience querying large scale data warehouse environments, in addition to uploading data via an ETL process
• Knowledge of basic Salesforce administration
• Ability to juggle and prioritize multiple projects simultaneously and be comfortable dealing with changing priorities and timelines
• Good understanding of relational databases utilizing multi-table joins and data aggregation
• Highly proficient with MS Excel including sorting, filtering, pivot tables, power pivots, charting and analytical formulas
• Working knowledge of WebFocus, Power BI or similar self-service BI products

No agencies, please.

MarketSource is an Equal Opportunity Employer; Minorities/Women/Veterans/Disabled