What are the responsibilities and job description for the Senior Pentaho ETL and Snowflake consultant position at SmartIT Frame?
Job Details
Role: Senior Pentaho ETL and Snowflake consultant
Location: New Jersey, NJ
Job Description:
Required Skills:
- Snowflake
- Dataiku
- ETL Tool - Pentaho
- MongoDB
- Data Lake Concepts
Responsibilities:
- Lead the design and implementation of ETL processes using Pentaho to ensure efficient data integration and transformation.
- Oversee the development and maintenance of data lakes to support large-scale data storage and analysis.
- Provide expertise in Snowflake to optimize data warehousing solutions and improve data accessibility.
- Utilize Dataiku to develop and deploy data science workflows and machine learning models.
- Manage MongoDB databases to ensure data integrity, performance, and scalability.
- Collaborate with cross-functional teams to understand data requirements and deliver solutions that meet business needs.
- Conduct data analysis to identify trends, patterns, and insights that drive business decisions.
- Ensure data quality and consistency across all data sources and systems.
- Develop and maintain documentation for data processes, workflows, and system configurations.
- Provide technical support and troubleshooting for data-related issues.
- Stay updated with the latest industry trends and technologies to continuously improve data solutions.
- Mentor and guide junior team members to enhance their technical skills and knowledge.
- Communicate effectively with stakeholders to present findings and recommendations.
Qualifications:
- Possess strong expertise in ETL Tool - Pentaho for designing and implementing data integration processes.
- In-depth knowledge of Data Lake Concepts to manage large-scale data storage solutions.
- Proficiency in Snowflake for optimizing data warehousing and improving data accessibility.
- Utilize Dataiku to develop and deploy data science workflows and machine learning models.
- Manage MongoDB databases to ensure data integrity, performance, and scalability.
- Strong analytical skills to identify trends and insights from data.
- Excellent communication skills to effectively present findings and recommendations.
- Proactive approach to staying updated with the latest industry trends and technologies.
- Mentor and guide junior team members to enhance their technical skills and knowledge.
- Collaborate with cross-functional teams to understand and meet data requirements.
- Ensure data quality and consistency across all data sources and systems.
- Develop and maintain comprehensive documentation for data processes and workflows.
- Provide technical support and troubleshooting for data-related issues.
Certifications Required:
- Certified Pentaho Data Integration Developer
- Snowflake SnowPro Core Certification
- MongoDB Certified Developer Associate
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
