Sales Reporting Analyst
Our organization is looking for dynamic individuals who love to learn, thrive on innovation, and are open to exploring new ways to achieve our goals. If this describes you, we want to speak with you. You can help us achieve our vision to lead nationally in innovating equitable whole-person health.
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
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
Diversity, Equity, and Inclusion
At Independence, everyone can feel valued, supported, and comfortable to be themselves. Our commitment to equity means that all associates have a fair opportunity to achieve their full potential. We put these principles into action every day by acting with integrity and respect. We stand together to speak out against injustice and to break down barriers to support a more inclusive and equitable workplace. Celebrating and embracing the diverse thoughts and perspectives that make up our workforce means our company is more vibrant, innovative, and better able to support the people and communities we serve.
About Our Company
Serving more than 8 million people nationwide, including 2.5 million in southeastern Pennsylvania, Independence Health Group — together with its subsidiaries — is the leading health insurance organization in the Philadelphia region. Our mission to build healthier lives for you, your family, and your employees shapes our actions and decisions every day.
At Independence, we see each of our members as an individual, with unique needs and concerns. We’re dedicated to harnessing the very latest ideas and technologies to deliver access to care that meets those needs and surpasses your expectations. For more information about Independence access our website at www.ibx.com. We’re revolutionizing health care, and our focus is on you!
Equal Employment Opportunity
Independence Blue Cross is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to their age, race, color, religion, sex, national origin, sexual orientation, protected veteran status, or disability.
Agency Disclaimer
All resumes submitted directly to an Independence Blue Cross employee from a vendor via email, the Internet or in any other form without a valid written search agreement in place for this position from the Independence Blue Cross Family of Companies Human Resources Department will be deemed the sole property of Independence Blue Cross and the Independence Blue Cross Family of Companies. Please note that no fee will be paid in the event the candidate is hired by Independence Blue Cross or the Independence Blue Cross Family of Companies as a result of the referral or through means other than our established process.