What are the responsibilities and job description for the Senior PeopleSoft Systems Analyst and Data Lead position at Allied Consultants, Inc.?
Overview
Allied Consultants, Inc is a proudly Austin based firm with over 33 years of experience delivering top-tier technical and business professionals within Texas State Agencies. We are currently seeking an experience Senior PeopleSoft Systems Analyst and Data Lead to play a key role within a high-impact technical services team.
At Allied Consultants, we value our consultants and are committed to providing an exceptional experience including:
- Highly competitive pay rates
- Local support staff for responsive, personal service
- Comprehensive benefits package, including:
- Medical insurance (with employer cost sharing)
- Life insurance
- A 401(K) plan with company match
- Flexible spending through a cafeteria plan
Candidates selected for interviews will be subject to a criminal background check and may be required to pass a drug screening, in compliance with federal and state regulations. All offers of employment are contingent upon successful completion of these checks.
Allied Consultants is a proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.
Responsibilities
The worker must have impeccable communication skills, both written and oral, and solid experience with the integration of the core modules within the PeopleSoft HCM 8.8 application (Human Resources, Payroll, Base Benefits, Benefits Administration, Pension Administration), including experience researching processing requirements between other systems – both upstream and downstream. This worker must be equally confident conversing with top level management and developers. In addition, the worker must be confident having detailed conversations with the users at the functional level and with developers at the technical level. The ideal candidate should have hands-on experience working as a technical resource on data conversion and data cleansing projects, as well as have a deep functional understanding of the Benefits Administration, Payroll, and/or Pension Administration modules. Additionally, the Worker should have development experience, including SQL, Application Engine, PeopleCode, and SQR - and also the ability to analyze data, identify data quality/consistency issues (and determine the root cause of any data issues), define data conversion mapping requirements, and troubleshoot any conversion issues.
Responsibilities include:
- Working closely with client staff to gain a comprehensive understanding of their database and outline expectations / necessary outcomes, recommend conversion strategy, and compile migration requirements
- Driving conversion data mapping activities, including defining the conversion approach/populations, determining the correct source data attributes, and analyzing source data to uncover potential data issues that may impact the conversion
- Reviewing and validating all mapping logic and SQLs written by ETL Mappers to ensure accuracy and completeness - and support ETL Developers and QC Testers as needed
- Developing SQLs/Alteryx Workflows to identify quality/consistency issues within the PeopleSoft source data - and recommending methods to cleanse the data, repair the root cause of the data issue, and/or adjust the conversion rules for migrating the data.
- Collaborating closely with cross-functional teams, applying advanced skills to diagnose and resolve functional issues
- Conducting root-cause analysis for data quality/integrity issues identified in the conversion process - and provide recommendations for remediating data quality issues
- Interpreting PeopleCode, SQR, and Application Engine logic to unravel complex system processes and discover insights
- Employing robust SQL skills to analyze data, identify data quality issues, and make recommendations for remediation
- Reviewing validation reports and determine if client needs to clean the data, repair the root cause of the data issue, and/or adjust the conversion rules
- Assisting with defining new Data Quality checks so that client can monitor and fix data issues that may impact the conversion
Qualifications
Minimum (Required):
Years
Skills/Experience
7
Very strong SQL skills - and the ability to write/execute advanced SQL in both Oracle and SQL Server
7
Extensive hands-on Data Conversion project experience (preferably conversions to or from PeopleSoft)
7
Deep understanding of PeopleSoft HCM data model, specifically the Human Resources, Base Benefits, Benefits Administration, Pension Administration, and/or Payroll modules
7
Experience using Agile Methodologies
5
Impeccable oral and written communication skills
5
Strong attention to detail
Preferred (Optional):
Years
Skills/Experience
7
Experience using Microsoft Azure DevOps
7
Solid knowledge of Master Data Management (MDM), specifically in the Person domain
7
Experience working on software implementations