Apply on Employer Site

Extra Space Storage · 7 hours ago

Senior Data Engineer

Salt Lake City, UT

Full-time

Hybrid

Senior Level

5+ years exp

Extra Space Storage is seeking a Senior Data Engineer who will serve as a technical expert within the team, owning critical data systems and driving reliability in data engineering. The role focuses on optimizing data architectures for scalability and mentoring others while implementing advanced tools and methodologies for robust data solutions.

Real EstateCommercialReal Estate InvestmentSelf-Storage

Growth Opportunities

No H1B

Responsibilities

Architect scalable data pipelines and dimensional models across hybrid environments, applying Kimball methodology (e.g., bus architecture, star/snowflake schemas, fact table granularity, slowly changing dimensions, surrogate keys)

Lead technical execution of data projects, including migrations to Microsoft Fabric (e.g., refactoring Synapse Pipelines to Fabric equivalents while preserving dimensional integrity)

Mentor Associates and Mid-level engineers; review pipeline designs, Python code, dimensional models, and implementations

Proactively identify and resolve data performance, quality, security, or scalability issues

Ensure adherence to data governance standards, security practices (e.g., encryption, access controls), and compliance requirements

Break down complex data initiatives into actionable plans, incorporating Kimball principles and Fabric components (e.g., Dataflows, Notebooks, Lakehouse)

Implement and maintain Git-based workflows for data pipelines, notebooks, and transformations, including branching strategies for safe development

Configure and execute promotions in Fabric Deployment Pipelines, handling environment-specific rules and content

Conduct data quality and pipeline tests during the development cycle, ensuring changes are reliable before cross-environment deployment

Support migration-related CI/CD activities, such as refactoring Synapse Pipelines to Fabric equivalents with version-controlled artifacts

Independently interpret business requests into technical requirements through direct engagement with requestors

Deliver end-to-end solutions for complex or high-impact requests, including proactive suggestions for improvements

Provide technical guidance during requirement refinement and feedback sessions with requesting teams

Designs and implements archive, recovery, and load strategies

Determines database structural requirements by analyzing client or internal operations, applications, and programming

Reviews objectives with clients or internal users and evaluates current systems

Coordinates new data development, ensuring consistency and providing for integration with existing warehouse structure

Qualification

PythonAdvanced SQLMicrosoft FabricDimensional ModelingAzure Synapse PipelinesGit IntegrationData GovernanceCI/CD Best PracticesMentoring

Required

Typically requires 5+ years of related experience and a bachelor's degree (or equivalent experience)

Strong hands-on experience with Microsoft Azure data services, SQL Server, Python, and data modeling (Kimball methodology preferred)

Demonstrates proficiency in all areas of data engineering with advanced in-depth specialization in dimensional modeling, pipeline architecture, and modern cloud platforms

Participates in developing technical/business approaches and new or enhanced technical tools, including CI/CD best practices

Has advanced knowledge of scalable data pipelines, lakehouse architectures, and high-volume processing in Azure Synapse and Microsoft Fabric environments