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 4plan optionsso 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 achild, adoption, or placement of a child
• Paid Time Off including tenholidays, vacation, personal, sick time, bereavement and pay for jury duty

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

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