Sr Data Analyst II - Performance Food Group
Richmond, VA
About the Job
110480BR
Job Title:
Sr Data Analyst II
Location:
West Creek-Richmond Corp (0999)
Job Description:
We Deliver the Goods:
+ Competitive pay and benefits, including Day 1 Health & Wellness Benefits, Employee Stock Purchase Plan, 401K Employer Matching, Education Assistance, Paid Time Off, and much more
+ Growth opportunities performing essential work to support America’s food distribution system
+ Safe and inclusive working environment, including culture of rewards, recognition, and respect
Position Summary:
The Sr Data Analyst II position conducts analysis of business and user needs and then documents requirements with diverse levels of complexity. Working with business process teams and application system personnel, the Sr Data Analyst II identifies data sources, confirms conversion requirements, and resolves data mapping and data integrity issues.
The Sr Data Analyst II supports the data delivery needs of a wide set of initiatives:
Data Warehousing / Business Intelligence (DW/BI) projects These efforts involve gathering data from disparate systems for the purpose of reporting and analysis. Ensure project/solution success by:
• Identifying data quality issues that must be corrected in the source system
• Identifying issues that can be corrected in ETL processing
• Discovering unanticipated business rules
Data conversion/migration for application modernization
• These efforts involve moving data from a legacy system to a new system. Reduce project risk by:
• Identifying data quality issues that must be handled in the code that moves data from the legacy system to the new system
• Identifying data issues that may require a change to the target (new) system
Source system data quality & data consistency between applications
These efforts assess and improve the data quality of a given source system, seeking to fix existing issues as well as avoid those issues in the future. Maximize project ROI by:
• Highlighting the areas within the system suffering from the most serious and/or numerous data quality issues
• Identifying issues that may be the result of bad user input or errant system interfaces
Position Responsibilities:
Analytical Data Evaluation & Quality Management:
• Demonstrates process and technology fluency with analytic applications
• Demonstrates ability to collect knowledge about information assets: where they are, what format they are in, what level of quality they represent, and their value to the enterprise through search & discovery, data modeling, and advanced data profiling
• Conduct data verifications during builds and data validations as required by the business
• Monitors and shares data quality metrics with scorecards and reports to track data quality
Business Engagement:
• Business Requirements Gathering: Demonstrates ability to engage within a collaborative process, bringing stakeholders together to establish which business outcomes are desired.
• Demonstrates skills to train users to use information correctly; oversees training activities for business resources new to analysis tools
• Supports end-user ‘self-service’ strategy and the development of business super user teams
• Demonstrates a high proficiency in business facing technology tools as required: Snowflake, Microsoft SQL Server, Microsoft Power BI, Microsoft Fabric, Informatica IICS
• Enables stakeholders to collaborate, build, and manage a common business vocabulary across the organization
• Collaborates with data stewards and developers during initial data profiling activities and for resolution of data quality problems
Functional Specification development (source to target mapping) for technical design and delivery:
• Documents source to target system conversion requirements
• Develops test scenarios and verification procedures for transformation rule quality assessment
• Assesses whether data is fit for use by performing initial validation of data delivered
• Liaison role between business and development teams for coordination of activities to approve final conversion results
• Acts a as a champion-challenger when testing proposed transformation rules or mappings from other Information/Systems
Analysts
Communication Skills:
• Shows executives how business intelligence (processes, practices, and technologies) plays a critical role in improving business
management, optimization, and competitiveness
• Encourages collaboration between IT and business information consumers/analysts
• Communicates across lines of business (LOBs) to ensure that new applications integrate and comply with business intelligence
governance and architecture.
• Ensures that business users support the IT department's mission of providing platforms that can handle changing business
requirements.
• Fosters user interest and adoption
• Identifies opportunities that drive business value and follow-through to execution
• Influences coordination of resolution of design issues
• Documents and communicates business impact and business value related to data issues
Leadership:
• Serve as mentor to new data analysts and take responsibility for their onboarding
• Train other system analysts on the data environment, data mapping techniques and best practices
• Share expertise and provide guidance to all team members on data related issues and concerns
Req Number:
110480BR
Address Line 1:
12500 West Creek Pkwy
Job Location:
Richmond, Virginia (VA)
Shift:
1st Shift
Full Time / Part Time:
Full Time
EEO Statement:
Performance Food Group and/or its subsidiaries (individually or collectively, the "Company") provides equal employment opportunity (EEO) to all applicants and employees, regardless of race, color, national origin, sex, marital status, pregnancy, sexual orientation, gender identity, religion, age, disability, genetic information, veteran status, and any other characteristic protected by applicable local, state and federal laws and regulations. Please click on the following links to review: (1) our EEO Policy (http://pfgc.com/Policy) ; (2) the "EEO is the Law" poster (http://pfgc.com/Poster) and supplement (http://pfgc.com/Supplement) ; and (3) the Pay Transparency Policy Statement (http://pfgc.com/PayTransparency) .
Required Qualifications:
- Bachelor's degree in IT, Computer Science, or other related field
- 5 to 7 years of experience
- 5+ years of experience in data-related disciplines
- Extensive knowledge of data management, data analysis, and business intelligence concepts
- Experience with a broad range of database and Business Intelligence environments including Snowflake, Microsoft Power Bi, Microsoft Fabric and Microsoft SQL Server
- Experience with manual querying of data sources using Structured Query Language (SQL)
- Strong technical skills with data warehousing technologies
- Experience with data profiling software
- Able to interact with data architects and ETL resources, understand and extract data from any type of data sources such as star, normalized, transactional databases, etc.
- Strong collaboration, listening, communication, and presentation skills
- Strong analytical skills and problem-solving skills
- Strong team player who collaborates well with others to solve problems and actively incorporates input from various sources
- Project management skills
Division:
Performance Food Group
Job Category:
Information Systems
Preferred Qualifications:
- Bachelor's degree in IT, Computer Science, or other related field
- 7 to 10 years of experience
- 7+ years of experience id data-related disciplines
- Extensive experience with medium to high complexity project delivery
- DBA experience on the Snowflake platform
- Working knowledge of Microsoft Power BI, Microsoft Fabric, Microsoft Azure, Informatica IICS
- Prior experience as a report programmer /ETL specialist in support of large-scale data and reporting projects
- Knowledge of the foodservice distribution industry and related business processes
State:
Virginia
Company Description:
Performance Food Group is a customer-centric foodservice distribution leader headquartered in Richmond, Va. Grounded by roots that date back to a grocery peddler in 1885, PFG has a nationwide network of approximately 150 distribution centers, 35,000-plus talented associates, and thousands of valued suppliers across the country. With the goal of helping customers thrive, PFG markets and delivers quality food and related products to independent and chain restaurants, schools, business and industry locations, convenience operations, healthcare facilities, vending distributors, office coffee service distributors, big box retailers, and theaters across the U.S.
Benefits:
Click Here for Benefits Information (https://pfgc.com/Careers.aspx#benefits)
Compensation:
$115k - $145k
Job Title:
Sr Data Analyst II
Location:
West Creek-Richmond Corp (0999)
Job Description:
We Deliver the Goods:
+ Competitive pay and benefits, including Day 1 Health & Wellness Benefits, Employee Stock Purchase Plan, 401K Employer Matching, Education Assistance, Paid Time Off, and much more
+ Growth opportunities performing essential work to support America’s food distribution system
+ Safe and inclusive working environment, including culture of rewards, recognition, and respect
Position Summary:
The Sr Data Analyst II position conducts analysis of business and user needs and then documents requirements with diverse levels of complexity. Working with business process teams and application system personnel, the Sr Data Analyst II identifies data sources, confirms conversion requirements, and resolves data mapping and data integrity issues.
The Sr Data Analyst II supports the data delivery needs of a wide set of initiatives:
Data Warehousing / Business Intelligence (DW/BI) projects These efforts involve gathering data from disparate systems for the purpose of reporting and analysis. Ensure project/solution success by:
• Identifying data quality issues that must be corrected in the source system
• Identifying issues that can be corrected in ETL processing
• Discovering unanticipated business rules
Data conversion/migration for application modernization
• These efforts involve moving data from a legacy system to a new system. Reduce project risk by:
• Identifying data quality issues that must be handled in the code that moves data from the legacy system to the new system
• Identifying data issues that may require a change to the target (new) system
Source system data quality & data consistency between applications
These efforts assess and improve the data quality of a given source system, seeking to fix existing issues as well as avoid those issues in the future. Maximize project ROI by:
• Highlighting the areas within the system suffering from the most serious and/or numerous data quality issues
• Identifying issues that may be the result of bad user input or errant system interfaces
Position Responsibilities:
Analytical Data Evaluation & Quality Management:
• Demonstrates process and technology fluency with analytic applications
• Demonstrates ability to collect knowledge about information assets: where they are, what format they are in, what level of quality they represent, and their value to the enterprise through search & discovery, data modeling, and advanced data profiling
• Conduct data verifications during builds and data validations as required by the business
• Monitors and shares data quality metrics with scorecards and reports to track data quality
Business Engagement:
• Business Requirements Gathering: Demonstrates ability to engage within a collaborative process, bringing stakeholders together to establish which business outcomes are desired.
• Demonstrates skills to train users to use information correctly; oversees training activities for business resources new to analysis tools
• Supports end-user ‘self-service’ strategy and the development of business super user teams
• Demonstrates a high proficiency in business facing technology tools as required: Snowflake, Microsoft SQL Server, Microsoft Power BI, Microsoft Fabric, Informatica IICS
• Enables stakeholders to collaborate, build, and manage a common business vocabulary across the organization
• Collaborates with data stewards and developers during initial data profiling activities and for resolution of data quality problems
Functional Specification development (source to target mapping) for technical design and delivery:
• Documents source to target system conversion requirements
• Develops test scenarios and verification procedures for transformation rule quality assessment
• Assesses whether data is fit for use by performing initial validation of data delivered
• Liaison role between business and development teams for coordination of activities to approve final conversion results
• Acts a as a champion-challenger when testing proposed transformation rules or mappings from other Information/Systems
Analysts
Communication Skills:
• Shows executives how business intelligence (processes, practices, and technologies) plays a critical role in improving business
management, optimization, and competitiveness
• Encourages collaboration between IT and business information consumers/analysts
• Communicates across lines of business (LOBs) to ensure that new applications integrate and comply with business intelligence
governance and architecture.
• Ensures that business users support the IT department's mission of providing platforms that can handle changing business
requirements.
• Fosters user interest and adoption
• Identifies opportunities that drive business value and follow-through to execution
• Influences coordination of resolution of design issues
• Documents and communicates business impact and business value related to data issues
Leadership:
• Serve as mentor to new data analysts and take responsibility for their onboarding
• Train other system analysts on the data environment, data mapping techniques and best practices
• Share expertise and provide guidance to all team members on data related issues and concerns
Req Number:
110480BR
Address Line 1:
12500 West Creek Pkwy
Job Location:
Richmond, Virginia (VA)
Shift:
1st Shift
Full Time / Part Time:
Full Time
EEO Statement:
Performance Food Group and/or its subsidiaries (individually or collectively, the "Company") provides equal employment opportunity (EEO) to all applicants and employees, regardless of race, color, national origin, sex, marital status, pregnancy, sexual orientation, gender identity, religion, age, disability, genetic information, veteran status, and any other characteristic protected by applicable local, state and federal laws and regulations. Please click on the following links to review: (1) our EEO Policy (http://pfgc.com/Policy) ; (2) the "EEO is the Law" poster (http://pfgc.com/Poster) and supplement (http://pfgc.com/Supplement) ; and (3) the Pay Transparency Policy Statement (http://pfgc.com/PayTransparency) .
Required Qualifications:
- Bachelor's degree in IT, Computer Science, or other related field
- 5 to 7 years of experience
- 5+ years of experience in data-related disciplines
- Extensive knowledge of data management, data analysis, and business intelligence concepts
- Experience with a broad range of database and Business Intelligence environments including Snowflake, Microsoft Power Bi, Microsoft Fabric and Microsoft SQL Server
- Experience with manual querying of data sources using Structured Query Language (SQL)
- Strong technical skills with data warehousing technologies
- Experience with data profiling software
- Able to interact with data architects and ETL resources, understand and extract data from any type of data sources such as star, normalized, transactional databases, etc.
- Strong collaboration, listening, communication, and presentation skills
- Strong analytical skills and problem-solving skills
- Strong team player who collaborates well with others to solve problems and actively incorporates input from various sources
- Project management skills
Division:
Performance Food Group
Job Category:
Information Systems
Preferred Qualifications:
- Bachelor's degree in IT, Computer Science, or other related field
- 7 to 10 years of experience
- 7+ years of experience id data-related disciplines
- Extensive experience with medium to high complexity project delivery
- DBA experience on the Snowflake platform
- Working knowledge of Microsoft Power BI, Microsoft Fabric, Microsoft Azure, Informatica IICS
- Prior experience as a report programmer /ETL specialist in support of large-scale data and reporting projects
- Knowledge of the foodservice distribution industry and related business processes
State:
Virginia
Company Description:
Performance Food Group is a customer-centric foodservice distribution leader headquartered in Richmond, Va. Grounded by roots that date back to a grocery peddler in 1885, PFG has a nationwide network of approximately 150 distribution centers, 35,000-plus talented associates, and thousands of valued suppliers across the country. With the goal of helping customers thrive, PFG markets and delivers quality food and related products to independent and chain restaurants, schools, business and industry locations, convenience operations, healthcare facilities, vending distributors, office coffee service distributors, big box retailers, and theaters across the U.S.
Benefits:
Click Here for Benefits Information (https://pfgc.com/Careers.aspx#benefits)
Compensation:
$115k - $145k
Source : Performance Food Group
