Data & BI Engineer
30 days ago
Monroe
Job Description 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