/

Sales Reporting Analyst - 230938

 

DESCRIPTION/RESPONSIBILITIES:
The Sales Reporting Analyst will be responsible for gathering, analyzing, and publishing standard and ad hoc reports for Senior Leadership.  In this role, the Analyst will work with various areas within organization to accurately report current data and forecast for upcoming year.  The candidate should be self-motivated, flexible, have strong problem-solving and time management skills, and able to work individually as well as in a team environment.  The individual should have strong Microsoft Excel skills and experience with Power BI and SQL. 

Responsibilities include, but are not limited to:
* Create and publish reports in Power BI, Excel, PowerPoint, and PDF
* Gather and synthesize information to provide explanations for variances in data, such as membership changes 
* Collaborate with senior management and prepare accurate membership forecast for multiple lines of business
* Prepare presentations for senior management
* Ensure data received from various sources, such as Informatics, Actuarial and Finance is accurate 
* Create/run SQL reports in data warehouse 
* Manage reporting needs based on reporting requests and workload 
* Performs other duties as assigned

REQUIRED SKILLS:
Qualifications
* Bachelor's degree in business, Accounting, Finance, Information Systems/Science or related field preferred plus a minimum 1-3 years of relevant experience
* Microsoft Excel experience (intermediate to advanced user) required
* SQL experience, including writing new queries, and using existing queries
* Power BI experience highly preferred
* Strong written and verbal communication skills required, to include the ability to communicate with all levels of management
* Demonstrated ability to prepare reports, presentations and executive summaries for senior management meetings
* Proven statistical and analytical experience in corporate environment
* Ability to build relationships across all management levels as well as internal and external constituents
* Strong work ethic and ability to work independently with little supervision required
* Strong use of judgment and ability to work in ambiguous situations with little direction
* Takes initiative to solve issues with minimal guidance
* Ability to collaborate and influence a process
* Ability to work under tight deadlines required

Equal Opportunity Employer-minorities/females/veterans/individuals with disabilities/sexual orientation/gender identity