Senior Data Engineer

• Remote or Hybrid Onsite at the Studio McGee | McGee & Co. HQ Office located in Draper, Utah • Reports To: Director, Technology & Strategic Operations Who We Are Founded in 2014, Studio McGee, Inc. is one of the fastest growing home design brands in America. Our journey began with a thriving interiors business that focused on approachable, yet aspirational design. By leveraging the power of digital communities, we were able to expand our footprint in the interior design industry through an unconventional approach that connected us with our consumers. We continued to carry that forward-thinking attitude into the launch of our retail business, McGee & Co., which anchors the operational and revenue growth of our company. Our licensing partnerships allow us to further expand our design voice beyond our own collection. From a multi-year partnership with Target to an Emmy-nominated Netflix Series and a NY Times Best-Selling book, Studio McGee's passion is to empower people to design with an approachability that enhances their daily life and elevates their everyday. Whether following us on social media or becoming part of our company, we invite you to join us on our mission to “Make Life Beautiful.” About the Role The Senior Data Engineer is responsible for the development, configuration, and maintenance of ETL and data integration solutions that power McGee & Co.'s growing AI and analytics capabilities. This role is within the Technology department and sits at the center of McGee & Co.'s data and analytics evolution. The Senior Data Engineer owns the business intelligence tech stack and is responsible for ensuring clean, reliable, and well-governed data flows from source systems, including cloud infrastructure and ERP platforms, into the tools and environments that power decision-making across the organization. As McGee & Co. continues to migrate processes and reporting to Power BI and data analytics platforms across all departments, this role serves as the technical cornerstone of that transformation. Acting as a data leader, this individual drives best practices, ensures data and code quality, and makes significant contributions to architectural integrity and Business Intelligence initiative success. Duties & Responsibilities • Develop and manage ETL processes using SQL Server, SSIS, Azure Data Factory, and Snowflake for efficient and scalable data integration • Write code in C#/.NET and Python to optimize the performance and efficiency of the organization's IT platform and infrastructure • Leverage managed integration platforms such as Fivetran and Celigo for connectivity with Net Suite and other operational systems • Troubleshoot and resolve issues across development, testing, and production environments • Own the architecture and maintenance of the MS Azure environment, including Azure SQL Server, Azure Data Factory, Azure API Management, and related services • Manage storage, compute, and orchestration resources across Snowflake and Azure • Leverage Azure Dev Ops and/or Git for source control, CI/CD pipelines, and release management • Proactively coordinate security-related best practices and solutions with IT security and agile delivery teams AI Enablement • Partner with business and operations stakeholders to design data foundations supporting AI use cases, including RAG pipelines, structured knowledge bases, and embeddings storage • Evaluate and implement tools for connecting internal data to LLM-based workflows, including vector databases, chunking strategies, and metadata schemas Knowledge, Skills & Abilities • Strong understanding of data architecture, data modeling, and integration design principles • Familiarity with data integration and exchange frameworks including JSON, XML, and EDI • Strong analytical and problem-solving abilities with a demonstrated ability to identify root causes and implement durable fixes • Ability to document, evangelize, and guide adoption and implementation of standards across agile delivery teams • Demonstrated ability to take ownership of complex initiatives and drive them to successful completion • Strong communication skills — able to translate technical decisions for non-technical audiences • Experience with…