"Alerted.org

Acts as a strategic partner to the business to facilitate and implement technology solutions that support financial and regulatory reporting. This role is responsible for writing detailed system requirements to ensure technology solutions align with business needs. It involves deep engagement in source data analysis, data mapping to the Oracle Financial Services Analytical Applications (OFSAA) and Oracle Financial Services Data Foundation (FSDF) data models. Partner with business team to gather and document functional and non-functional business requirements. Actively collaborated with business partners, technology teams and cross functional teams.

Key Responsibilities:

+ Develop detailed business requirements for both functional (e.g., business processes, rules) and non-functional (e.g., data, security) capabilities.

+ Gather and interpret information from multiple sources—including databases, stakeholder interviews, and documentation—and provide actionable recommendations.

+ Help building RDM (Reg Data Mart) for regulatory data consumption.

+ Leverage experience with OFSAA and FSDF out-of-the-box solutions to trace data movement lineage from Staging to Result and Reporting layers.

+ Perform data analysis and profiling on source system data to assess quality, completeness, and consistency.

+ Write SQL queries to extract, analyze, and validate data from various databases.

+ Map key data attributes and dimensions from source systems to the OFSAA FSDF standard data model.

+ Validate test cases to ensure they accurately evaluate the intended business functions.

+ Support application development teams by documenting business processes and data flows.

+ Translate technical concepts for business stakeholders and convey business requirements to technical teams.

+ Contribute to project planning by developing estimates and implementation plans for technical solutions.

+ Collaborate with team members to create project schedules, reports, and documentation; may lead small to medium-sized projects or guide other team members.

+ Work with UX/Design teams to help visualize requirements through prototypes.

Skills & Previous Experience:

+ Bachelor’s degree in information systems, Computer Science, Business Analytics, or a related field.

+ Minimum of seven (7) years of relevant experience as Technology Business Analyst, Systems Analyst or Data Analyst

+ Strong background in the financial services industry is highly preferred.

+ Proven experience in gathering and documenting business and system requirements using BRDs, use cases, flowcharts, and wireframes.

+ Hands-on experience in data analysis, profiling, and mapping across complex data environments.

+ Solid understanding of relational databases, data models, and ETL processes.

+ Proficiency in SQL and data profiling tools for querying and validating data.

+ Experience in documenting metadata and managing data lineage.

+ Familiarity with Oracle Financial Services Analytical Applications (OFSAA) and Financial Services Data Foundation (FSDF) data models is highly preferred.

Licenses/Certifications:

+ None required.