Data Engineer

1 week ago

Asheville, United States Allergy Partners Full time
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.

  • Data Engineer

    1 week ago

    Asheville, North Carolina, United States Allergy Partners Full time

    Job Title: Data EngineerAbout the Role:We are seeking a highly skilled Data Engineer to join our team at Allergy Partners. As a Data Engineer, you will be responsible for designing, developing, testing, and maintaining database applications using SQL (Structured Query Language).Key Responsibilities:Write, optimize, and debug SQL queries, stored procedures,...

  • Data Analytics Engineer

    1 month ago

    asheville, United States Insight Global Full time

    A company in the Asheville area is looking for a Data Analytics engineer to join their team. You will have the opportunity to produce datasets for users internal and external users that guide analysis and inform decision making, develop business requirements for new and existing data extracts and reports, document data workflows and provide solutions and...

  • Data Analytics Engineer

    1 month ago

    Asheville, United States Insight Global Full time

    A company in the Asheville area is looking for a Data Analytics engineer to join their team. You will have the opportunity to produce datasets for users internal and external users that guide analysis and inform decision making, develop business requirements for new and existing data extracts and reports, document data workflows and provide solutions and...

  • Data Analytics Engineer

    1 month ago

    asheville, United States Insight Global Full time

    A company in the Asheville area is looking for a Data Analytics engineer to join their team. You will have the opportunity to produce datasets for users internal and external users that guide analysis and inform decision making, develop business requirements for new and existing data extracts and reports, document data workflows and provide solutions and...

  • Data Engineering Manager

    7 days ago

    Asheville, North Carolina, United States Allergy Partners Full time

    Job OverviewWe are seeking an experienced Data Engineer to join our team at Allergy Partners. This is a fantastic opportunity for someone who wants to utilize their skills and knowledge to drive business growth and improve data quality.

  • Data Analytics Professional

    4 days ago

    Asheville, North Carolina, United States Insight Global Full time

    At Insight Global, we are seeking an experienced Data Analytics Professional to join our team in Asheville. This role will provide opportunities to work with diverse datasets, develop business requirements for new and existing data extracts, and create reports that combine data from multiple sources.Job Overview:This Data Analytics Professional position is...

  • Data Analytics Engineer

    1 month ago

    Asheville, NC, United States Insight Global Full time

    A company in the Asheville area is looking for a Data Analytics engineer to join their team. You will have the opportunity to produce datasets for users internal and external users that guide analysis and inform decision making, develop business requirements for new and existing data extracts and reports, document data workflows and provide solutions and...

  • Engineer III, Refrigeration

    1 week ago

    Asheville, United States Thermo Fisher Scientific Full time

    Work Schedule Standard (Mon-Fri) Environmental Conditions Office Job Description COMPANY: Thermo Fisher Scientific Inc. LOCATION: 275 Aiken Rd., Asheville, NC 28804 TITLE: Engineer III, Refrigeration HOURS: Monday to Friday, 8:00 am to 5:00 pm DUTIES: • Develop refrigeration systems to achieve the highest quality and long term reliability while at...

  • Engineer II, Mechanical

    2 days ago

    Asheville, United States Thermo Fisher Scientific Full time

    Work Schedule Other Environmental Conditions Office Job Description COMPANY: Thermo Fisher Scientific Inc. LOCATION: 275 Aiken Road, Asheville, NC 28804 TITLE: Engineer II, Mechanical HOURS: Monday to Friday, 8:00 am to 5:00 pm DUTIES: • Develop specifications for system-level, subsystem and component performance based on customer needs and...

  • Cyber Security Engineer

    7 days ago

    Asheville, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are in the process of recruiting a Cyber Security Engineer to become a part of our team. The position is based in Asheville, North Carolina. As a Cyber Security Engineer, you will be instrumental in enhancing our security stance through the implementation, management, and optimization of security solutions. This role offers a...

  • Cyber Security Engineer

    3 weeks ago

    Asheville, United States Robert Half Full time

    Job DescriptionJob DescriptionWe are in the process of recruiting a Cyber Security Engineer to become a part of our team. The position is based in Asheville, North Carolina. As a Cyber Security Engineer, you will be instrumental in enhancing our security stance through the implementation, management, and optimization of security solutions. This role offers a...

  • Lead Xray Engineer

    2 months ago

    asheville, United States GE Aerospace Full time

    The Xray L3/CA engineer will be responsible for ensuring business wide quality Xray processes, including Xray Computed Tomography. You will work with materials and design engineers, value stream engineers and shops, external vendors and research teams to develop and validate new material/part inspections. You will work directly with internal and external...

  • Software Engineer

    1 week ago

    Asheville, United States Alpha Omega Integration, LLC Full time

    Description Job Title: Software Engineer Clearance Required: Public Trust (National Agency Check with Inquiries (NACI)) Work Location: Remote; Asheville, NC; Silver Spring, MD; Stennis Space Center, MS; Boulder, CO The demand for high-value environmental data and information has dramatically increased in recent years. NOAA's National Centers for...

  • Senior Quality Assurance Engineer

    3 days ago

    Asheville, North Carolina, United States Thermo Fisher Scientific Full time

    OverviewAt Thermo Fisher Scientific, you'll be part of a dynamic team that drives innovation and excellence in the field of quality assurance. Our company is dedicated to working with customers to find cures for cancer, protect the environment, ensure food safety, and deliver COVID-19 solutions.Job DescriptionWe're seeking an experienced Senior Quality...

  • MarTech Lifecycle Specialist

    2 days ago

    Asheville, United States Aeroflow Full time

    The Opportunity Within Aeroflow, the Product Engineering team is composed of 50 team members including Software Engineers, Product Owners, Quality Testers, Marketing Tech, UX and UI experts. We focus on delivering high quality, best in class digital products and experiences to our patients and our internal colleagues. We support all of Aeroflow’s business...

  • Vehicle and Equipment Mechanic

    6 months ago

    Asheville, United States UNC Asheville Full time

    Position Summary This position performs semi-skilled and skilled small engine, automotive and heavy equipment mechanic work. The position also performs a variety of recurring and related tasks using steps and processes that are readily understood and that are associated with less complex systems and components. Work includes NC State Inspections, fluid...

  • Vehicle Service Technician

    4 weeks ago

    Asheville, North Carolina, United States UNC Asheville Full time

    This is a skilled Mechanic position that performs preventative maintenance, repairs, and troubleshooting on a variety of equipment and vehicles. The ideal candidate will have experience with small engines, heavy equipment, and automotive systems, as well as knowledge of hydraulic systems and emergency generators. A State Inspection License is preferred, and...

  • Survey Department Lead

    7 days ago

    Asheville, North Carolina, United States FutureRecruit Full time

    FutureRecruit seeks a highly experienced and skilled Survey Project Manager to lead its survey department activities. This is an exceptional opportunity for a professional land surveyor to grow their career with our company.About the RoleThe ideal candidate will have a strong background in surveying, civil engineering, or a related field, with at least eight...

  • Environmental Specialist

    4 months ago

    Asheville, United States UNC Asheville Full time

    Position Summary The UNC Asheville Environmental Specialist assists with environmental programs within Campus Operations. The UNC Asheville Campus Operations department has been a leader in environmental programs within the University system for many years. Environmental sustainability is a core component of the University’s strategic plan.Under the...

  • Clean Room Operator

    5 days ago

    Asheville, United States Chipton Ross Inc. Full time

    Job DescriptionJob Description12 month contract, possible temp-to-permRESPONSIBILITIES:o Operate manufacturing equipment and perform production tasks according to standard operating procedures on site.o Work in a clean room and follow proper gowning procedures.o Strictly adhere to safety guidelines and ensure a safe work environment.o Collaborate with team...