CareOregon
IS Data Engineer
CareOregon, Salt Lake City, Utah, United States, 84193
Career Opportunities: IS Data Engineer (24660)
Requisition ID
24660
- Posted
11/04/2024
-
CareOregon
-
Full Time - Permanent
-
Portland
- Multi Location (9)
Job Description Print Preview
Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.
Job Title
IS Data Engineer
Exemption Status
Exempt
Management Level
n/a
Direct Reports
n/a
Manager Title
IS Development Supervisor
Department
Business Intelligence
Requisition
24654
Pay & Benefits
Estimated hiring range $121,770 - $148,830 / year, 5% bonus target, full benefits. www.careoregon.org/about-us/careers/benefits
Posting Notes
This is a fully remote position, but you must reside in one of the listed 9 states
Job Summary
The IS Data Engineer plays a pivotal role in operationalizing and advancing data and analytics for CareOregon's business initiatives. This involves building, managing and optimizing data pipelines and moving them effectively into production for data and analytics consumers. Consumers include business data analysts, data scientists and other roles that need curated data for data and analytics use cases. The IS Data Engineer ensures compliance with data governance and data security requirements while enabling faster data access, integrated data reuse and acceleration of time-to-solution for CareOregon's data and analytics initiatives.
Essential Responsibilities
Create, maintain and optimize data pipelines as workloads move from development to production for specific use cases.
Manage data pipelines through stages, beginning with ingestion of data sources through integration to consumption for specific use cases.
Utilize innovative tools, techniques and architectures to partially or completely automate tasks in order to minimize manual processes, reduce the potential for error and improve productivity.
Assist with the renovation of data management infrastructure that supports automation in data integration and management.
Partner with other Information Systems teams, business data analysts and other data and analytics consumers to refine their data requirements for initiatives and consumption.
Train data and analytics consumers about data pipelines and preparation techniques to make it easier for them to integrate and consume the data they need for their own use cases.
Apply understanding of data and domains to address emerging data requirements.
Propose innovative data ingestion, preparation, integration and operationalization techniques to optimally address data requirements.
Promote CareOregon's available data and analytics capabilities and expertise to IS staff and department leaders.
Collaborate with and educate staff and leadership on how to leverage data and analytics capabilities to achieve business goals.
Organizational Responsibilities
Perform work in alignment with the organization's mission, vision and values.
Support the organization's commitment to equity, diversity and inclusion by fostering a culture of open mindedness, cultural awareness, compassion and respect for all individuals.
Strive to meet annual business goals in support of the organization's strategic goals.
Adhere to the organization's policies, procedures and other relevant compliance needs.
Perform other duties as needed.
Experience and/or Education
Required
Minimum 5 years' experience in data management, RDBMs required in roles that included all or most of the following functions:
Database design and development experience
ETL experience
Development utilizing tools such as Microsoft SQL Server, Snowflake and/or similar tools
Data warehouse technical development that encompasses the data management life cycle and establishes end-to-end data warehousing, data management and analytics architecture
Experience with multi-source and multi-data from different format sources and/or data structure
Preferred
Data management experience within the healthcare industry preferred.
Utilization of data integration, modeling, optimization and data quality improvement processes
Development using Microsoft Azure products such as Data Factory, Functions, Databricks, Monitor and/or similar products
Knowledge, Skills and Abilities Required
Knowledge
In depth knowledge of commonly used database programming languages for relational databases (e.g. SQL)
In depth knowledge of commonly used cloud-based data warehouse platforms (e.g. Snowflake, Redshift, etc.)
Understanding of business intelligence solutions including working knowledge of commonly used data discovery, analytics and BI software tools for semantic layer-based data discovery (e.g. Tableau, Power BI, etc.)
Knowledge of emerging data ingestion and integration technologies
Knowledge of the basic concepts of managed care preferred
Knowledge of health insurance business entities, relationships and processes preferred
Skills and Abilities
Strong ability to design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata and workload management
Strong ability to work with IT and business staff to integrate analytics and data science output into business processes and workflows
Strong ability to partner with data science teams to leverage data science and refine and optimize machine learning models and algorithms
Strong ability to collaborate with data governance, quality and security experts to move data pipelines into production in compliance with applicable standards and certification
Ability to work across multiple deployment environments including cloud, on-premises and hybrid
Ability to work with multiple operating systems and containerization platforms (e.g. Docker, Kubernetes, AWS Elastic Container Service, etc.)
Ability to develop using Microsoft Azure products (e.g. Data Factory, Functions, Databricks, Monitor, etc.)
Ability to work with large, heterogeneous datasets to build and optimize data pipelines, pipeline architectures and integrated datasets
Ability to extract business value while considering automation opportunities
Adept in the use of traditional data integration technologies including ETL/ELT, data replication/CDC and API design and access
Strong ability to work with and optimize existing ETL/ELT processes and data integration, data preparation flows and helping to move them into production
Strong ability to work with analytics tools for object-oriented/object function scripting using R, Python, Java, Scala and/or similar languages
Strong ability to apply Agile methodologies
Ability to apply DevOps practices and tools and DataOps principles to data pipelines to improve data flows
Possess curiosity and desire for ongoing learning about new data initiatives and how to address them
Ability to continually learn the latest versions of development tools and software products
Excellent written and oral communication skills
Ability to successfully manage multiple tasks, concurrent high priority projects and continuous deadlines
Possess a high degree of initiative, motivation, self-discipline and good judgment
Ability to work effectively with diverse individuals and groups
Ability to learn, focus, understand, and evaluate information and determine appropriate actions
Ability to accept direction and feedback, as well as tolerate and manage stress
Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day
Ability to hear and speak clearly for at least 3-6 hours/day
Working Conditions
Work Enviornment(s):
Indoor/Office Community Facilities/Security Outdoor Exposure
Member/Patient Facing: No Telephonic In Person
Hazards: May include, but not limited to, physical and ergonomic hazards.
Equipment: General office equipment
Travel: May include occasional required or optional travel outside of the workplace; the employee's personal vehicle, local transit or other means of transportation may be used.
Work Location: Work from home
#MULTI
Candidates of color are strongly encouraged to apply. CareOregon is committed to building a linguistically and culturally diverse and inclusive work environment.
Veterans are strongly encouraged to apply.
We are an equal opportunity employer. CareOregon considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, disability, or veteran status.
Visa sponsorship is not available at this time.Email this job to a friend
The job has been sent to
Please provide the information below
Job title:
*Your friend's email address:
Message:
Maximum character limit: 1000
Requisition ID
24660
- Posted
11/04/2024
-
CareOregon
-
Full Time - Permanent
-
Portland
- Multi Location (9)
Job Description Print Preview
Candidates hired for remote positions must reside in Oregon, Washington, Utah, Idaho, Arizona, Nevada, Texas, Montana, or Wisconsin.
Job Title
IS Data Engineer
Exemption Status
Exempt
Management Level
n/a
Direct Reports
n/a
Manager Title
IS Development Supervisor
Department
Business Intelligence
Requisition
24654
Pay & Benefits
Estimated hiring range $121,770 - $148,830 / year, 5% bonus target, full benefits. www.careoregon.org/about-us/careers/benefits
Posting Notes
This is a fully remote position, but you must reside in one of the listed 9 states
Job Summary
The IS Data Engineer plays a pivotal role in operationalizing and advancing data and analytics for CareOregon's business initiatives. This involves building, managing and optimizing data pipelines and moving them effectively into production for data and analytics consumers. Consumers include business data analysts, data scientists and other roles that need curated data for data and analytics use cases. The IS Data Engineer ensures compliance with data governance and data security requirements while enabling faster data access, integrated data reuse and acceleration of time-to-solution for CareOregon's data and analytics initiatives.
Essential Responsibilities
Create, maintain and optimize data pipelines as workloads move from development to production for specific use cases.
Manage data pipelines through stages, beginning with ingestion of data sources through integration to consumption for specific use cases.
Utilize innovative tools, techniques and architectures to partially or completely automate tasks in order to minimize manual processes, reduce the potential for error and improve productivity.
Assist with the renovation of data management infrastructure that supports automation in data integration and management.
Partner with other Information Systems teams, business data analysts and other data and analytics consumers to refine their data requirements for initiatives and consumption.
Train data and analytics consumers about data pipelines and preparation techniques to make it easier for them to integrate and consume the data they need for their own use cases.
Apply understanding of data and domains to address emerging data requirements.
Propose innovative data ingestion, preparation, integration and operationalization techniques to optimally address data requirements.
Promote CareOregon's available data and analytics capabilities and expertise to IS staff and department leaders.
Collaborate with and educate staff and leadership on how to leverage data and analytics capabilities to achieve business goals.
Organizational Responsibilities
Perform work in alignment with the organization's mission, vision and values.
Support the organization's commitment to equity, diversity and inclusion by fostering a culture of open mindedness, cultural awareness, compassion and respect for all individuals.
Strive to meet annual business goals in support of the organization's strategic goals.
Adhere to the organization's policies, procedures and other relevant compliance needs.
Perform other duties as needed.
Experience and/or Education
Required
Minimum 5 years' experience in data management, RDBMs required in roles that included all or most of the following functions:
Database design and development experience
ETL experience
Development utilizing tools such as Microsoft SQL Server, Snowflake and/or similar tools
Data warehouse technical development that encompasses the data management life cycle and establishes end-to-end data warehousing, data management and analytics architecture
Experience with multi-source and multi-data from different format sources and/or data structure
Preferred
Data management experience within the healthcare industry preferred.
Utilization of data integration, modeling, optimization and data quality improvement processes
Development using Microsoft Azure products such as Data Factory, Functions, Databricks, Monitor and/or similar products
Knowledge, Skills and Abilities Required
Knowledge
In depth knowledge of commonly used database programming languages for relational databases (e.g. SQL)
In depth knowledge of commonly used cloud-based data warehouse platforms (e.g. Snowflake, Redshift, etc.)
Understanding of business intelligence solutions including working knowledge of commonly used data discovery, analytics and BI software tools for semantic layer-based data discovery (e.g. Tableau, Power BI, etc.)
Knowledge of emerging data ingestion and integration technologies
Knowledge of the basic concepts of managed care preferred
Knowledge of health insurance business entities, relationships and processes preferred
Skills and Abilities
Strong ability to design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata and workload management
Strong ability to work with IT and business staff to integrate analytics and data science output into business processes and workflows
Strong ability to partner with data science teams to leverage data science and refine and optimize machine learning models and algorithms
Strong ability to collaborate with data governance, quality and security experts to move data pipelines into production in compliance with applicable standards and certification
Ability to work across multiple deployment environments including cloud, on-premises and hybrid
Ability to work with multiple operating systems and containerization platforms (e.g. Docker, Kubernetes, AWS Elastic Container Service, etc.)
Ability to develop using Microsoft Azure products (e.g. Data Factory, Functions, Databricks, Monitor, etc.)
Ability to work with large, heterogeneous datasets to build and optimize data pipelines, pipeline architectures and integrated datasets
Ability to extract business value while considering automation opportunities
Adept in the use of traditional data integration technologies including ETL/ELT, data replication/CDC and API design and access
Strong ability to work with and optimize existing ETL/ELT processes and data integration, data preparation flows and helping to move them into production
Strong ability to work with analytics tools for object-oriented/object function scripting using R, Python, Java, Scala and/or similar languages
Strong ability to apply Agile methodologies
Ability to apply DevOps practices and tools and DataOps principles to data pipelines to improve data flows
Possess curiosity and desire for ongoing learning about new data initiatives and how to address them
Ability to continually learn the latest versions of development tools and software products
Excellent written and oral communication skills
Ability to successfully manage multiple tasks, concurrent high priority projects and continuous deadlines
Possess a high degree of initiative, motivation, self-discipline and good judgment
Ability to work effectively with diverse individuals and groups
Ability to learn, focus, understand, and evaluate information and determine appropriate actions
Ability to accept direction and feedback, as well as tolerate and manage stress
Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day
Ability to hear and speak clearly for at least 3-6 hours/day
Working Conditions
Work Enviornment(s):
Indoor/Office Community Facilities/Security Outdoor Exposure
Member/Patient Facing: No Telephonic In Person
Hazards: May include, but not limited to, physical and ergonomic hazards.
Equipment: General office equipment
Travel: May include occasional required or optional travel outside of the workplace; the employee's personal vehicle, local transit or other means of transportation may be used.
Work Location: Work from home
#MULTI
Candidates of color are strongly encouraged to apply. CareOregon is committed to building a linguistically and culturally diverse and inclusive work environment.
Veterans are strongly encouraged to apply.
We are an equal opportunity employer. CareOregon considers all candidates regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, genetic information, disability, or veteran status.
Visa sponsorship is not available at this time.Email this job to a friend
The job has been sent to
Please provide the information below
Job title:
*Your friend's email address:
Message:
Maximum character limit: 1000