Data Engineer

Optum is a global organisation that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together. 

About the role:

At UnitedHealth Group and Optum, we want to make healthcare work better for everyone. This depends on hiring the best and brightest. With a thriving ecosystem of investment and innovation, our business in Ireland is constantly growing to support the healthcare needs of the future.

Our teams are at the forefront of building and adapting the latest technologies to propel healthcare forward in a way that better serves everyone. With our hands at work across all aspects of health, we use the most advanced development tools, AI, data science and innovative approaches to make the healthcare system work better for everyone. Join us and do your life’s best work.

Todays’ RCM is inherently complex due to opaque and payer-specific adjudication rules, incurring significant waste and inefficiency. Optum Insight is committed to delivering new technology and processes to improve the Revenue Cycle Management (RCM) workflow using advances in Gen AI and other state-of-the-art technology that would ultimately benefit all stakeholders involved in the healthcare ecosystem — payers, providers, and patients.

Careers with Optum offer flexible work arrangements and individuals who live and work in the Republic or Ireland will have the opportunity to split their monthly work hours between our Dublin or Letterkenny office and telecommuting from a home-based office. 

Primary Responsibilities:

• Design, build and implement automation processes for production release of data engineering, machine learning and business intelligence processes.
• Write code, and leverage tools, to transform data to incorporate business logic as defined in conjunction with the OptumInsight business and technology partners.
• Design, code, test, document, and maintain high-quality and scalable Big Data solutions
• Analyze raw data sources, data transformation, structural requirements for new software and application
• Migrate data from legacy systems to new solutions
• Design conceptional and logical data model and flowcharts
• Define security and backup strategy for data solutions
• Design, build and implement real time / near real time data pipelines
• Design and prototype data monitoring models for pipeline
• Write technical documentation

You will be rewarded and recognised for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role, as well as providing development for other roles you may be interested in.

Required Qualifications:

• Experience with data processing and SQL databases.
• Advanced SQL experience
• Previous experience with Relational Databases (RDBMS) and Non – Relational Database.
• Previous experience in implementation of ETL applications, Data warehousing/ data modelling principles, architecture and its implementation in large environments
• Working Knowledge on public clouds like Azure, AWS, Google Cloud and developing applications on Linux environments
• Experience with Hadoop/Snowflake/Vertica/Redshift/Synapse
• Experience with Spark/Databricks in data processing and machine learning processes.
• Experience with Airflow in implementation of data pipeline orchestrations, Airflow operators and hooks.
• Experience with Kubernetes and Docker, designing, implementing and running data applications.
• Hands-on experience with Python (Java, Scala, useful too)
• Experience with agile / scrum methodologies

Preferred Qualifications:

• Practical experience of developing solutions hosting within key major cloud providers such as Azure, AWS and Google Cloud
• Experience building OLAP Cubes/Databases
• Experience working in data warehouse.
• Experience with Apache Kafka
• Knowledge of DevOps tools and practices
• Agile development methodology
• Experience of Kimball, Data Vault
• Experience of Data Build Tool

Please note you must currently be eligible to work and remain indefinitely without any restrictions in the country to which you are making an application. Proof will be required to support your application.

All telecommuters will be required to adhere to the UnitedHealth Group’s Telecommuter Policy.

At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone–of every race, gender, sexuality, age, location and income–deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalised groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes — an enterprise priority reflected in our mission.

Diversity creates a healthier atmosphere: Optum is an Equal Employment Opportunity employer and all qualified applicants will receive consideration for employment without regard to gender, civil status, family status, sexual orientation, disability, religion, age, race, and membership of the Traveller community, or any other characteristic protected by law. Optum is a drug-free workplace. © 2024 Optum Services (Ireland) Limited. All rights reserved.

Read Full Description