Senior BI/Data Engineer

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.

Requirements

• 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.

Items Needed for Possible Employment

• Completion of on-line application, https://answersingenesis.org   
• Salary Requirements 
• Salvation Testimony  
• Creation Belief Statement 
• Confirmation of your agreement with the AiG Statement of Faith (AiG Statement of Faith can be found on the website).  https://answersingenesis.org/about/faith/
• Completion of a Background Check and Pre-Employment Drug Screen