Position : Business / Data Analyst

Location : Pittsburgh, PA / Hybrid

Duration : 12 Months Contract

Required Skills :

technical lineage diagrams / mapping documents, Data mapping, SQL, UAT

Job Description :

Collect requirements to map the data flows within the organization. Create technical source to target mappings between systems, which includes mapping the names of databases / schemas / tables / physical data elements of each system as well as the transformation logic between them.

Perform gap analysis on technical lineage diagrams / mapping documents.

Perform QA testing and UAT on developed lineages to obtain necessary approvals. Ensure lineage diagrams developed match the technical mapping documents collected during requirements gathering.

Ability to read and understand SQL ideal (coding not required).

Liase between lineage developers, application managers, and lines of business

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide.

As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants.

Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions.

Visit www.dexian.com to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.

Position Overview

At PNC, our people are our greatest differentiator and competitive advantage in the markets we serve. We are all united in delivering the best experience for our customers.

We work together each day to foster an inclusive workplace culture where all of our employees feel respected, valued and have an opportunity to contribute to the company’s success.

As a(n) Data Analyst Senior within PNC's Technology organization, you will be based in Cleveland, OH or Pittsburgh, PA.

Job Description

• Manages and develops information systems for clients; conducts data information analysis for a variety of studies under the direction of organizational standards.
• Advises end-users on data manipulation, end-user support systems and statistical analysis.
• Selects new information sources and acquires stock. Catalogs and indexes new materials.
• Implements and supports technologies for managing and effectively utilizing multiple information sources, formats and uses.
• Researches customers needs, conducts awareness and promotional sessions for potential customers.

PNC Employees take pride in our reputation and to continue building upon that we expect our employees to be :

• Customer Focused - Knowledgeable of the values and practices that align customer needs and satisfaction as primary considerations in all business decisions and able to leverage that information in creating customized customer solutions.
• Managing Risk - Assessing and effectively managing all of the risks associated with their business objectives and activities to ensure they adhere to and support PNC's Enterprise Risk Management Framework.

Competencies

Application Design, Architecture Knowledge of application design activities, tools and techniques; ability to utilize these to convert business requirements and logical models into a technical application design.

Business Intelligence Knowledge of and ability to utilize business processes and technologies for gathering, storing, analyzing, and providing access to data that helps the organization make better business decisions.

Data Architecture Knowledge and ability to create models and standards to govern which data is collected, and how it is stored, arranged, integrated, and put to use in data systems and in organizations.

Data Mining Knowledge of tools, techniques and practices in data mining technologies used to acquire essential business information.

Emerging Technologies Knowledge of and ability to design, apply and evaluate new information technologies for business environments in order to improve work productivity and accuracy.

Informatics / Information Sciences Knowledge of and the ability to gather, communicate and store useful information within and across organizations in order to enhance employee knowledge and improve organizational performance.

Information Management Knowledge of an organization's existing and planned Information Architecture and Information Management (IM) methodology;

ability to collect and manage information from different sources, and distribute this information to enhance operational efficiency.

IT Environment Knowledge of an organization's IT purposes, activities and standards; ability to create an effective IT environment for business operations.

Modeling : Data, Process, Events, Objects Knowledge of and the ability to use tools and techniques for analyzing and documenting logical relationships among data, processes or events.

Requirements Analysis Knowledge of methods and techniques to elicit, analyze and record required business functionality and non-functionality requirements;

ability to analyze these requirements to ensure the success of a system or software development project.

Work Experience

Roles at this level typically require a university / college degree, with 3+ years of relevant / direct industry experience.

Certifications are often desired. In lieu of a degree, a comparable combination of education and experience (including military service) may be considered.

Education

Bachelors

Additional Job Description

Benefits

• PNC offers employees a comprehensive range of benefits to help meet your needs now and in the future. Depending on your eligibility, options for full-time employees include 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; maternity and parental leave;
• paid holidays, vacation days and occasional absence time; 401(k), pension and stock purchase plans; dependent care reimbursement account;

back-up child / elder care; adoption assistance; educational assistance and a robust wellness program with financial incentives.

To learn more about these and other programs, including benefits for part-time employees, visit >

New to PNC.

The Human Resources Service Center hours of operation are Monday - Friday 9 : 00 AM to 5 : 00 PM ET.

Equal Employment Opportunity (EEO) :

PNC provides equal employment opportunity to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.

California Residents

Refer to the to gain understanding of how PNC may use or disclose your personal information in our hiring practices.

Position : Business / Data Analyst

Location : Pittsburgh, PA / Hybrid

Duration : 12 Months Contract

Required Skills :

technical lineage diagrams / mapping documents, Data mapping, SQL, UAT

Job Description :

Collect requirements to map the data flows within the organization. Create technical source to target mappings between systems, which includes mapping the names of databases / schemas / tables / physical data elements of each system as well as the transformation logic between them.

Perform gap analysis on technical lineage diagrams / mapping documents.

Perform QA testing and UAT on developed lineages to obtain necessary approvals. Ensure lineage diagrams developed match the technical mapping documents collected during requirements gathering.

Ability to read and understand SQL ideal (coding not required).

Liase between lineage developers, application managers, and lines of business

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide.

As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants.

Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions.

Visit www.dexian.com to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.

Techstra is seeking an experienced Senior Data Analyst to work closely with the business, analytic and IT teams to support the ingestion of data into the Hadoop environment.

From the day you join, you will hit the ground running surrounded by amazing people. Here is a look of some of the expectations and responsibilities for this position : Responsibilities Work with stakeholders to gather requirements (STTM), test, process, and maintain data resources for the analytics organizations.

This will include working to maintain data sourcing, transformation and delivery, for key analytic platforms throughout the organization.

ETL / ELT) Analyzes data requirements, complex source data, and the data model, and determine the best methods in extracting, transforming and loading the data into the data staging, Ensuring that there is an integration path between source and target data which includes multiple data sources.

Keep current with Big Data technologies in order to recommend best tools in order to perform current and future work. Employ best-practices and standards with security and privacy in mind Key Qualifications Bachelor's Degree in Computer Science, Computer Engineering, Informatics or Management Information Systems Significant hands-on Hadoop development experience, preferably in the Hortonworks platform Experience with the following technologies : SQL, Python, Hadoop HDFS, Spark, etc.

Data warehousing and / or Data Lake experience in Healthcare or Financial Services industry Outstanding troubleshooting / problem solving abilities.

Inquisitive and resourceful not afraid to network within the organizations to ask relevant questions Excellent verbal and written communication skills ability to explain complex concepts to a wide variety of individuals with varying technical skills.

Team builder and facilitator of cross team discussions with proven ability to identify and remove roadblocks and resolve issues Ability to handle sensitive and confidential information appropriately Location : This position is located in Pittsburgh, PA.

At Techstra Solutions, we help top companies and brands achieve the business value of Digital and Talent Transformation.

We believe there are three components in successful business transformation : Business Strategy, Technology and Talent. It is the coming together of these three disciplines that enable companies to take full advantage of opportunities.

It differentiates us. Our approach is holistic and all encompassing. We consider the full picture as we guide our clients on this journey.

We are experts in transformation, business strategy, technology, innovation, and human capital management. We deliver our expertise through client consulting, innovative staffing solutions and software development.

From strategy through implementation, we are dedicated to bringing our clients world-class business and talent solutions that fit strategic requirements and most importantly, deliver results.

Equal Employment Opportunity Statement Techstra Solutions maintains a strong policy of equal opportunity in employment. It is our objective to recruit, hire, and retain the most qualified individuals without regard to race, color, creed, religion, gender, national origin, age, pregnancy, marital status, sexual orientation, gender identity or expression, disability, veteran status, or any other characteristic or status protected by applicable federal, state, or local law.

Primary Office Location :

30 Isabella Street. Pittsburgh, Pennsylvania. 15212.

Join our team. Make a difference - for us and for your future.

This position is primarily responsible for the implementation of

data governance program. The incumbent works with the Director to develop data governance policies, standards and guiding principles.

The incumbent will lead the data governance council and interact with senior management, and business and IT leaders to deploy data governance.

Primary Responsibilities :

• Works with Risk, Audit and Compliance stakeholders to implement or modify necessary policies, procedures and guiding principles to fill current and future Data Governance Gaps.
• Works with lines of business, documents critical data elements, understanding data lineage, data transformation, reporting and ultimately how it feeds into business decisions and actions.
• Develops Corporate KRI reports for data governance and provide them regularly to the required stakeholders and contribute to status meetings.
• Collaborates with ITBS teams on required Data Governance IT projects to ensure data change assessments are completed in a timely manner.

Assists in identifying data issues and provides insight on issues as how they might impact the data and business analysis.

• Connects with data stakeholders across the organization, champions data ownership, develops training for data owners and data stewards on data governance.
• Leads corporate data governance initiatives, owns / manages the business glossaries and deployment of data governance tool.

Position Title : Lead Business Systems Analyst

Business Unit : Technology

Reports to : Manager of Business Systems Analysis

Position Overview :

This position is primarily responsible for developing work plans or reviewing work plan timelines and managing workflows to meet timeframes.

Participates in the project management estimation process. The incumbent is knowledgeable of business functionality with assigned application systems, has a very solid general business domain and banking knowledge and has a Subject Matter Expert (SME) understanding level of systems life cycle, systems integration, data flows and reporting tools.

Primary Responsibilities :

Performs business operational assessments and provides support to lines of business for software applications. Generates the complete elicitation of complex Technology business requirements.

Consults, develops and drives priorities for Technology and business product roadmap. Identifies gaps between application systems and the business product roadmap.

Uses expert level skills for requirements elicitation and documentation, an advanced understanding of Technology and business application functionality and advanced business writing and communication skills.

Troubleshoots escalated issues and works toward resolution and directs resolution activities of junior staff.

Develops test plans, test cases and scripts in areas of responsibility. Approves quality assurance assessments and remediation steps.

Develops, reviews and approves test plans and scripts. Approves documentation and changes to application systems as designated by management.

Collaborates on the development of application road maps and Technology system plans. Is a resource for business unit strategic planning with nearly unlimited latitude allowed to meet objectives.

Determines and drives decisions to optimize Technology goals and objectives and maximizes effectiveness of Technology strategies.

Acts as a vendor liaison for business units for assigned applications. Defines requirements at a corporate-wide level and reviews production changes that can impact the corporation.

Collaborates with management business partners in related lines of business. Interacts with Technology resources and internal customers including Operations, Project Management Office and lines of business management.

Develops and maintains relationships with vendors.

Leads team, helps coordinate work and processes, assigns work and provides input for performance management.

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 Level of Education Required to Perform the Primary Responsibilities of this Position :

BA or BS

Minimum # of Years of Job Related Experience Required to Perform the Primary Responsibilities of this Position :

Skills Required to Perform the Primary Responsibilities of this Position :

Excellent customer service skills

Ability to use general office equipment

Ability to work and multi-task in a fast paced environment

Excellent organizational, analytical and interpersonal skills

Detail-oriented

Expert business knowledge and expert knowledge of SDLC, integration, data flows, requirements elicitation and reporting tools, RDBMS and SQL, banking systems and integration practices, MS Office applications and Visio.

Licensures / Certifications Required to Perform the Primary Responsibilities of this Position :

Systems and Business Analysis (BA) classes. Completion of a BA Certificate track or (CCBA).

Physical Requirements or Work Conditions Beyond Traditional Office Work :

N / A