Business Intelligence Developer

AIB International, Inc; Manhattan (KS); On-site; USD 70,000 - 100,000; Full time

Job summary

AIB International, Inc is seeking a BI Developer to build and maintain BI solutions that support internal operations and client reporting. You will query source systems, maintain pipelines, and develop Power BI dashboards and client reports.

This role collaborates with the Manager, Business Intelligence to expand Databricks and Azure platform usage, while ensuring data quality, documentation, and timely delivery of dashboards and ad hoc reports to stakeholders.

Qualifications

• Proficient in SQL with ability to query relational databases independently.
• Working knowledge of Python and pandas for data manipulation.
• Able to design and deliver Power BI dashboards and client reports.
• Detail-oriented with strong analytical and data-visualization skills.
• Experience building reports and dashboards for internal and external stakeholders.

Responsibilities

• Design, build, and maintain Power BI dashboards and reports for internal and external clients.
• Write SQL and Python/pandas to query databases and pull data from APIs.
• Own production delivery of ad hoc client reports in Excel and PowerPoint.
• Monitor Databricks notebook jobs and coordinate issue resolution.
• Support automated data pipelines to reduce manual Excel reporting.
• Maintain documentation, data dictionaries, and user guides.
• Collaborate with BI team on QA and distribution workflows.
• Grow familiarity with Azure Data Lake Storage Gen2 and Databricks.

Skills

SQL

Python

Pandas

Attention to detail

Data storytelling

Education

Bachelor's degree in a related field

Tools

Power BI

Excel

PowerPoint

Databricks

Azure (ADLS Gen2)

Job description

AIB International is a global leader in food safety and quality professional services, including training, consulting, certification and inspection. We are committed to supporting the food industry through expert guidance, innovation, and a deep understanding of global safety regulations.

Description of Job Function:

The BI Developer is a technical role responsible for building and maintaining business intelligence solutions that support internal operations and external client reporting. This role sits at the intersection of data preparation and reporting delivery — querying source systems, maintaining automated pipelines, and developing Power BI dashboards and client-facing reports. The BI Developer works closely with the Manager, Business Intelligence and will collaborate on data infrastructure projects as the team expands its Databricks and Azure platform footprint.

Responsibilities:

• Design, build, and maintain Power BI dashboards and reports for internal stakeholders and external clients via the company BI portal
• Write SQL and Python/pandas scripts to query operational databases and pull data from APIs including Salesforce
• Own the production and delivery of ad hoc client reports in Excel and PowerPoint
• Monitor and maintain Databricks notebook jobs, identify failures, and coordinate resolution
• Support the development of automated data pipelines, working toward reducing manual Excel-based reporting
• Maintain report documentation, data dictionaries, and end user guides
• Participate in BI-related meetings and contribute to project intake and prioritization
• Collaborate with the Analyst, Business Intelligence on report QA and distribution workflows
• Grow familiarity with Azure Data Lake Storage Gen2 and Databricks as the team expands platform use

Qualifications

Required:

• 2 to 4 years of experience in a BI, reporting, or data analyst role
• Bachelor's degree in a related field
• Proficiency in SQL — comfortable querying relational databases independently
• Able to query relational databases (SQL) and transform data with Python
• Working knowledge of Python, particularly pandas for data manipulation
• Experience building reports and dashboards in Power BI
• Familiarity with Excel and PowerPoint for client-facing deliverables
• Ability to troubleshoot data issues and pipeline failures with moderate supervision
• Strong attention to detail and comfort working with structured data

Preferred:

• Experience with Azure cloud services, particularly ADLS Gen2 or Azure Databricks
• Exposure to REST API data pulls or Salesforce reporting
• Familiarity with Power BI embedded reporting or the Power BI service
• Experience working in a BI team supporting external client.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.