Data Warehouse & Analytics Systems Analyst II

Veriipro; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

Veriipro is seeking a Data Warehousing Systems Analyst II to support enterprise data warehouse solutions, data analysis, system integrations, and business applications. The role will work closely with technical and business stakeholders to gather requirements, troubleshoot issues, support data processes, and improve system functionality.

You will work across ETL, SQL, data governance, and reporting initiatives, continually optimizing data flows, ensuring data integrity, and contributing to

Qualifications

• 5+ years of Information Technology experience.
• Strong proficiency in writing and executing SQL.
• Working knowledge of Data Warehousing, ETL processes, and Data Security.
• Experience with enterprise applications, data analysis, reporting, and system integrations.
• Strong analytical, problem-solving, and communication skills.
• Ability to work effectively with both technical and business stakeholders.
• Demonstrated aptitude, ownership, and thought leadership in previous roles.
• Solid understanding of the Software Development Life Cycle (SDLC).

Responsibilities

• Support enterprise data warehousing, ETL processes, and data integrations.
• Write, execute, and troubleshoot complex SQL queries.
• Analyze data, reporting requirements, system issues, and data flows.
• Gather, document, and translate business and technical requirements.
• Support enterprise applications and business systems.
• Perform systems analysis, troubleshooting, and process improvement.
• Support software implementations, projects, and application lifecycle activities.
• Ensure data integrity, security, and governance.
• Create user stories, support backlog activities, and document functional requirements.
• Collaborate with business users, IT teams, vendors, and management.
• Provide end-user support and training when required.

Skills

SQL

Data warehousing

ETL

Data security

Data analysis

System integrations

SDLC

Leadership

Problem solving

Stakeholder comms

Tools

Oracle R12

Oracle 19c

PL/SQL

Linux

Job description

Veriipro is seeking a Data Warehousing Systems Analyst II to support enterprise data warehouse solutions, data analysis, system integrations, and business applications. The role will work closely with technical and business stakeholders to gather requirements, troubleshoot issues, support data processes, and improve system functionality.

You will work across ETL, SQL, data governance, and reporting initiatives, continually optimizing data flows, ensuring data integrity, and contributing to