What are the responsibilities and job description for the Data Analyst II position at Benefitfocus?
Advanced Data Analyst – 100% Remote
Benefitfocus Inc.
Benefitfocus, Inc. (NASDAQ: BNFT) is a leading provider of cloud-based benefits software solutions for consumers, employers, insurance carriers and brokers. Benefitfocus has served numerous consumers on its platform that consists of an integrated portfolio of products and services enabling clients to more efficiently shop, enroll, manage and exchange benefits information. With a user-friendly interface and consumer-centric design, the Benefitfocus Platform provides one place for consumers to access all their benefits. Benefitfocus solutions support the administration of all types of benefits including core medical, dental and other voluntary benefits plans as well as wellness programs.
As a Data Analyst II with our Data Services team, you will be responsible for ensuring the integrity and synchronization of the data we provide to our clients and integrated partners. You will be tasked with ensuring that inbound data is received and processed timely, outbound data is sent accurately and within client processing deadlines, and with tracking daily, weekly or monthly metrics. You will perform detailed triage and root cause analysis for data issues found during file validation processes or for issues reported by customers, internal teams, and integrated partners. Additional responsibilities will include coordinating fixes or improvements to data issues through partnership with engineering, configuration, and customer support/management teams and occasional direct customer contact.
Responsibilities:
- Perform triage, root cause analysis, and corrections to data issues found during validations
- Perform triage, root cause analysis, and corrections to data issues reported by customers or exceptions reports
- Research Data Discrepancies encountered during extraction and reported by trading partners
- Coordinate fixes or improvements to data issues across multiple departments
- Resolve customer and internal escalations in a timely manner
- Perform prioritization of daily tasks to ensure on time file delivery and timely corrections
- Execute testing on new product releases for data processing related changes
- Execute tasks related to operationalizing new process and tool improvements
- Exercise judgment in escalating issues to management
- Manage EDI file schedule changes and file processing enhancements
- Manage EDI file go-lives and handoffs from Benefitfocus delivery teams
- Train new team members on processes and tools for performing complex Data Analyst duties
- Identify opportunities to improve our processes or technology to achieve increased efficiency and/or quality
- Extract, validate and deliver EDI files that are too complex to be processed by the Data Analyst
- Process ad hoc test and production files and open enrollment files
- Proactively notify internal teams if/when files will not meet their agreed upon deadlines
- Develop relationships with internal Benefitfocus teams
- Other duties as assigned
Requirements:
- BA/BS degree or equivalent
- Minimum of 2 years of relevant experience
- Must be an independent worker that can work in a fast paced, changing environment
- Must be able to work across multiple departments to support internal customers
- Must be a strong analytical thinker - Must have the ability to handle multiple tasks simultaneously
- Strong verbal and written communication skills required
- Advanced Excel and Database Management System skills a plus (Oracle, SQL, Access)
- Prior Salesforce experience a plus
- Microsoft Office suite (Outlook, Word, Excel)
Mymap: Data Analyst II