Register
Recruit Create CV
Unfortunately, this job posting is expired.
Don't worry, we can still help! Below, please find related information to help you with your job search.
Related keywords
Some similar recruitments
Business Intelligence Developer (Etl)
Recruited by State of Arizona 8 months ago Address , Phoenix, 85007 $84,000 a year
Customer Support Specialist (Information Systems Specialist 4)
Recruited by Department of Consumer & Business Services 9 months ago Address , Salem, 97304, Or $4,452 - $6,732 a month
User Support Specialist (Information Systems Specialist 4)
Recruited by Oregon Department of Education 11 months ago Address , Salem, 97310, Or $4,452 - $6,732 a month
Sr. Business Intelligence Developer | Full Time
Recruited by Henry Ford Health 11 months ago Address , Detroit, Mi
Business Intelligence / Etl Cognos Developer (Information Systems Specialist 7)
Recruited by Department of Justice 11 months ago Address , Salem, 97301, Or $5,885 - $8,894 a month
Director, Business Systems Jobs
Recruited by Momentive.ai 1 year ago Address Portland, OR, United States

Information Systems Specialist 6 (Child Support Program Business Intelligence / Etl Developer)

Company

Department of Justice
Address , Salem, 97301, Or
Employment type FULL_TIME
Salary $5,315 - $8,049 a month
Expires 2023-10-05
Posted at 9 months ago
Job Description
Initial Posting Date:
08/01/2023
Application Deadline:
08/21/2023
Agency:
Department of Justice
Salary Range:
$5,315 - $8,049
Position Type:
Employee
Position Title:
Information Systems Specialist 6 (Child Support Program Business Intelligence / ETL Developer)
:
The Department of Justice,
Division of Child Support
, is looking for experienced Business Intelligence / ETL Developer (Information Systems Specialist 6) to join our Child Support Technology Team. This role will support team members and project groups throughout DCS in the creation and maintenance of cost-effective and timely business solutions for large systems that are complex, working with internal and external partners. This role is responsible for software development of the reporting systems utilized by the program research analysts.

This position may require on-call and after-hours support of the Origin batch process as it pertains to ETL and report processing.

The Oregon Child Support Program, administered by the Division of Child Support, is one of the top four anti-poverty programs in the nation. Become part of a program whose mission is to enhance the well-being of children and promote positive parental involvement by providing child support services to families. Your contributions will make a difference in the lives of Oregon’s most valuable resource—our children.

You will find that we embrace inclusive and supportive work environments and respect the diverse perspectives, knowledge, and experiences of our coworkers and those seeking to join the organization. We strive to build an inclusive and performance-oriented workplace where all individuals are welcomed and appreciated, leading to increasingly higher levels of fulfillment and success.

This role is a hybrid of remote work and will need to report to office as business needs. Remote work is embraced to the fullest extent possible without interfering with business. The finalist must reside in the state of Oregon by the time of appointment. Apply today!

WHAT'S IN IT FOR YOU
  • Pension and retirement programs.
  • Excellent medical, vision, and dental.
  • Advancement opportunity within DOJ and other State agencies.
  • Opportunity to expand your technical and professional skills.
  • Work where individual contribution matters and is recognized, where creativity and accomplishment are rewarded.
  • Permanent, full-time, and stable employment without the need to bounce between contract assignments.
  • Representation and support by the Service Employees International Union (SEIU).
  • Equal pay in accordance with Oregon Pay Equity Laws; we will ensure you are paid well and equitable to your peers.
  • Vacation, sick leave, 11 paid holidays a year, and special days off.
  • Team members of the Department are also expected to understand the DOJ’s affirmative action goals and objectives and to develop and implement plans to meet them. In addition, recognize the value of individual and cultural differences, create work environments where individuals’ differences are valued, and consistently treat staff, colleagues, customers, and stakeholders/partners with dignity and respect.
  • Meaningful work that immediately impacts the efficacy of the Child Support Program and improves the services provided to families in Oregon.
REQUIRED EXPERIENCES AND ATTRIBUTES
  • Associate’s Degree (or 2-year vocational training) = Two (2) Years
  • Bachelor's Degree = Four (4) Years
  • Master's Degree = Six (6)
  • Five (5) years of information systems experience with ETL and Business Intelligence development, implementation, and support. Education will be counted as experience if degree is in Computer Science, Information Technology, or related field, or if a two (2) year accredited vocational training program was completed in information technology or related field. Work experience is based on a 40-hour work week. (Example: 20 hours a week for one year would equal six-months of work experience.)
AND
  • Strong communication skills with the ability to communicate clearly, concisely, and in a way that technical information is understood by all customers and users, both verbally and in writing.
  • Experience with SQL, enterprise-grade DBMS (such as DB2, Oracle or SQL Server) and ETL tools (such as DataStage or Informatica)
  • Strong interpersonal skills with the ability to establish and maintain great working relationships with all levels of staff in the Department and with outside federal, state, and local agencies.
  • Consistently treats colleagues, customers and stakeholders/partners with dignity and respect, no matter what the situation.
  • Desire and ability to learn and master new technical and business skills.
  • Strong organization skills with the ability to shift priorities quickly while continuing to make progress on all work assignments.
  • Recognizes and champions the value of individual and cultural differences and contributes to a work environment where individuals’ differences are not only valued, but also tapped into for the benefit of both the Technology Services section and the Department.
  • Ability to plan and perform assignments with minimal or no supervision.
  • Is responsible for understanding the agency’s affirmative action goals and objectives.
  • Keen understanding of system administration, best practices, and technology solutions.
  • Ability to meet deadlines while maintaining attention to detail and accuracy.
  • Ability to communicate effectively to both business and information services staff.
  • Finalists must pass a comprehensive employment reference check and fingerprint-based criminal background check. A driver history check will be included for positions requiring state vehicle driving privileges. Adverse findings will be evaluated to determine eligibility for the position.
  • Ability to sort through multiple and, at times, conflicting needs and priorities is required.
  • Proactive troubleshooting, listening, and problem-solving skills.
  • Ability to work independently or on a team as a partner to collectively achieve goals.

DESIRED EXPERIENCES
  • Experience participating in Software Development Lifecycle (SDLC) activities, including requirements, design, development, unit/regression testing, deployment, and maintenance.
  • DataStage/ ETL Developer with strong SQL skills
  • Demonstrated ability to adapt to rapid changes in business process.
  • Ability to review and understand complex database structures and SQL code
  • Demonstrated ability to coordinate conflicting needs and resolutions.
  • Strong data warehousing knowledge
APPLICATION PROCESS

Diversity is a core value of the Oregon Department of Justice. We are working to build and maintain an inclusive and equitable work environment. Every employee expands our diversity by contributing to the range of ways to understand and communicate with one another, identify challenges, and work cooperatively.
  • Attach your resume.
  • Follow the "Apply" link and complete the application online and all supplemental questions.
  • Attach your cover letter.
If you are interested in assistance with completing your resume, cover letter, or interview workshops please check out WorkSource Oregon
here
.
ALL APPLICANTS: You will only have one opportunity to upload the requested resume and cover letter. Drag and drop both resume and cover letter into Workday when prompted to upload your resume. If you are concerned that one or both requested documents didn't attach to your application, if you need an accommodation under the Americans with Disabilities Act (ADA), have questions, or need assistance with the application process, please contact . Any materials emailed will be associated on your behalf if received before the posting deadline.

CURRENT STATE EMPLOYEES: Login to Workday using your state-issued login and apply via the Career Worklet located on your home page. Using a private account disrupts the hiring process for all internal candidates. Prior to clicking "Apply", update your employee profile to reflect your Education, Skills, and Job History (including your current job).
WHAT YOU WILL DO (in part)
  • Respond to non-critical system stoppages, which may or may not include internal and external partner agencies.
  • Analyze performance issues and develop, test and implement resolutions.
  • Perform batch cycle support for reporting which may include after hours or shift modifications in order to support the Origin System as it pertains to ETL and reporting.
  • Write new programs and maintains/modifies existing programs using relational databases maintaining data integrity which may change or re-engineer a business process.
  • Create program specifications, detailed program design and operational documentation.
  • Evaluates and tests new products are compatible with existing internal and external systems.
  • Programs involve the use of SQL, DB2, Infosphere Information Server
  • Evaluate performance and resource competition issues, resolve and coordinate solutions.
  • Adhere to Child Support Technology Services standards and version controls.
  • Remain familiar with state-of-the-art tools within the organization and utilizing these tools for enhancements, resolving issues, and addressing the distributed needs of the agency.
  • Work with internal and external partners to determine the best solution for enhancing the system and its interfaces.
  • Other duties as assigned.
  • Create necessary documentation per IT shop standards, ensuring design and implementation conform to policy.
  • Diagnose and resolve system issues referred directly from the customer.
  • Provide solutions to the issues based on the time criticality of the normal operation of the system. Areas may include: revenue being tracked or lost; regulatory requirements being met; issues where public safety is involved.
  • Obtain customer sign-off at each phase indicating the customer understands requirements and design, inputs, outputs, reporting formats and contents, processing functions and other requirements dependent on specific system functionality.
  • Develop, design, and maintain DataStage ETL jobs
  • Ensure version compatibility between new releases that support the distributed needs of the system which may also impact partner agencies.
  • Perform system analysis to support current and future business needs.
  • Other duties in part include the construction, customer service, and operations of data.
  • Use of Cognos software for developing reports based on business needs.
  • Work closely with the customer in defining detailed system requirements and design.
  • Perform root cause analysis and address existing issues

Candidates from diverse backgrounds are encouraged to apply. The Department of Justice is an equal opportunity employer, does not discriminate based on race, color, national origin, ethnicity, veteran, gender, sexual orientation, religion, age, or disability, and is committed to workplace diversity.

For additional information regarding benefits and application assistance,
click HERE
.
Oregon Department of Justice
1162 Court St NE
Salem OR, 97301
Phone: (503) 947-4328
Fax: (503) 373-0367