Data Analyst I - Pinnacle Group
Indianapolis, IN
About the Job
Key Responsibilities:
- Data Validation: Conduct thorough 1:1 validations of conversion data, identifying discrepancies and ensuring data accuracy across various datasets.
- Data Quality Assurance: Perform data quality validations, confirming that all impacted employees are accounted for in the employee planning system and addressing any discrepancies identified.
- Mass Data Loads: Manage mass loads into multiple HR systems using EIBs (Enterprise Interface Builders) and data loader tools to ensure accurate data transfer and integrity.
- SOX Compliance: Ensure that all validation processes and data handling practices comply with Sarbanes-Oxley (SOX) regulations, maintaining documentation and audit trails as required.
- Collaboration with Business Analysts: Work closely with Business Analysts to resolve conversion fallout and discrepancies, facilitating timely solutions and ensuring data integrity.
- Data Analysis: Utilize Tableau prep and excel for data manipulation, analysis, and validation processes. Write scripts to automate routine validation tasks and improve efficiency.
- Collaboration: Work with cross-functional teams, including data engineers, business analysts and product managers, to understand data flows and ensure comprehensive validation processes.
- Documentation: Document validation processes, findings, and methodologies to ensure transparency and facilitate knowledge sharing within the team.
- Continuous Improvement: Proactively identify opportunities to enhance validation processes and contribute to the development of best practices in data quality assurance.
- Experience with data visualization tools, particularly Tableau Prep, and advanced Excel skills (including formulas, pivot tables, and data analysis functions).
- Strong analytical skills with a keen eye for detail and a passion for data accuracy.
- Excellent problem-solving abilities and the capability to work independently and collaboratively in a team environment.
- Strong communication skills, with the ability to convey complex data findings to non-technical stakeholders.
- Experience in data quality assurance or data analytics.
- Familiarity with SQL and database management.
- Knowledge of statistical analysis techniques.
- Experience with Workday is a strong plus.
Pay Range: $50 - $60
The specific compensation for this position will be determined by a number of factors, including the scope, complexity and location of the role as well as the cost of labor in the market; the skills, education, training, credentials and experience of the candidate; and other conditions of employment. Our full-time consultants have access to benefits including medical, dental, vision and 401K contributions as well as any other PTO, sick leave, and other benefits mandated by appliable state or localities where you reside or work.
#LI-KW
Source : Pinnacle Group