Data & BI Engineer at True Homes

The Data & Business Intelligence Engineer is responsible for shaping True Homes� enterprise data strategy and architecture while also contributing hands-on expertise in building and maintaining modern data solutions (pipelines, databases, warehouses, lake-houses, etc) . This role blends strategic oversight with technical delivery, ensuring that data systems are scalable, reliable , efficient, and aligned with organizational goals. The associate will leverage advanced knowledge of T-SQL, Azure SQL, Azure Data Factory, Microsoft Fabric, and ETL/ELT best practices to design robust solutions, guide modernization efforts, and support data-driven decision-making across the business in a fast-paced environment with lots of autonomy.

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

Results/Accountability:

� 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

Qualifications:

� Bachelor of Science in Computer Science, Bachelor of Arts in Information Systems, or relevant work experience required

� Seven or more years of experience in data architecture and engineering roles.

� Advanced proficiency in T-SQL.

� Effective at Azure SQL database design and optimization .

� Proven experience developing and maintaining pipelines with Azure Data Factory.

� Familiarity with Microsoft Fabric for advanced data integration and analytics.

� Strong understanding of data modeling, schema design, and warehousing techniques.

� Experience with ETL/ELT processes and performance tuning.

� Knowledge of Power BI or similar BI tools preferred.

� Demonstrated ability to set and enforce data governance and architecture standards.

� Microsoft certification in data architecture or Azure technologies preferred.

General Requirements:

� Excellent attention to detail

� Strong communication skills, written, and verbal skills

� Strong organizational skills

� Ability to work in a fast-paced environment

� Comply with all company policies and procedures

� Demonstrate the qualities and character traits as defined in the True Difference

Physical Requirements:

� Must be able to remain in a stationary position 75% of the time

� Associate needs to occasionally move about the office to access file cabinets, office equipment, etc.

� Constantly operates a computer and other office equipment