Job Title : Snowflake Engineer Job Location : Greensboro, NC(Onsite) Job Duration :Long-term Contract(12+ months) Pay rate: $90/hr on W2 & $100/hr on C2C Job Description: The successful candidate will design, build, and maintain a robust and scalable data infrastructure to support business intelligence, analytics, and data science initiatives. The responsibility includes managing the end-to-end data lifecycle, including data ingestion, transformation, storage, and accessibility for various stakeholders. Key Responsibilities: • Design, develop, and maintain efficient and scalable data pipelines to extract, transform, and load data from various sources. • Build and maintain data models within the Enterprise Data Warehouse, ensuring data is organized and accessible for analysis and reporting. • Gather business reporting requirements and translate them into technical specifications for data solutions. • Develop and implement ETL/ELT solutions to support data integration needs. • Integrate data from external partner applications and other internal systems. • Develop and support dashboards, analytics, and reports using Power BI. • Perform integration testing to ensure data quality and system functionality. • Design and implement data security measures and access controls. • Collaborate with cross-functional teams to ensure data solutions meet business needs. • Ensure data integrity and accuracy across the EDW solution and source systems. • Provide support for production data environments and troubleshoot data-related issues. • Participate in cutover planning and execution for new data solutions. • Stay up-to-date with industry trends and emerging technologies in data engineering. Required Skills and Experience: • Extensive Data Engineering Experience: A minimum of 10+ years of proven experience in Data Engineering is required, including designing, developing, and supporting complex data environments. • Data Warehouse Design and Development: • Experience in designing, implementing, and optimizing enterprise data warehouses (EDWs) is required. • Expertise in data modeling and schema design (e.g., relational, dimensional) is required to ensure efficient data storage and retrieval. • Snowflake: Hands-on experience with Snowflake data warehousing, including optimization techniques, is required. • ETL/ELT and Data Integration: • A deep understanding and experience with ETL/ELT processes and tools are required. • Matillion and Fivetran HVR: Proficiency with Matillion and Fivetran HVR for building data pipelines is required. • Experience integrating data from various sources using APIs, EDI, SFTP, and other methods is required. • Data Modeling and Design: • A strong understanding of data modeling principles and best practices is required. • The ability to translate business requirements into efficient data models is required. • Data Quality and Governance: • Experience implementing data quality checks and validation processes is required. • Familiarity with data governance principles and best practices is required. • Ensuring data security and access controls are implemented and maintained is required. • Data Security: • Experience implementing industry-standard data security measures, including encryption and access controls, is required. • Familiarity with data privacy regulations (e.g., GDPR) is required. • Testing and Validation: • Experience in designing and executing integration testing for data pipelines and EDW is required. • The ability to implement robust error handling and recovery mechanisms is required. • Collaboration and Communication: • The ability to work collaboratively in cross-functional teams, including data scientists, analysts, and business stakeholders, is required. • Strong communication skills, both verbal and written, with the ability to explain complex technical concepts to non-technical audiences, are required. • Agile Methodologies: • Experience working in Agile/Scrum development methodologies is required. • Data Integrity and Accuracy: • Experience ensuring data integrity and accuracy across various data sources is required. • BI and/or EDW Lifecycle Implementation: • Experience with multiple BI and/or EDW lifecycle implementations (e.g., blueprinting, build/test, go-live, support) is required. Preferred Skills: • Experience with external partner integrations, including eCommerce, EDI, WMS, and B2B integration. • Experience with Snowflake Marketplace integrations. • Proficiency in SQL and scripting languages (e.g., Python, Bash). • Experience with data visualization tools (e.g., Power BI). • Cloud computing experience (e.g., AWS, Azure, Google Cloud). • Familiarity with containerization technologies (e.g., Docker, Kubernetes). Regards, Vishwajeet Verma