Data & BI Engineer

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