Data Analyst II

Information technology is the backbone of Blue Cross Blue Shield of Michigan and Blue Care Network, supporting everything we do to improve the health of Michigan’s residents and communities.  We are invested in advancing technology to provide best-in-class customer support, protect member information with enhanced security, and develop sophisticated technologies. Join us and help shape the future of IT and health care in Michigan.

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: database,software development,teamwork,analysis,support,technical,reporting,process management,management,experience,knowledge,departmental preferences,education,skills

Full-time

Competitive Total Compensation Package

Overview: Develop medium to highly complex logical database designs, logical data models and relational data definitions in support of corporate and customer information systems requirements. 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.
Responsibilities: <ul> <li>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. Act as a gatekeeper for new data that do not meet the set business requirements.</li> <li>Gather and document the data needs of the organization. Work with business and vendor partners, and project delivery leads to gather reporting requirements. Interpret and document the data needs for the business.</li> <li>Collect, analyze and summarize data to support business decisions. Design reports to identify patterns and trends. 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. Provide data that is congruent and reliable and is easily accessible by the user. Identify opportunities for reuse of data across the enterprise. Validate data sources. Assist with management of all metadata associated with individual models. Manage the flow of information between departments.</li> <li>Translate business requirements into conceptual, logical and physical data model. Develop and maintain an integrated logical and physical data model. Assist in creating a framework for representing the data elements including the entities, relationships and attributes. Recognize and resolve conflicts between models, ensuring that data models are consistent with the enterprise model (e.g., entity names, relationships and definitions). Work closely with other IT groups to use the data models throughout the whole life cycle.</li> <li>Ensure and maintain a high level of data integrity by using tools to monitor and mass update data changes. Develop data profiling and preventative procedures to improve data quality. Monitor and resolve daily exception reports. Analyze data inaccuracies and recommend process improvements or system changes to enhance overall quality of the data. Communicate data integrity accuracy to the business, and escalates/communicates issues when necessary. Identify opportunities and support the development of automated solutions to enhance the quality of enterprise data. Analyze data issues and work with development teams for problem resolutions. Monitor data dictionary statistics, analyze reports of data duplicates or other errors to provide ongoing appropriate data reports. 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.</li> <li>Research and resolve production problems/system abends.</li> <li>Assist with creating data quality metrics for identifying data related issues. Test and produce metrics and samples for further analysis. Identify opportunities for process improvements. Support the development of automated solutions that will enhance the quality of enterprise data. Develop and maintain technical documentation about the data.</li> <li>Assist in the coaching and training of customers in the use of business intelligence tools to enhance business decision-making capability.</li> <li>Other duties may be assigned.</li> </ul>
Requirements: <p><strong><u>DEPARTMENTAL PREFERENCES</u></strong></p> <p><strong>Engagement Description&nbsp;-&nbsp;A brief description of the project or initiative. Include:</strong></p> <ul> <li>Data analyst will work with Master Data Management team primarily supporting reference data management. This resource will also support entity definition and management, and data relationship management.</li> </ul> <p><strong>Top 3 Required Skills/Experience&nbsp;&ndash; The most important must-have skills. Include:</strong></p> <ul> <li>Experience supporting/developing data governance for reference data.</li> <li>Experience defining business process related to reference data.</li> <li>Experience supporting master data management solution(s) in a big data environment.</li> </ul> <p><strong>Required Skills/Experience&nbsp;&ndash; The rest of the required skills/experience. Include:</strong></p> <ul> <li>Working with IBM, Informatica, Attacama data management tools.</li> <li>Experience defining reference data, hierarchy, attributes and definitions.</li> <li>Experience leading role out/ delivery of reference data management solutions.</li> </ul> <p><strong>Preferred Skills/Experience&nbsp;&ndash; Optional but preferred skills/experience. Include: </strong></p> <ul> <li>Minimum of 3 years working as a data analyst in a healthcare setting.</li> <li>Minimum of 2 years working with a reference data management solution.</li> <li>Demonstrated experience working in a delivery lead role responsible for planning, organizing, and allocating work deliverables.</li> </ul> <p><strong><em>EDUCATION AND/OR EXPERIENCE</em></strong></p> <ul> <li>Bachelor's degree in related field preferred.</li> <li>Three (3) years IT work experience in data modeling, data analysis, relational DBMS design and support and relevant computing environment required.</li> </ul> <p><strong><em>OTHER SKILLS AND ABILITIES</em></strong></p> <ul> <li>Must have a solid understanding of logical database design principles.</li> <li>Understand the methodologies and technologies that depict the flow of data within and between technology systems and business functions/operations.</li> <li>Analytical thinking accuracy and attention to detail skills.</li> <li>Written and verbal communication skills interpersonal skills.</li> <li>Ability to establish and maintain effective working relationships with team members.</li> <li>Other related skills and/or abilities may be required to perform this job.</li> </ul>