Senior Data Engineer

OVERVIEW

The Senior 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 Sr. 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 and maintains 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
• Supports & mentors the data team on best practices & methodologies
• Leads navigating challenging or technical situations to find best business outcomes
• Works with Microsoft support to ensure an ongoing stable data system.
• Configures, validates, and implements various Azure tools such as but not limited to Databricks, Data Factory, Data Lake, Synapse Analytics and 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
• Configures APIs for data extraction
• Creates and organizes Data Lake and Azure Synapse serverless 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

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
• 5 years experience designing and building an enterprise data warehouse
• 5 years of experience in modern data platforms based on Azure including but not limited to Azure Data Lake, Azure Data Factory, Azure Databricks, Synapse Analytics (Required)
• Proficient in creating data factory pipelines; copy activity, custom Azure development, custom databricks development (Required)
• Experience with ELT and ETL processes (Required)
• Advanced SQL experience and organizing database for query performance (Required)
• Experience with one or more object-oriented programming languages such as Python, C#, Java or JavaScript (Required)
• Experience using big data file formats and compression techniques
• Experience 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

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 with Free Personal Training & Group Fitness Classes
• 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