Job Description
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
Job Classification
Industry: IT Services & Consulting
Functional Area / Department: Data Science & Analytics
Role Category: Data Science & Machine Learning
Role: Data Engineer
Employement Type: Full time
Contact Details:
Company: Orcapod Consulting
Location(s): Chennai
Keyskills:
snowflake
python
Tableau
Hr Data
Sql
Power Bi
Hr Databases