The Bank of New York Mellon is a provider of investment services and investment management and we are a world-renowned leader in each. When combined, the power of our extensive capabilities can help drive your success in markets around the world. BNY Mellon is the corporate brand of The Bank of New York Mellon Corporation.
BNY Mellon Technology's mission is to provide our business partners with technology based solutions that enhance their ability to be successful through world-class software solutions maintained on a stable and secure infrastructure, and to provide our employees with the tools and means to enhance their professional qualifications and careers.Our Team
TSG provides reliable, resilient, next-generation enterprise technology infrastructure and support that enables BNY Mellon employees to deliver the whole firm to their colleagues and clients around the world. We are continuously improving automation and bridging the gap between cost, customer needs, and innovative tools to ensure the best possible experience.
TSG Production Services team is dedicated to ensuring that our technology environments are best in class. Our Production Services team runs the systems that keep BNY Mellon running. Ourmission is to deliver a full IT service management lifecycle across all run-the-bank applications and infrastructure support with the purpose of providing a controlled, secure, and predictable production environment.
Our team members use their technical skills and business knowledge to bring forth solutions that will take our company into the future. If you are a collaborative continual learner with a global mindset and a desire to contribute to our company’s top priorities, this is the place for you.
The Service Management Office is actively seeking a Data Analyst who will be responsible for building, maintaining, and improving the Service Management Reporting platform.
We are responsible for proactive governance, control, and continuous improvement of the Production Services Operating model, underlying IT operational processes and supporting tools to ensure optimal and effective service delivery, production stability and regulatory compliance.
Specialist Data Analyst->> Designs and creates highly complex logical/physical data models, and data dictionaries that cater to the specific business and functional requirements of applications. Consults with businesses to identify needs and translates those needs into data architecture solutions. Develops comprehensive data/technical specifications that bridge business/product needs with system design/deliverables. Performs data extracts and creates complex data reports to analyze user metrics. Develops understanding of business needs and functionalities to determine compatibility of database with existing hardware/software applications and recommend the most cost effective methods. Consults with database administration and client areas and provides solutions in resolving issues during the translation to a physical database design. Provides knowledge and expertise of enterprise data to assist the business in the creation and definition of internal and external message flows. Provides knowledge and expertise in existing database environments and makes recommendations for opportunities to share data and/or reduce data redundancy. Analyzes market trends for data modeling tools and metadata management software. Provides input into the selection of tools and any necessary migration into the company's environment. Contributes to the achievement of area objectives.
- Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions and upgrades
- Drive design build and management of large, complex Oracle database running on Oracle 12c environments on Exadata.
- Participate in planning and executing database migrations, application software upgrades/migrations.
- Provide proactive input into design issues/constraints and enforcing data integrity across multiple platforms.
- Manage logins and user accounts, including assigning database object permissions and ancillary privileges.
- Schedules and manages jobs for data transfers, procedures and monitors performance and impact on operations.
- Database performance monitoring and tuning: Closely monitor performance, identify problems and implement solutions;
- Performing ad-hoc reviews and updates as required to resolve data discrepancies
Bachelor's degree in computer science or a related discipline, or equivalent work experience required, 8-10 years of experience in data modeling, 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.
- Strong knowledge of Oracle;
- Experience in database performance tuning and database mangement
- Data Modelling experience
- Analytical mindset with problem-solving skills
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:
- Knowledge of ITIL framework will be a plus
- Prior experience with ServiceNow
United States-New York-New YorkInternal Jobcode:
Technology Production Services-HR17024Requisition Number: