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