Systems Analyst II

Data Warehouse Support Analyst responsible for SQL development, data warehouse support, ETL processes, production support, project work, and stakeholder coordination. Job Requirements Minimum 5 years of Information Technology experience

Strong proficiency writing and executing SQL

Working knowledge of data warehousing concepts

Working knowledge of ETL processes

Working knowledge of data security concepts

Experience supporting production systems

Experience with data warehouse development

Experience coordinating with stakeholders

Ability to demonstrate technical aptitude or prior thought leadership examples

Preferred Skills 2 or more years of experience supporting data warehousing solutions

Oracle ERP module exposure or working knowledge

Finance module experience

Project Accounting module experience

Procurement module experience

Order-to-Cash experience

Procure-to-Pay experience

Oracle R12 version 12.2 experience

Oracle 19c database experience

PL/SQL experience

Linux experience

Software development life cycle knowledge

Experience interacting with customers, vendors, IT professionals, and management

Job Responsibilities Provide production support for data warehouse and related systems

Support project work related to data warehouse development and business requirements

Write, execute, and troubleshoot SQL queries

Support ETL processes and data movement activities

Apply data security concepts to data warehouse support and development work

Support data warehouse development activities throughout production and project work

Coordinate with stakeholders on data requests, issues, and project needs

Troubleshoot data, system, and reporting issues

Support Oracle ERP-related data needs as applicable

Work with Oracle databases, PL/SQL, and Linux systems as needed

Participate in software development life cycle activities related to data warehouse changes

Balance responsibilities across production support and project work, with production support representing the majority of the role

Pay Details: The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and/or security clearance requirements, including, as applicable: The California Fair Chance Act Los Angeles City Fair Chance Ordinance Los Angeles County Fair Chance Ordinance for Employers San Francisco Fair Chance Ordinance Massachusetts Candidates Only: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.