Apply on Employer Site

NSA Storage · 1 month ago

OPERATIONS IT - DATA ENGINEER

Denver Headquarters, 8400 E Prentice Ave, Greenwood Village, Colorado, United States of America

Full-time

Onsite

Mid, Senior Level

$40.86/hr - $52.80/hr

4+ years exp

NSA Storage is a leading self-storage REIT based in Denver, seeking a Data Engineer to support their data engineering and analytics team. The role focuses on ensuring data products are designed and delivered with high quality, involving database migration, data profiling, and collaboration with stakeholders.

E-Commerce PlatformsReal EstateSmart Home

No H1B

U.S. Citizen Only

Responsibilities

Primary skills required will include advanced SQL, data-based python (not SW apps) coding and ETL development in any mainstream tool. Preference for experience with Databricks, Snowflake, MSSQL, ADF, and Azure. Required experience migrating at least 2 enterprise databases

Work with internal/business stakeholders on collecting reporting requirements for migration and translate those requirements into technical migration strategy

Perform technical research, data profiling, and testing of data assumptions in data sources and in current data products

Explain data concepts, reports, KPIs, and other technical subjects in business terms

Document development standards, KPI calculations, business glossary terms, table diagrams, and other subjects related to NSA data or reports

Cross-functional collaboration between stakeholders and data engineers to provide requirements for new dataset requests, modifications to existing ones and resolve any existing data issues

Document existing MSSQL ETL process, work with architect to create migration strategy into Snowflake

Perform dimensional data modeling and design database objects for ease of access, performance, and consistency is a strong plus

Qualification

MSSQL developmentETL developmentPython programmingData warehouse designSQL scriptingDB migrationsSnowflakeData modelingCustomer facingProject managementDocumentation skills

Required

Bachelor's degree in a technical field or equivalent related work experience

2+ Enterprise level database migration projects

4+ years working with Microsoft SQL Server; specifically, the ability to reverse engineer existing data processes

4+ years working with mainstream ETL tools

4+ years experience manipulating/extracting/working with data via Python and extracting data from REST APIs

4+ years of technical experience in data warehouse development, design, and modeling

Extensive understanding of reporting & analytic testing frameworks and passionate about documentation

Experience working in a data warehouse environment that is subject to external auditing practices

Strong understanding of data modeling concepts in data warehousing

Exceptional communication skills and ability to document software requirements and functionality for various audiences is required

Ability & willingness to own delivery of your own work product

Preferred

Experience with Databricks, Snowflake, MSSQL, ADF, and Azure

Perform dimensional data modeling and design database objects for ease of access, performance, and consistency is a strong plus

Benefits

100% paid medical/vision/dental for employee only plans with up to $2,400 funding towards HSA.

401(K) with employer match.

Employee Assistance Program.

A positive work culture of high integrity team members.

Opportunities for career development and training.

A healthy work life balance including quarterly wellness days.

Company

NSA Storage

NSA Storage stands as a premier real estate investment trust, comprised of 12 self-storage brands and managing over 1,000 storage facilities across the U.S..

Founded in 2013

Greenwood Village, Colorado, USA

1001-5000 employees