Remote New

Sr. Database Engineer

Ansira Partners
United States, Missouri
Jan 14, 2026
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