Data Management Analyst

PGMTEK Inc.; New York (NY); Sur place; USD 85 000 - 125 000; Plein temps

Résumé du poste

PGMTEK Inc. is seeking a Business Analyst to develop detailed business requirements, conduct stakeholder interviews, and collaborate with the development team to automate reporting capabilities and migrate BI processes.

The role supports a data initiative to streamline manual processes, improve regulatory and risk compliance, and deliver deeper insights for the banking sector. The ideal candidate has strong data analytics experience in Financial Services and an ability to manage end-to-end

Qualifications

• 4+ years in data management and business analysis, preferably in banking.
• Experience with data integration, data warehouse, data migration, and report automation.
• SQL reading/writing ability and understanding of data lake/data warehouse concepts.

Responsabilités

• Develop business and functional requirements for report automation and system implementation.
• Elicit requirements from stakeholders and plan requirements workshops.
• Lead meetings to gather requirements and create detailed BRD documents.
• Design workflows and provide solutions from multiple teams and technical capabilities.
• Design and implement data lake ingestion and data warehouse construction.
• Develop SQL queries to extract data from data lake/warehouse for reports.
• Collaborate with IT during SDLC: BRD, data warehouse, troubleshooting, UAT testing.
• Lead UAT, create plan and test cases, report progress.
• Address issues in daily operations with stakeholders for resolution.
• Create and maintain user manuals for automated reports; manage project activities.
• Proactively identify risks and communicate mitigation plans.

Connaissances

Data management

Business analysis

SQL

Stakeholder interviews

Analytical thinking

Formation

Bachelor/Master in finance or related field

Advanced degree in data analytics or business analysis

Outils

Data lake tooling

Data warehouse tooling

Description du poste

Summary:

The Business analyst is a hands‑on role to develop detailed business requirements, conduct stakeholder interviews to gather necessary requirements and collaborate with the development team to automate/migrate reporting capabilities and business intelligence. This data initiative project will enable the bank to streamline and reduce manual processes, and gain deeper insights into their business while meeting increasing regulatory and risk compliance requirements. The ideal candidate possesses fundamental understanding of Financial Services Industry (FSI) experience with in data and analytics domain.

Proficiency in speaking and writing in Chinese/Mandarin is MANDATORY for managing communications with the Head Office.

Responsibilities:

• Develop business and functional requirements for report automation/migration and system implementation
• Assist the team leads in eliciting business requirement from the business stakeholders, manage the planning and execution of requirements gathering workshop
• Conduct stakeholder meetings independently, with minimal supervision, to gather necessary requirements, and develop detailed business requirements document
• Design and maintain workflows based on requirements collected, able to provide solutions by analyzing requirements received from multiple teams and technical capability
• Design and implement data lake ingestion and data warehouse construction
• Develop SQL queries in the reporting platform to extract data from data lake and data warehouse to build automated reports
• Collaborate with IT teams during SDLC cycle, not limited to, includes BRD discussion, data warehouse construction, coding troubleshooting, UAT testing, etc.
• Lead the User Acceptance Testing, develop UAT plan and create test cases, report testing status/progress
• Assist in addressing issue identified in day-to-day operations by collaborating with concerned stakeholders for effective issue resolution
• Create and maintain user manuals and procedures related to reports automated, as needed
• Manage all project management activities, including but not limited to, status updates, project plan updates/maintenance, socialization of deliverables with the stakeholders etc.
• Proactively identify and mitigate risks before they become roadblocks

Education and Experience Requirements:

• Bachelor/Master degree in finance or related field
• Advanced degree in data analytics, business analysis, etc. is preferred

Skills and Knowledge:

• 4+ year experience in data management and business analysis, preferably in the banking sector
• Should have experience on data integration, data warehouse, data migration, report automation and process management tools
• Should be able to read and write SQL
• Should understand the architecture and concept of data lake and data warehouse related knowledge and design
• Must have strong written and verbal communication skills and suitable in teamwork environment
• Must be proactive and analytical to evaluate and solve problems independently
• Must be able to work under pressure with the team and deliver results in a timely manner
• Must be willing to learn, self-driven and responsible