Saxon Global
Data Engineer - Snowflake
Saxon Global, Somerville, Massachusetts, us, 02145
Consultant - Data Engineer Job Description
Principal Duties and Responsibilities
Perform EDW ETL/ELT ingestions and integrations to ensure support data and analytic needs.Build and enhance standard solution that provides efficient and scalable ETL/ELT solutions from multiple data sources.Ensure the quality of data assets and robustness of data engineering processes.Experience with change control, release management and other ITIL processes.Participate in building out EDW on Snowflake, expanding and optimizing the data ecosystem, as well as optimizing data engineering processes.Support BI Developers, Data Architects, Data Analysts and Data Scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.Conduct ETL solution, code, and pre-prod review to ensure optimal data delivery architecture is consistent throughout ongoing projects.Perform troubleshooting on ETLs and related components.Identify application bottlenecks and opportunities to optimize performance.Qualifications
7+ plus years of experience designing and building data ingestions and data integration solution for Enterprise Data and Analytics Solutions3+ years of experience with developing data pipelines using on Snowflake features ( Snowpipe, SnowSQL, Snow Sight, Data Streams )2+ years of experience with developing models in DBTDemonstrate good knowledge of scrum & agile principlesExperience with Azure DevOps, Azure Git and CI/CD data pipeline integrations.Demonstrates good knowledge of cloud computing platforms such as AzureExperience of support and enhance existing Enterprise Data Warehouse or Data LakeEnsure designed systems are highly reliable, self-recovering, and require little or no supporting manpowerFamiliar with change control, release management, and other ITIL methodologyDeep experience in traditional Data Warehousing & Cloud data warehousingMastery of SQL, especially within cloud-based data warehouses like SnowflakeExperience developing data pipelines using Snowflake features (Snow pipe, SnowSQL, Data Streams, Snow Sight)Experience with logical and physical data modelingHealthcare experience, most notably in Clinical data, Epic, Payer data and reference data is a plus but not mandatory.Ability to clearly and concisely communicate complex technical concepts to both technical and non-technical audiencesProven verbal, communication, and presentation skillsProven ability to work independently.Consultant - Data Engineer Job Description
Principal Duties and Responsibilities
Perform EDW ETL/ELT ingestions and integrations to ensure support data and analytic needs.Build and enhance standard solution that provides efficient and scalable ETL/ELT solutions from multiple data sources.Ensure the quality of data assets and robustness of data engineering processes.Experience with change control, release management and other ITIL processes.Participate in building out EDW on Snowflake, expanding and optimizing the data ecosystem, as well as optimizing data engineering processes.Support BI Developers, Data Architects, Data Analysts and Data Scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.Conduct ETL solution, code, and pre-prod review to ensure optimal data delivery architecture is consistent throughout ongoing projects.Perform troubleshooting on ETLs and related components.Identify application bottlenecks and opportunities to optimize performance.Qualifications
7+ plus years of experience designing and building data ingestions and data integration solution for Enterprise Data and Analytics Solutions3+ years of experience with developing data pipelines using on Snowflake features ( Snowpipe, SnowSQL, Snow Sight, Data Streams )2+ years of experience with developing models in DBTDemonstrate good knowledge of scrum & agile principlesExperience with Azure DevOps, Azure Git and CI/CD data pipeline integrations.Demonstrates good knowledge of cloud computing platforms such as AzureExperience of support and enhance existing Enterprise Data Warehouse or Data LakeEnsure designed systems are highly reliable, self-recovering, and require little or no supporting manpowerFamiliar with change control, release management, and other ITIL methodologyDeep experience in traditional Data Warehousing & Cloud data warehousingMastery of SQL, especially within cloud-based data warehouses like SnowflakeExperience developing data pipelines using Snowflake features (Snow pipe, SnowSQL, Data Streams, Snow Sight)Experience with logical and physical data modelingHealthcare experience, most notably in Clinical data, Epic, Payer data and reference data is a plus but not mandatory.Ability to clearly and concisely communicate complex technical concepts to both technical and non-technical audiencesProven verbal, communication, and presentation skillsProven ability to work independently.
Required Skills : Snowflake DBT - Data Build Tool - need 1+ years with this ideally SQL Scheduling tool - ideally Tidal but ok for something else like AirlfowBasic Qualification :
Snowflake development experience DBT for ETL Strong SQL experienceAdditional Skills :
Snowflake development experience DBT for ETL Strong SQL experienceremoteBackground Check :YesDrug Screen :YesNotes :Selling points for candidate :remoteProject Verification Info :Candidate must be your W2 Employee :YesExclusive to Apex :YesFace to face interview required :NoCandidate must be local :NoCandidate must be authorized to work without sponsorship ::NoInterview times set :YesType of project :0012595 | Mass General Brigham - SOWMaster Job Title :BUSBranch Code :
Principal Duties and Responsibilities
Perform EDW ETL/ELT ingestions and integrations to ensure support data and analytic needs.Build and enhance standard solution that provides efficient and scalable ETL/ELT solutions from multiple data sources.Ensure the quality of data assets and robustness of data engineering processes.Experience with change control, release management and other ITIL processes.Participate in building out EDW on Snowflake, expanding and optimizing the data ecosystem, as well as optimizing data engineering processes.Support BI Developers, Data Architects, Data Analysts and Data Scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.Conduct ETL solution, code, and pre-prod review to ensure optimal data delivery architecture is consistent throughout ongoing projects.Perform troubleshooting on ETLs and related components.Identify application bottlenecks and opportunities to optimize performance.Qualifications
7+ plus years of experience designing and building data ingestions and data integration solution for Enterprise Data and Analytics Solutions3+ years of experience with developing data pipelines using on Snowflake features ( Snowpipe, SnowSQL, Snow Sight, Data Streams )2+ years of experience with developing models in DBTDemonstrate good knowledge of scrum & agile principlesExperience with Azure DevOps, Azure Git and CI/CD data pipeline integrations.Demonstrates good knowledge of cloud computing platforms such as AzureExperience of support and enhance existing Enterprise Data Warehouse or Data LakeEnsure designed systems are highly reliable, self-recovering, and require little or no supporting manpowerFamiliar with change control, release management, and other ITIL methodologyDeep experience in traditional Data Warehousing & Cloud data warehousingMastery of SQL, especially within cloud-based data warehouses like SnowflakeExperience developing data pipelines using Snowflake features (Snow pipe, SnowSQL, Data Streams, Snow Sight)Experience with logical and physical data modelingHealthcare experience, most notably in Clinical data, Epic, Payer data and reference data is a plus but not mandatory.Ability to clearly and concisely communicate complex technical concepts to both technical and non-technical audiencesProven verbal, communication, and presentation skillsProven ability to work independently.Consultant - Data Engineer Job Description
Principal Duties and Responsibilities
Perform EDW ETL/ELT ingestions and integrations to ensure support data and analytic needs.Build and enhance standard solution that provides efficient and scalable ETL/ELT solutions from multiple data sources.Ensure the quality of data assets and robustness of data engineering processes.Experience with change control, release management and other ITIL processes.Participate in building out EDW on Snowflake, expanding and optimizing the data ecosystem, as well as optimizing data engineering processes.Support BI Developers, Data Architects, Data Analysts and Data Scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects.Conduct ETL solution, code, and pre-prod review to ensure optimal data delivery architecture is consistent throughout ongoing projects.Perform troubleshooting on ETLs and related components.Identify application bottlenecks and opportunities to optimize performance.Qualifications
7+ plus years of experience designing and building data ingestions and data integration solution for Enterprise Data and Analytics Solutions3+ years of experience with developing data pipelines using on Snowflake features ( Snowpipe, SnowSQL, Snow Sight, Data Streams )2+ years of experience with developing models in DBTDemonstrate good knowledge of scrum & agile principlesExperience with Azure DevOps, Azure Git and CI/CD data pipeline integrations.Demonstrates good knowledge of cloud computing platforms such as AzureExperience of support and enhance existing Enterprise Data Warehouse or Data LakeEnsure designed systems are highly reliable, self-recovering, and require little or no supporting manpowerFamiliar with change control, release management, and other ITIL methodologyDeep experience in traditional Data Warehousing & Cloud data warehousingMastery of SQL, especially within cloud-based data warehouses like SnowflakeExperience developing data pipelines using Snowflake features (Snow pipe, SnowSQL, Data Streams, Snow Sight)Experience with logical and physical data modelingHealthcare experience, most notably in Clinical data, Epic, Payer data and reference data is a plus but not mandatory.Ability to clearly and concisely communicate complex technical concepts to both technical and non-technical audiencesProven verbal, communication, and presentation skillsProven ability to work independently.
Required Skills : Snowflake DBT - Data Build Tool - need 1+ years with this ideally SQL Scheduling tool - ideally Tidal but ok for something else like AirlfowBasic Qualification :
Snowflake development experience DBT for ETL Strong SQL experienceAdditional Skills :
Snowflake development experience DBT for ETL Strong SQL experienceremoteBackground Check :YesDrug Screen :YesNotes :Selling points for candidate :remoteProject Verification Info :Candidate must be your W2 Employee :YesExclusive to Apex :YesFace to face interview required :NoCandidate must be local :NoCandidate must be authorized to work without sponsorship ::NoInterview times set :YesType of project :0012595 | Mass General Brigham - SOWMaster Job Title :BUSBranch Code :