Business Intelligence Architect

Business Intelligence Architect

Galvion designs, develops, and manufactures ballistic helmets and dynamic power and data management solutions for the modern battlefield. We are a passionate, global, and fast-paced team collaborating with several strategic partners and are committed to enhancing the overall agility and survivability of the modern warfighter and tactical operator.

The Opportunity

The Business Intelligence Architect has a strong background in Power BI, SQL, ETL development, Azure Data Lake, and secure cloud data architectures. The Architect/developer will have hands-on experience with Azure infrastructure—including RBAC, Key Vault, sensitivity labeling, and Medallion architecture—as well as Gov Cloud and GCC High tenant environments. Tier 1 or Tier 2 ERP experience required in a manufacturing setting and experience with Infor Syteline CSI Cloud ERP, Factory Track MES, and manufacturing data flows is a plus. Familiarity with compliance frameworks such as CMMC and NIST 800-171 is an added bonus.

What You Will Be Doing

• Design, develop, and maintain Power BI dashboards, datasets, and data models
• Develop ETL/ELT pipelines to support analytics, operational reporting, and secure data movement
• Build and optimize SQL queries, stored procedures, and data transformations
• Develop solutions leveraging Azure Data Lake with Medallion architecture (Bronze/Silver/Gold)
• Implement RBAC, sensitivity labels, and Key Vault for secure data access and credential management
• Operate within Gov Cloud and GCC High environments ensuring compliance with CMMC and NIST 800-171
• Integrate data between Infor Syteline CSI Cloud ERP, Factory Track MES, and other systems
• Collaborate closely with business functions—including operations, engineering, IT, quality, and finance
• Maintain data governance, documentation, and data quality standards
• Support manufacturing intelligence initiatives across multiple sites

What You Will Need To Succeed

• 5–10 years of experience in Business Intelligence, Data Engineering, or Data Analytics
• Expert-level experience with Power BI (DAX, Power Query, data modeling, row-level security)
• Advanced SQL experience with large datasets and complex joins
• Hands-on experience with Azure Data Lake, Azure AD, RBAC, and Key Vault
• Experience implementing Medallion data architecture (Bronze/Silver/Gold layers)
• ETL tool experience (e.g., Azure Data Factory, SSIS, Talend, Informatica)
• Tier 1 or Tier 2 ERP experience (Oracle, SAP, Infor)
• Experience with ERP/MES data structures, supply chain systems, and quality systems
• Manufacturing industry experience required
• Experience working with secure data labeling, classification, and audit requirements
• Manufacturing Data & Process Understanding
• U.S. Citizenship required (no sponsorship available)

Preferred Skills

• Experience working in Azure Gov Cloud or GCC High tenant environment
• Strong understanding of CMMC Level 2 and NIST 800-171 data and security requirements.
• CMMC Level 2 / NIST 800-171 compliance awareness
• Infor Syteline CSI Cloud ERP
• Factory Track MES
• Experience with Boomi or similar integration tools
• Understanding of CI/CD processes using Azure DevOps or equivalent tools

Galvion provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. Galvion complies with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.