Logo
Delta Dental of Minnesota

Data Analyst

Delta Dental of Minnesota, Minneapolis, Minnesota, United States, 55400


GENERAL SUMMARYThe Data Analyst will support the data analysis and analytical needs of the organization by applying the knowledge of mathematics, probability, statistics, data analytics, BI Analytics/reporting tools, and the principles of finance and business. Responsible for analyzing data and converting it to actionable information through the creation and implementation of innovative, flexible, and informative reports to drive growth, margin improvement, and strategic business management. This position will author and create database queries, formatted reports, and dashboards, interpret data and analyze results through statistical techniques. The position is responsible for monitoring and ensuring data integrity. As a member of an Agile team, this position is responsible for meeting Sprint goals, delivering business insights, and compelling data analysis products.ESSENTIAL FUNCTIONSData Expertise

Knowledge of the different data sources available for analysis and the ability to identify the source or sources of data best suited for each situation.Understand the data in each data source as well as the opportunities and limitations of using the data.Provide requirements for new data tables/data needs to support analysis.Perform the essential functions such as:Queries, aggregates, and formats data for data extracts, reports, and dashboards.Create, implement, and maintain reports and dashboards (ad-hoc/scheduled) using business intelligence tools.With minimal guidance, provides troubleshooting and analysis for business questions, with an eye toward possible solution implementation.Partners with IT colleagues and business users to understand data requirements and create proofs of concept deliverables where necessary.Develops and documents data dictionaries.Documents and tracks work using modern project, feature, and solution tracking tools such as JIRA.

Data Analytics

Analysis of products and related factors, including, but not limited to, claims experience, profit margins, administrative expenses, rate adequacy, sales, terms, provider reimbursements, network value, experience studies, and competitive positioning.Analyze and proactively monitor the current reporting/business intelligence environment, including recommending improvements.Collaborate with other internal teams on data analysis needs and work with these teams to define the purpose and scope of analysis, perform the analysis, and communicate the results.Support the data needs/analysis related to the strategic planning process.Conduct analysis of various business relationships and partnerships including analysis of key experience drivers.Analyze ongoing claim trends including, but not limited to, trends in utilization, fee inflation, and intensity in aggregate as well as within specific blocks of business, or subsets of specific blocks of business.Develop solutions to streamline data analysis to support departmental and company-wide data needs more effectively and efficiently.

External Industry Awareness

Identify and analyze the internal and external factors which affect statistics for use in data analysis, forecasting, trending, reporting/dashboarding, etc.Keep informed about analytical tools/concepts available to support necessary analysis and understand the application/relevancy to Delta Dental's business model.Keep informed about market conditions, competitive information, and political factors that may impact the goals and interests of the organization. Communicate key developments to appropriate stakeholders and use information appropriately when performing analysis or collaborating on internal and external projects.

Special projects and other job-related duties as assigned.REQUIRED KNOWLEDGE, SKILLS, AND ABILITIESExperience formatting data extracts into business-friendly reports, charts, and dashboards. (Power BI experience a plus)Experience using SQL (oracle preferred, but not required) and proficiency in MS Excel (Pivot tables, VLOOKUP), Business Intelligence, and proprietary software applications.Knowledge of Python (or other object-oriented programming languages) is a plus.Demonstration of strong analytical and problem-solving abilities.Ability to establish priorities and make decisions and to work independently and accurately, using good analytical and organizational skills.Proven history and consistent ability to multi-task in a fast-paced environment.Aptitude to learn new technologies and new languages independently.Collaborate regularly with business users to define needs.Ability to work effectively with other information technology staff.Advanced verbal and written communication skills.REQUIRED EDUCATION AND EXPERIENCEBachelor's degree in Computer Science, Information Systems, Mathematics, related field and/or equivalent work experience.Minimum 2 years of related data analytics work experience.WORK ENVIRONMENT/PHYSICAL DEMANDSTravel Requirements:

Minimal local.Weight Lifting Requirements:

up to 20 lbs.RELATIONSHIPSReports To:

Data Analytics Manager.Directly Manages:

None.Internal Relationships:

Technology Services staff, Project Management, Other business stakeholders and product owners.External Relationships:

External vendors and Business affiliates.Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities.

#J-18808-Ljbffr