Avita Pharmacy

ETL Software Developer (Remote)

United States US

Search this Category

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 and work CST/EST time zone hours.
About the 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
• Support our CST/ EST time zones
About You:
• Bachelors degree or equivalent experience
• 3+ years of experience with MS SQL
• 2+ years of experience with developing ETL solutions in SSIS
• 1+ years of experience with MS Azure SQL Database and Data Factory
• Skill in scripting for data manipulation and analysis
• Skill in writing queries, reports, and technical documentation
• Solid working knowledge of MS Office 365
• Experience of moving data between disparate database systems (MS SQL, REST API, Flat Files, etc.)
• Exceptional data analytics skills
• Able to work CST/ EST time zone hours
• Must be fully vaccinated against COVID-19 and if hired, must provide proof of vaccination
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

Click here Report Job to report this job.
Do you want the latest remote jobs?
Get the latest jobs straight to your inbox.
US United States
GB United Kingdom
CA Canada
Notify Me
Please enter a valid email address
Your job notification has been set up
Check your mailbox to confirm your email address

Cookie Policy

We use cookies to make your experience of our website better. You can use your browser's settings to change your preferences. Otherwise we'll assume you're ok to continue

I'm fine with that
Rate this job