Sales Reporting Analyst (W2 ONLY)
Philadelphia, PA 19103
NO VISA/NO C2C/NO 3 RD PARTY CANDIDATES
6-months Contract-to-Hire
Must work onsite every Tuesday-Wednesday-Thursday). DO NOT APPLY if are not CURRENTLY living in the Greater Philadelphia, PA area.
Pay: $33/hour on W2
Send resume to asim dot ghosh at insourcenow dot com
POSITION SUMMARY
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 the organization to accurately report current data and forecast for upcoming year. The individual should have strong Microsoft Excel skills and experience with Power BI and SQL.
Job Duties
- 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.
Requirements
- 1-3 years of relevant experience in a Reporting Analyst role.
- Must have strong experience in MS Excel & Access.
- Some experience in writing basic SQL queries (or using existing queries), is desirable.
- Experience in Power BI is preferred, but not required.
- Experience in any CRM tool is preferred, but not required.
- Must have demonstrated ability to prepare reports, presentations, and executive summaries for senior management meetings.
- Proven statistical and analytical experience in corporate environment.
- Strong written and verbal communication skills required, to include the ability to communicate with all levels of management.
- 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.
- Bachelor s degree in Business, Accounting, Finance or related field is preferred, but not required.