Sr. BI Developer - Finance & Accounting

LJA 2025; Houston, Katy (TX, TX); On-site; USD 120,000 - 170,000; Full time

Job summary

LJA 2025 in Houston, TX seeks a Sr. BI Developer to design, publish, and govern Power BI semantic models for Finance and Accounting. You will rely on MS SQL, DAX, and data transformations to deliver reliable insights and scalable reporting.

You will mentor report builders, enforce visualization standards, and independently solve complex data challenges while supporting cross-functional stakeholders.

Qualifications

• 10+ years of relevant work experience in BI, 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

Responsibilities

• Writing SQL queries to transform and consolidate Finance and Accounting data from multiple operational databases
• 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
• Teaching DAX, visualization best practices, and workspace administration to report builders
• Performing other finance systems, reporting, data, or accounting system duties as warranted or directed

Skills

Power BI

DAX

Semantic models

Workspace administration

MS SQL

Data transformation

Financial reporting

Analytical thinking

Education

Bachelor’s degree in accounting, finance, information systems, data analytics, or related field

Tools

Microsoft Azure

Microsoft Fabric

Data lake

Data warehouse

Job description

POSITION OVERVIEW: The Sr. BI Developerwill 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:

• 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

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.