Business Intelligence Developer

Description About Dean Dorton

Dean Dorton is a leading professional services firm spanning certified public accounting, business advisory, and technology solutions. We are your partners in redefining success through innovation and data-driven strategies. Our experts provide an integrated suite of audit, tax, business management, consulting and technology solutions to companies both domestic and international. We help our clients strategize, adapt, and change in every stage of business, from startup and growth to succession planning and everything in between.

The Reporting team serves as the foundation for firm-wide data strategy, reporting, and analytics. This team designs and maintains the infrastructure that enables accurate, timely, and actionable insights across service lines and internal operations. By leveraging modern cloud platforms, data warehousing strategies, and visualization tools, we empower leaders to make informed decisions that drive growth, performance, and operational excellence.

The Business Intelligence Developer plays a key role in designing, building, and maintaining modern data solutions that support strategic decision-making across the firm. This role focuses on developing scalable data pipelines, enterprise data models, and insightful dashboards using Microsoft Power BI, Azure Data Factory, Microsoft Fabric, and related technologies.

This position partners closely with internal stakeholders to translate business needs into technical solutions while ensuring data accuracy, accessibility, and performance.

This role may not be for you:
If you prefer narrowly defined tasks without cross‑functional collaboration, this role may feel limiting. If you are uncomfortable translating ambiguous business questions into structured data solutions, or if you prefer maintaining existing reports rather than building new, scalable analytics frameworks, this role may not align with your strengths. This position requires curiosity, adaptability, and a strong ownership mindset in a fast‑evolving data environment.

This role may be for you:
If you enjoy building end‑to‑end data solutions that influence strategic decisions, this role provides meaningful impact. If you are energized by transforming raw data into clear, actionable insights and collaborating with leaders to improve reporting visibility, you will thrive here. This role is ideal for someone who enjoys solving complex data challenges, optimizing performance, and continuously improving analytics capabilities across the firm.

• Design and implement end‑to‑end data solutions using Microsoft Power BI, Azure Data Factory, Microsoft Fabric, and modern data warehousing techniques.
• Develop, deploy, and maintain Power BI reports and dashboards that provide actionable and strategic insights.
• Build and optimize scalable data pipelines for integration, transformation, and automation of data movement.
• Design and maintain enterprise‑level data models and data warehouse structures that support reporting and analytics initiatives.
• Utilize SQL, DAX, Power Query, and advanced analytical functions to enhance reporting capabilities.
• Monitor data quality, performance, and system reliability, proactively identifying and resolving issues.
• Deliver ad hoc analyses and dashboards to support business initiatives and leadership requests.
• Provide technical support and guidance to team members regarding BI tools and data strategy.

• Collaborate effectively with cross‑functional stakeholders to translate business requirements into technical solutions.
• Communicate complex technical concepts in a clear and understandable manner to non‑technical audiences.
• Demonstrate strong analytical thinking and structured problem‑solving skills.
• Manage multiple priorities and projects while maintaining high standards of quality and accuracy.
• Display accountability and ownership for data integrity and solution delivery.
• Adapt to evolving technology and business needs in a dynamic environment.

• Participate in internal initiatives to improve reporting frameworks and data governance practices.
• Contribute to the…