Provides support to the business and other internal IT organizations regarding data definition standards, architectures, and policies.
Provides support to business users for mining and interpretation of warehoused and operational data.
Plans and performs activities regarding designed data models for systems development.
Resolves metadata and data sourcing problems.
Maintains metadata and data dictionaries.
Manages data definitions and data traceability within data repository to improve documentation and coordination.
Requirements
Strong experience with Big Data technologies including Hadoop ecosystem (Hive, Impala, Spark) and advanced SQL querying for data analysis and reporting.
Ability to understand business processes and requirements and translate them into clear technical specifications, STM documents, and data solutions.
Excellent communication and collaboration skills to work effectively with Product Owners, Business Analysts, developers, and stakeholders throughout the project lifecycle.
Experience creating and maintaining technical documentation, including data mappings, source-to-target mappings (STM), data dictionaries, and process documentation.
Working knowledge of Agile methodologies, including participation in sprint planning, daily standups, backlog refinement, and delivery within Scrum-based teams.
Tech Stack
Hadoop
Spark
SQL
Benefits
medical/prescription drug coverage (with a Health Savings Account feature)
dental and vision options
employee and spouse/child life insurance
short and long-term disability protection
401(k) with PNC match
pension and stock purchase plans
dependent care reimbursement account
back-up child/elder care
adoption, surrogacy, and doula reimbursement
educational assistance, including select programs fully paid
a robust wellness program with financial incentives
maternity and/or parental leave
up to 11 paid holidays each year
9 occasional absence days each year, unless otherwise required by law
between 15 to 25 vacation days each year, depending on career level; and years of service