Data/Business Analyst II
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.
Related Jobs
Data/Business Analyst II
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.
Senior data analyst
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.
Senior data analyst
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.
Data governance lead
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
Data Quality Analyst
Position : Data Quality Analyst
Location : Carnegie Mellon University
Job Summary :
Carnegie Mellon University is embarking on a data project for aligning and aggregating graduate application and admission data.
The overall project goal is to provide solution(s) for routine and standard access to CMU’s graduate application and admission data allowing the university and academic colleges to perform analysis and assessments in areas like enrollment trends and enrollment management as well as overall program success and routine and future planning.
We are looking for a new team member who will develop a deep understanding of the graduate application data from the various graduate programs and application systems and primarily support this new data solution that combines all of this data for the University.
The Data Quality Analyst will work on cleaning data, person matching, and other data quality related tasks. The position may also prepare the data for use in Tableau dashboards and reports and may even stretch into developing them.
The position will primarily work on the graduate application data, but may also work on other similar data quality needs over time.
Responsibilities :
- Identify, compare, and resolve data quality problems.
- Evaluate large datasets for quality and accuracy.
- Perform complex analyses on data quality issues and share results and recommendations.
- Assess business impact for issues and work to resolve them
- Develop and implement data cleanup measures.
- Maintain a record of original data and corrected data.
- Ensure consistency with data quality standards.
- Resolve all internal data exceptions in a timely and accurate manner.
- Identify areas of improvement to achieve data quality.
- Collaborate with other team members to understand data requirements and implement solutions.
- Create and maintain documentation.
- Support the development and maintenance of Enterprise data quality initiatives.
- Continuously improve the data quality processes and procedures.
You should demonstrate :
- Ability to perform data quality activities (data quality rule creation, profiling and deployment, edit checks, identification of issues, root cause analysis, value case analysis, remediation planning)
- Experience in cleaning and validating large datasets.
- Strong problem-solving skills and attention to detail.
- Good communication skills and the ability to work in a collaborative environment.
- Proficiency in SQL and Excel.
- Knowledge of at least one additional coding language that can be used for analysis (i.e. SAS, Python, R).
- Knowledge of visualization tools such as Tableau.
Qualifications :
- Bachelor's degree in Computer Science, Information Technology, Mathematics, Statistics or related field.
- At least 3 years of data quality analysis experience
- Experience in higher education is a plus.
Are you passionate about data quality analysis and want to join a dynamic team that is dedicated to delivering high-quality data-driven solutions?
In that case, we encourage you to apply for this position!
CMU’s COVID-19 Vaccination Requirements : As a condition of employment, Carnegie Mellon University requires all staff and faculty working in the United States to be fully vaccinated, including a booster when eligible, against COVID-19.
Prior to commencement of employment, new hires in the United States must provide proof of vaccination or obtain an approved exemption.
Exemptions may be requested for medical reasons or for religious or strong moral or ethical conviction.) Staff and faculty must comply with all applicable COVID-19 mitigation requirements.
Please see Minimum Requirements to Return to Campus for details regarding the university’s current COVID-19 mitigation requirements.
Location
Pittsburgh, PA
Job Function
Data Analysis
Position Type
Staff Regular
Full Time / Part time
Full time
Pay Basis
Salary
More Information :
Please visit Why Carnegie Mellon to learn more about becoming part of an institution inspiring innovations that change the world.
Click here to view a listing of employee benefits
Carnegie Mellon University is an Equal Opportunity Employer / Disability / Veteran .
Statement of Assurance