BI DATA ENGINEER

Job Description

Job Description

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:

Data Engineering & Platform Development

• 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.

Innovation & Continuous Improvement

• 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:

• Data Engineering & Pipeline Development
• Microsoft Fabric & Cloud Data Platforms
• Data Modeling & Data Warehousing
• Financial Systems Integration
• SQL Development & Query Optimization
• Data Governance & Security
• Process Automation
• Performance Tuning & Reliability Engineering
• Stakeholder Collaboration
• Technical Documentation & Standards
• Continuous Improvement & Innovation

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.

Interested and qualified applicants should apply via our website at -working-at-mva. Equal Employment Opportunity Employer.

Applicant Disclosures

Family Medical Leave Act Employer: For more information, visit Employee Rights Under the Family and Medical Leave Act

Employee Polygraph Protection Act: For more information, visit Employee Polygraph Protection Act

Employee Rights Under the Fair Labor Standards Act: For more information, visit Employee Rights Under the Fair Labor Standards Act

MVABOps