What are the responsibilities and job description for the Data Engineer II position at Navia Benefit Solutions?
This is a remote opportunity or hybrid depending on location.
This position pays $75,000-$85,000
This position pays $75,000-$85,000
Position Summary |
The Data Engineer supports data requests for data integrations and migrations, EDI or API integrations with external trading partners, Power BI visualizations, and BI development. This includes guiding projects to completion by establishing schedules and coordinating tasks required to complete, creating logical data mappings and documentation, developing data integration flows, testing data integrations with QA staff, and implementation support. This position must also gain a solid understanding of business requirements, industry standards and guidelines to ensure compliance is met with internal and external partners. |
Essential Functions |
- Maintain EDI standards and implementation guides to document data exchange requirements
- Perform set-up of new trading partners, including coordination of optional fields, testing, and verifying that EDI HIPAA standards are being followed
- Develop and maintain relationships with external trading partners
- Act as a focal point for transactional data exchanges between Navia and trading partners
- Troubleshoot transactional data exchanges with internal departments and external trading partners
- Work with others to identify system problems and recommend solutions to improve processing efficiency and stability
- Demonstrated experience with EDI translators, mapping external business documents with internal data structures, including but not limited to EDI transactions and resolving transmission and data structure issues with trading partners
- Familiarity with the enrollment formats and APIs (e.g., 834 for COBRA benefits)
- Effectively communicates issues to management in a technically skilled manner and with strong focus on customer service
- Strong attention to detail with the ability to quickly assess and analyze problems and develop solutions
- Interface with business analysts and product owners on project/request requirements to turn into specifications for development.
- Prototype gathering via T-SQL and/or visualizing data in Excel or PowerBI for projects/requests facilitating better understanding of customer requirements.
- Lead or assist in developing Boomi processes with subject matter expertise.
- Lead or assist with data quality analysis with T-SQL scripts, scripting languages, and/or Excel macros.
Requirements |
- Familiarity with EDI document standards (e.g., the 834 or 837 specification)
- 2-3 years of T-SQL coding experience
- SQL Server Management Studio (SSMS) familiarity
- 2-3 years of experience with Power BI or like tools in creating data models, visualizations, and transformations
- 2 years of data integration tool (e.g., Boomi, MuleSoft, or Wakato) development experience in creating EDI or API interchanges
- 2 years of experience with Postman for API integrations
- 2 years of experience with the Python, PowerShell, or JavaScript scripting languages
- Strong written and verbal communication skills.
- High attention to detail with large volumes of data.
- Ability to self-manage and prioritize tasks with strict deadlines.
- Must be able to create relationships through phone/email correspondence.
- Basic knowledge of Microsoft Word, Outlook, Excel, Access, Adobe, XML and JSON.
Please visit our career page and apply directly: www.naviabenefits.com/workatnavia
Not all positions allow for remote work, but those that do will only be available in the following states: AZ, CA ,CO, FL, GA, IL, IN, KS, MI, MN, MO, MT, NC, ND, NE, NJ, NV, NY, OH, OR, PA, TN, TX, UT, AND WA
Salary : $75,000 - $85,000
