Principal Data Engineer (Snowflake)
Job Description Position Title: Principal Data Engineer (Snowflake) Position Description: Protingent Staffing has an exciting contract opportunity Principal Data Engineer (Snowflake) with our client in Redmond, Washington. Job Responsibilities: • Lead the implementation of Snowflake solutions, including setting up Snowflake environments, schema design, warehouse setup, RBAC, and ingestion and transformation data pipelines. • Build scalable and maintainable ETL/ELT pipelines using tools and frameworks such as Azure Data Factory (ADF), Airflow / Dagster, and dbt, with SQL and Python. • Design and implement robust data integration pipelines to ingest, process, and unify structured and unstructured data from a variety of sources-including APIs, cloud storage systems, External websites, and relational/non-relational databases-using a modern medallion architecture (bronze, silver, gold layers) to ensure data quality, lineage, and accessibility across the organization. • Lead efforts in migrating legacy data systems to a modern cloud-based stack centered on Snowflake. • Own the end-to-end data lifecycle, from ingestion and transformation to reporting and governance. • Collaborate with product, data science, and analytics teams to define data models that support analytical dashboards, reporting, experimentation, and AI/ML initiatives. • Create and manage reports and dashboards using Power BI to provide actionable insights to the team and leadership. • Drive performance tuning, cost optimization, and security enforcement within the Snowflake platform. • Utilize SQL and Python for ETL, data manipulation, analysis, and process automation. • Implement data quality, monitoring, and governance frameworks across the data pipeline. • Ensure data security, privacy, and compliance with relevant regulations (e.g., GDPR, CCPA). • Implement and manage Snowflake's security features, such as access controls, encryption, and data masking. • Drive initiatives to automate and improve data operations, including testing, CI/CD deployment, and documentation. • Provide technical leadership and mentorship to a growing team of data engineers. • Participate in long-term strategic planning, providing technical insights and recommendations to support business growth. Job Qualifications: • 8+ years of experience in data engineering, data warehousing, or cloud data architecture. • 3+ years of hands-on experience with Snowflake, including architecture, performance tuning, and security. • Expertise in Snowflake performance tuning, warehouse sizing, and cost optimization. • Experience in building secure patient and prescription data marts with strong adherence to HIPAA and Safe Harbor compliance requirements. • Advanced proficiency in SQL and data modeling (star, snowflake, 3NF, and/or Data Vault). • Proven experience building ETL/ELT Orchestration tools like Azure Data Factory, Airflow / Dagster, Airbyte, and dbt. • Strong understanding of data warehousing concepts, data modeling techniques (Kimball, Data Vault 2.0), and architecture best practices. • Experience with cloud platforms such as Azure, AWS, or GCP (especially Snowflake integrations, storage, and data services). • Proficiency in SQL and Python or another scripting language used in data engineering. • Understanding and hands-on experience in enabling data privacy, governance, and compliance frameworks (HIPAA, GDPR, etc.). • Experience with Data orchestration tools. • Expertise in setting up CI/CD pipelines and DevOps for data projects (e.g., GIT, Terraform, etc.). • Skilled in cost-effective cloud resource allocation and management. • Strong testing capabilities (unit, integration, end-to-end). • Strong understanding of OLTP Vs OLAP. • 5+ years of experience with Power BI for data visualization and reporting. Job Details: • Job Type: Contract • Location: Redmond, WA/Remote. • Pay Rate: $70-85/hr. Benefits Package: Protingent offers competitive salaries, insurance plan options (HDHP plan or POS plan), education/certification reimbursement, pre-tax commuter benefits, Paid Time Off (PTO), and an administered 401k plan. About Protingent: Protingent is an Award-Winning provider of top-tier Engineering and IT talent, trusted by companies at the forefront of innovation - from Software and Aerospace to AI, Clean Tech, Medical Devices, and Connected Technologies. We're passionate about making a positive impact by connecting exceptional talent with meaningful opportunities and helping our clients build the future. Meet Your Recruiter Raj Laxmi Apply tot his job