People Analytics - Data Engineer

People Analytics - Data EngineerJob Summary: Talent Software Services is in search of a People Analytics - Data Engineer for a contract position in San Mateo, CA. The opportunity will be twelve months with a strong chance for a long-term extension.Position Summary: People Analytics collaborates across Human Resources and the business to uncover data-driven insights to solve business challenges across the talent/employee lifecycle and enable transformational change. Our team is on a journey to provide a holistic and client-centric approach that complements to identify of valuable workforce insights which, in turn, fuels the business. The People Analytics team collaboratively uses behavioral, analytics and data science approaches to address key business questions and employs best practices in data visualization to provide actionable insights in support of Human Resources priorities.Primary Responsibilities/Accountabilities:As a Data Engineer in the People Analytics team, you will:

• Collaborate with the People Analytics team-members to improve data models that feed business intelligence tools
• Manage and expand the existing data infrastructure; serve as the data warehouse (MS SQL Server) administrator, and run the weekly / monthly data update
• Build and
• run various data integrity checks, and work with various stakeholders to fix any identified data inconsistencies
• Design data integrations and data quality framework
• Extract data from additional Human Resources Systems and support continuing increases in data volume and complexity; identify key data fields and consolidate new data sets with the existing data
• Develop and maintain scalable data pipelines and build out new integrations
• Implement processes and systems to monitor data quality, ensuring production data is always accurate
• Write unit/integration tests, contribute to engineering wiki, and document work
• Work on ad hoc data reporting requests and perform other role-related duties as assigned

• Knowledge of best practices and IT operations in an always-up, always-available service
• Excellent problem solving and troubleshooting skills
• Process oriented with great documentation skills
• Excellent oral and written communication skills with a keen sense of customer service
• Self-starter with ability to take things to the next level
• Ability to balance multiple priorities simultaneously and meet deadlines as required
• BS or MS degree in Computer Science or a related technical field
• 4+ years of Python or Java development experience from an ETL perspective
• 4+ years with ETL tools; working knowledge of Talend Studio is a plus
• 4+ years of SQL experience
• 4+ years of experience with schema design and dimensional data modeling
• Experience designing, building, and maintaining data processing systems
• Experience in troubleshooting data integrity issues and creating frameworks to avoid/catch them
• Proficiency with Microsoft Excel is a plus