Vacancy expired!
- The consultant must be proficient and have hands-on experience with Oracle DB release 9i or higher (5+ years' experience);
- Must be proficient and have hands-on experience with ERwin development environment (3+ years' experience);
- Must be proficient and have hands-on experience with Oracle P/L SQL (Oracle 8i, or preferable 9i) with 3+ years' experience;
- Must be experienced with TOAD (Tool for Oracle Application Development) (3+ years' experience)
- 6+ years' experience: Data modeling and prototyping, Database search strategies, Human Resources, Computer Science, Data Management, Analyzing and synthesizing qualitative data, PeopleSoft, Power BI, SQL, SQL Query Manager, Data Analysis, Data Cleansing Techniques, Data Entry, Data Integrity, Data Management, Data Modeling, Data Quality Analysis, Data retrieval, customization and archiving of data, Data Storage, Data Warehousing, Database management, Relational database design and management of relational databases, Structured Query Language (SQL), Ability to create accurate math models from scan data, Data Lineage Analysis and PeopleSoft SQR
- Design, build and support Oracle DBS using ERwin
- TOAD and SQL+ development tools
- Work closely with applications developers on new development of ColdFusion/Oracle systems
- Expert in building Stored Procedures, DB Packages, Triggers and Views
- Provide additional technical assistance with custom development and support activities as directed by the designated agency Project Manager. This includes knowledge transfer in the areas of Oracle DBA, Oracle SQL and PL-SQL programming and performance monitoring
- Assist agency staff with learning how to develop and implement Oracle SQL and Oracle SP
- Develop PeopleSoft query data pipelines to integrate into Power BI and Oracle Analytics Cloud applications.
- Work with the HR leadership team and other stakeholders to assess requirements for insights into workforce data
- Perform end-to-end data analysis starting from hypothesis formation, investigation, data discovery, to data wrangling, in-depth analysis, and build data visualizations and reporting solutions
- Strong domain knowledge of PeopleSoft HCM data (HR, TAM, Benefits, ELM, Portal and EPM)
- Support a multitude of HR and company initiatives around diversity and inclusion, organization composition, retention/attrition, flight risk score card, hiring/recruitment, talent and performance, compensation, and more
- Apply quantitative skills, data science techniques and research methodologies to enrich understanding and/or improve prediction of employee motivation and behaviors
- Actively partner with other People Analytics practice areas such as Reporting and Data Strategy and participate in the ongoing development of the business intelligence and data warehousing activities
- Work on ad hoc reports, research and analyses that could involve gathering data from variety of sources and domains and weave a compelling story and present insights to senior management
- Stage data for ETL process
- Assist the HR Data Science team on the generation and delivery of analyses and insights on workforce data.
Vacancy expired!