Overseas Adventure Travel
Data Warehousing Operations Analyst/ETL-ELT Developer
Overseas Adventure Travel, Boston, Massachusetts, us, 02298
Career Opportunities with Grand Circle Corporation
A great place to work.
Data Warehousing Operations Analyst/ETL-ELT Developer
Grand Circle LLC is seeking a dedicated DW Operations Analyst/ETL-ELT Developer to join our team in Boston, MA. This hybrid role (onsite 3x/week) is pivotal in our migration from Oracle to a cloud-based data warehousing solution using Snowflake and DBT. The ideal candidate will have a robust background in data warehousing, cloud computing, and ETL processes, with a strong emphasis on Snowflake development. Position Responsibilities: Contribute to the implementation of Snowflake with DBT, as part of our Migration from Oracle to a cloud-based data warehousing. Collaborate closely with cross-functional teams to design, develop, and optimize ELT processes within a cloud-based Data Warehouse environment. Provide DW Production Support, including HD tickets, bug resolution and successful batch completion. Provide on-call support of the Data Warehouse nightly processing. Develop and maintain Fivetran data pipelines to ensure smooth data extraction and loading from various source systems into Snowflake. Work with both technical staff and business constituents to translate digital business requirements into technical solutions. Estimate workload and participate in an Agile project team approach. Implement technology improvements to Grand Circle’s Enterprise Data Warehouse environment. Contribute to technical architectural planning, digital data modeling, process flow documentation and the design and development of innovative digital business solutions. Create technical designs and mapping specifications. Demonstrate high communication skills as a proven individual contributor and team player. Position Requirements & Qualifications: Advanced Oracle & Snowflake database skills including packages, procedures, indexing and query tuning (8 years). Working experience with cloud computing architecture. Experience with Azure DevOps, Jira, TFS (Team Foundation Server) or other similar Agile Project Management tools. Conduct efficient data integration with other third-party tools and Snowflake. Hands-on experience with Snowflake development. At least 5 years of experience supporting Data Warehouse & Data related environments. Experience working with Web services using Informatica for external vendor data integration. Experienced with cloud-based Data Warehousing solutions, particularly Snowflake. Knowledge of data governance practices and data security considerations in a cloud environment. Experience working with a number of XML data sources & API Calls. Solid understanding of Data Warehouse design theory including dimensional data modeling. Ability to thrive in change by having a fast, flexible, cooperative work style and ability to reprioritize at a moment’s notice. Bachelor's degree required. Why Join Us? Be part of a collaborative team redefining web analytics in a dynamic and impactful setting. Opportunity to engage in end-to-end analytics processes, from data collection to reporting and strategy. Work with a company passionate about providing unique travel experiences for our customers worldwide. Benefits (30 hours +): 401K Retirement Savings account with Company Match. 50% Discount on GCC trips and opportunities for on-site training and travel. Robust healthcare benefits, including Medical, Dental, Vision, and Flex Spending Accounts. Generous Paid Time Off (PTO). Paid holidays throughout the year. 100% Commuter Benefit subsidy for Public transportation. Company-paid life insurance. Paid short and long-term disability insurance.
#J-18808-Ljbffr
Grand Circle LLC is seeking a dedicated DW Operations Analyst/ETL-ELT Developer to join our team in Boston, MA. This hybrid role (onsite 3x/week) is pivotal in our migration from Oracle to a cloud-based data warehousing solution using Snowflake and DBT. The ideal candidate will have a robust background in data warehousing, cloud computing, and ETL processes, with a strong emphasis on Snowflake development. Position Responsibilities: Contribute to the implementation of Snowflake with DBT, as part of our Migration from Oracle to a cloud-based data warehousing. Collaborate closely with cross-functional teams to design, develop, and optimize ELT processes within a cloud-based Data Warehouse environment. Provide DW Production Support, including HD tickets, bug resolution and successful batch completion. Provide on-call support of the Data Warehouse nightly processing. Develop and maintain Fivetran data pipelines to ensure smooth data extraction and loading from various source systems into Snowflake. Work with both technical staff and business constituents to translate digital business requirements into technical solutions. Estimate workload and participate in an Agile project team approach. Implement technology improvements to Grand Circle’s Enterprise Data Warehouse environment. Contribute to technical architectural planning, digital data modeling, process flow documentation and the design and development of innovative digital business solutions. Create technical designs and mapping specifications. Demonstrate high communication skills as a proven individual contributor and team player. Position Requirements & Qualifications: Advanced Oracle & Snowflake database skills including packages, procedures, indexing and query tuning (8 years). Working experience with cloud computing architecture. Experience with Azure DevOps, Jira, TFS (Team Foundation Server) or other similar Agile Project Management tools. Conduct efficient data integration with other third-party tools and Snowflake. Hands-on experience with Snowflake development. At least 5 years of experience supporting Data Warehouse & Data related environments. Experience working with Web services using Informatica for external vendor data integration. Experienced with cloud-based Data Warehousing solutions, particularly Snowflake. Knowledge of data governance practices and data security considerations in a cloud environment. Experience working with a number of XML data sources & API Calls. Solid understanding of Data Warehouse design theory including dimensional data modeling. Ability to thrive in change by having a fast, flexible, cooperative work style and ability to reprioritize at a moment’s notice. Bachelor's degree required. Why Join Us? Be part of a collaborative team redefining web analytics in a dynamic and impactful setting. Opportunity to engage in end-to-end analytics processes, from data collection to reporting and strategy. Work with a company passionate about providing unique travel experiences for our customers worldwide. Benefits (30 hours +): 401K Retirement Savings account with Company Match. 50% Discount on GCC trips and opportunities for on-site training and travel. Robust healthcare benefits, including Medical, Dental, Vision, and Flex Spending Accounts. Generous Paid Time Off (PTO). Paid holidays throughout the year. 100% Commuter Benefit subsidy for Public transportation. Company-paid life insurance. Paid short and long-term disability insurance.
#J-18808-Ljbffr