Job Title: IS Data Engineer

Company Name: CareOregon

Job Details: $124k-$152k/yrRemoteFull,Time

Job Url: https://hiring.cafe/viewjob/gt4ii07dlnocxxmb

Job Description: Posted 2w agoIS Data Engineer@ CareOregonView All JobsWebsiteUnited States$124k-$152k/yrRemoteFull TimeResponsibilities:Create pipelines, Manage pipelines, Collaborate stakeholdersRequirements Summary:5+ years in data management with SQL, ETL, data warehousing; experience with Snowflake, Azure Data Factory, and related tools.Technical Tools Mentioned:Microsoft SQL Server, Snowflake, Azure Data Factory, Databricks, Power BI, Tableau, Python, R, SQL
IS Data Engineer---------------------------------------------------------------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.Estimated Hiring Range:$124,200.00 - $151,800.00Bonus Target:Bonus - SIP Target, 5% AnnualCurrent CareOregon Employees: Please use the internal Workday site to submit an application for this job.---------------------------------------------------------------Essential ResponsibilitiesCreate, 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.Experience and/or EducationRequiredMinimum 5 years’ experience in data management, RDBMs required in roles that included all or most of the following functions:Database design and development experienceETL experienceDevelopment utilizing tools such as Microsoft SQL Server, Snowflake and/or similar toolsData warehouse technical development that encompasses the data management life cycle and establishes end-to-end data warehousing, data management and analytics architectureExperience with multi-source and multi-data from different format sources and/or data structurePreferredData management experience within the healthcare industry preferred.Utilization of data integration, modeling, optimization and data quality improvement processesDevelopment using Microsoft Azure products such as Data Factory, Functions, Databricks, Monitor and/or similar productsKnowledge, Skills and Abilities RequiredKnowledgeIn 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 technologiesKnowledge of the basic concepts of managed care preferredKnowledge of health insurance business entities, relationships and processes preferredSkills and AbilitiesStrong ability to design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata and workload managementStrong ability to work with IT and business staff to integrate analytics and data science output into business processes and workflowsStrong ability to partner with data science teams to leverage data science and refine and optimize machine learning models and algorithmsStrong ability to collaborate with data governance, quality and security experts to move data pipelines into production in compliance with applicable standards and certificationAbility to work across multiple deployment environments including cloud, on-premises and hybridAbility 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 datasetsAbility to extract business value while considering automation opportunitiesAdept in the use of traditional data integration technologies including ETL/ELT, data replication/CDC and API design and accessStrong ability to work with and optimize existing ETL/ELT processes and data integration, data preparation flows and helping to move them into productionStrong ability to work with analytics tools for object-oriented/object function scripting using R, Python, Java, Scala and/or similar languagesStrong ability to apply Agile methodologiesAbility to apply DevOps practices and tools and DataOps principles to data pipelines to improve data flowsPossess curiosity and desire for ongoing learning about new data initiatives and how to address themAbility to continually learn the latest versions of development tools and software products Excellent written and oral communication skillsAbility to successfully manage multiple tasks, concurrent high priority projects and continuous deadlinesPossess a high degree of initiative, motivation, self-discipline and good judgmentAbility to work effectively with diverse individuals and groupsAbility to learn, focus, understand, and evaluate information and determine appropriate actionsAbility to accept direction and feedback, as well as tolerate and manage stressAbility to see, read, and perform repetitive finger and wrist movement for at least 6 hours/dayAbility to hear and speak clearly for at least 3-6 hours/dayWorking ConditionsWork Environment(s):        ☒ Indoor/Office    ☐ Community      ☐ Facilities/Security     ☐ Outdoor ExposureMember/Patient Facing:    ☒ No                          ☐ Telephonic        ☐ In PersonHazards: May include, but not limited to, physical and ergonomic hazards.Equipment:  General office equipmentTravel: 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 homeWe offer a strong Total Rewards Program. This includes competitive pay, bonus opportunity, and a comprehensive benefits package.  Eligibility for bonuses and benefits is dependent on factors such as the position type and the number of scheduled weekly hours. Benefits-eligible employees qualify for benefits beginning on the first of the month on or after their start date. CareOregon offers medical, dental, vision, life, AD&D, and disability insurance, as well as health savings account, flexible spending account(s), lifestyle spending account, employee assistance program, wellness program, discounts, and multiple supplemental benefits (e.g., voluntary life, critical illness, accident, hospital indemnity, identity theft protection, pre-tax parking, pet insurance, 529 College Savings, etc.). We also offer a strong retirement plan with employer contributions. Benefits-eligible employees accrue PTO and Paid State Sick Time based on hours worked/scheduled hours and the primary work state. Employees may also receive paid holidays, volunteer time, jury duty, bereavement leave, and more, depending on eligibility. Non-benefits eligible employees can enjoy 401(k) contributions, Paid State Sick Time, wellness and employee assistance program benefits, and other perks. Please contact your recruiter for more information.We are an equal opportunity employerCareOregon is an equal opportunity employer.  The organization selects the best individual for the job based upon job related qualifications, regardless of race, color, religion, sexual orientation, national origin, gender, gender identity, gender expression, genetic information, age, veteran status, ancestry, marital status or disability. The organization will make a reasonable accommodation to known physical or mental limitations of a qualified applicant or employee with a disability unless the accommodation will impose an undue hardship on the operation of our organization.