Lead Business Systems Analyst
Assist in planning, organizing, and controlling the activities for System build. Work with Product Managers and Team SMEs to identify and specify/document the complex system design based on business requirements and processes, and help in the application design, testing and implementation process.
Document and maintaining Compliance Systems Data Requirements, Systems Catalog, and data integration ETL/API specifications. Establish Data Quality profiling and governance rules and partner with technical SMEs to automate those data rules using Python and other enterprise ETL tools.
Conduct source system data profiling, results analysis, and documentation of the data remediation plan. Conduct source-to-target technical data mapping for ETL and Data integration specifications. Build and maintain global data intake/onboarding and change pipelines for Data Integration and data operations journeys in JIRA.
Collaborate closely with Compliance Operations, Compliance technology vendors and other Global Technology teams to support the implementation and maintenance of Data Integration and Data operations pipelines for the Financial Crimes portfolio.
Supporting Data onboarding, data integration testing and ETL deployments using both manual and automated processes. Support Data migrations as part of Prudential Compliance Technology transformation. Review, analyze, and report on data processing/governance related issues and trends to Compliance LCBE Technology leadership on an ongoing basis.
Partner with the appropriate technology teams and/or global stakeholders to address system and data issue findings in a timely manner. Act as expert technical resource to development staff in all phases of the development and implementation process.
Execute all work using the Agile methodology, while leveraging enterprise level ETL, API, Analytics and CI/CD tools.
Telecommuting permitted up to 1 day per week.
Full time employment, Monday Friday, 40 hours per week.
MINIMUM REQUIREMENTS:
Must have a Bachelors degree in Computer Science, Information Technology, Data Science, or a related field, and 5 years of progressive, post-baccalaureate related work experience; OR a Masters degree in Computer Science, Information Technology, Data Science, or a related field, and 3 years of related work experience.
Of the required experience, must have 3 years of experience in each of the following:
Performing data operations and systems analysis;
Creating and maintaining detailed data flows and diagrams, data relationships and dependencies, and creating data mapping and ETL specification documents; and
Utilizing Agile tools, including JIRA, for project execution using Agile methodology.
Of the required experience, must have 2 years of experience in each of the following:
Utilizing Python and SQL for data analysis;
Utilizing Data and ETL tools, including AWS Glue, Informatica or Denodo, for data analysis and transformation of data feed files; and
Performing Data Quality profiling, statistical analysis, and implementing ongoing data quality improvements.
Of the required experience, must have 1 year of experience utilizing AWS Data stack, including S3, EC2, Lambda or DynamoDB, for data analysis and transformation of data feed files.
Telecommuting permitted up to 1 day per week.