Sr. BI Developer - Finance & Accounting

POSITION OVERVIEW: The Sr. BI Developer will be responsible for creating and supporting a self-service reporting model for Finance and Accounting. This role will use SQL queries to transform and consolidate information from multiple operational databases, publish cleaned data as semantic models in Power BI, and support downstream report builders with guidance on DAX, visualization best practices, and workspace administration. As a senior-level role, this position is expected to operate independently with minimal supervision.

A TYPICAL DAY MIGHT INCLUDE:Self-Service Reporting Model Development

• Writing SQL queries to transform and consolidate Finance and Accounting data from multiple operational databases

• Analyzing complex data scenarios and trace data through systems to understand sources, dependencies, and downstream reporting impacts

• Understanding the meaning behind the data and how it can be used to create reliable business insights

• Identifying opportunities to improve data quality through system design, process improvement, and reporting model structure

Power BI Semantic Model Publishing and Administration

• Developing, publishing, and supporting semantic models through Power BI workspaces

• Supporting workspace administration, data model organization, and downstream report development standards

• Communicating how semantic models should be used to develop business insights and consistent reporting outputs

Training, Communication, and Independent Problem Solving

• Teaching DAX, visualization best practices, and workspace administration to report builders

• Communicating technical concepts to non-technical stakeholders

• Applying a high level of attention to detail and logic-based problem solving when reviewing, building, and supporting reporting solutions

• Performing other finance systems, reporting, data, or accounting system duties as warranted or directed

PREFERRED EDUCATION/LICENSE/CERTIFICATIONS:

• Bachelor’s degree in accounting, finance, information systems, data analytics, business administration, or a related field preferred

• Relevant Microsoft, Power BI, SQL, data analytics, or reporting certifications are preferred

REQUIRED QUALIFICATIONS:

• 10+ years of relevant work experience in business intelligence, data analytics, finance systems, accounting systems, financial reporting, or related roles

• Expertise with accounting data, particularly financial reporting and project accounting data