Snowflake Data Engineer
Think IT Project Management
Job ID: in-d410e0f05aa3dd66
Location: Boston, MA, US
Description:
**Summary**
The **Snowflake Data Engineer** is responsible for:
o Design, develop, and maintain complex snowflake data warehouses, including data modeling, ETL processes, and data quality control.
o Ensure data integrity, quality, and security across all data warehousing activities.
o Develop and maintain data pipelines to integrate data from various internal and external sources.
o Develop and maintain data pipelines using tools for data transformation, testing, and deployment. Ensure data pipelines are scalable, reliable, and efficient.
o Write Python code to automate data processing, transformation, and loading tasks, including data ingestion, data quality control, and data visualization.
o Collaborate with data analysts and business stakeholders to understand data requirements and develop data solutions that meet business needs.
o Develop and maintain data visualizations and reports using Snowflake's built\-in visualization tools or third\-party tools like Tableau.
o Ensure data quality, integrity, and security by developing data validation rules, data cleansing processes, and data access controls.
o Optimize snowflake data warehouse performance, scalability, and reliability, including monitoring and troubleshooting data issues.
o Develop and maintain technical documentation, including data dictionary, data flow diagrams, and code comments.
o Participate in code reviews and provide feedback to ensure high\-quality code and adherence to coding standards.
o Work closely with the agency’s data team and the overall state technology team to ensure alignment on data strategy and technology standards.
o Communicate complex data findings to non\-technical stakeholders in a clear and concise manner
o Provide technical guidance and mentorship to junior analysts and other team members
**Qualifications:**
o data warehouse development and management, data engineering field.
o Strong understanding of Snowflake architecture, data modeling, and data warehousing concepts.
o Proficiency with SQL, including snowflake’s SQL dialect and complex query writing for performance optimization.
o Experience with Snowflake features, including cloning, time travel, data sharing, and micro\-partitioning.
o Strong understanding of Snowflake’s architecture, including virtual warehouses, storage, and compute separation.
o Expertise in Snowflake Role\-Based Access Control (RBAC), data masking, and encryption.
o Proficiency with data integration tools and ETL/ELT processes.
o Experience in Python or similar scripting languages for automation and data processing.
o Knowledge of data security and compliance standards as they relate to Snowflake.
o Experience with cloud platforms like AWS, Azure.
o SnowPro Advanced certification is a plus.
o Knowledge of data governance frameworks and tools.
o Strong experience integrating Snowflake with Tableau, Salesforce, third party APIs etc.
o Strong analytical, problem\-solving, and communication skills
o Ability to work collaboratively in a cross\-functional team environment
o Excellent verbal and written communication skills with project teams and business teams
o Team\-oriented attitude and the proven ability to collaborate at all levels of an organization
**Desired Skills/Experience:**
* SnowPro Advanced Architect or SnowPro Data Engineering certification is preferred.
* Experience in building complex data pipelines in an multi cloud environment.
* Experience implementing data masking, and aggregation to reduce privacy risks
* Experience integrating data from Salesforce solutions
* Knowledge of CI/CD practices and tools.
* Familiarity JIRA or other project management tools
* Experience using GitHub
* Experience working on projects in the affordable housing sector or other public benefit programs
Job Type: Full\-time
Pay: $80\.00 \- $85\.00 per hour
Expected hours: 40 per week
Schedule:
* 8 hour shift
Ability to Relocate:
* Boston, MA 02114: Relocate before starting work (Required)
Work Location: Hybrid remote in Boston, MA 02114
Remote: True
Min Salary: 80
Max Salary: 85
Salary Frequency: hourly
Posted Date: 2025-02-04
URL: https://www.indeed.com/viewjob?jk=d410e0f05aa3dd66
Craft Resume Craft Cover Letter