Data Analyst III-IT Performance and Agility Office

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.&nbsp;<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 />For Application Timeline &amp; Selection Process:&nbsp;<a href="" target="_blank" rel="noopener noreferrer">Click Here</a>. Learn more about your options as an external candidate. <a href="" target="_blank" title="BCBSM" rel="noopener noreferrer">Click here</a> to view open positions.

keywords: position summary,analysis,teamwork,develop,create,research,performance,quality assurance,support,reporting,prepare,production,document,experience,knowledge,education,technical,create,analysis,communication,write,establish


Competitive Total Compensation Package

Overview: <p>&nbsp;</p> 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 enterprise-wide complex projects/issues/enhancements as a team member or lead.
Responsibilities: <ul> <li>Creating and implementing a data and reporting strategy with clear objectives and goals</li> <li>Performing ad hoc data analysis and summarizing observations and recommendations</li> <li>Collaborating with customers and other subject matter experts to understand their reporting needs</li> <li>Assisting with the development of a standard reporting catalog with user-friendly definitions</li> <li>Preparing and presenting to a variety of stakeholders, including executive leadership</li> <li>Participate in the development of short and long-term information architecture strategies, support and participate in the strategic planning process. Build data migration strategies.</li> <li>Provide support for master data management (MDM) system development, implementation, and maintenance. Participate in establishing governance for metadata management across the enterprise. Develop metadata integrity processes. Participate in the governance activities associated with ensuring compliance with the enterprise information/data architecture. Work with IT teams to ensure compliance. Perform regular audits of data.</li> <li>Work with business and vendor partners, and project delivery leads to determine business data intelligence needs. Interpret and document the data needs of the business. Analyze program needs and translate them into data warehousing and data mart requirements.</li> <li>Work in partnership with data architects to design the common customer view of information. Create and implement detailed specifications for metadata repository solutions. Manage the data dictionary. Define, document, and maintain all data definitions, data sources, business meaning, and usage of information. Develop a single source data strategy. Research internal and external data sources for new data and better sources of data feeds. Identify and validate opportunities to share/reuse existing data/information. Direct the production of regular reports and analysis of data.</li> <li>Create 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). Support the effort for high-level modeling of key program processes and key data entities. Ensure integration of the project logical data model into the enterprise conceptual data model and that physical models align with the logical data model.</li> <li>Develop solutions and recommendations for improving data integrity issues. Analyze data issues and work with development teams for problem resolutions. 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 business-critical production problems/system abends.</li> <li>Establish data profiling and preventative procedures to improve data quality. Create data quality metrics for identifying data-related issues. Collaborate with multiple teams to establish appropriate data access management.</li> <li>Ensure technical documentation is developed and maintained.</li> <li>Assist in the coaching and training of customers in the use of business intelligence tools to enhance business decision-making capability. Work with project teams to understand the business environment in order to manage enterprise-wide information/data support systems. Provide guidance on complex issues to other team members.</li> <li>Provide leadership, coaching, and mentoring to team members. Provide performance feedback to managers, as needed.</li> <li>Other duties as assigned.</li> </ul>
Requirements: <ul> <li>Extensive experience with Microsoft Power BI, Tableau, or other related business intelligence reporting tools</li> <li>Ability to create, maintain, and analyze databases using Microsoft Excel</li> <li>Working experience with Planview, including a solid understanding of its database schema and reporting features</li> <li>Ability to write complex queries using SQL Server</li> <li>Knowledge of Atlassian Jira is a plus</li> <li>Ability to interface with customers and provide technical support</li> <li>Experience with the Scaled Agile Framework (SAFe) is preferred</li> </ul> <p><strong>EDUCATION AND/OR EXPERIENCE</strong></p> <ul> <li>Bachelor's degree in related field preferred.</li> <li>Seven (7) years IT work experience with five (5) years in quality assurance and/or data management required.</li> <li>Expertise with data quality tools for data profiling, cleansing and standardization preferred.</li> <li>Experience in implementing solutions and processes for master data and hierarchy synchronizations preferred.</li> </ul> <p><strong>OTHER SKILLS AND ABILITIES</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> <div><em>All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, gender identity, protected veteran status or status as an individual with a disability.</em></div>