Senior Data Engineer

Studio McGee • Draper, UT

8d • Hybrid

About The Position

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.

Requirements

• 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
• 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

Nice To Haves

• 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

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 NetSuite 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 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
• 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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior