Senior Snowflake Data Engineer

Position Title: Senior Snowflake Data Engineer

Location: Remote

Duration: 6+ Month Contract

Job Description:

Possessing 5-8 years of progressive experience in data engineering, demonstrating a strong track record of designing, developing, and deploying robust data solutions within complex enterprise environments.

Required Skills:

Demonstrated expert-level proficiency in Snowflake, including advanced capabilities in data warehousing, performance optimization, and complex query development for large-scale datasets.

Proven expert-level experience with Power BI, encompassing the design and development of sophisticated dashboards, reports, and data visualizations to support critical business intelligence needs.

Extensive expert-level experience in data modeling, specifically with Star Schema and Snowflake methodologies, to create efficient and scalable data architectures.

Advanced proficiency in Electronic Data Interchange (EDI) systems, with practical experience in integrating, processing, and managing data exchanges with external partners.

Preferred Skills:

Familiarity with Databricks platform capabilities, including experience in developing and deploying data processing workflows and machine learning solutions.

A strong understanding of the Retail and eCommerce domain, with experience applying data engineering principles to solve industry-specific challenges.

Job Responsibilities:

Design, develop, deploy, and maintain robust data solutions leveraging Snowflake and PowerBI.

Architect and implement scalable data ingestion pipelines from diverse sources, ensuring efficient transmission of large-scale structured and unstructured data between systems.

Develop and optimize data aggregation pipelines to feed critical analytics and reporting solutions, ensuring data integrity and performance.

Ensure all developed code is scalable, adheres to established company standards, and is thoroughly documented for maintainability and future enhancements.

Drive technical ownership for specific data platform components, ensuring their reliability, performance, and alignment with overall architectural goals.

Support pipeline failures and request for data validation / queries from business stakeholders

Contribute to the architectural design and evolution of the data analytics platform, proposing innovative solutions and best practices.

Lead the translation of complex business requirements into detailed technical specifications and actionable user stories, including acceptance criteria and tasks.

Conduct thorough peer code reviews to uphold high standards of code quality, performance, and adherence to architectural guidelines.

Communicate complex technical solutions, challenges, and recommendations clearly and effectively to management and cross-functional teams.

Supervise and proactively resolve complex data issues, applying creative problem-solving skills to ensure data accuracy and system stability.

Mentor junior data engineers, sharing expertise and fostering their technical growth within the team.

Maintain in-depth knowledge of the evolving data ecosystem, industry trends, and emerging technologies to act as a domain expert.

Evaluate and recommend new tools and technologies to enhance the current data stack and efficiently address evolving data needs.