Data Engineer

Working Conditions

Work Environment(s): ☒ Indoor/Office ☐ Community ☐ Facilities/Security ☐ Outdoor Exposure

The IS Data Engineer plays a pivotal role in operationalizing and advancing data and analytics for Care Oregon’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 Care Oregon’s data and analytics initiatives.

$ - $

Bonus – SIP Target, 5% Annual

Current Care Oregon Employees:
Please use the internal Workday site to submit an application for this job.

• 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 Care Oregon’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.

• 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

• 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
• Experience with Security and Compliance.
• 3 years of SQL experience
• 3 years of Snowflake experience
• 3 years of Azure Data Factory experience

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…