Data Engineer

Overview The Data Engineer is a key resource in building and maintaining a modern enterprise data lake and data warehouse in Sun's 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 Sun's business. Overview The Data Engineer is a key resource in building and maintaining a modern enterprise data lake and data warehouse in Sun's 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 Sun's business. Job Duties Builds an Azure data platform for Sun including enterprise data lake and data warehouse in alignment with Sun's strategic objectives and organizational goals. (Essential) Incorporates Azure data platform best practices into Sun's Azure data platform. (Essential) Develops policies and implements mechanisms for data ingestion into Azure data platform from various sources. (Essential) Configures APIs for data extraction. (Essential) Creates and organizes Azure Synapse serverless and dedicated tables and objects to optimize performance. (Essential) Actively collaborates with the business intelligence team, business teams, project teams, and others to understand data requirements, integration needs, constraints, and performance requirements. (Essential) 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 in experience designing and building enterprise data lake (Required) 3 years in experience designing and building an enterprise data warehouse (Required) 3 years in experience in modern data platforms based on Azure (Required) 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. #J-18808-Ljbffr