Job description

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 • Expertise with Power BI, DAX, semantic models, and workspace administration • Expertise with MS SQL, including query development, data transformation, consolidation, and troubleshooting across multiple databases IDEALLY, YOU SHOULD ALSO HAVE: • Strong understanding of Finance and Accounting processes, reporting needs, and operational database structures • Experience working with ERP, accounting, or project accounting systems and the underlying data structures that support financial and operational reporting • Familiarity with Microsoft Azure, Microsoft Fabric, data lake, data warehouse, or related cloud-based data platform concepts • Working knowledge of data governance practices, including data definitions, ownership, lineage, quality controls, and reporting consistency standards • Ability to evaluate data quality issues and recommend system or process improvements that improve reporting reliability • Superior verbal and written communication skills, including the ability to explain technical concepts to non-technical stakeholders • Strong analytical, logic-based problem-solving capabilities and the ability to work independently with minimal supervision • Ability to teach, coach, and support report builders on DAX, visualization standards, and Power BI workspace practices

Requirements

Must-haves

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
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
Expertise with Power BI, DAX, semantic models, and workspace administration
Expertise with MS SQL, including query development, data transformation, consolidation, and troubleshooting across multiple databases
Strong understanding of Finance and Accounting processes, reporting needs, and operational database structures
Experience working with ERP, accounting, or project accounting systems and the underlying data structures that support financial and operational reporting
Familiarity with Microsoft Azure, Microsoft Fabric, data lake, data warehouse, or related cloud-based data platform concepts
Working knowledge of data governance practices, including data definitions, ownership, lineage, quality controls, and reporting consistency standards

Nice-to-haves

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

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlazure

Platform: ukg
Effort: medium

Benefits

Benefits detected in the listing.

Vision