Senior Data Engineer

Job Type:

• Full Time
• 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:

Data Pipeline & Intergration Development

• 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 NetSuite and other operational systems
• Troubleshoot and resolve issues across development, testing, and production environments

Cloud Infrastructure & Security

• 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 DevOps 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 Azure API Management and broader MS Azure environment development

Qualifications:

• Experience building data pipelines for AI/LLM applications (RAG, embeddings, vector stores)
• Exposure to API-based integrations and webhook-driven architectures
• Familiarity with modern data stack components such as dbt or Databricks
• Experience with NetSuite or similar ERP systems
• BS in Computer Science, Information Technology, or a related field
• 7 years in data engineering, integration development, or a closely related role
• Hands-on experience with Azure Data Factory (ADF) and SSIS
• Proficiency in C#/.NET and Python
• Strong SQL skills and experience with SQL Server and Azure SQL
• Experience with Azure DevOps and/or Git for source control and CI/CD

Benefits:

• Competitive compensation bonuses
• Comprehensive health benefits (medical, dental, vision, pet)
• Open PTO
• 401k with 4% company match up to 6%
• Team Member discount at McGee & Co. access to Team Member only warehouse sales
• Opportunity to be part of a vibrant, inclusive, and innovative team

McGee is proud to be an equal opportunity employer - we see the beauty of celebrating our teams' differences, regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, or veteran status. Together we Make Life Beautiful.