Data Engineer

Role & responsibilities

Must have Skills Tableau/PowerBI, Snowflake, SQL, Python, HR Data

Data Management

• Develop data mapping specifications and transformation rules
• Perform data cleansing, validation, and reconciliation activities
• Create and execute data conversion scripts and processes
• Document data models, mappings, and migration procedures

System Integration:

• Configure integrations for third-party applications
• Develop integration specifications and technical designs
• Troubleshoot integration issues and implement solutions
• Monitor integration performance and implement optimizations

Technical Configuration & Development

• Design and implement Snowflake data models optimized for the application
• Create and maintain Snowflake objects (tables, views, stored procedures)
• Develop SQL transformations within Snowflake for reporting requirements
• Build and maintain business processes, security configurations, and reports
• Develop custom calculations, rules, and business logic
• Create and maintain configuration workbooks and technical documentation
• Participate in system testing, including unit, integration, and regression testing

Reporting & Analytics

• Develop reporting solutions using Snowflake as the data source
• Create data visualization dashboards connected to Snowflake
• Build self-service reporting capabilities for HR and business users
• Design and implement metrics and KPIs for HR analytics
• Support data analysis needs throughout the implementation lifecycle

Required Experience & Skills

• 5+ years of experience in implementation, data management, or system integration

• Experience with Snowflake or similar cloud data warehouse platforms • Experience with architecting or working with ELT technologies (such as DBT) and data architectures

• Strong SQL skills and experience with data transformation tools

• Experience with ETL processes and data validation techniques

• Understanding of HR data structures and relationships

• Excellent analytical and problem-solving abilities

• Knowledge of programming languages (Python etc.)

• Experience with data visualization tools (Tableau)

• Understanding of API integration patterns and technologies

• Experience with agile development methodologies