Job Location: Salem, OR
Initial Posting Date:
10/25/2022
Application Deadline:
11/08/2022
Agency:
Department of Human Services
Salary Range:
$5,315 – $8,049
Position Type:
Employee
Position Title:
Data Engineer (Information Systems Specialist 6)
Job Description:
We are proud to be an Equal Opportunity Employer. We are actively working to build an equitable agency with the
Equity North Star
as our guide toward our vision of an agency free of racism, discrimination and bias. We believe that teams in which everyone can show up as their full authentic self are key to creating a thriving workforce that can better serve communities. We welcome members of historically underrepresented racial/ethnic groups, women, individuals with disabilities, veterans, LGBTQIA2S+ community members, and others to apply.
Are you interested in being part of a dynamic team? Are you a self-starter that thrives on knowing you have done your best? Has your background provided you with extensive knowledge of relational database management systems (RDBMS)? Do you have experience creating dimensional modeling in both star and snowflake schema? Are you able to work collaboratively and contribute to the team’s success? Do you have experience collaborating with a variety of individuals and interested parties to identify data and to design and develop tabular cubes/models for optimal performance and ease of use? Has your background provided you with experience identifying, developing, and implementing methods to extract, transform, and load data in preparation for the data warehouse? Then, we want to hear from you!
We are seeking a Data Engineer (Information Systems Specialist 6) to join our Office of Reporting, Research, Analytics and Implementation team.
Oregon Department of Human Services (ODHS), A place to belong and make a difference!
-
When you join theODHS
, you join a community of over 10,000 employees dedicated to serving and helping Oregonians achieve wellbeing and independence through opportunities that protect, empower, respect choice, and preserve dignity.
-
Connect with ODHS Employee Resource Groups (ERGs) and find a place to belong, build community and participate in shared learning. ERGs are employee-driven committees that support each other as well as the ODHS’ overall mission and vision.
-
We are committed to building an antiracist and equitable agency. Equity is foundational to our role as a human services agency, and we are committed to integrating equity into all we do. TheEquity North Star
has four points that explain the agency’s goals related to equity, inclusion, and racial justice.
-
We know that life is unpredictable and ODHS cares about keeping you well. Enjoy a work-life balance, 11 paid holidays a year, flexible work schedules, andcompetitive benefits packages
including health, dental, vision and much more!
What you need to qualify
Five (5) years of information systems experience.
Education will substitute for experience based on the following:
-
Associate degree in Computer Science, Information Technology, or related field will substitute for two (2) years of experience.
-
Completion of a two (2) year accredited vocational training program in information technology or related field will substitute for two (2) years of experience.
-
Bachelor’s degree in Information Technology, Computer Science, or related field will substitute for four (4) years of experience.
Essential attributes
We are looking for candidates with:
-
Attention to detail.
-
Extensive knowledge of relational database management systems (RDBMS).
-
Experience creating dimensional modeling in both star and snowflake schema.
-
Ability to contribute to the team’s success, provide feedback, and work collaboratively.
-
Experience collaborating with professionals from multiple programs to identify data and to design and develop tabular cubes/models for optimal performance and ease of use.
-
Experience identifying, developing, and implementing methods to extract, transform, and load data in preparation for the data warehouse.
Preferred Attributes
These attributes are not required to be competitive; they are a plus.
-
Experience with cloud environments and Microsoft Power Platform.
-
Experience with Azure or AWS and Azure DevOps or other Development Operations tools.
-
Experience designing, developing, and deploying in a modern SaaS-based architecture.
Please be sure to clearly describe how you meet these attributes within your application materials. These attributes will be used to determine which candidates will be selected to move forward in the process.
Please note a cover letter is required.
Your duties at a glance
The Office of Reporting, Research, Analytics and Implementation (ORRAI) provides mission critical information to leadership and employees, legislators, partner agencies, and the public. The office utilizes ODHS and inter-agency program data and tools such as predictive analytics, workload modeling, and other quantitative and qualitative methods to improve outcomes for children and families. The office translates data into information and develops practitioner tools to ensure decisions are data informed.
We have two teams that work very closely together. These teams are essential and perform a wide variety of very precise work. These teams are the data warehouse team and the reporting team.
As a Data Engineer, you will be part of the data warehouse team.
You will be responsible for:
-
Supporting five programs with very different data systems.
-
Following standards carefully and accurately.
-
Bringing in data to the data warehouse from a variety of sources and systems from all the agency’s real systems.
-
Following set requirements and established workflow.
-
Managing and writing code, building data sources for reporting purposes, and creating reports and dashboards for a variety of programs and users.
-
Extracting, transferring, and loading information and data.
-
Working closely with Database Administrators to manage data transfers, share data with other agencies and organizations, etc.
Working conditions
-
Working remotely will be considered in filling this position. The ability to report to Salem is required when business or operational needs are dependent on onsite activities.
-
Our work is foundational and requires you to keep up to date with new tools and technology.
-
Normally you will work a standard work week that may involve irregular work hours at times of contract development and budget implementation and rebalancing.
-
We are a family friendly organization and realize the importance of flexibility in managing your personal and professional schedules.
-
You may need to infrequently travel throughout Oregon.
Application instructions & requirements
Your work history profile, cover letter, and resume are the perfect opportunity to highlight your interest in the position and demonstrate your skills, lived and/or work experience that shows you are an excellent candidate for the position.
-
A cover letter is required. Attach a cover letter that demonstrates how you meet the qualifications and attributes for the position.
-
Please upload a resume or complete the work history profile.
-
Note: Upload/attach your documents in the Resume/CV field of the online application.
-
Current State of Oregon employees: Apply via your employee Workday account.
-
If you are not a current State of Oregon employee, view thisapplication instructional video
.
-
After you submit your application, you will have additional tasks to complete in Workday. Please continue to check your Workday account throughout the recruitment process.
Additional requirements
-
Finalists for this position will be subject to a computerized criminal history and abuse check. Adverse background information will be reviewed and could result in withdrawal of a conditional job offer or termination of employment.
-
The Oregon Department of Human Services does not offer visa sponsorship. Within three days of hire, you will be required to complete the US Department of Homeland Security’s I-9 form confirming authorization to work in the United States. ODHS will use E-Verify to confirm that you are authorized to work in the United States.
Helpful information
-
This position is represented by the Service Employees International Union (SEIU).
-
This recruitment may be used to fill future vacancies.
-
Have questions about Workday, and want some tips on understanding the state application process? Check out ourOregon job opportunities
page.
-
If you need an accommodation under the Americans with Disabilities Act (ADA), have questions or need assistance with the application process, please contact Rebecca Wilson via emailRebecca.A.Wilson@dhsoha.state.or.us
or call 503-881-9248. Please be sure to include the job requisition number.
Submit CV To All Data Science Job Consultants Across United States For Free
🔍 Explore All Related ITSM Jobs Below! 🚀
✅ Select your preferred "Job Category" in the Job Category Filter 🎯
🔎 Hit "Search" to find matching jobs 🔥
➕ Click the "+" icon that appears just before the company name to see the Job Detail & Apply Link 📝💼