About This Role
Developing, deploying, and supporting Power BI reports, semantic models, and business automation solutions are the core functions of this role. The Business Intelligence Developer will help the company use operational data more effectively by working hands-on within real operational and enterprise-system constraints, utilizing strong SQL and backend development skills to deliver reliable data from source systems.
Responsibilities
- Design, build, test, deploy, and support Power BI reports, dashboards, semantic models, and datasets that support operational and strategic decision-making
- Develop clear data models, relationships, reusable DAX measures, and consistent business definitions so reporting remains accurate, understandable, and maintainable
- Use Power Query and SQL to connect, clean, combine, transform, and validate data from ERP, Excel, Microsoft 365, and other business systems
- Build and improve Excel-based tools when Excel is the right solution, including structured tables, PivotTables, Power Query, Power Pivot, formulas, and validation controls
- Use Power Automate to reduce manual work through scheduled workflows, approvals, notifications, file processing, and practical integrations; monitor and troubleshoot failures
- Work directly with the Business Transformation team and business users to understand processes, define requirements and measures, validate results, explain tradeoffs, and improve solutions through feedback
- Support the Power BI Service lifecycle, including workspaces, access, refresh schedules, gateways, deployment, performance, usage, and production monitoring
- Investigate data discrepancies, refresh failures, report-performance issues, automation failures, and user-reported problems; identify root causes and own resolution after deployment
- Use testing, review, release, documentation, and knowledge-sharing practices that make reports and automations understandable and supportable by others
- Collaborate with the Data Engineer and Application Developer for data integration efforts
Requirements
- Bachelor's degree in a relevant technical field or an equivalent combination of education and demonstrated professional experience
- Three or more years developing, implementing, or supporting production business intelligence, reporting, analytics, or automation solutions
- Experience working with ERP, operational, sales, inventory, purchasing, financial, warehouse, or supply-chain data
- Strong Power BI skills, including reports, semantic models, relationships, DAX measures, and visual design
- Experience using Power Query in Power BI and Excel to transform, combine, and validate data
- Working knowledge of relational data concepts and SQL
- Experience building or supporting Power Automate cloud flows and Microsoft 365 integrations