Sr. Data Warehouse Business Analyst

University of Pittsburgh; Pittsburgh (Allegheny County); Hybrid; USD 80,000 - 100,000; Full time

Job summary

An established industry player is seeking a Senior Data Warehouse Business Analyst to bridge the gap between business needs and technology solutions. This role involves analyzing and optimizing data warehouse processes, collaborating with stakeholders, and overseeing project lifecycles. The ideal candidate will possess strong analytical skills, attention to detail, and a deep understanding of data integration and reporting. Join a diverse and inclusive environment where your contributions will drive strategic decision-making and enhance business processes. If you are passionate about leveraging technology to solve complex problems, this opportunity is perfect for you.

Qualifications

• 5+ years of experience in data warehouse methodologies and business intelligence.
• Expertise in SQL and familiarity with Tableau or PowerBI is a plus.

Responsibilities

• Analyze and optimize data warehouse processes to meet business needs.
• Oversee the full lifecycle of data warehouse projects from planning to support.

Skills

Attention to Detail

Analytical Skills

Communication

Team Collaboration

Time Management

Education

Master's Degree

Tools

SQL

Tableau

PowerBI

Job description

On March 10, the University of Pittsburgh announced the implementation of a strategic hiring freeze. Currently, the University is only accepting applications for positions that are essential or operationally critical. Those positions are listed on our website.

Job Description - Sr. Data Warehouse Business Analyst (25001882)

Sr. Data Warehouse Business Analyst

The Senior Data Warehouse Business Analyst plays a critical role in bridging the gap between business needs and technology solutions by analyzing, designing, and optimizing data warehouse processes.

This position involves working closely with business stakeholders, IT teams, and data architects to gather requirements, define data models, and ensure that data is stored, managed, and delivered in a way that enables strategic decision-making.

The Senior Data Warehouse Business Analyst will also be responsible for overseeing the full lifecycle of data warehouse projects, from planning and requirements gathering to implementation and post-deployment support.

The ideal candidate will have extensive experience with data warehouse methodologies, business intelligence tools, and a deep understanding of data integration, reporting, and analytics.

Knowledge of Data Warehouse concepts and SQL is a must. Experience with Tableau or PowerBI is a plus.

Skills Required:

1. Attention to Detail: Ability to notice minute details and meet quality standards.
2. Analytical Skills: Strong analytical and problem-solving abilities.
3. Communication: Excellent written and verbal communication skills.
4. Team Collaboration: Ability to work well in a team-oriented environment.
5. Time Management: Ability to manage multiple tasks and deadlines.

Job Summary:

Works with business groups to solve diverse and highly complex problems using technology. Analyzes advanced business needs and evaluates complex business processes to recommend process enhancements and expert-level solutions. Assists business analysts with complex and advanced projects.

Essential Functions:

1. Works with business groups to solve diverse and highly complex problems using technology. Resolves issues, which may impact timelines, to avoid delays.
2. Identify data sources and analyze data sources to identify data completeness and ensure it is documented.
3. Analyzes advanced business needs for data warehouse and recommends expert-level solutions. Oversees the gathering of as well as creates requirements to ensure customer needs are fully understood.
4. Supervises the maintenance of careful documentation by team members and maintains responsibility for overall business requirements documentation.
5. Ensures that documentation is available to team members and others throughout the project timeline.
6. Evaluates complex business processes to identify gaps and inefficiencies and recommends solutions to enhance processes.
7. Provides clarification to ensure proper understanding of testing specifications and business processes.
8. Participates in meetings with project teams to document changing business requirements and processes and seeks advice and assistance when necessary.
9. Works with a business analyst team to ensure the proper documentation of specifications and business processes.
10. Collaborates with team members on complex and advanced projects. Works collaboratively with colleagues, effectively communicating progress, challenges, and issues that may affect the larger project outcome.
11. Receives and acts on instructions given to ensure success in an assigned area.

Physical Effort:

Light, Little physical effort. Duties are primarily Sedentary. May be required to move objects up to 25 pounds occasionally.

The University of Pittsburgh is committed to championing all aspects of diversity, equity, inclusion, and accessibility within our community. This commitment is a fundamental value of the University and is crucial in helping us advance our mission, which includes attracting and retaining diverse workforces. We will continue to create and maintain an environment that allows individuals to discover, belong, contribute, and grow, while honoring the experiences, perspectives, and unique identities of all.

The University of Pittsburgh is an Affirmative Action/Equal Opportunity Employer and values equality of opportunity, human dignity and diversity. EOE, including disability/vets.

Assignment Category: Full-time regular

Job Classification: Staff. Information Technology Business Analyst IV

Job Family: Information Technology

Job Sub-Family: Quality Management Solutions

Campus: Pittsburgh

Minimum Education Level Required: Master's Degree

Minimum Years of Experience Required: 5

Will this position accept substitution in lieu of education or experience? Combination of education and relevant experience will be considered in lieu of education and/or experience requirement.

Required Licensure/Certification: Business Analyst Certification, QSA certification, and/or Lean Six Sigma

Additional details about Required Licensure/Certification: Knowledge of Data Warehouse concepts and SQL is a must. Experience with Tableau or PowerBI is a plus.

Work Schedule: Monday - Friday, 8:30 a.m. - 5:00 p.m

Work Arrangement: Hybrid: Combination of On-Campus and Remote work as determined by the department.

Hiring Range: TBD Based Upon Qualifications

Relocation Offered: No

Visa Sponsorship Provided: No

Background Check: For position finalists, employment with the University will require successful completion of a background check

Child Protection Clearances: Not Applicable