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 the ministry. 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 centers on serving others and supporting the mission of Answers in Genesis. The position is expected to demonstrate the organization’s SERVE Core Values—Serve, Equip, Relate, Value, and Engage—in interactions with internal and external customers, and to represent the message and mission in an effective and God-honoring manner. The role offers opportunities for spiritual, personal, and professional development.

Requirements

Must agree with and be able to sign the Answers in Genesis Statement of Faith.
Maintain a personal relationship with Jesus Christ.
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 with 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 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 in all work performed.
Approach tasks with a second-mile mindset and prioritize personal integrity.
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 for operational systems, reporting, analytics, and self-service BI.
Design and maintain resilient SSIS and T-SQL ETL processes that integrate source data into the ODS and data warehouse, with error handling and logging for data reliability and recovery.
Govern the data warehouse and ODS by establishing 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 conduct 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 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 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 where appropriate.
Perform other duties and responsibilities assigned by management.