Data Engineer

OVERVIEW

The Data Engineer is a key resource in building and maintaining a modern enterprise data lake and data warehouse in Suns Azure data platform. They will facilitate modern data platform processes and procedures for Sun and will establish robust data governance and management best practices. The Data Engineer works under the leadership of the Manager, Data Architecture to ensure core enterprise data objectives are accounted for in the design and implementation of the data platform infrastructure. Further, they will liaison with key business leadership and stakeholders to ensure that the design, validation, and implementation of the new data platform infrastructure meets the needs of Suns business.

JOB DUTIES

Builds an Azure data platform for Sun including enterprise data lake and data warehouse in alignment with Suns strategic objectives and organizational goals.

Incorporates Azure data platform best practices into Suns Azure data platform.

Develops policies and implements mechanisms for data ingestion into Azure data platform from various sources.

Configures APIs for data extraction.

Creates and organizes Azure Synapse serverless and dedicated tables and objects to optimize performance.

Actively collaborates with the business intelligence team, business teams, project teams, and others to understand data requirements, integration needs, constraints, and performance requirements.

Works with Microsoft support to ensure an ongoing stable data system.

Configures, validates, and implements various Azure tools including data catalog as appropriate.

Works with the Manager, Data Architecture to define and implement robust data governance, certification, and management policies and mechanisms.

Converts functional requirements into technical specifications; creates technical documentation as needed.

Develops and maintains relationships with vendors.

Assists in maintaining business documentation for the data and data structure in the data warehouse.

Other duties as assigned.

REQUIREMENTS

Bachelor's Degree in Computer or Data Science, Data Analytics, Statistics, or Information Management (Required)

3 years experience designing and building enterprise data lake

3 years experience designing and building an enterprise data warehouse

3 years experience in modern data platforms based on Azure

3 years of experience in modern data platforms based on Azure including: Azure Data Lake, Azure Data Factory, Azure Blob, SQL Data Warehouse (Synapse) Dedicated and Serverless, and Data Catalog (Required)

Proficient in creating data factory pipelines; copy activity, custom Azure development (Required)

Advanced SQL experience and organizing database for query performance (Required)

Experience with at least one of the object-oriented programming languages such as C#, Java, JavaScript or Python (Required)

Experience using big data file formats and compression techniques

Familiarity with CI/CD processes and Azure DevOps

Ability to effectively manage multiple and competing priorities in a dynamic and fast-paced environment

Exceptional organizational skills

Strong attention to detail

Ability to work well with others inside as well as outside the organization

Excellent verbal and written communication skills

Experience with ELT and ETL processes (Required)

BENEFITS

At Sun Communities, you will be part of an industry-leading organization where you will be challenged, inspired, rewarded and transformed. We place a high priority on our team members, and this is a big part of what sets us apart. We will ask you to give us your very best every day, and will challenge you with interesting work, stretch assignments, a collaborative and supportive work environment and plenty of learning and growth. In exchange, we will reward you with great pay, advancement opportunities, paid time off, great benefits, and flexibility.

Comprehensive Medical and Prescription coverage with 4 plan options so you can choose the plan that best meets the needs of you and your family

Comprehensive Dental and Vision Plans

On-Site Fitness Center

Voluntary Health and Dependent Care Reimbursement Accounts

Life, Accidental Death & Dismemberment Insurance and Dependent Life

Short and Long-Term Disability Coverage

401(k) Plan with Sun matching contribution

Employee Assistance Program

Identity Theft Insurance

Legal Assistance Plan

Pet Insurance

Tuition Reimbursement program providing financial support to team members who further their formal education

Vacation RV Site Discounts for team members when visiting SunRV Resorts across the nation

Team Member Perks & Discounts program with hundreds of discounts on things like travel, merchandise, mobile phone service, and more

Up to six weeks of paid parental leave for the birth of a child, adoption, or placement of a child

Paid Time Off including ten holidays, vacation, personal, sick time, bereavement and pay for jury duty

Apply for a Corporate Headquarters (HQ) position, located in the Metro Detroit, Michigan market today.

Join our Talent Community and explore Corporate Headquarters jobs at Sun Communities.