Data Engineer II

Location: Remote
Salary Range: $95,000-$110,000 Annually

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 and API integration standards and implement guides to document data exchange requirements
• Perform set-up of new trading partners; including configuration, testing, and verifying that EDI HIPAA standards are being followed
• Lead on API projects in assessing feasibility and work effort for estimating project timelines
• Develop and maintain relationships with external trading partner subject matter experts
• 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 equivalent API calls (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 data via T-SQL and/or visualizing outcomes 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, command line scripting languages, and/or Excel macros.

• Requirements

• Familiarity with EDI document standards (e.g., the 834 or 837 specification)
• 3-5 years of T-SQL coding experience
• SQL Server Management Studio (SSMS) familiarity
• 3-5 years of experience with Power BI or like tools in creating data models, visualizations, and transformations
• 3+ years of data integration tool (e.g., Boomi, MuleSoft, or Wakato) development experience in creating EDI or API interchanges
• 3+ years of experience with Postman for API integrations
• 3+ years of experience with Python, PowerShell, or JavaScript scripting languages
• 3+ years of experience with Git or other Git based source control (e.g., Bitbucket)
• Working knowledge of SFTP and PGP/GPG encryption a plus
• 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:

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