Sr. Database Engineer

The Sr. Database Engineer is responsible for designing, building, and sustaining scalable data solutions that integrate internal and external data into a unified, governed data platform. This includes leading and supporting enterprise initiatives such as consolidating multiple data repositories into a central cloud data lake and enabling consistent, high-quality data for analytics and reporting across the organization.

This individual partners with cross-functional teams throughout the full project lifecycle (Initiation, Planning, Development, Deployment, and Ongoing Support / Maintenance) using Agile practices and project documentation that defines scope and deliverables. Typical activities include data modeling and architecture, development and optimization of ETL / ELT pipelines into the data lake, implementation of data quality and governance controls, BI and semantic model development, and support for downstream reporting, campaign execution, and advanced analytics use cases.

Essential Duties and Responsibilities

• Apply strong critical thinking and problem-solving skills to design, troubleshoot, and optimize database and data pipeline solutions
• Develop Logical and Physical models based on the defined architecture
• Extract Transform Load (ETL) development and testing
• Development of appropriate notification / alert strategies within all data pipelines
• Serve as Subject Matter Expert (SME) within the Data Platforms Department for multiple clients / projects
• Develop BI solutions using various tools i.e. Azure Data Factory, SSIS, to meet organizational needs
• Develop, implement and support custom stored procedures, functions, and views
• Maintain data integrity
• Suggest software, hardware, and process-level improvements to upper management
• Suggest overall process improvements for existing solutions to upper management
• Define and maintain data governance documentation across project phases-including data dictionaries, entityrelationship diagrams, ETL / ELT specifications, and data lineage and quality rules-ensuring that all designs and implementations adhere to established data governance policies and standards.
• Capacity / scalability planning for expanding data needs
• Participate in peer code review
• Other duties and responsibilities as assigned
• Sense of ownership and pride in your performance and its impact on the company's success
• Background / Experience
• Excellent understanding of T-SQL
• 10+ years Microsoft SQL Server 2016 and above
• 10+ years IT industry experience; Marketing or Advertising experience a plus
• Excellent skills with ETL tools like Azure Data Factory and SSIS
• Azure Cloud experience a plus
• Advanced problem-solving skills and excellent communication skills
• Team player
• Good time-management skills
• Great interpersonal and communication skills