Principal Data Analyst-Data Architect

The Bank Of New York Mellon Florham Park , NJ 07932

Posted 2 weeks ago

Pershing Technology

Want to work on the team that was fintech before there was "fintech" and

which continues to win top global awards for innovation, quality, and service? Pershing Technology is the global leader trusted by other global leaders to ideate, innovate, and implement next-generation solutions for trade execution, clearing, custody, and a broad array of the critical technology services upon which enterprises from all segments of the financial markets rely.

Our platforms rest on world-class infrastructure that supports portals and systems through which we deliver state-of-the-art applications that empower our clients to build their businesses and better serve their investors. By the numbers, we perform at a level and a scale which few firms can equal: every business day, ~USD 14 billion flows through our systems as part of an average of ~8,500,000 transactions and ~1,200,000 trades. We maintain the systems that handle this massive volume with 99.98% average monthly uptime; needless to say, risk management, resiliency, and security are our watchwords.

We have developed a high-performance culture in which responsiveness and agility are tied to our commitment to serving our clients' best interests. Our flexible, open-architecture, fully-integrated suite of solutions are consumed by clients who want us to manage their technology portals, those who want to integrate our products and services with their own, and those who want to develop their own technologies and control them, end-to-end. From advanced artificial intelligence to virtual reality, from robotic process automation to blockchain, we're building the digital experiences through which the global financial industry will be transformed, and new titans arise.Do you want to join us and help build that future? Read on.

Principal Data Analyst->> Demonstrates expert proficiency in the design, development and implementation of data, reporting and database technologies and tools. Consults with businesses to resolve complex data issues.

Continues to extend existing data architecture to support increasing user demands and application requirements. Assesses and evaluates risk to understand the implications of design decisions and new technologies. Develops database design/code through in-depth understanding of business needs/functionalities and provides expertise in devising, negotiating and defending database schemas and data models.

Consults with database administration and client areas and provides solutions in resolving complex issues during the translation to a physical database design. Provides knowledge and expertise of enterprise data to lead the process for assisting the business in the creation and definition of internal and external message flows. Provides direction and guidance on reports and ensures recommendations are aligned with user needs and capabilities.

Uses expertise to evaluate market trends and provide input into the selection of tools and any necessary migration into the company's environment. Contributes to the achievement of area objectives.

Qualifications

Sr. Enterprise data architect experience and willing to be hands-on and would like to work on financial data platform

DB2 mainframe, Oracle, Teradata, Hadoop, Micro-service architecture

  • Main key expertise:

  • Understanding Enterprise data governance very well

  • Business glossary

  • Hands-on data modeling (relational, mpp, no sql) using Erwin

Excellent communication skills

Bachelor's degree in computer science or a related discipline, or equivalent work experience required 10-12 years of experience in in integration architecture, micro-service design, data modeling, data lakes, big data, data warehousing, data entity analysis, logical and relational database design, or an equivalent combination of education and work experience required, experience in the securities or financial services industry is a plus

..

BNY Mellon is an Equal Employment Opportunity/Affirmative Action Employer.

Minorities/Females/Individuals With Disabilities/Protected Veterans.

Our ambition is to build the best global team - one that is representative and inclusive of the diverse talent, clients and communities we work with and serve - and to empower our team to do their best work. We support wellbeing and a balanced life, and offer a range of family-friendly, inclusive employment policies and employee forums.

Primary Location: United States-New Jersey-Florham Park

Internal Jobcode: 45179

Job: Information Technology

Organization: Pershing Technology-HR06376

Requisition Number: 1913127



icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Oracle Cloud Product Data Hub (Pdh) Senior Principal Consultant

Accenture

Posted 1 week ago

VIEW JOBS 3/24/2020 12:00:00 AM 2020-06-22T00:00 Product Data Hub, Solution Architect Ready to reimagine your Oracle career? Join Accenture and be empowered with innovative tools, continuous learning and a global community. There has never been a better time to join our team of 54,000+ Oracle experts, where you'll: * Drive end-to-end innovation. Gain early access to Oracle innovations through our unparalleled program of collaboration. Accenture is Oracle's #1 systems integrator globally for 12 years running and a proud Global Cloud Elite and Platinum-Level member of the Oracle Partner Network. * Lead the Journey to Cloud. Define and implement Oracle Cloud solutions on large, complex client projects with a scope unsurpassed in the industry. * Deliver award-winning work. Accenture has won more than 145 Oracle awards since 2003—more than any other systems integrator. * Learn and Grow Continuously. Benefit from unmatched training and development including workshops and training to secure Oracle certifications, expert-curated learning boards and Oracle Cloud Academy training on sales and delivery excellence. * Advance your agenda. Grow your career as far as your ambition takes you. We provide real-time performance feedback based on your strengths – not stats. * Thrive in diversity. Succeed in an organization that actively promotes networking and mentorship among all communities. Job Description Candidate should have experience articulating solutions to stakeholders as this role involves discussions at various levels with client business users. Responsible for gap analysis of functional flows, provide solution design, perform demo for the Gaps solution from standard solution sets as well customized solutions. Can independently solution business requirements and recommend industry best practices. Should be able to lead cross functional discussions to analyze the requirements and brainstorm the solutions. * Review, analyze and evaluate business systems and user needs. Recommends, develops and executes plans for additional software module implementations based on business requirements Act as functional advisor and manager of technology resources * Prepare design documentation and work with application delivery resources as necessary to support business requirements * Prepare and present updates on projects to executive management * Adept at determining requirements by interviewing client personnel, reviewing documentation and facilitating working sessions. * Adept at creating business process models based on the requirements * Adept at mapping industry trends and best practices to the client's unique requirements and processes to determine applicable fit. * Capable of defining, and re-engineering business processes. * Able to present solutions described above to senior client management via whiteboard and PowerPoint. * Knowledgeable about the Oracle applications functionality, tools, templates and method and able to setup the system to meet the desired business process and requirements. * Adept at working with clients to develop testing scenarios and test scripts and leading teams in unit, integration and acceptance testing. WHO WE´RE LOOKING FOR? Skills * Successful Consultants will have the following background: * Experience in solution architecture and writing functional specifications, functional solution design for technical development. * Systems implementation skills: business process design and redesign, reengineering, requirements/process analysis, conceptual and detailed design, configuration, testing, training, change management and support * Consulting skills: business analysis in a variety of industries, able to articulate at the C-level, self-motivated, team oriented, positive attitude, with a can-do, jump-right-in attitude * Excellent written and verbal communication including presentation skills * Ability to work independently and manage multiple task assignments * Tool knowledge: MS Project, MS Visio, MS PowerPoint, Excel, Word Strong problem solving and troubleshooting skills with the ability to exercise mature judgment * Strong business background, working knowledge of generally accepted best business principles * Effectively produces deliverables * Ability to identify, assess and mitigate relevant risks during project execution * Organized and detailed oriented Essential Job Functions * Work with business users and business analysts to understand requirements and deliver master data solutions for Item/Product master; Employ best practices in the design * Create Item/Product master data model to fulfil needs of the overall supply-chain applications * Maintain configuration documentation for Oracle Product Data Hub; * Configure Oracle Product Data Hub along with Data Security for full access; limited access; view-only access * Produce data mappings between legacy and Fusion master list of values; Provide guidance on data cleansing in legacy environments; Create data conversion designs and data validation processes; coordinate data conversion/validation * Create training documentation; Train Master Data Management team on processes related to new product introduction; product maintenance and sunsetting) * Co-ordinate and Administer MDM deployments and migrations between environments * It is currently our objective to assign our people to work near where they live. However, given the nature of our business and our need to serve our clients our employees must be available to travel when needed. This role requires 100% travel flexibility to travel and work onsite with clients (typically Monday - Thursday) WHAT´S IN IT FOR YOU? * Competitive benefits, including a fair and balanced parental leave policy. * At Accenture, we believe in bringing the best to our clients through continuous learning & improvement – from basic skills to industry-specific content – available to all our people. * Career coaching and mentorship to help you manage your career and develop professionally. * Performance Achievement – our performance management process that focuses on your strengths, progress and career possibilities. * Fantastic opportunities to develop your career across a variety of clients. * Opportunities to get involved in corporate citizenship initiatives, from volunteering to doing charity work. Experience and Qualifications * Bachelor's degree or equivalent (minimum 12 years) work experience. * Minimum 10 years experience working with Oracle EBS; professional who has transitioned to Oracle Cloud coming from the Oracle EBS space. * Possesses end to end implementation experience with ERP – with Oracle EBS and Oracle ERP Cloud. Hands-on experience with Oracle Product Data Hub (Oracle Fusion product). * Has strong expertise on the business processes and best practices with the following areas (individually and cross-functionally) that closely related to Items/products: * Supply Chain Management (Procurement/MRO/Expenses) * Inventory Management (items, Kits, MRO, product Categories) * Sales Order Management (Customer, Items, Kits) * Basic Manufacturing (Items Master data, Bills of Material/Kits) * Basic Financials (Customers, Suppliers) * Implementation experience and strong expertise and best practices with master data management: * Expertise on best practices related to functional master data domain – Items (products, MRO, etc.), product categories, etc. * Hands on experience with configuration of various Product Data Hub components including Security roles; Data load process of Loading Master data into Product Data Hub * Experience with Data quality management; data governance; data consolidation and data standardization; Share-ability of data across business divisions; Reporting/Business Intelligence * Ability to perform data analysis and provide guidance on data cleansing approaches * Excellent interpersonal and communication skills (written and verbal); Good listening skills and openness to different points of view * Intermediate/advanced MS Excel skills * Detail oriented with strong information seeking skills; Good analytical and problem-solving skills * Good working knowledge of data architecture and database structure * Self-motivated and collaborative Essential Job Functions * Work with business users and business analysts to understand requirements and deliver master data solutions for Item/Product master; Employ best practices in the design * Create Item/Product master data model to fulfil needs of the overall supply-chain applications * Maintain configuration documentation for Oracle Product Data Hub; * Configure Oracle Product Data Hub along with Data Security for full access; limited access; view-only access * Produce data mappings between legacy and Fusion master list of values; Provide guidance on data cleansing in legacy environments; Create data conversion designs and data validation processes; coordinate data conversion/validation * Create training documentation; Train Master Data Management team on processes related to new product introduction; product maintenance and sunsetting) * Co-ordinate and Administer MDM deployments and migrations between environments * It is currently our objective to assign our people to work near where they live. However, given the nature of our business and our need to serve our clients our employees must be available to travel when needed. This role requires 100% travel flexibility to travel and work onsite with clients (typically Monday - Thursday) To learn more about Accenture, and how you will be challenged and inspired from Day 1, please visit our website at www.accenture.com/careers. Applicants for employment in the US must have work authorization that does not now or in the future require sponsorship of a visa for employment authorization in the United States and with Accenture (i.e., H1-B visa, F-1 visa (OPT), TN visa or any other non-immigrant status). Candidates who are currently employed by a client of Accenture or an affiliated Accenture business may not be eligible for consideration. Accenture is a Federal Contractor and an EEO and Affirmative Action Employer of Females/Minorities/Veterans/Individuals with Disabilities. Equal Employment Opportunity All employment decisions shall be made without regard to age, race, creed, color, religion, sex, national origin, ancestry, disability status, veteran status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status or any other basis as protected by federal, state, or local law. Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process. Accenture is committed to providing veteran employment opportunities to our service men and women. Accenture Florham Park NJ

Principal Data Analyst-Data Architect

The Bank Of New York Mellon