Please login/register to apply for this job.
27 Aug 2021

Full-Time ETL Data Engineer

Avita – Posted by Avita Pharmacy Anywhere

Job Description

At Avita, you can be the care. Compassionate care is at the heart of everything we do. As the largest independent nationwide provider of pharmacy services and solutions for Ryan White/STD Grantees, AIDS Service Organizations, and Federally Qualified Health Centers, Avita provides individually focused pharmacy services, support, and advocacy for our patients and covered entity partners. Join Avita and get inspired to be the care that unlocks the full potential of health for all.

We offer excellent benefits including medical, dental, 401k, vision, pet insurance, life insurance, FSA, HSA, award recognition, professional development, and career growth opportunities.

This position can be based remotely at a home office.

About this role:

  • Data extraction, profiling, cleansing, deduplication, standardization, conversion, transformation and loading, data mining, warehousing, archiving, and reporting
  • Collect, clean, store, organize, integrate data, and create data pipelines
  • Acquire data from primary or secondary data sources and maintain data systems
  • Evaluate changes and updates to source production systems
  • Process, cleanse, and verify the integrity of data used for analysis
  • Perform ad-hoc analysis and present results in a clear manner
  • Collaborate with the data analysis team to assess and troubleshoot potential data quality issues
  • Perform problem assessment, resolution, and documentation in existing ETL packages, mapping, and workflows in production
  • Document ETL data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance
  • Integrate ETL development with existing projects to maximize object reuse
  • Develop transformation queries, views, stored procedures for ETL processes, and process automations
  • Create, execute, and document unit test plans for ETL, data integration processes, and programs
  • Ability to read, modify, and create SSIS integration packages

About You:

  • Bachelor’s degree or equivalent experience
  • 3+ years designing, developing, testing, and implementing enterprise ETL solutions
  • Skill in scripting for data manipulation and analysis
  • Skill in writing queries, reports, and technical documentation
  • Solid working knowledge of MS Office 365
  • Experience with MS SQL Server Management Studio
  • Experience with Microsoft Azure SQL Database and Data Factory
  • Experience with SSRS
  • Experience of moving data between disparate database systems (DB2, MS SQL)
  • Exceptional data analytics skills

Avita is an Equal Opportunity Affirmative Action employer and is subject to federal regulations pertaining to employment. Avita does not unlawfully discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, disability, marital status, veteran status, or any other basis prohibited under federal, state or local laws governing non-discrimination in employment in every location in which the Company has facilities. Avita also provides reasonable accommodation for qualified individuals with disabilities in accordance with the Americans with Disabilities Act (ADA) and any other state or local laws.

How to Apply

Please submit an application using the link: https://careers.avitapharmacy.com/jobs/1751?lang=en-us

Job Categories: Equal Opportunities. Job Types: Full-Time. Salaries: Not Disclosed.

Job expires in 17 days.

90 total views, 2 today

Apply for this Job