Carthage System - Professional Swine Management LLC · 14 hours ago
Business Intelligence & Data Specialist
United States
Full-time
Remote
Mid Level
3+ years expCarthage System is seeking a Business Intelligence & Data Solutions Specialist responsible for developing, maintaining, and enhancing business intelligence reporting and automated data solutions. This role focuses on transforming data into actionable insights and improving reporting performance while collaborating with internal stakeholders.
ConsultingFarmers MarketFood and Beverage
Responsibilities
Design, develop, and maintain Power BI reports and dashboards with an emphasis on accuracy, performance, and end-user experience
Build, manage, and optimize data pipelines within Microsoft Fabric to ensure clean, accurate, and timely data delivery
Write, test, and optimize SQL queries to support reporting, integrations, and ETL processes
Develop, maintain, and monitor automated workflows using Power Automate, including:
Data refresh and process automation
Scheduled notifications and alerts
Approval workflows and business process automation
Integration with Microsoft 365 applications (SharePoint, Teams, Outlook, Forms, Dataverse)
Collaborate with analysts, business owners, and cross-functional partners to gather requirements and translate business needs into scalable BI and automation solutions
Establish and follow best practices for data modeling, governance, documentation, version control, and performance optimization
Troubleshoot and resolve issues related to data pipelines, SQL transformations, Power BI reports, and Power Automate workflows
Research and evaluate new tools and technologies to continuously improve analytics and automation capabilities within the organization
Perform other related duties as assigned
Qualification
Required
Advanced experience with Power BI, including DAX, data modeling, row-level security, and performance tuning
Hands-on experience with Microsoft Fabric, including Lakehouses or dataflows
Strong SQL skills, including writing and optimizing complex queries using joins, CTEs, indexing, and query tuning techniques
Proficiency in Power Automate, including building cloud, approval, and scheduled flows from the ground up
Ability to integrate workflows across Microsoft 365 applications
Strong analytical, problem-solving, and troubleshooting skills
Ability to communicate technical concepts clearly to non-technical stakeholders
Strong organizational skills with the ability to manage multiple priorities and deadlines
Ability to work independently in a self-directed environment while maintaining strong collaboration with team members
Minimum of three (3) years of experience in business intelligence, data engineering, analytics, or automation-related roles
Ability to sit for extended periods of time while working at a computer
Ability to communicate effectively via phone, video conferencing, and written correspondence
Ability to manage multiple tasks, meet deadlines, and perform effectively in a fast-paced, deadline-driven environment
Ability to adapt to changing priorities and business needs
Preferred
Knowledge of data warehousing concepts and modern data architecture
Experience with Azure data and analytics tools
Understanding of API integrations and custom connectors in Power Automate
Company
Carthage System - Professional Swine Management LLC
The Carthage System is a collective group of individual farm families throughout the Midwest linked together through the common goal of optimizing health, genetic performance, and cost of production throughout the value chain.
501-1000 employees
Funding
Current Stage
Late StageLeadership Team
Shaun McGinn
Chief Operating Officer
Twyla Stevens
Chief Human Resources Officer
Company data provided by crunchbase