Snowflake Data Engineer
3 days ago
The following information aims to provide potential candidates with a better understanding of the requirements for this role.
JOB LOCATION: Boston MA
WAGE RANGE*: $80-$85
JOB NUMBER: Client-25-1076-OCDDE-OCD01-110646
REQUIRED EXPERIENCE: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.
SnowPro Advanced certification is a plus.
Knowledge of data governance frameworks and tools.
Strong experience integrating Snowflake with Tableau, Salesforce, third party APIs etc.
JOB DESCRIPTION
The Snowflake Data Engineer plays a critical role in designing, building, and supporting the components of the agency's data warehouse. This position involves working with various stakeholders to ensure accurate and efficient data management, reporting, and analytics. As a Snowflake Data Engineer, you will collaborate closely with the technology group, the agency data team, agency program staff and external organizations that assist in delivery of EOHLC programs. The Data Engineer will report to EOHLC Director of Information Technology Development
Responsibilities
The Snowflake Data Engineer is responsible for: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.
Equal Opportunity Employer Veterans/Disabled
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
-
Data Solutions Architect
2 weeks ago
Somerville, United States Mass General Brigham (Enterprise Services) Full timeDescription As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and...
-
Enterprise Solutions Architect
4 days ago
Somerville, Massachusetts, United States Mass General Brigham (Enterprise Services) Full timeAbout the RoleMass General Brigham (Enterprise Services) is seeking a highly skilled Solutions Architect to join our team. As a Solutions Architect, you will play a crucial role in designing and developing clinical data products that meet the needs of our organization.Key Responsibilities:Design and develop clinical data products that meet the needs of our...
-
Cloud Data Architect for Enterprise Services
2 weeks ago
Somerville, Massachusetts, United States Mass General Brigham (Enterprise Services) Full timeOverviewMass General Brigham (Enterprise Services) is a leading healthcare organization dedicated to delivering innovative solutions and exceptional patient care. As a cloud data architect, you will play a critical role in shaping our data landscape and driving business growth.Job SummaryWe are seeking an experienced Cloud Data Architect to join our team at...
-
Data Analyst II, Value Based Care
2 weeks ago
Somerville, United States Mass General Brigham Full timeDescription: As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Womens Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and...
-
Data Warehouse Architect
3 weeks ago
Somerville, United States Mass General Brigham (Enterprise Services) Full timeDescription As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including community and...
-
Data Science Specialist
3 weeks ago
Somerville, United States Tufts University Full timeOverview: Tufts Technology Services (TTS) is a university-wide service organization committed to delivering adaptable, results driven technology solutions in support of Tufts mission of teaching, learning, research, innovation, and sustainability. With staff working remotely, hybrid and on campus across Tufts University, as well as a 24x7 IT Service Desk, we...
-
Senior Data Analyst
2 weeks ago
Somerville, United States Mass General Brigham Full timeDescription: About Us: As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Womens Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including...
-
Senior Data Scientist
2 months ago
Somerville, United States Mass General Brigham (Enterprise Services) Full timeDescription About Us As a not-for-profit organization, Mass General Brigham is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Mass General Brigham supports a complete continuum of care including...
-
Principal Engineer, Machine Learning
3 weeks ago
Somerville, United States Tessera Therapeutics Full timeYour experience includes Bachelor's or Master's degree in Computer Science, Software Engineering, or related field with 8+ years of industry experience in software, data, and machine learning engineering Proven track record in deploying and auto-scaling ML pipelines for sparse, high-dimensional data across multiple data and model scales Strong proficiency...
-
Electrical Engineer
1 week ago
Somerville, United States Futures Consulting Full timeJob DescriptionJob DescriptionSEEKING ANY LEVEL OF ELECTRICAL!DESIGNERS, ENGINEERS, EIT, PE Currently seeking an Electrical Engineer to join our sustainable design team. The ideal candidate has the ability to design lighting and power distribution systems for complex commercial and industrial buildings, and has an understanding of energy use and...
-
Manufacturing Engineer
1 month ago
Somerville, United States Form Energy Full timeAre you ready to build America‘s clean energy future with the team that will deliver? Form Energy is an American energy technology and manufacturing company. We are pioneering a new class of iron-air batteries to enable our electric grid to run on renewable, reliable, and affordable energy, every day of the year. Form Energy has been recognized by TIME as...
-
Senior Software Engineer
3 weeks ago
Somerville, Massachusetts, United States Tessera Therapeutics Full timeAbout Tessera TherapeuticsTessera Therapeutics is a pioneering biotechnology company revolutionizing genetic medicine with its groundbreaking Gene Writing technology. As a leader in the field, we are seeking an exceptional Senior Software Engineer to join our dynamic team.Job DescriptionWe are looking for a highly skilled Senior Software Engineer with...
-
Head of Software Engineering
1 month ago
Somerville, United States Formlabs Full timeIf you are customer-obsessed and forward-thinking, we want you to join us as our Head of Software Engineering. Our software product portfolio spans many areas and is rapidly growing, including:Firmware/UI: Supporting our 3D printers with industrial quality 3D printing enabled by firmware and world-class user experience enabled by the UI on each...
-
Somerville, Massachusetts, United States Mass General Brigham (Enterprise Services) Full timeAbout Mass General Brigham (Enterprise Services)We are a not-for-profit organization committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. As a national leader in biomedical research, we provide our employees with more ways to achieve their potential. Our focus is on a people-first...
-
Battery Engineer
4 weeks ago
Somerville, United States Form Energy Full timeAre you ready to build America‘s clean energy future with the team that will deliver? Form Energy is an American energy technology and manufacturing company. We are pioneering a new class of iron-air batteries to enable our electric grid to run on renewable, reliable, and affordable energy, every day of the year. Form Energy has been recognized by TIME as...
-
Spring Semester Mechanical Engineering Role
3 days ago
Somerville, Massachusetts, United States RISE Robotics Full timeJob DescriptionSpring Semester InternshipWe're seeking a motivated mechanical engineering student or recent graduate to join our team as a part-time Spring semester intern through the Massachusetts Clean Energy Internship Program. The ideal candidate will contribute to conceptualizing, designing, and testing components, systems, and assemblies while...
-
Head of Software Engineering
1 day ago
Somerville, United States Formlabs Full timeIf you are customer-obsessed and forward-thinking, we want you to join us as our Head of Software Engineering. Our software product portfolio spans many areas and is rapidly growing, including:Firmware/UI: Supporting our 3D printers with industrial quality 3D printing enabled by firmware and world-class user experience enabled by the UI on each...
-
Somerville, Massachusetts, United States Formlabs Full timeAbout the RoleWe are seeking a Senior Director of Software Engineering and Operations to lead our software engineering team in driving business growth through innovative solutions. This is a unique opportunity to shape the future of 3D printing and make a significant impact on our customers.Key ResponsibilitiesLead a team of 50+ Engineers globally to develop...
-
Mechanical Systems Integration Engineer
2 weeks ago
Somerville, Massachusetts, United States Formlabs Full timeAbout the Role:We are seeking a skilled Mechanical Systems Integration Engineer to join our team at Formlabs. This role involves supporting all parts of the product development cycle from early R+D to continuing engineering for shipped products. The ideal candidate will have previous experience designing complex electro-mechanical systems or robotic...
-
Head of Software Engineering
2 weeks ago
Somerville, United States Formlabs Full timeIf you are customer-obsessed and forward-thinking, we want you to join us as our Head of Software Engineering. Our software product portfolio spans many areas and is rapidly growing, including:Firmware/UI: Supporting our 3D printers with industrial quality 3D printing enabled by firmware and world-class user experience enabled by the UI on each...