Ascension LLC is seeking a Data Engineer / Integration Specialist to support the American Battle Monuments Commission (ABMC) in transforming fragmented, stovepiped data into a unified, enterprise-level Business Intelligence (BI) ecosystem. This role is critical to enabling ABMC’s mission to manage globally dispersed cemeteries and memorial sites through data-driven decision-making.

The ideal candidate is a technically strong, mission-focused professional who thrives in data transformation, integration, and structuring efforts, and can bridge the gap between raw operational data and actionable intelligence. This individual will play a key role in designing data pipelines, standardizing data structures, and enabling Power BI dashboards that provide real-time insights across global operations.

This role is essential because over 60% of the effort involves building a common data framework to support BI capabilities , making this position foundational to the success of the entire initiative.

Position Summary

The Data Engineer / Integration Specialist will support enterprise data modernization efforts by transforming, integrating, and structuring disparate data sources into formats consumable by BI tools such as Power BI. The role requires strong expertise in ETL processes, data modeling, SharePoint/Excel data structuring, and Microsoft-based environments.

The ideal candidate is:

• Detail-oriented and highly analytical
• Self-driven and capable of working in ambiguous environments
• Skilled at translating business needs into data solutions
• Experienced in integrating structured and unstructured data sources
• Comfortable engaging with stakeholders to understand data requirements

This role will directly support ABMC’s need to:

• Consolidate fragmented data sources
• Improve data accessibility and usability
• Enable real-time BI dashboards for operational decision-making
• Establish sustainable, user-friendly data frameworks

Day-to-Day Activities

• Analyze existing data sources (SharePoint, Excel, Access, Oracle outputs) to assess structure, quality, and usability
• Design and implement ETL processes to transform raw data into BI-ready formats
• Integrate data from disparate systems into a unified data architecture
• Develop data models and schemas to support dashboard development and analytics
• Standardize data formats to ensure consistency across functional domains (personnel, facilities, horticulture, etc.)
• Collaborate with business analysts and stakeholders to define data requirements and KPIs
• Cleanse and validate data to ensure accuracy and reliability for reporting
• Support Power BI dashboard development by providing structured and optimized datasets
• Document data sources, transformation logic, and integration workflows
• Recommend improvements to data governance, accessibility, and architecture
• Assist in establishing data pipelines that can be maintained by non-technical users
• Participate in stakeholder workshops to identify and capture data needs