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.
About the Team
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.
About the Role
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.
|
Essential Duties & Responsibilities
The essential duties & responsibilities of the Business Intelligence Developer role are outlined below in correlation with Dean Dorton’s performance management impact areas.
Technical
Definition: your specialized knowledge & expertise associated with the work you perform for/with clients (note: clients may be internal to Dean Dorton).
- 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.
Behavioral
Definition: the behaviors associated with performing your job (interpersonal skills).
- 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.
Non-Charge
Definition: the contribution you make to Dean Dorton outside of client work.
- Participate in internal initiatives to improve reporting frameworks and data governance practices.
- Contribute to the development of firm-wide data strategy and modernization efforts.
- Assist in evaluating emerging tools and technologies to enhance reporting capabilities.
- Support training and knowledge sharing related to BI tools and best practices.
- Commit to continuous learning and professional development in cloud data and analytics technologies.
Experience & Qualifications
- Bachelor’s degree in Computer Science, Engineering, Information Technology, or related field required.
- Minimum of two (2) years of experience in Business Intelligence development.
- Demonstrated experience with Microsoft Power BI, Azure Data Factory, and Microsoft Fabric.
- Strong understanding of SQL, data modeling, ETL processes, and data warehousing design principles.
- Experience working with Azure cloud services in a data management environment.
- Strong analytical, problem-solving, and communication skills.
Software & Tools
- Microsoft Power BI, including DAX and Power Query
- Microsoft Fabric
- Azure Data Factory
- SQL, including T-SQL
- Data modeling and data warehousing technologies
- Microsoft Azure data services
- ETL and data orchestration tools
- Microsoft 365, including Excel, Teams, and SharePoint
This job description is intended to describe the general nature and level of work being performed by team members assigned to this position. It is not intended to be an exhaustive list of all responsibilities, duties, and skills required. Additionally, responsibilities and duties may vary depending on business needs and individual circumstances. Dean Dorton is an equal opportunity employer.
We do not accept unsolicited resumes or candidate submissions from staffing agencies, recruiters, or search firms. Any resumes or candidate information submitted without a current, signed agreement in place will be considered unsolicited, become the property of the company, and will not obligate the company to pay any fees or commissions.