Senior Data Analyst

Papigen; Washington (District of Columbia); On-site; USD 140,000 - 170,000; Full time

Job summary

Papigen in Washington, DC seeks a senior Data Analyst to enhance a financial sustainability reporting system and an operational data store. You will work with business users and cross-functional teams to translate requirements into robust data solutions.

The role emphasizes data modeling, performance tuning, and coordinating user acceptance testing while guiding offshore developers. A Master’s or 9+ years path is required.

Qualifications

• Master's or Bachelor's with substantial relevant experience in IT or data analytics.
• 7+ years Oracle databases with PL/SQL skills and accounting data understanding.
• Experience creating data models and using ERwin; strong communication with technical and business users.
• Proven problem-solving and prioritization skills to deliver on projects.

Responsibilities

• Understand requirements and design database structures; develop procedures, functions, packages, scripts.
• Guide offshore resources to translate requirements into solutions.
• Perform data analysis and inform analytics and report development with proper data prep.
• Modify code for performance and troubleshoot issues promptly.
• Coordinate user acceptance testing of reports and data-driven solutions.
• Build domain knowledge and address ad hoc requests as SME for business users.

Skills

PL/SQL

Data analysis

Data modeling

UAT coordination

Accounting data understanding

Education

Master's degree in IT/CS/MIS

Bachelor's degree + 9+ years experience

Tools

ERwin

Job description

Role Overview

We are looking for a senior Data Analyst (Standard Level 3) with strong Oracle PL/SQL skills to support enhancements to a financial sustainability reporting system and an operational data store. The role requires the ability to understand the functional meaning of the data and to work effectively with business users and other technical teams.

Scope of Work

• Understand requirements and design database structures; develop database components including stored procedures, functions, packages, and scripts.
• Interact with other technical team members, including guiding offshore development resources to translate requirements into solutions.
• Perform data analysis and inform analytics and report development with appropriate data layer preparation.
• Modify code to optimize for performance and troubleshoot issues in a timely manner.
• Coordinate user acceptance testing of reports and data-driven solutions.
• Build application knowledge and serve as the SME to address ad hoc requests from business users.

Skills & Experience Required

• Master's degree in IT, Computer Science, Mathematics, or MIS with 7+ years of relevant experience, or Bachelor's degree with 9+ years of relevant experience.
• 7+ years of experience working on Oracle databases with strong PL/SQL skills and an understanding of accounting data.
• Proven expertise creating data models and using the ERwin tool.
• Excellent communication skills, with experience communicating effectively with technical and non-technical audiences and coordinating with team members and business users.
• Demonstrated problem-solving and task prioritization skills to support successful project completion.

Skills: data analysis,functions,packages,scripts,uat coordination,stored procedures,analytics,pl/sql,data models,erwin