Enterprise Data Governance Platform Administrator - Pittsburgh Or Hermitage, PA

First National Bank (Fnb Corp.) Pittsburgh , PA 15201

Posted 2 months ago

Primary Office Location:One North Shore Center. Pittsburgh, Pennsylvania. 15212.

Join our team. Make a difference - for us and for your future. Overview of Description:

Enterprise Data Governance Platform administration with a broad scope of responsibilities including management of applications in Enterprise Data Governance area including Enterprise Data Warehouse, Master Data Management, Data Virtualization and Data Governance. Administration of FNB Corporate Data Repositories including Implementation, Configuration, Maintenance and performance of FNB Enterprise Data Warehouse. Development and sustenance of SQL Server databases part of Enterprise Data Governance function including TIBCO MDM platform, Fiserv Prime SQLServer databases, Credit Risk systems to name a few.

Manage SQL Server databases project lifecycle environments, from development to mission-critical production systems. Monitoring of system health and performance, to ensure high levels of performance, availability, and security. Refine and automate regular processes, track issues, and document changes . Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.

Assist Data Engineering team with complex query tuning and schema refinement. Provide 24x7 support for critical production systems. Perform scheduled maintenance and support release deployment activities after hours.) Core Skills: Expert Microsoft SQLServer Database administration skills.

Expert in administering Enterprise Data Warehouse systems. Excellent interpersonal and communication skills.

Expert in implementing complex data warehousing projects , multiple source systems, deep knowledge in SSIS, SSRS and other Microsoft technologies. Strong collaborator and ability to partner/network with multiple development teams, Information Security and Network Engineering teams. Nice to Have:

Prefer experienced professionals with Banking/Financial Industry domain expertise. Experience in TIBCO platform administration (MDM, Business Works, Spotfire, Data Virtualization) Experience in Cognos platform Administration Experience in Data Vault modeling Experience in implementation and management of Data Virtualization Platforms like Denodo Exposure to Data Modeling/Data Science methodologies and programming languages such as SCALA and R/Python. Position Title: Database Administrator
  • Information Technology Business Unit: Technology Reports To:

    Manager of Information Systems Position Overview:
    This position is primarily responsible for managing multiple databases including maintaining, analyzing and providing reporting from the databases while ensuring high levels of accessibility for users and applications using the databases.

    The incumbent identifies data sources, provides data flow diagrams and documents processes and writes code for database access, modifications and constructs.

    The incumbent is a Structured Query Language(SQL) expert and trains other members of the team. The incumbent uses Core Prime, Corillian, Profitability and TTM databases. Primary Responsibilities: Works closely with other team members to provide reporting and extracts from the database while working independently and with limited direction from the manager. Researches and analyzes data to generate requested reports and data extracts from the database. Uses SQL (Structured Query Language) to program reporting and data extracts over appropriate databases.

    Coordinates changes to the computer databases and tests and implements the database changes applying knowledge of database management systems. Writes reports and creates files in support of this essential function. Develops standards and guidelines to guide the user and acquisition of software and to protect vulnerable information.

    Plans, coordinates and implements security measures to safeguard information in computer files against accidental or unauthorized damage, modification or disclosure. Implements security measures to safeguard databases.

    Creates new databases and upgrades existing databases including creating and maintaining documentation related to these databases.

    Creates reports and extracts or supports the creation of required reports and extracts in response to the business user needs. Business users include any business line within the organization including Retail Support, Electronic Delivery, Treasury Management, Consumer Banking, Marketing, Deposit Operations and Loan Operations. Conducts training related to the databases.

    Troubleshoots all technical issues related to the databases. Performs other related duties and projects as assigned. All employees have the responsibility and the accountability to serve as risk managers for their businesses by understanding, reporting, responding to, managing and monitoring the risk they encounter daily as required by F.N.B.

    Corporation's risk management program. F.N.B.

    Corporation is committed to achieving superior levels of compliance by adhering to regulatory laws and guidelines.

    Compliance with regulatory laws and company procedures is a required component of all position descriptions. Minimum Education: BA or BS Minimum Years Experience: 5 Special Skills: Excellent organizational, analytical and interpersonal skills Excellent communication skills, both written and verbal Excellent project management skills Ability to use general office equipment Ability to use a personal computer and job-related software MS Word
  • Intermediate Level MS Excel

  • Intermediate Level MS PowerPoint

  • Intermediate Level Knowledge of Microsoft Structured Query Language (SQL), SQL databases and report writing applications such as Business Analytics or Web Intelligence. Ability to perform limited travel.

    Special Licenses and Certificates: N/A Physical Requirements:
    N/A
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
Enterprise Data Architect

Armstrong Flooring, Inc.

Posted 3 days ago

VIEW JOBS 10/20/2021 12:00:00 AM 2022-01-18T00:00 <p>As our Enterprise Data Architect, you will provide analysis and business process expertise to identify and implement improvement opportunities that mature enterprise data management at Armstrong Flooring. In addition, will support the data governance model, which includes aligning roles and responsibilities of the functional and technical areas, drives the strategy and execution of SAP master data across Armstrong Flooring.<br><br></p><p><strong>Location</strong>: Remote- 10% travel as needed <br><strong>New Headquarters</strong><em>:</em>1770 Hempstead Road, Lancaster, PA 17601. Catch a preview <a href="https://www.armstrongflooring.com/corporate/en-us/news/pressroom/armstrong-flooring-announces-new-headquarters-location.html" rel="nofollow noreferrer noopener" class="external">here</a>!<br></p><p><br><strong>Business Analyst, Enterprise Data Salary</strong>: $100,000- $130,000, based on experience (Gr. 12/13)</p><p><br></p><p><strong>How you’ll contribute to the team:</strong></p><p><strong>DATA SERVICES: </strong>Provide SAP subject matter expert support to business changes, strategic projects and integrations that span across multiple platforms.</p><ul> <li>Lead business and IT resources in conducting full assessments to identify impacts to data reliability, data standards (data definitions and business rules) and data process governance.</li> <li>Liaison between business functions and technical areas to ensure that data related business requirements are clearly defined, communicated, and well understood.</li> <li>Provide solution proposals and provide appropriate recommendation on alignment to the data model, leveraging SAP standard model and enterprise direction.</li> </ul><p><strong>DATA GOVERNANCE:</strong> Establish and uphold data management policies, standards, and processes.</p><ul> <li>Lead identification and resolution of data quality problems through the data governance structure.</li> <li>Profile data content, structure, and reliability including inconsistencies, inaccuracies and incompatibilities between data applications utilizing data profiling techniques and tools.</li> <li>Establish data relationships, and generate accurate source-to-target mapping between different data structures and define the necessary transformation specifications.</li> <li>Lead continuous improvement to data governance processes and practices utilizing process excellence tools.</li> <li>Research industry standards and practices applicable to AFI master data in order to make appropriate decision around new and existing data definitions in support of the standard.</li> </ul><p><strong>Requirements</strong></p><p><strong>What you'll bring to the table</strong>:</p><ul> <li>3+ years of experience with SAP</li> <li>5+ years of data management</li> <li>3+ years of experience working as a Business Analyst across multiple projects and business information systems</li> </ul><p><strong>We'll be excited if you have:<br></strong></p><p></p><ul> <li>Computer Science degree, Engineering degree; Information Systems, Data Analytics degree; Bachelor’s</li> <li>Process Excellence Certified (LEAN, Six Sigma)</li> <li>Project Management (PMP, ACP, CSM)</li> </ul><p><strong>Benefits</strong></p><p><strong>WHO WE ARE</strong></p><p>For over 160 years, our greatest asset has been the resiliency of our people. We are a community of makers and creators. Activators and achievers. Fearless innovators and tireless visionaries whose staunch determination and adaptability continue to fuel everything that we do. We are in search of strong candidates that are prepared to build with integrity, progress together and reimagine what is and what can be. Join us in raising the <a href="https://apply.workable.com/armstrong-flooring/?lng=en" target="_blank" rel="nofollow noreferrer noopener" class="external">B.A.R.</a></p><p><strong>That’s us. That’s Armstrong Flooring.</strong></p><p>Community &amp; Philanthropy: We have a heritage of investing millions of dollars in programs that enhance the neighborhoods where we live and work. Additionally, we’re proud that our employees regularly and willingly give of their time and talents to support the efforts of local organizations. </p><p>Sustainability: Armstrong Flooring has a long-standing reputation for sustainable innovation, starting with using cork waste to make linoleum floors over 100 years ago. We continue to develop products that have lower environmental footprints, and in some cases, reduce the environmental footprints of the buildings where they are installed. </p><p><strong>DEVELOPMENT</strong></p><p>At Armstrong Flooring, every employee has a development plan and discussions around career growth. We have many employees with diverse backgrounds and career paths. We offer the following opportunities which promote a growth culture:</p><ul> <li>Certifications</li> <li>On-the-Job training</li> <li>Tuition reimbursement</li> <li>Instructor-led &amp; online courses</li> <li>Cross-functional exposure</li> </ul><p><strong>BENEFITS </strong></p><ul> <li>Choice of competitive Medical, Dental and Vision plans - effective Day 1 of employment</li> <li>401k with company match</li> <li>Health Savings &amp; Flexible Spending Accounts</li> <li>Prescription plan with mail-order options</li> <li>Dependent Care Flexible Spending Account</li> <li>Paid vacation with graduated schedule &amp; option to purchase more</li> <li>Paid holidays</li> <li>Product discounts</li> <li>Employee Assistance Program</li> </ul><p><strong>LIFESTYLE </strong></p><ul> <li>Hybrid working model </li> <li>Celebrations &amp; gatherings </li> <li>Employee Resource Groups </li> <li>Recognition program</li> <li>Service awards</li> </ul><p><strong>We are an Equal Opportunity Employer: </strong>Armstrong Flooring provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.</p><p><em><strong>We strongly encourage people from underrepresented groups to apply.</strong></em></p> Armstrong Flooring, Inc. Pittsburgh PA

Enterprise Data Governance Platform Administrator - Pittsburgh Or Hermitage, PA

First National Bank (Fnb Corp.)