Sr. BI Developer - Finance & Accounting

LJA•Houston, TX

19d

About The Position

The Sr. BI Developer will create and support a self-service reporting model for Finance and Accounting. The role uses SQL to transform and consolidate information from multiple operational databases, publishes cleaned data as semantic models in Power BI, and supports downstream report builders with guidance on DAX, visualization best practices, and workspace administration. As a senior-level role, it is expected to operate independently with minimal supervision. The position develops and administers Power BI semantic models and workspaces, helps establish data model organization and downstream report development standards, and communicates how semantic models can be used to produce reliable business insights and consistent reporting. It also involves analyzing complex data scenarios and tracing data through systems to understand sources, dependencies, and reporting impacts; identifying opportunities to improve data quality; and teaching report builders. Other finance systems, reporting, data, or accounting system duties may be assigned as warranted or directed.

Requirements

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.

Nice To Haves

Bachelor’s degree in accounting, finance, information systems, data analytics, business administration, or a related field.
Relevant Microsoft, Power BI, SQL, data analytics, or reporting certifications.
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.

Responsibilities

Write SQL queries to transform and consolidate Finance and Accounting data from multiple operational databases.
Analyze complex data scenarios and trace data through systems to understand sources, dependencies, and downstream reporting impacts.
Understand data meaning and how it can support reliable business insights.
Identify opportunities to improve data quality through system design, process improvement, and reporting model structure.
Develop, publish, and support semantic models through Power BI workspaces.
Support workspace administration, data model organization, and downstream report development standards.
Communicate how semantic models should be used to develop business insights and consistent reporting outputs.
Teach DAX, visualization best practices, and workspace administration to report builders.
Communicate technical concepts to non-technical stakeholders.
Apply attention to detail and logic-based problem solving when reviewing, building, and supporting reporting solutions.
Perform other finance systems, reporting, data, or accounting system duties as warranted or directed.