What are the responsibilities and job description for the Snowflake Data Engineer_W2_MA position at Chelsoft Solutions Co?
Our company has a client in Boston, MA that is seeking a Snowflake Data Engineer.
Responsibilities:
* Snowflake Data Engineer will design, develop, and maintain complex snowflake data warehouses
* 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
* 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 built-in visualization tools or third-party 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
* As a Snowflake Data Engineer, you will develop and maintain technical documentation, including data dictionary, data flow diagrams, and code comments
* Participate in code reviews and provide feedback to ensure high-quality 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 non-technical stakeholders in a clear and concise manner
* Provide technical guidance and mentorship to junior analysts and other team members
Required Skills : * 8 years of experience in Snowflake data warehouse development and management, data engineering field * Experience with Snowflake features, including cloning, time travel, data sharing, and micro-partitioning * Strong experience integrating Snowflake with Tableau, Salesforce, third party APIs, etc. * Experience in Python or similar scripting languages for automation and data processing * Experience with cloud platforms like AWS, Azure * Strong understanding of Snowflake architecture, data modeling, and data warehousing concepts * Strong understanding of Snowflake s architecture, including virtual warehouses, storage, and compute separation * Expertise in Snowflake Role-Based Access Control (RBAC), data masking, and encryption * Knowledge of data security and compliance standards as they relate to Snowflake * Knowledge of data governance frameworks and tools * Proficiency with SQL, including snowflake s SQL dialect and complex query writing for performance optimization * Proficiency with data integration tools and ETL/ELT processes * Strong analytical, problem-solving, and communication skills * Excellent verbal and written communication skills with project teams and business teams * Ability to work collaboratively in a cross-functional team environment
Salary : $119,900 - $144,000
