Benefits:

• 401(k) matching
• Dental insurance
• Health insurance
• Vision insurance

Payroll Analytics
Resumes to bobross@tristateplacements.com
Onsite
$125-175K plus benefits
Bethesda, Maryland

JOB SUMMARY
This role will also be instrumental in executing Global Hotel’s multi-year payroll analytics transformation plan, and as such will be required to assist with organizing, understanding, and ultimately architecting the payroll data. This role entails business to technical translation, structured creative thinking, cross-functional collaboration, and hands-on development of a custom payroll data solution, including: ETL design, data modeling, RPD development, analytics products, dashboards, and web applications.

Education and Experience

• 4-year degree from an accredited university AND 5 years of relevant professional experience, demonstrating progressive career growth and a pattern of exceptional performance OR Advanced degree in operations research, applied mathematics, statistics, economics, physics, business analytics, engineering, AND 2 years of relevant professional experience.
• Minimum of 5 years’ experience gathering & transforming raw data, data modeling, and ETL design required. A strong preference for experience with payroll data.
• Minimum of 5 years’ experience using SQL to create data models and database views, must be an expert.
• Minimum of 5 years’ experience with data analysis required, including: Querying, manipulation, transformation, and transfer of data, large data volumes (1B records), and consolidating multiple, disjointed data sets
• Experience with Oracle Analytics tools and Oracle Cloud Infrastructure a strong plus: Oracle Analytics Model Administration Tool, Oracle Semantic Data Modeler, Oracle APEX , Oracle Analytics Cloud Data Visualization
• Minimum of 3 years’ experience building custom analytics products/applications.
• Experience or knowledge in UI/UX design, front end web development, HTML and CSS a strong plus.
• Familiarity with a data manipulation programming language: “pandas” in Python, R, or SAS is a strong plus
• Familiarity with programming a data retrieval process using APIs
• Excellent project management and verbal and written communication skills required

Architect and Model Payroll Data

• In partnership with Global Technology (IT), design new ETL from HCM system to Oracle DW.
• Conceptualize, design and build data models and materialized views for use by all payroll reporting and analytics stakeholders
• Create and execute testing plan, to ensure data models are accurate.
• Adapt to use a variety of tools to accomplish key tasks - data tool "agnostic"
• Transform multiple, complex data sources using python
• Help define technical standards and calculations for talent analytics and reporting
• Conduct root cause analysis for data discrepancies between environments
• Develop enhancements consistent with the analytics best practices & guidelines.
• Partners with payroll stakeholders to support their data efforts through a variety of avenues: advanced analytics, detail reports, custom applications, strategic analysis, tracking performance vs. goals, and providing recommendations
• Explain complex analytics to a broad audience with varying levels of technical background and understanding.
• Communicate effectively with Payroll stakeholders & subject matter experts