The Panther Group Inc - Senior Snowflake Developer (Hybrid Boston)

Developer is needed in Boston, United States.

Client: The Panther Group Inc

Location: Boston, MA

Contract: Contract

Job Description

We are hiring a Senior Snowflake Developer for our client in downtown Boston. This is a hybrid role with two days per week in the office. The selected candidate will be responsible for the design, development, and support of our client’s cloud-based data warehouse environment. This role entails building scalable data solutions that support reporting, analytics, and data-driven decision-making for the client, enabling program teams to effectively manage, analyze, and leverage critical data. The Developer will report to the Director of Information Technology Development.

Please note: No Corp to Corp, subcontracting, or visa sponsorship is available for this role.

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, ensuring scalability, reliability, and efficiency.
• 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 validation rules, cleansing processes, and access controls.
• Optimize snowflake data warehouse performance, scalability, and reliability, including monitoring and troubleshooting data issues.
• Develop and maintain technical documentation, including data dictionaries, 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.

Qualifications

• 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 micro-partitioning.
• 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.
• 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 and services such as AWS Glue, DMS, S3, Appflow, etc.
• Knowledge of data governance frameworks and tools.
• Strong experience integrating Snowflake with Tableau, Salesforce, third-party APIs, etc.
• Strong analytical, problem-solving, and communication skills.
• Ability to work collaboratively in a cross-functional team environment.
• Excellent verbal and written communication skills with project teams and business teams.
• Team-oriented attitude and the proven ability to collaborate at all levels of an organization.

Desired Skills/Experience

• Experience working on projects in the affordable housing sector or other public benefit programs.
• SnowPro Advanced Architect or SnowPro Data Engineering certification is preferred.
• Experience in building complex data pipelines in a 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 with JIRA or other project management tools.
• Experience using GitHub.

Compensation

Pay: $71.40 to $85.70/hour W2 depending on experience.

Work Location

In-person in downtown Boston.