What are the responsibilities and job description for the Data Analyst Sr - Contractor position at pnc?
Position Location: Hybrid (2-3 days/week in office) - Pittsburgh, PA; Strongsville, OH; or Dallas, TX
Summary:
The main function is to coordinate changes to computer databases, test, and implement the database applying knowledge of database management systems.
Job Responsibilities:
• Work with senior management, technical and client teams in order to determine data requirements, business data implementation approaches, best practices for advanced data manipulation, storage and analysis strategies
• Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions
• Design, implement, automate and maintain large scale enterprise data ETL processes
• Modify existing databases and database management systems and/or direct programmers and analysts to make changes
• Test programs or databases, correct errors and make necessary modifications
Must Have Technical Skills:
Experience with programming on Hadoop, Teradata, and/or Oracle platforms in SQL, Spark, and Python.
Experience working with relational databases, big data, unstructured data files, and understanding data warehouse/ ETL concepts.
Experience with Oozie, Slurm, Iceberg, or similar automation tools.
Intermediate Excel skills.
Experience in data visualization tools like Tableau, Elastic Stack, and Power BI.
Ability to create process flows.
Experience with business analytics.
Experience developing and maintenance of documentation both technical and process/procedural.
Flex / Nice to Have Skills:
Good working understanding on Agile framework, Jira, Confluence, and Git repositories.
Knowledge of retail lending (know what loans, deposits, etc.)
Soft Skills:
Ability to conduct in depth technical discussions with both technology partners as well as be able to convey technical concepts and approaches to business stakeholders.
Education/Experience:
• Bachelor's degree in a technical field such as computer science, computer engineering or related field required or equivalent work experience.
• 6-8 years applicable experience required
