Senior Analyst (Data and Reporting) - IBU Operations

With more than 7,000 employees, we are the largest health insurance company in Michigan. We offer an exciting work environment with a diverse group of employees. Our goal is to make health insurance easier for our members. We want to transform the industry and become a resource that people can trust.

Detroit, MI

Blue Cross Blue Shield of Michigan

When you think of <a href="https://www.bcbsm.com/" target="_blank" rel="noopener noreferrer">Blue Cross Blue Shield of Michigan</a> for health insurance, you can know you&rsquo;re getting much more. We're a company founded on a tradition of affordable, quality health care for everyone, improving the present and investing in the future.<br /><br />We offer:<br />Plans for employers and individuals that meet today&rsquo;s needs, budgets and lifestyle<br />The largest network of doctors and hospitals in the state<br />Lower health care costs Higher quality health care<br />Award-winning diversity practices<br />Grants and programs that promote better health throughout Michigan<br /><strong><br />Mission:&nbsp;</strong>We commit to being our members&rsquo; trusted partner by providing affordable, innovative products that improve their care and health.<br /><br /><a href="http://www.bcbsm.com/index/about-us/our-company.html" target="_blank" rel="noopener noreferrer"><strong>Click here</strong></a> to learn more about our commitment to our Social Mission, view company updates and reviews, and view our awards &amp; accolades.<br /><br />Learn more about your options as an external candidate. <a href="https://bcbsm.taleo.net/careersection/2/jobsearch.ftl?lang=en" target="_blank" rel="noopener noreferrer">Click here</a> to view open positions. http://www.bcbsm.com

keywords: reporting,project management,critical thinking,quality assurance,leadership,communication,quality assurance,prepare,consulting,maintain,analysis,database,performance,build,teamwork,compliance,leadership,communication,analysis,experience,insurance,technical,maintain,degree,department requirements,technology,relationships,teamwork,organization

Full-time

Competitive Total Compensation Package

Overview: Encompassing business and IT experience, the Sr Analyst will be responsible for supporting the data &amp; reporting needs of various departments of the Individual business segment (Operation, Sales, Marketing, Distribution, etc.). Gather and clarify business requirements with the customer to understand the business need. Learn the customer's business processes and help deliver projects requiring data, reporting and dashboards. Work on several applications and/or projects simultaneously, mainly involving Salesforce. Leadership responsibility to coordinate the development and implementation of programs (Salesforce) and strategies to improve service to our customers.<br /><br />Job functions include but are not limited to developing Salesforce queries for data extraction and conversions, report creation, data visualization and dashboards. Also, trouble-shooting data-related issues, and reviewing quality controls. Ideal candidate will be a self-starter, willingness to learn new skills, and creativity and critical thinking ability is a must.<br />Must have strong communication and customer engagement skills given their role in explaining and clarifying issues with the customer. In some cases, this individual will own specific data and reporting deliverables, and have responsibility for the health of the data within their scope of influence.
Responsibilities: <ul> <li> <div><span style="font-family: Arial; font-size: small;"><strong>Retrieve data from various sources and prepare data for analysis and reporting.</strong></span></div> </li> <li> <div><span style="font-family: Arial; font-size: small;"><strong>Develop Salesforce and SQL Database queries and reports to fulfill daily, monthly, or ad hoc requests.</strong></span></div> </li> <li> <div><span style="font-family: Arial; font-size: small;"><strong>Build and implement dashboards, and the reports to populate the dashboard, to support the business areas in the IBU, as well as for senior leaders.</strong></span></div> </li> <li> <div><span style="font-family: Arial; font-size: small;"><strong>Work on data manipulation and extraction of data using Salesforce and related technologies.</strong></span></div> </li> <li> <div><span style="font-family: Arial; font-size: small;"><strong>Quality Assurance - Verify accuracy of data pulled and revise methods of data retrieval by following a standard process.<br /></strong></span></div> </li> <li> <div><span style="font-family: Arial; font-size: small;"><strong>Perform internal audits: gather data from various sources/applications and databases to validate audit steps performed; evaluate quality assurance.</strong></span></div> </li> <li> <div><span style="font-family: Arial; font-size: small;"><strong>May provide data and respond to questions to external partners/agencies/vendors.</strong></span></div> </li> <li> <div><span style="font-family: Arial; font-size: small;"><strong>Write queries and stored procedures to review results for quality and data integrity and send results to internal clients or external partners.</strong></span></div> </li> <li> <div><span style="font-family: Arial; font-size: small;"><strong>Other duties may be assigned.</strong></span></div> </li> </ul> <p><span style="font-family: Arial; font-size: small;">Develop and improve work flows and business processes within area(s) to improve customer service, decrease operational costs and improve overall quality. Identify and/or analyze business problems and devise procedures for solutions to the problems. Effectively lead projects/teams in order to produce desired results. Responsible for corporate communication of project results. Recommend and assist with implementing standard policies and procedures for providing routine service. Assure that corporate compliance is communicated, implemented and monitored on an ongoing basis.&nbsp; Participate in systems testing, develop procedures/controls and provide recommendations for the ongoing improvement of the updated process. Assist personnel (both internal and external) by answering questions, supplying information and training. Develop and maintain an effective working relationship with customers.&nbsp;</span></p>
Requirements: <ul> <li>Bachelor's Degree in a related field is preferred.</li> <li>Four (4) years of experience in a related field is required.</li> <li>Excellent analytical and problem-solving skills to identify, evaluate, recommend and implement changes to processes or procedures to address problems and improve departmental effectiveness.</li> <li>Organizational skills and ability to prioritize; must be able to lead multiple activities with varying timelines.</li> <li>Excellent verbal, written communication and interpersonal skills.</li> <li>Ability to lead and contribute to business unit and/or corporate projects.</li> <li>Proficient in Microsoft Office Suites.</li> <li>Ability to develop and maintain effective working relationships.</li> <li>Other related skills and/or abilities may be required to perform this job.</li> </ul> DEPARTMENT REQUIREMENTS<br /> <ul> <li>Ability to work under general direction.</li> <li>Ability to work effectively in a collaborative, team environment.</li> <li>Experience with data, reporting, and dash boarding concepts.</li> <li>Good analytical, organizational, planning, verbal and written communication skills.</li> <li>Desire to develop decision analysis capabilities.</li> <li>Highly self-driven and self-motivated.</li> <li>Health Insurance industry experience preferred.</li> </ul> Additional Qualifications:<br /> <ul> <li>Ability to understand compile information from multiple sources and present them in a clean understandable conclusion for the required audience.</li> <li>Strong business, client orientation. Good balance between business and technical skills.</li> </ul>