BI DATA ENGINEER

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

Job summary

Moore & Van Allen PLLC in Charlotte, NC seeks a BI/Data Engineer to design and maintain the firm's data infrastructure, pipelines, and analytics platform within Microsoft Fabric. You will integrate on-prem and cloud financial systems and enable trusted, automated reporting.

Collaborate with Finance Systems, FP&A, IT, and BI teams to deliver scalable data solutions, ensure data governance and security, and optimize performance for dashboards and strategic decision-making.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field.
• 3–5+ years of experience in Data Engineering, BI, 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 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 cross-functional collaboration.

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 environment.
• Optimize data pipelines, queries, and architecture for scalability, reliability, and performance.
• Monitor and troubleshoot production data processes and pipeline issues.
• Partner with Finance Systems and BI teams to translate requirements into technical solutions.
• Ensure high-quality, trusted data for dashboards, analytics, and reporting.
• Support migration of legacy reporting and integration processes into Microsoft Fabric.

Skills

SQL Development

ETL/ELT

Data Modeling

Data Warehousing

Data Governance

CI/CD

Stakeholder Collaboration

Technical Documentation

Education

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

Tools

Microsoft Fabric

Microsoft Azure

Power BI

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.