The 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.
This position is offered by Abōva Talent, LLC, a subsidiary of Stratacor and an affiliate of Delta Dental of Minnesota.
Essential Functions
Data 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 Abilities
Experience 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 Experience
Bachelor'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 DEMANDS
Travel Requirements: Minimal local
Weight Lifting Requirements: up to 20 lbs.
RELATIONSHIPS
Reports 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
Seniority level
Entry level
Employment type
Full-time
Job function
Information Technology
Industries
Insurance
Referrals increase your chances of interviewing at Delta Dental of Minnesota by 2x