Snowflake Data Engineer
Snowflake Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Snowflake Data Engineer
Boston MA
Responsibilities:
* Design develop and maintain complex snowflake data warehouses including data modeling ETL processes and data quality control
* Ensure data integrity quality and security across all data warehousing activities
* Develop and maintain data pipelines to integrate data from various internal and external sources
* Develop and maintain data pipelines using tools for data transformation testing and deployment; Ensure data pipelines are scalable reliable and efficient
* Write Python code to automate data processing transformation and loading tasks including data ingestion data quality control and data visualization
* Collaborate with data analysts and business stakeholders to understand data requirements and develop data solutions that meet business needs
* Develop and maintain data visualizations and reports using Snowflake s builtin visualization tools or thirdparty tools like Tableau
* Ensure data quality integrity and security by developing data validation rules data cleansing processes and data access controls
* Optimize snowflake data warehouse performance scalability and reliability including monitoring and troubleshooting data issues
* Develop and maintain technical documentation including data dictionary data flow diagrams and code comments
* Participate in code reviews and provide feedback to ensure highquality code and adherence to coding standards
* Work closely with the agency s data team and the overall state technology team to ensure alignment on data strategy and technology standards
* Communicate complex data findings to nontechnical stakeholders in a clear and concise manner
* Provide technical guidance and mentorship to junior analysts and other team members
Required Skills : * SnowPro Advanced certification is a plus * 8 years of experience in Snowflake data warehouse development and management data engineering field * Strong understanding of Snowflake architecture data modeling and data warehousing concepts * Proficiency with SQL including snowflake s SQL dialect and complex query writing for performance optimization * Experience with Snowflake features including cloning time travel data sharing and micropartitioning * Strong understanding of Snowflake s architecture including virtual warehouses storage and compute separation * Expertise in Snowflake RoleBased Access Control (RBAC) data masking and encryption * Proficiency with data integration tools and ETL/ELT processes * Experience in Python or similar scripting languages for automation and data processing * Knowledge of data security and compliance standards as they relate to Snowflake * Experience with cloud platforms like AWS Azure * Knowledge of data governance frameworks and tools * Strong experience integrating Snowflake with Tableau Salesforce third party APIs etc. * Strong analytical problemsolving and communication skills * Ability to work collaboratively in a crossfunctional team environment * Excellent verbal and written communication skills with project teams and business teams
Employment Type
Full Time
