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
