Senior BI/Data Engineer

ANSWERS IN GENESIS GROUP•Erlanger, KY

About The Position

This is a hands-on technical role responsible for designing, developing, optimizing, and supporting database and business intelligence solutions across Answers in Genesis. The position provides strategic governance for the data warehouse and Operational Data Store (ODS), ensuring high standards of data integrity and quality. It also oversees the technical output and service delivery of the ministry’s outsourced DBA service provider to support operational excellence and high-performance infrastructure. The role is expected to reflect Answers in Genesis’ SERVE core values—Serve, Equip, Relate, Value, and Engage—and a service mindset focused on the ministry’s mission. It offers opportunities for spiritual, personal, and professional development.

Requirements

Must agree with and be able to sign the Answers in Genesis Statement of Faith.
Must maintain a personal relationship with Jesus Christ.
Must regularly attend a local Bible-believing church.
Bachelor’s degree in computer science, MIS, or a related discipline, or equivalent relevant professional experience.
Approximately 5–7 years of relevant professional experience in database engineering, database development, business intelligence, or closely related technical roles.
Strong hands-on experience with Microsoft SQL Server, including recent enterprise versions, and advanced T-SQL development.
Proficiency in relational database design, E/R modeling, indexing, query optimization, and execution-plan analysis.
Proven experience designing and supporting production ETL processes, preferably SSIS, and implementing data-quality, validation, and reconciliation controls in a data warehouse environment.
Experience with SQL Server Data Tools (SSDT) and appropriate database development and deployment tooling.
Experience developing BI solutions using Power BI and SSRS; proficiency developing SSAS Tabular Models and DAX.
Expert knowledge of dimensional data modeling and data warehouse concepts.
Ability to work independently, manage multiple technical priorities, communicate clearly with technical and business stakeholders, and take ownership of assigned technical outcomes.

Nice To Haves

Experience working with third-party or managed DBA services, including the ability to review and challenge technical work and recommendations.

Responsibilities

Promote the mission and standards of Answers in Genesis.
Create a SERVE-culture environment in all work and approach tasks with a second-mile mindset.
Prioritize personal integrity in all interactions and assignments.
Design, develop, maintain, and optimize database solutions, primarily using Microsoft SQL Server.
Write and tune complex T-SQL; analyze execution plans, indexing, query performance, and database design to improve reliability and performance.
Design and maintain relational and dimensional data models supporting operational systems, reporting, analytics, and self-service BI.
Design and maintain resilient SSIS and T-SQL ETL processes to integrate source data into the ODS and data warehouse, with advanced error handling and logging.
Govern the data warehouse and ODS by setting and enforcing standards for data definitions, lineage, access, and change management.
Implement validation, reconciliation, and monitoring to maintain data accuracy, completeness, and consistency.
Develop and support BI solutions using Power BI, SSRS, SSAS Tabular Models, DAX, and related Microsoft data tools.
Apply appropriate dimensional modeling practices, including Kimball methodology, where suited to analytical solutions.
Troubleshoot database, ETL, and BI issues and perform hands-on technical analysis through resolution.
Optimize in-house and third-party database applications in collaboration with application owners, developers, vendors, and business analysts.
Work directly with business stakeholders to understand reporting and data requirements and translate them into technical solutions.
Maintain technical documentation for database designs, data models, ETL, BI solutions, standards, and operational procedures.
Provide technical oversight of the outsourced DBA service, including reviewing work, validating technical quality and completeness, monitoring service delivery, and ensuring issues and recommendations are addressed.
Support database platforms other than SQL Server as required, working with internal teams or specialist vendors.
Perform other duties and responsibilities assigned by management.