Position Summary

Triumph Foods is seeking a Junior Business Intelligence Developer to serve as the technical execution lead for the company’s enterprise data analytics and operational intelligence initiative. This position bridges the gap between business intelligence strategy and technical implementation, building and maintaining the data pipelines, automated workflows, database structures, and reporting tools that transform raw operational data into actionable executive intelligence.

The role sits within the Business Support department, which provides financial analysis, organizational development, and purchasing services to the organization. A functional dotted-line relationship with the IT department ensures alignment on infrastructure, security, and network requirements. The successful candidate will work closely with executive leadership, which has designed the analytical frameworks and automated content workflows this role brings to life.

Core Responsibilities

Data Pipeline Development and Automation

• Design, build, and maintain Power Automate flows that collect, route, and process operational data from multiple sources including email attachments, SharePoint libraries, and external APIs.
• Develop and manage custom connectors to integrate the enterprise analytics platform APIs and USDA Agricultural Marketing Service report endpoints with the Triumph Foods Microsoft 365 environment.
• Automate the daily ingestion of production reports (kill floor, cut floor, boning operations, value-added processing) from email sources into structured SharePoint storage with consistent naming conventions and error handling.
• Build scheduled data collection workflows that pull market intelligence data from USDA AMS APIs (reports LM_HG201, LM_HG200, LM_PK602) at daily, weekly, and monthly intervals.

Database Design and Management

• Design and maintain SQL Server or Azure SQL database structures to support long-term storage of production metrics, market data, and operational intelligence.
• Write and optimize SQL queries, stored procedures, and views that support reporting, trend analysis, and data validation requirements.
• Manage data migration from Excel-based storage to SQL database backends as data volumes and concurrent access needs increase.
• Ensure data integrity, implement backup procedures, and maintain documentation of all database schemas and relationships.

Reporting and Visualization

• Develop and maintain Power BI or Tableau dashboards that present production performance, market intelligence, and operational KPIs to executive leadership.
• Create calculated fields, rolling averages, seasonal comparisons, and year-over-year trend visualizations for commodity market analysis.
• Design and implement data refresh schedules that ensure dashboards reflect current operational data.
• Produce ad hoc reports and data extracts as requested by executive leadership, operations, and finance.

Enterprise Platform Administration

• Support the deployment and maintenance of enterprise analytics platforms, including M365 Connector activation, SharePoint integration, and API key management.
• Build and test custom connectors for platform-to-external-system integrations as directed by technical specifications.
• Assist in encoding business analysis frameworks into platform workflow specifications by translating analytical logic into structured, repeatable processes.
• Maintain compliance with the Data Governance Policy, including data classification requirements, prompt audit logging, and incident reporting procedures.

Cross-Functional Collaboration

• Partner with the IT department on infrastructure requirements including network whitelisting, credential storage, Entra ID configuration, and security reviews.
• Work with executive leadership and department heads to translate content production workflows into automated technical processes.
• Support financial analysis and purchasing teams with data extraction, reporting, and process automation needs.
• Document all technical specifications, flow designs, and database schemas to a level of detail that allows independent review, audit, and handoff.

 

Required Qualifications

• Associate’s or bachelor’s degree in computer science, information technology, data analytics, management information systems, or a related field; or equivalent practical experience.
• Proficiency in SQL (T-SQL