Business Intelligence / ETL Cognos Developer (Information Systems Specialist 7)

Initial Posting Date:
10/07/2024
Application Deadline:
10/21/2024
Agency:
Department of Justice
Salary Range:
$6,268 - $9,472
Position Type:
Employee
Position Title:
Business Intelligence / ETL Cognos Developer (Information Systems Specialist 7)
Job Description:
The Department of Justice, Division of Child Support,, is looking for experienced Software Developers to join our Child Support Technology Team as a Business Intelligence / ETL Cognos Developer (Information Systems Specialist 7). This role will support team members and project groups throughout DCS in the creation, 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 the software develop of the reporting systems utilized by the program research analysts. As a mentor to junior team members, you will help us to develop and build our diverse work family.
This position will 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

• Permanent, full-time, and stable employment without the need to bounce between contract assignments.
• Meaningful work that immediately impacts the efficacy of the Child Support Program and improves the services provided to families in Oregon.
• Equal pay in accordance with Oregon Pay Equity Laws; we will ensure you are paid well and equitable to your peers.
• Work where individual contribution matters and is recognized, where creativity and accomplishment are rewarded.
• Vacation, sick leave, 11 paid holidays a year, and special days off.
• Excellent medical, vision, and dental.
• Pension and retirement programs.
• Representation and support by the Service Employees International Union (SEIU).
• Advancement opportunity within DOJ and other State agencies.
• Opportunity to expand your technical and professional skills.
• 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.

REQUIRED EXPERIENCES AND ATTRIBUTES
Research suggests that women and people of color are less likely to apply unless they are confident they meet 100% of the listed qualifications. We welcome members of historically underrepresented racial/ethnic groups, women, individuals with disabilities, veterans, and all interested individuals to apply, and allow us to evaluate the knowledge, skills, and abilities that you demonstrate, using an intentional equity lens.
Six (6) 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.)Associate's Degree (or 2-year vocational training) = Two (2) Years

• Bachelor's Degree = Four (4) Years
• Master's Degree = Six (6)

AND

• 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.
• DataStage/ ETL Developer with strong SQL skills
• Practical experience using Cognos
• Strong data warehousing knowledge
• Ability to review and understand complex database structures and SQL code
• Experience participating in Software Development Lifecycle (SDLC) activities, including requirements, design, development, unit/regression testing, deployment, and maintenance.
• Demonstrated ability to coordinate conflicting needs and resolutions.
• Demonstrated ability to adapt to rapid changes in business process.

DESIRED EXPERIENCES

• Experience with SQL, DB2 and WebSphere application Servers
• Desire and ability to learn and master new technical and business skills.
• Keen understanding of system administration, best practices, and technology solutions.
• Proactive troubleshooting, listening, and problem-solving skills.
• Ability to plan and perform assignments with minimal or no supervision.
• Ability to meet deadlines while maintaining attention to detail and accuracy.
• Ability to sort through multiple and, at times, conflicting needs and priorities is required.
• 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.
• Ability to communicate effectively to both business and information services staff.
• Ability to work independently or on a team.
• Ability to provide clear guidance and training to junior team members.
• Strong interpersonal skills with the ability to establish and maintain great working relationships.
• Strong organization skills with the ability to shift priorities quickly.
• 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.

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.
The use of AI is prohibited in the application process. This includes any selection related processes through the recruitment process including assessments and interviews. If there is known use of AI, you will be disqualified.

• Follow the "Apply" link and complete the application online and all supplemental questions.
• Attach your resume.
• Attach your optional 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 optional 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 Jobs Hub 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)

• Develop, design, and maintain DataStage ETL jobs
• Perform root cause analysis and address existing issues
• Programs involve the use of SQL, DB2, Infosphere Information Server
• Use of Cognos software for developing reports based on business needs.
• Perform system analysis to support current and future business needs.
• Work with internal and external partners to determine the best solution for enhancing the system and its interfaces.
• Create program specifications, detailed program design and operational documentation.
• Write new programs and maintains/modifies existing programs using relational databases maintaining data integrity which may change or re-engineer a business process.
• Adhere to Child Support Technology Services standards and version controls.
• Analyze performance issues and develop, test and implement resolutions.
• Respond to non-critical system stoppages, which may or may not include internal and external partner agencies.
• 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.
• Diagnose and resolve system issues referred directly from the customer.
• Work closely with the customer in defining detailed system requirements and design.
• 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.
• 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.
• Ensure version compatibility between new releases that support the distributed needs of the system which may also impact partner agencies.
• Evaluate performance and resource competition issues, resolve and coordinate solutions.
• Create necessary documentation per IT shop standards, ensuring design and implementation conform to policy.
• Evaluates and tests new products are compatible with existing internal and external systems.
• 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.
• Other duties in part include the construction, customer service, and operations of data.
• Mentor junior-level developers to diagnose and solve system related problems.
• Other duties as assigned.

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 working for the Department of Justice and application assistance, click HERE.
Oregon Department of Justice
1162 Court St NE
Salem, OR 97301
Phone: (503) 947-4328
Fax: (503) 373-0367