Manager-Reporting and Data Management

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="" 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="" 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="" target="_blank" rel="noopener noreferrer">Click here</a> to view open positions.

keywords: analysis,departmental preferences,management,initiate,provide,teamwork,quality assurance,consulting,knowledge,degree,experience,teamwork,management,finance


Competitive Compensation and Benefits Package

Overview: Evaluate and assess risks to safeguard the financial assets of the company.<br /> <p style="font-weight: 400;"><strong>Departmental Preferences</strong></p> <ul style="font-weight: 400;"> <li>Six or more years of experience in reporting, analytics, data science, or related field - especially in health insurance.</li> <li>Comprehensive knowledge of Data warehousing, data analysis, and Business Intelligence / Data mining tools.</li> <li>Strong proficiency in SQL, or another BI-relevant language/platform (WebFocus, SAP Business Intelligence, SPSS, SAS, R, Tableau, etc).</li> <li>Experience with relational databases and the ability to work with big data sets.</li> <li>Experience with data quality, cleansing, and transformation.</li> </ul>
Responsibilities: <ul> <li><span style="font-size: small;">Provide consultative analysis on BCBSM's value proposition (how our products add value to the customer) to internal &amp; external stakeholders and partner with the business segments to meet corporate underwriting financial goals and associated P&amp;L objectives.&nbsp;</span></li> <li><span style="font-size: small;">Lead, facilitate, direct and coordinate the production of renewal rates or new business proposals, cost estimates for benefit modifications and various coordinating reports. Manage and communicate results of renewal and quote adequacy monthly meetings.&nbsp;</span></li> <li><span style="font-size: small;">Assess, approve, reject or make recommendations for complex underwriting rating policy exception requests taking into consideration financial and operational impact.&nbsp;</span></li> <li><span style="font-size: small;">I</span><span style="font-size: small;">nitiate and maintain appropriate rating and underwriting policies, procedures, systems, documentation and audit readiness to comply with state and federal requirements.&nbsp;</span></li> <li><span style="font-size: small;">Ensure application of underwriting practices and processes including risk management, differences in insured vs ASC programs, managing stop-loss, demographic rating vs claims rating.&nbsp;</span></li> <li><span style="font-size: small;">Maintain knowledge of systems and cross corporate workflows to ensure all processes for the team are completed with an end-to-end view.&nbsp;</span></li> <li><span style="font-size: small;">Manage and/or enhance reporting capabilities for financial forecasting, membership and performance metric reporting. Responsible for presenting department and divisional impacts of financials / membership results to internal and external stakeholders.&nbsp;</span></li> <li><span style="font-size: small;">Use judgment to recommend actions related to talent such as: interview, hire, orient, train, performance evaluation, feedback, coach, discipline and develop.&nbsp;</span></li> <li><span style="font-size: small;">Develop short and long term goals to realize corporate, divisional and departmental objectives. Participate and lead project work in support of the business strategy.</span></li> <li><span style="font-size: small;">Other duties as assigned.</span></li> </ul>
Requirements: <ul style="font-weight: 400;"> <li>Bachelor's Degree in Mathematics, Statistics, Finance, Accounting, Economics, or related field required. Master's Degree preferred.</li> <li>Six (6) years of experience in rating/underwriting or related field with two (2) years at a Senior Underwriter or leadership level.</li> <li>Experience with: actuarial and group insurance principles, health care benefits and claims processing procedures, rating formulas, self-funded and alternative financial arrangements, and the systems and mainframe applications.</li> <li>Ability to participate in multifunctional workgroups as SME or Business Lead</li> <li>Ability to analyze financial data, draw valid conclusions, suggest reasonable solutions and prepare summary reports required.</li> <li>Strong understanding of mathematics principals and their practical applications required.</li> <li>Excellent verbal and written communication skills required including the ability to present to executive leadership and external customers.</li> <li>Ability to function independently under minimal supervision adjusting effectively to changes in work and keeping an open mind to new and better ways of accomplishing results.</li> <li>Knowledge of Microsoft Excel, Word and PowerPoint required.MS Access &amp; Visual Basic required.</li> <li>Ability to maintain knowledge of Federal and State laws and regulations related to health care delivery systems (HMO, PPO, ACO, etc.) and sales distribution channels required.</li> <li>Good organizational and time management skills with an ability to handle multiple tasks.</li> <li>Strong understanding of national &amp; local competitive landscape and apply it to rating decisions and consultative analysis.</li> </ul>