Demo
Salary Resume Critique Job Openings

Data Engineer

Allergy Partners
Asheville, NC Full Time
POSTED ON 1/31/2025
AVAILABLE BEFORE 4/27/2025

Job Details

Job Location

95-00-Corporate - Asheville, NC

Remote Type

Fully Remote

Description

POSITION : Data Engineer

RESPONSIBLE TO : Vice President of Systems and Growth

JOB SUMMARY : The Data Engineer is responsible for designing, developing, testing, and maintaining database applications using SQL (Structured Query Language). The Data Engineer works with various data sources, such as relational databases, data warehouses, cloud databases, and APIs, to create queries, reports, dashboards, and data pipelines that meet the business requirements and data standards.

RESPONSIBILITIES INCLUDE, BUT ARE NOT LIMITED TO, THE FOLLOWING :

  • Write, optimize, and debug SQL queries, stored procedures, functions, triggers, and views.
  • Create and maintain database schemas, tables, indexes, constraints, and keys.
  • Develop and implement ETL (Extract, Transform, Load) processes to integrate data from various sources.
  • Design and develop data models, data dictionaries, and data quality rules.
  • Perform data analysis, validation, and troubleshooting to ensure data accuracy and integrity.
  • Collaborate with business analysts, developers, and stakeholders to understand and translate data requirements into technical solutions.
  • Document and test database applications and provide technical support and maintenance.
  • Follow and enforce best practices, standards, and security policies for database development and management.
  • Maintain master data mappings across multiple platforms including, but not limited to, CPS / NetSuite / Paycom in MS Power BI.
  • Execute stored procedures related to month end Accounting close process.
  • Perform manual inputs and execution of True-Up, Quarterly Biologics Adjustment, and any changes in processing rules or manual overrides as necessary.
  • Update relevant MS Power BI validation reports.
  • Monitor ETLs and integrations to systems and troubleshoot any issues.
  • Ability to define project scopes, develop detailed timelines, and assess potential risks from a data engineering perspective.
  • Demonstrate strong skills in articulating project requirements, managing deliverables, and coordinating with cross-functional teams to ensure successful project outcomes.

OTHER

  • Completes all assigned AP training (such as CPR, OSHA, HIPAA, Compliance, Information Security, others) within designated timeframes.
  • Complies with Allergy Partners and respective hub / department policies and reports incidents of policy violations to a Supervisor / Manager / Director, Department of Compliance & Privacy or via the AP EthicsPoint hotline.
  • Models the AP Code of Conduct and demonstrates a commitment to the AP Compliance Program, standards and policies.

    • SUPERVISORY RESPONSIBILITIES

    This position has no supervisory responsibilities.

    TYPICAL PHYSICAL DEMANDS

    Position requires sitting, standing, some bending, stooping, and stretching. Good eye-hand coordination and manual dexterity sufficient to operate lab equipment. Must be able to life 25 lbs.

    Qualifications

    EDUCATIONAL REQUIREMENTS :

  • Bachelor's degree in computer science, Information Systems, or related field, or equivalent work experience.

    • QUALIFICATIONS AND EXPERIENCE :

  • At least 8 years of experience as a SQL developer or a similar role.
  • Proficient in SQL and database development tools, such as SQL Server, Oracle, MySQL, PostgreSQL, or SQLite.
  • Experience with ETL tools, such as SSIS, Informatica, Talend, or Pentaho.
  • Ability to work with multiple healthcare-related technologies (HL7, CCD, CCD-A, etc.) is highly preferred to ensure seamless data interoperability and compliance with industry regulations.
  • Knowledge of data modeling, data warehousing, and business intelligence concepts and tools.
  • Strong analytical, problem-solving, and communication skills.
  • Ability to work independently and as part of a team.
  • Attention to detail and quality.
  • Expertise in MS Power BI and Data Analysis Expressions (DAX).
  • Familiarity with the data warehouse and business functions of Allergy Partners, such as Internal CPT to GL Mappings, Allowance Rates, True-Up Distribution, MSO Rate Calculation, and Provider Revenue for Compensation including Injection Reallocation.

    • If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Data Engineer?

    Sign up to receive alerts about other jobs on the Data Engineer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $92,929 - $122,443
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $122,257 - $154,284
    Income Estimation: 
    $143,391 - $179,890
    Income Estimation: 
    $71,122 - $96,652
    Income Estimation: 
    $92,929 - $122,443
    Employees: Get a Salary Increase
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Allergy Partners

    Medical Assistant
    Allergy Partners
    Hired Organization Address Santa Fe, NM Full Time
    POSITION: Medical Assistant RESPONSIBLE TO: Practice Manager JOB SUMMARY: Coordinates patient care with physician, assis...
    Patient Service Representative
    Allergy Partners
    Hired Organization Address Springfield, VA Full Time
    Job Details Job Location 88-00-Springfield - Springfield, VA Description POSITION : Patient Services Representative RESP...
    Patient Service Representative
    Allergy Partners
    Hired Organization Address Henderson, NV Full Time
    POSITION: Patient Services Representative RESPONSIBLE TO: Practice Manager JOB SUMMARY: With a customer service orientat...
    Patient Service Representative
    Allergy Partners
    Hired Organization Address Vienna, VA Full Time
    POSITION: Patient Services Representative RESPONSIBLE TO: Practice Manager JOB SUMMARY: With a customer service orientat...
    View More Jobs at Allergy Partners

    Not the job you're looking for? Here are some other Data Engineer jobs in the Asheville, NC area that may be a better fit.

    Data Engineer

    ALLERGY PARTNERS, Asheville, NC

    Data Engineer

    Twenty Ideas, Asheville, NC

    View More Jobs

    AI Assistant is available now!

    Feel free to start your new journey!