Sign upLog in
Science Jobs

Senior Snowflake Developer (Hybrid - Boston)

The Panther Group

Boston, MA

Apply
JOB DETAILS
SALARY
$85.70
SKILLS
Access Control, Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Analysis Skills, Application Programming Interface (API), Atlassian JIRA, Cloning, Cloud Computing, Code Reviews, Coding Standards, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cross-Functional, Cryptography, Customer Support/Service, Data Analysis, Data Collection, Data Management, Data Modeling, Data Processing, Data Quality, Data Visualization, Data Warehousing, Database Extract Transform and Load (ETL), GitHub, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Mentoring, Microsoft Windows Azure, Performance Tuning/Optimization, Presentation/Verbal Skills, Problem Solving Skills, Project Management Software, Python Programming/Scripting Language, Quality Control, Regulatory Compliance, Reporting Skills, Risk Management, SQL (Structured Query Language), Salesforce.com, Scalable System Development, Scripting (Scripting Languages), Snowflake Schema, Standards Strategy, Tableau, Team Player, Technical Leadership, Technical Strategy, Technical Writing, Transformation Tools, Warehousing, Writing Skills
LOCATION
Boston, MA
POSTED
30+ days ago
We are hiring a Senior Snowflake Developer for our client in downtown Boston.  This is a hybrid role with two days / week in office.  The person selected for this roll will be responsible for design, development, and support our client’s cloud-based data warehouse environment.  This role is responsible for building scalable data solutions that support reporting, analytics, and data-driven decision-making for our 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. 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 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.
  • 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
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 JIRA or other project management tools
  • Experience using GitHub

Pay $71.40 to 85.70/ hour W2 depending on experience

#INDIT
 

About the Company

T

The Panther Group

The Panther Group is minority owned and certified, making diversity, equity and inclusion core components of our mission.

With our commitment to respecting and empowering our employees as individuals, diversity is a competitive advantage in the marketplace.

The Panther Group has a proven track record of connecting quality talent with the right position. We believe in a hands-on approach, with a focus on building lasting relationships with our Employees and our Clients. Our Employees find flexibility and growth to reach their career goals.

The Panther Group celebrates 25 years of recruitment and workforce solutions expertise. 

COMPANY SIZE
20 to 49 employees
INDUSTRY
Staffing/Employment Agencies
FOUNDED
1992
WEBSITE
http://thepanthergrp.com

Similar Job Searches

Analytical Scientist JobsApplications Scientist JobsBiological Scientist JobsClinical Research Associate JobsClinical Research Coordinator JobsClinical Research Manager JobsClinical Scientist JobsClinical Trials Assistant JobsData Scientist JobsDirector Of Research And Development Jobs