Optum
Healthcare SQL Developer - Oracle - Remote
Optum, Eden Prairie, Minnesota, United States, 55344
Optum is a global organization 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.
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 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, engineering, data science, AI and innovative approaches to make the healthcare system work better for everyone.
About The Role:
As a Fortune 5 business, we're one of the world's leading healthcare companies. There are no limits here on the resources you'll have or the challenges you'll encounter.
As a Data Engineer, you will be responsible for the development of complex data sources and pipelines into our data platform (i.e. Oracle) along with other data applications (e.g., GitHub, etc.), automation and innovation. You will work in collaboration with business analysts and SMEs to ensure that complex processes and calculations are implemented and maintained across several clients.
You'll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges.
Primary Responsibilities:
All phases of software engineering including requirements analysis, application design, code development, and testingDesign and implement product features in collaboration with business and IT stakeholdersDesign reusable stored procedures, routines, and functions to perform complex transformations componentsLead technology decisions, drive product implementation and deliveryTroubleshoot production support issues post-deployment and determine solutions as requiredDemonstrate substantial depth of knowledge and experience in Oracle PL/SQL, Unix, ETL toolsManage code in Git/GitHubUnderstand data requirements and design optimal pipelines to fulfill use-casesUnderstand logical & physical data models to ensure data integrity is maintainedTune and optimize data processesOversee code deployments to production environment, troubleshoot production data issuesModel large datasets to maximize performance for our Business Intelligence TeamSolid organizational skills and focus on accuracy and attention to detailExcellent analytical, problem solving, and troubleshooting abilitiesSelf-motivated with the ability to work both independently and in a team environmentProvide accurate and timely estimates for tasksProvide support and leadership in critical production support issue resolutionConduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action planWork with team to achieve timely resolution of all production issues meeting or exceeding Service Level AgreementsConduct code reviews to ensure the work delivered by the team is of high-quality standardsDevelop innovative approaches
You'll be rewarded and recognized 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 provide development for other roles you may be interested in.
Required Qualifications:
5+ years of data engineering work experience in development, design, test and implementation of complex database programs using Oracle and third-party tools within a distributed, service-based enterprise environment5+ years of experience writing complex queries in Oracle PL/SQLProficiency in database design, querying, optimization & troubleshooting with any of the following RDBMS: Oracle, SQL Server, and/or TeradataDemonstrated expertise in a variety of data warehousing and business intelligence concepts, practices, and proceduresSolid experience with Oracle functions, procedures, triggers, packages & performance tuningAnalytical and problem-solving experience applied to large datasetsExperience with data warehousing principles, architecture and its implementation in large environmentsProven knowledge of different data modelling techniques such as Star Schema, Dimensional models, Data vaultExperience in code lifecycle management and repositories such as GIT & GitHub
Preferred Qualifications:
Experience working with AirflowPractical experience of developing solutions hosting within key major cloud providers such as OpenShift, Kubernetes, AWS, Google Cloud and AzureExperience working with SnowflakeExperience developing optimized data models for Viz tool E.g. Tableau, and PowerBIExposure and experience in other programming languages such as Python, Spark, etc.Understanding of United States Healthcare data and applicable regulationsExperience writing and executing functional specificationsExperience working with and analyzing healthcare administrative, medical, or pharmacy claims data to support downstream applications, data marts, and end usersAnalytical approach to problem solvingExcellent time management, communication, decision making, and presentation skillsAbility to display a solid desire to achieve and attain high levels of both internal and external customer satisfactionSolid experience of operating in a quickly changing environment and driving technological innovation to meet business requirementsProven track record of building relationships across cross-functional teamsDemonstrated initiative-taker. Ability to show grit and can solve problems without management oversightProven excellent communication skills - verbal and writtenExperience working in projects working with high performing team(s)
*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy.
California, Colorado, Connecticut, Hawaii, Nevada, New Jersey, New York, Rhode Island, Washington, Washington, D.C. Residents Only:
The salary range for this role is $88,000 to $173,200 annually. Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. UnitedHealth Group complies with all minimum wage laws as applicable. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements).
Application Deadline:
This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
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 marginalized 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: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.
UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
#J-18808-Ljbffr
Caring. Connecting. Growing together.
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 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, engineering, data science, AI and innovative approaches to make the healthcare system work better for everyone.
About The Role:
As a Fortune 5 business, we're one of the world's leading healthcare companies. There are no limits here on the resources you'll have or the challenges you'll encounter.
As a Data Engineer, you will be responsible for the development of complex data sources and pipelines into our data platform (i.e. Oracle) along with other data applications (e.g., GitHub, etc.), automation and innovation. You will work in collaboration with business analysts and SMEs to ensure that complex processes and calculations are implemented and maintained across several clients.
You'll enjoy the flexibility to work remotely from anywhere within the U.S. as you take on some tough challenges.
Primary Responsibilities:
All phases of software engineering including requirements analysis, application design, code development, and testingDesign and implement product features in collaboration with business and IT stakeholdersDesign reusable stored procedures, routines, and functions to perform complex transformations componentsLead technology decisions, drive product implementation and deliveryTroubleshoot production support issues post-deployment and determine solutions as requiredDemonstrate substantial depth of knowledge and experience in Oracle PL/SQL, Unix, ETL toolsManage code in Git/GitHubUnderstand data requirements and design optimal pipelines to fulfill use-casesUnderstand logical & physical data models to ensure data integrity is maintainedTune and optimize data processesOversee code deployments to production environment, troubleshoot production data issuesModel large datasets to maximize performance for our Business Intelligence TeamSolid organizational skills and focus on accuracy and attention to detailExcellent analytical, problem solving, and troubleshooting abilitiesSelf-motivated with the ability to work both independently and in a team environmentProvide accurate and timely estimates for tasksProvide support and leadership in critical production support issue resolutionConduct or facilitate root cause analysis on all in-scope incidents and recommend a corrective action planWork with team to achieve timely resolution of all production issues meeting or exceeding Service Level AgreementsConduct code reviews to ensure the work delivered by the team is of high-quality standardsDevelop innovative approaches
You'll be rewarded and recognized 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 provide development for other roles you may be interested in.
Required Qualifications:
5+ years of data engineering work experience in development, design, test and implementation of complex database programs using Oracle and third-party tools within a distributed, service-based enterprise environment5+ years of experience writing complex queries in Oracle PL/SQLProficiency in database design, querying, optimization & troubleshooting with any of the following RDBMS: Oracle, SQL Server, and/or TeradataDemonstrated expertise in a variety of data warehousing and business intelligence concepts, practices, and proceduresSolid experience with Oracle functions, procedures, triggers, packages & performance tuningAnalytical and problem-solving experience applied to large datasetsExperience with data warehousing principles, architecture and its implementation in large environmentsProven knowledge of different data modelling techniques such as Star Schema, Dimensional models, Data vaultExperience in code lifecycle management and repositories such as GIT & GitHub
Preferred Qualifications:
Experience working with AirflowPractical experience of developing solutions hosting within key major cloud providers such as OpenShift, Kubernetes, AWS, Google Cloud and AzureExperience working with SnowflakeExperience developing optimized data models for Viz tool E.g. Tableau, and PowerBIExposure and experience in other programming languages such as Python, Spark, etc.Understanding of United States Healthcare data and applicable regulationsExperience writing and executing functional specificationsExperience working with and analyzing healthcare administrative, medical, or pharmacy claims data to support downstream applications, data marts, and end usersAnalytical approach to problem solvingExcellent time management, communication, decision making, and presentation skillsAbility to display a solid desire to achieve and attain high levels of both internal and external customer satisfactionSolid experience of operating in a quickly changing environment and driving technological innovation to meet business requirementsProven track record of building relationships across cross-functional teamsDemonstrated initiative-taker. Ability to show grit and can solve problems without management oversightProven excellent communication skills - verbal and writtenExperience working in projects working with high performing team(s)
*All employees working remotely will be required to adhere to UnitedHealth Group's Telecommuter Policy.
California, Colorado, Connecticut, Hawaii, Nevada, New Jersey, New York, Rhode Island, Washington, Washington, D.C. Residents Only:
The salary range for this role is $88,000 to $173,200 annually. Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. UnitedHealth Group complies with all minimum wage laws as applicable. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements).
Application Deadline:
This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
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 marginalized 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: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law.
UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment.
#J-18808-Ljbffr