Senior BI/Data Engineer

Answers In Genesis Group; Erlanger (KY); On-site; USD 110,000 - 140,000; Full time

Job summary

Answers In Genesis Group in Erlanger, KY seeks a hands-on database/BI engineer to design, develop, and optimize SQL Server-based solutions, govern data warehouse and ODS, and oversee outsourced DBA service.

This role partners with stakeholders to deliver reliable analytics via Power BI, SSRS, SSAS, and T-SQL, ensuring data quality and performance, with responsibilities spanning ETL, modeling, and documentation.

Qualifications

• Must agree with and sign Statement of Faith.
• Must maintain personal relationship with Jesus Christ.
• Regular church attendance at a Bible-believing church.
• Bachelor’s degree in computer science, MIS, or related discipline (or equivalent experience).
• 5–7 years of database engineering/BI experience.
• Strong hands-on SQL Server and advanced T-SQL skills.
• Relational design, E/R modeling, indexing, query optimization.
• Experience building production ETL processes (SSIS preferred).
• Experience with Power BI, SSRS, SSAS; DAX knowledge.
• Dimensional modeling and data warehouse concepts.

Responsibilities

• Promote the mission and standards of Answers in Genesis.
• Create a SERVE culture in all work.
• Design, develop, and optimize SQL Server database solutions.
• Tune complex T‑SQL; analyze execution plans and performance.
• Develop and support BI solutions with Power BI, SSRS, SSAS, and DAX.
• Govern data warehouse and ODS; enforce data definitions and change management.
• Oversee outsourced DBA service quality and delivery.
• Collaborate with stakeholders to translate requirements into technical solutions.

Skills

MS SQL Server

T-SQL

Data modeling

ETL design

Power BI

SSRS/SSAS

Data warehousing

Performance tuning

Documentation

Stakeholder communication

Education

B.S. in CS or MIS

Tools

SSDT

SSRS

SSAS

DAX

Job description

Job Details: Job Location: Answers in Genesis HQ - Erlanger, KY 41018, Position Type: Full Time, Job Category: Technology, 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 the highest standards of data integrity and quality. Additionally, this role oversees the technical output and service delivery of the ministry’s outsourced DBA service provider to ensure operational excellence and high-performance infrastructure.

This position will allow one to impact others through a service mindset centered on making an eternal difference. This position should display our Core Values of SERVE (Serve, Equip, Relate, Value, Engage) when interfacing with both internal and external customers to ensure that the message and mission of Answers in Genesis is portrayed in an effective and God-honoring fashion. This position provides opportunities for spiritual, personal, and professional development.

Responsibilities

• Promote the mission and standards of Answers in Genesis.
• Create a SERVE culture environment in all work done.
• Approach all tasks with a second mile mindset.
• Prioritize personal integrity in all interactions and assignments.
• Design, develop, maintain, and optimize database solutions, with primary emphasis on 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, incorporating advanced error handling and logging to ensure data reliability and rapid recovery.
• Govern the data warehouse and ODS by setting and enforcing standards for data definitions, lineage, access, and change management. Put validation, reconciliation, and monitoring in place to keep data accurate, complete, and consistent.
• 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, were 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 effective technical solutions.
• Maintain clear 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 performed, validating technical quality and completeness, monitoring service delivery, and ensuring issues and recommendations are appropriately addressed.
• Support database platforms other than SQL Server as required, working with internal teams or specialist vendors where appropriate.
• And all other duties and responsibilities assigned by management.

Qualifications

• Must agree with and be able to sign our Statement of Faith.
• Maintains a personal relationship with Jesus Christ.
• Regularly attends a local Bible‑believing church.
• Bachelor’s degree in computer science, MIS, 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.
• Proficient in relational database design, E/R modeling, indexing, query optimization, and execution‑plan analysis.
• Proven experience designing and supporting production ETL processes (SSIS preferred) and putting data quality, validation, and reconciliation controls in place 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; proficient in developing SSAS Tabular Models and DAX.
• Expert knowledge of dimensional data modeling and data warehouse concepts.
• Experience working with third‑party or managed DBA services is preferred, including the ability to review and challenge technical work and recommendations.
• Ability to work independently, manage multiple technical priorities, communicate clearly with technical and business stakeholders, and take ownership of assigned technical outcomes.

Education & Experience

Technical Environment

• Primary platform: Microsoft SQL Server.
• BI/Data Tools: Power BI, SSRS, SSAS Tabular, DAX, SSDT.