Data Analyst II

<p>With more than 8,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. Interested in joining us?</p>

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.&nbsp; http://www.bcbsm.com

keywords: database,software development,teamwork,analysis,support,maintain,design,reporting,production,research,process management,teamwork,management,knowledge,performance,education,experience,analysis,communication

Analyst

Competitive Total Compensation Package

Overview: <span style="font-size: small;">Develop medium to highly complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements.&nbsp; Work closely with customers, vendors, business analysts and application development project teams to resolve information flow and content issues. Work on multiple large complex projects/issues/enhancements as a team member or lead.</span>
Responsibilities: Provide input in support of the strategic planning process and short and long term planning. Assist in establishing and maintaining standards for data quality and the development of data standards, policies and procedures. Work with IT teams to ensure compliance.&nbsp; Act as a gatekeeper for new data that do not meet the set business requirements. Gather and document the data needs of the organization.&nbsp; Work with business and vendor partners, and project delivery leads to gather reporting requirements.&nbsp; Interpret and document the data needs for the business. Collect, analyze and summarize data to support business decisions.&nbsp; Design reports to identify patterns and trends.&nbsp; Design, develop and deploy query parameters, layout, filters, and analytics for program information solutions. Ensure that the information is named properly and defined consistently across the organization.&nbsp; Provide data that is congruent and reliable and is easily accessible by the user.&nbsp; Identify opportunities for reuse of data across the enterprise. Validate data sources.&nbsp; Assist with management of all metadata associated with individual models.&nbsp; Manage the flow of information between departments. Translate business requirements into conceptual, logical and physical data model.&nbsp; Develop and maintain an integrated logical and physical data model.&nbsp; Assist in creating a framework for representing the data elements including the entities, relationships and attributes.&nbsp; Recognize and resolve conflicts between models, ensuring that data models are consistent with the enterprise model (e.g., entity names, relationships and definitions).&nbsp; Work closely with other IT groups to use the data models throughout the whole life cycle. Ensure and maintain a high level of data integrity by using tools to monitor and mass update data changes.&nbsp; Develop data profiling and preventative procedures to improve data quality.&nbsp; Monitor and resolve daily exception reports.&nbsp; Analyze data inaccuracies and recommend process improvements or system changes to enhance overall quality of the data.&nbsp; Communicate data integrity accuracy to the business, and escalates/communicates issues when necessary.&nbsp; Identify opportunities and support the development of automated solutions to enhance the quality of enterprise data.&nbsp; Analyze data issues and work with development teams for problem resolutions.&nbsp; Monitor data dictionary statistics, analyze reports of data duplicates or other errors to provide ongoing appropriate data reports.&nbsp; Identify problematic areas and conduct research to determine the best course of action to correct the data, identify, analyze and interpret trends and patterns in complex datasets. Research and resolve production problems/system abends. Assist with creating data quality metrics for identifying data related issues. Test and produce metrics and samples for further analysis.&nbsp; Identify opportunities for process improvements.&nbsp; Support the development of automated solutions that will enhance the quality of enterprise data. Develop and maintain technical documentation about the data. Assist in the coaching and training of customers in the use of business intelligence tools to enhance business decision-making capability. Other duties may be assigned.
Requirements: <div id="requisitionDescriptionInterface.ID1574.row1" class="inlinepanel" title=""><span class="subtitle">Qualifications</span></div> <p><strong><span style="font-size: small;">EDUCATION AND/OR EXPERIENCE</span></strong></p> <ul> <li><span style="font-size: small;">Bachelor&rsquo;s degree in related field preferred.</span></li> <li><span style="font-size: small;">Three (3) years IT work experience in data modeling, data analysis, relational DBMS design and support and relevant computing environment required.</span></li> </ul> <p><strong><span style="font-size: small;">OTHER SKILLS AND ABILITIES</span></strong></p> <ul> <li><span style="font-size: small;">Must have a solid understanding of logical database design principles.</span></li> <li><span style="font-size: small;">Understand the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations.</span></li> <li><span style="font-size: small;">Analytical thinking accuracy and attention to detail skills.</span></li> <li><span style="font-size: small;">Written and verbal communication skills interpersonal skills.</span></li> <li><span style="font-size: small;">Ability to establish and maintain effective working relationships with team members.</span></li> <li><span style="font-size: small;">Other related skills and/or abilities may be required to perform this job.<br /></span></li> </ul> <p><em>All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, protected veteran status or status as an individual with a disability.</em></p>