Galvion

Business Intelligence Architect

Galvion

full-time

Posted on:

Location Type: Hybrid

Location: Portsmouth • New Hampshire • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AzureCloudERPETLInformaticaOracleSQLSSISVault

About the role

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

Requirements

  • 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
  • U.S. Citizenship required (no sponsorship available).
Benefits
  • 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.
  • Compliance with applicable state and local laws governing non-discrimination in employment in every location in which the company has facilities.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Power BIDAXPower Querydata modelingSQLETLELTdata transformationsAzure Data LakeMedallion architecture
Soft Skills
collaborationcommunicationdata governancedocumentationdata quality management