Cloud Data Engineer IT Data Management - Journey (ITDM/ETS)
- Please Note: This position is open until filled. Application
assessment will be ongoing and the hiring authority reserves the
right to offer the position at any time during the recruitment
process. It is to the applicant's advantage to apply as early as
The Cloud Data Engineer develops cloud native data warehouse and
business intelligence solutions, in collaboration with a team of
data modelers, data analysts, data engineers, and subject matter
experts from divisions across HCA, to support HCA's Enterprise Data
This role provides the opportunity to perform end-to-end
development of data solutions using cutting edge cloud technology,
incorporating best practices of software development including:
automated testing, continuous integration, and service oriented
Some of what you will do:
- Independently design, develop and document ETL data workflows
and code for new data integrations and maintain/enhance existing
workflows and code.
- Create ETL data landing and staging structures as well as
source to target mapping documents.
- Perform data cleansing, data conversion, import and export of
data within and between internal and external software
- Using Python and AWS Command Line Interface (boto3) to automate
AWS activities, not limited to, but including resource building
through CloudFormation, resource scheduling (Starting and stopping
EC2 instances based on events), and secondary operations related to
AWS resources (e.g. encryption automation, maintaining 'code as
infrastructure' standards by building all resources with
- Facilitate and perform comprehensive testing, including but not
limited to, unit testing, system testing, security and
vulnerability testing, performance testing, and user acceptance
testing as appropriate.
- Provide troubleshooting to solve the most complex technical
data and infrastructure issues for production and preproduction
- Implement tools and frameworks for automating unit tests,
identification of data-quality issues, and data governance.
- Provide technical consulting and advises teams and customers on
ETL and integrations resulting in an efficient and effective data
ETL and integrations.
- Provide technical consulting and advises teams and customers on
automation and interface with AWS CLI and use of
- Analyze business intelligence data and make recommendations for
data warehouse growth and optimal performance.
Here is what we are looking for (Required Qualifications):
A minimum of three (3) years of experience with Object Oriented
Programming and scripting language design, development, integration
and deployment with mid to large-scale development efforts.
Experience with programming language such as C#, Java, C++,
etc. and scripting languages like python, JSON, PowerShell, ruby
and Unix shell scripts. Python experience is preferred.
College coursework including substantial credits in Object
Oriented Programming and/or scripting may substitute for the
required experience on a basis of two years of education for one
year of experience.
A combination of at least four years of experience in the
following areas (experience may be gained concurrently):
- Writing data querying code, and performance tuning.
Excellent knowledge of SQL.
- Experience and advanced knowledge of databases gained through
design and creation of complex relational databases, data
warehousing, data analytics and analysis, including experience with
large, complex administrative databases/warehouses.
- Experience with Extract Transform and Load (ETL) from multiple
data sources in different formats.
Bachelor's degree or higher in Computer Science, Mathematics,
Business Analysis/Intelligence, or closely related field.
Experience with multiple SQL dialects.
Familiarity with columnar databases like Amazon Redshift.
Experience with cloud computing platforms such as AWS.
About the HCA:
The Washington State Health Care Authority (HCA) is committed to
whole-person care, integrating physical health and behavioral
health services for better results and healthier residents.
HCA purchases health care for more than 2.5 million Washington
residents through Apple Health (Medicaid), the Public Employees
Benefits Board (PEBB) Program, and the School Employees Benefits
Board (SEBB) Program. As the largest health care purchaser in the
state, we lead the effort to transform health care, helping ensure
Washington residents have access to better health and better care
at a lower cost.
What we have to offer:
- Meaningful work with friendly co-workers who care about those
we serve Voices of HCA
- A clear agency mission that drives our work and is
person-centered HCA's Mission, Vision & Values
- A healthy work/life balance, including alternative/flexible
schedules and mobile work options.
- Infants in the workplace Infants at the Workplace
- A great total compensation and benefit package WA State
- A safe, pleasant workplace in a convenient location with
restaurants, and shopping nearby.
- Tuition Reimbursement
- And free parking!
About Olympia and Washington State:
Washington State offers a total work/life package of pay,
benefits, flexibility, and workplace opportunities to help you get
the most out of your career and out of life. Washington State is a
great place to work, play, and be a part of a community, offering
quality of life that is unsurpassed. From the high energy urban
center of Seattle, one of the nation's top ranked cities, to the
more relaxed pace of our rural communities, Washington's
distinctive Northwest lifestyle blends a progressive, creative
culture with a casual nature.
This position is covered by the Washington Federation of State
In addition to the positions currently listed, this recruitment
announcement may be used to fill additional positions, for up to 60
days from the time of the initial posting date.
How to Apply:
Only candidates who reflect the minimum qualifications on
their NEOGOV profile will be considered. Failure to follow
the application instructions below may lead to disqualification.
To apply for this position you will need to complete your
profile and attach:
- A cover letter that specifically addresses how you meet the
qualifications for this position.
- Current resume
- Three professional references
Washington State is an equal opportunity employer. Persons
with disabilities needing assistance in the application process, or
those needing this job announcement in an alternative format may
call the Human Resources Office at 360.725.1197 or email
Prior to a new hire, a background check including
criminal record history will be conducted. Information from the
background check will not necessarily preclude employment but will
be considered in determining the applicant's suitability and
competence to perform in the position.