Summary:
As one of America’s fastest growing premium coffee brands, Summer Moon focuses on hospitably serving guests our delicious hot and cold beverages, featuring oak-roasted coffee and Moon Milk, with warmth and gratitude every day. We operate ten corporate-owned stores and over forty franchisee-owned stores across 12 states. Our continued success is reliant on partners that are eager to work as part of a high-energy, efficient team in a fast-paced environment.
About the Role:
As a Data Engineer, you will be responsible for designing, developing, and implementing automated standard business reports within the Microsoft Fabric platform. You will play a crucial role in automating business reporting, improving efficiency, and driving digital transformation initiatives within the organization. Your expertise in data modeling, data warehouses, pipelines, and related technologies will contribute to streamlining operations, reducing manual efforts, and enhancing productivity. You will work closely with business analysts, stakeholders, and data analysts to understand business processes and translate them into efficient and scalable data sets.
Responsibilities:
-
Configure and Integrate data connections with various systems, applications, and databases to ensure end-to-end “copy exact” system replication
-
Create reusable, automated, and scalable data collection pipelines
-
Design, Develop, Deploy, and test new data platforms, Data Hubs, Data Marts within the Global Data Warehouse
-
Adhere to internal standards for coding, project tracking and documentation.
-
Integrate data from source systems/data lake into a data warehouse.
-
Troubleshoot, debug, and tune issues in existing pipeline automation, identify areas for improvement, and implement enhancements
-
Document technical specifications, solution designs, and developer guides for data models
-
Collaborate with cross-functional teams to ensure smooth integration of data warehousing solutions within existing IT infrastructure
-
Apply data science Time Series Analysis modeling to all required data sets in the data lake, including SARIMA, XGBoost, and Prophet, complete with ADF P value and RMSE analysis.
-
Apply data science Regression Analysis modeling to prioritized variables in order to determine independent and dependent variable regression testing.
-
Stay up-to-date with the latest data warehousing trends, technologies, and best practices to continuously improve and optimize processes
-
Develop Data Models specific to a few construction industry data groups: Sales, Work Management, Invoices, and Financials such as General Ledger, P&L, and Expenses.
-
Perform other responsibilities as requested by leadership
Qualifications:
-
1-3 years of experience in Data Warehousing with Cloud technologies
-
BS degree educated in computer science or a relevant subject
-
Good software engineering principles
-
Basic working experience with Azure DevOps paired with knowledge of Agile and/or Scrum methods of delivery (or equivalent such as Jira)
-
Some experience connecting to various data sources and structures (like RDBMS, Data Lake, IoT, Blob Storage)
-
Strong practical experience with T-SQL or any variant from other RDBMS
-
Strong analytical and problem-solving skills
-
Strong communication skills in dealing with internal customers from a range of functional areas
-
Ability to work with remote & virtual project teams, third parties & consultants
-
Willingness to work flexible working hours according to project requirements
-
Technical documentation skills
-
Fluent in English
-
Experience with Toast point-of-sale software is a plus
-
Experience in working on Azure Services like Azure Data Factory, Azure Data Lake is a plus.
-
Local to Austin TX desired.
