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.