BI DATA ENGINEER

Moore & Van Allen; Charlotte (NC); On-site; USD 110,000 - 150,000; Full time

Job summary

Moore & Van Allen in Charlotte, NC seeks a talented BI/Data Engineer to design, build, and maintain the firm's financial data infrastructure, integrating enterprise systems within a Microsoft Fabric environment.

You will partner with Finance, FP&A, IT, and BI teams to enable automated reporting and advanced analytics, supporting strategic decision-making across the organization.

Qualifications

• Bachelor's degree in CS/IS/Data Eng or related field.
• 3-5+ years of experience in Data Engineering, BI, or related roles.
• Hands-on experience with Microsoft Fabric and/or Azure data services.
• Strong SQL development and data warehouse design skills.
• Experience building ETL/ELT pipelines and data integration.

Responsibilities

• Design, build, and maintain enterprise data pipelines and ETL/ELT processes.
• Develop integrations between on-prem and cloud-based financial systems.
• Build and support the firm's financial data warehouse and Microsoft Fabric Lakehouse.
• Optimize data pipelines, queries, and architecture for scalability and performance.
• Monitor and troubleshoot production data processes and pipeline issues.
• Partner with Finance, FP&A, and BI teams to translate business requirements into technical solutions.
• Ensure high-quality, trusted data for dashboards, analytics, and reporting.
• Support migration of legacy reporting into the Microsoft Fabric platform.

Skills

SQL development

ETL/ELT pipelines

Data modeling

Data governance

Stakeholder collaboration

Analytics & reporting

Cloud data platforms

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field

Tools

Microsoft Fabric

Power BI

Azure data services

Job description

Career Opportunities with Moore & Van Allen

A great place to work.

Careers At Moore & Van Allen

Are you ready for new challenges and new opportunities?

Join our team!

Current job opportunities are posted here as they become available.

Subscribe to our RSS feeds to receive instant updates as new positions become available.

Moore & Van Allen PLLC, a dynamic and fast-growing full-service law firm of more than 400 attorneys and professionals, is seeking a talented BI/Data Engineer to join our growing team in our Charlotte, NC office. This position is responsible for developing and maintaining the firm's financial data infrastructure, building scalable data pipelines, integrating enterprise systems, and ensuring trusted, high-quality data is available for reporting, analytics, and business decision-making.

In this role, you will help drive the evolution of our data platform by integrating multiple financial and business systems into a Microsoft Fabric environment. Working closely with Finance Systems, FP&A, IT, Business Intelligence, and firm stakeholders, you will enable reliable, automated reporting and advanced analytics that support strategic decision-making across the organization.

What You'll Do:

• Design, build, and maintain enterprise data pipelines and ETL/ELT processes.
• Develop integrations between on-prem and cloud-based financial systems.
• Build and support the firm's financial data warehouse and Microsoft Fabric Lakehouse environment.
• Optimize data pipelines, queries, and architecture for scalability, reliability, and performance.
• Monitor and troubleshoot production data processes and pipeline issues.

Business Intelligence & Analytics Support

• Partner with Finance, FP&A, and Business Intelligence teams to translate business requirements into technical solutions.
• Ensure high-quality, trusted data is available for dashboards, analytics, and reporting.
• Support the migration of legacy reporting and integration processes into the Microsoft Fabric platform.
• Collaborate closely with Financial Systems and Power BI development teams to enable automated reporting and advanced analytics.

Data Governance & Security

• Implement and maintain data governance, security, and access controls.
• Ensure data quality, integrity, and consistency through automated validation and monitoring processes.
• Document data architectures, data flows, technical standards, and operational procedures.
• Partner with infrastructure, application, and security teams to ensure reliable and secure data services.
• Stay current on Microsoft Fabric capabilities and emerging technologies.
• Recommend enhancements that improve efficiency, scalability, and user experience across the firm's data ecosystem.

What We're Looking For:

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 3-5+ years of experience in Data Engineering, Business Intelligence, or related roles.
• Hands-on experience with Microsoft Fabric and/or Microsoft Azure data services.
• Strong SQL development and database design skills.
• Experience building and maintaining ETL/ELT pipelines.
• Experience working with relational databases and data warehouse architectures.
• Familiarity with source control, CI/CD, and automated deployment practices.
• Strong analytical, troubleshooting, and problem-solving abilities.
• Excellent communication skills and the ability to effectively collaborate with both technical and non-technical stakeholders.

Preferred Qualifications

• Enterprise implementation experience with Microsoft Fabric.
• Microsoft Fabric, Azure Data Engineer, or other relevant Microsoft certifications.
• Experience with Power BI semantic models and report performance optimization.
• Familiarity with financial systems such as Aderant, Elite 3E, SAP, Oracle, or similar ERP platforms.
• Experience within a professional services or law firm environment.
• Understanding of financial accounting, budgeting, profitability reporting, and related financial concepts.
• Knowledge of data governance, metadata management, and master data management practices.

Technical Skills:

The ideal candidate will demonstrate expertise in:

• Microsoft Fabric & Cloud Data Platforms
• Data Modeling & Data Warehousing
• SQL Development & Query Optimization
• Data Governance & Security
• Process Automation
• Performance Tuning & Reliability Engineering
• Stakeholder Collaboration
• Technical Documentation & Standards

Physical Requirements

• The work is primarily sedentary.
• It requires the ability to communicate effectively using speech, vision, and hearing.
• The work requires the use of hands for simple grasping and fine manipulations.
• The work at times requires bending, squatting, and reaching, with the ability to lift, carry, push, or pull light weights.

Why Join Us?

You’ll have the opportunity to make a meaningful impact by helping modernize the firm's data ecosystem and driving data-driven decision-making across the business. This role offers exposure to cutting-edge Microsoft technologies, close partnership with business leaders, and the chance to help shape the future of enterprise analytics.