Apply on Employer Site

True Homes · 2 hours ago

Data & BI Engineer

Monroe, NC

Full-time

Onsite

Senior Level

7+ years exp

True Homes is focused on shaping enterprise data strategy and architecture. The Data & Business Intelligence Engineer will be responsible for building and maintaining modern data solutions, ensuring data systems are scalable, reliable, and aligned with organizational goals.

ConstructionHome ImprovementHome RenovationHome Services

Growth Opportunities

Responsibilities

Design, develop, and maintain ETL/ELT pipelines using Azure Data Factory and Microsoft Fabric

Write, optimize, and support complex T-SQL queries, stored procedures, functions, and views, including performance tuning and advanced query optimization

Design and implement efficient, scalable, and secure database schemas to support modernization initiatives

Build and manage Azure SQL and related cloud-based data services

Monitor and improve data pipeline performance, reliability, and cost efficiency

Collaborate with subject matter experts, discipline and job function leaders, software engineers, business analysts, and data scientists to meet data requirements

Implement data governance and best practices for data quality, consistency, and security

Support data integration from external providers and internal applications

Document data flows, schemas, and processes in a professional and timely manner

Design and optimize data models, schemas, and integration patterns across multiple platforms

Partner with leadership to align data architecture initiatives with business objectives and future growth

Evaluate and recommend emerging technologies, tools, and platforms for data integration, storage, and analytics

Establish and enforce best practices for data governance, quality, security, and compliance

Establish medallion architecture in Fabric to ensure consistent report ready data

Establish logic and governance patterns for business data calculations (schedule gates, architectural and job cost calculations, etc)

Collaborate with business units, analysts, and data scientists to ensure architecture supports analytics and reporting needs

Support and mentor team members in data engineering and architecture practices

Develop documentation for data flows, pipelines, and architectural decisions

Support Power BI users and leads visualization best practice discussions

Lead efforts to migrate on-premise data infrastructure to cloud

Perform other duties as needed or required

Deliver a comprehensive and forward-looking data architecture strategy

Ensure data solutions are scalable, secure, and aligned with organizational goals

Maintain reliable and performant data pipelines that meet business requirements

Provide architecture documentation that guides implementation and supports knowledge transfer

Proactively identify opportunities for modernization and efficiency improvements

Achieve high levels of internal client satisfaction through delivery of robust, future-ready solutions

Maintain good backlog and active sprint work item hygeine in Azure DevOps

Deliver solutions according to specifications and plan

Ensures that first time production release quality is feature complete and defect free

Manages deployment of business intelligence solutions to ensure the application of best practices and data integrity

Analyzes data environments and vision for long term data delivery performance proactively

Qualification

T-SQLAzure SQLAzure Data FactoryData architectureETL/ELT processesMicrosoft FabricData modelingPower BIData governanceCommunication skillsOrganizational skills