Data Engineer

Senior Data Architect/EngineerTeamBuilder is a rapidly growing healthcare SaaS company on a mission to transform healthcare with our innovative technology. We believe in empowering our customers through inventive solutions and a commitment to excellence. Our young, rapidly growing team is looking for passionate professionals who thrive in a dynamic, innovative, and collaborative environment. This role is fully remote, however you must reside in the US and be available on EST hours.Summary of Role We are seeking an experienced Senior Data Engineer / Data Architect to lead the design, development, optimization, and evolution of our enterprise data platform. This is a hands-on senior individual contributor role responsible for architecting scalable data solutions, building robust data pipelines, optimizing analytical workloads, and ensuring the delivery of trusted, high-quality data across the organization. The successful candidate will combine strong technical expertise in modern data engineering practices with the ability to design and govern enterprise-scale data architectures. You will work closely with software engineering, product, analytics, and business stakeholders to deliver reliable, high-performance data solutions that support operational reporting, business intelligence, advanced analytics, and AI initiatives.Key ResponsibilitiesData Architecture & Platform DesignDesign and evolve the organization's data architecture to support operational, analytical, and AI-driven workloads.Define and implement scalable data warehouse, data lake, and lakehouse architectures.Establish data modelling standards, governance practices, and architectural best practices.Design data structures and integration patterns that support long-term scalability, performance, and maintainability.Drive data platform modernization initiatives leveraging Azure cloud technologies.Data EngineeringDesign, develop, and maintain scalable ETL/ELT pipelines that ingest, transform, validate, and deliver data from multiple internal and external systems.Build robust data integration solutions using Azure data services and modern data engineering frameworks.Implement monitoring, alerting, and data quality controls to ensure reliable data operations.Automate data processing workflows and reduce operational overhead through engineering best practices.Performance & OptimizationOptimize SQL queries, data pipelines, and analytical workloads for performance, scalability, and cost efficiency.Analyze and improve large-scale datasets and reporting environments.Identify bottlenecks and implement solutions that improve system responsiveness and data availability.Partner with engineering teams to improve database design, indexing strategies, and query performance.Data Quality & ReconciliationEstablish data validation, reconciliation, and auditing processes to ensure trusted reporting outcomes.Investigate and resolve complex data discrepancies across source systems and analytical platforms.Develop repeatable controls and monitoring processes that improve confidence in business reporting.Define and maintain data quality standards across the platform.Analytics EnablementDesign and support data models that power reporting and analytics solutions.Collaborate with business stakeholders to understand analytical requirements and translate them into scalable data solutions.Support Power BI and custom analytics platforms through semantic modelling, data optimization, and performance tuning.Enable self-service analytics through well-designed and governed datasets.Required Qualifications7+ years of experience in Data Engineering, Data Architecture, or related disciplines.Strong experience designing and implementing enterprise-scale data architectures.Expert-level SQL skills with proven experience optimizing complex queries and large datasets.Extensive experience building ETL/ELT solutions in cloud-based environments.Strong understanding of data warehousing, dimensional modelling, and analytical data design.Experience implementing data quality, governance, lineage, and reconciliation processes.Strong analytical and problem-solving skills with the ability to diagnose complex data issues.Excellent written and verbal communication skills.Ability to work independently and collaborate effectively across technical and non-technical teams.Technical SkillsRequired: Azure SQL Database, Azure Data Factory, Azure Synapse Analytics and/or Azure Databricks, SQL Server and advanced SQL optimization, Data Warehouse and Lakehouse design, ETL/ELT architecture and implementation, Data modelling (Star Schema, Snowflake, Dimensional Modelling), Performance tuning and query optimization, Data quality and reconciliation frameworks, Power BI data modelling and performance optimizationPreferred: Microsoft Fabric, Azure Data Lake Storage, Apache Spark, Python, CI/CD for data platforms, Infrastructure as Code, Real-time and streaming data architectures, AI and machine learning data platform experienceWhat Success Looks LikeReliable, scalable, and well-governed data platforms.Trusted reporting supported by strong data quality and reconciliation processes.High-performance analytical environments that scale with business growth.Reduced operational overhead through automation and platform improvements.Data architectures that enable future analytics and AI initiatives.Strong collaboration with engineering, product, and business teams to drive measurable business outcomes.Additional InformationJob Type: Full-time, Exempt, Remote primarily East Coast time zone, Some Travel RequiredCompensation: Competitive including paid time off, medical benefits, and the potential for an annual performance bonus, and/or equityWe foster a collaborative, engaging, mission-driven culture that values innovation and prioritizes customer success. We like to have fun together and support each other too!