[Remote] Senior Data Architect Engineer (SaaS)

Note: The job is a remote job and is open to candidates in USA. TeamBuilder is a rapidly growing healthcare SaaS company on a mission to transform healthcare with innovative technology. They are seeking an experienced Senior Data Engineer / Data Architect to lead the design and development of their enterprise data platform, ensuring the delivery of high-quality data solutions that support operational reporting and advanced analytics.ResponsibilitiesDesign and evolve the organization's data architecture to support operational, analytical, and AI-driven workloadsDefine and implement scalable data warehouse, data lake, and lakehouse architecturesEstablish data modelling standards, governance practices, and architectural best practicesDesign data structures and integration patterns that support long-term scalability, performance, and maintainabilityDrive data platform modernization initiatives leveraging Azure cloud technologiesDesign, develop, and maintain scalable ETL/ELT pipelines that ingest, transform, validate, and deliver data from multiple internal and external systemsBuild robust data integration solutions using Azure data services and modern data engineering frameworksImplement monitoring, alerting, and data quality controls to ensure reliable data operationsAutomate data processing workflows and reduce operational overhead through engineering best practicesOptimize SQL queries, data pipelines, and analytical workloads for performance, scalability, and cost efficiencyAnalyze and improve large-scale datasets and reporting environmentsIdentify bottlenecks and implement solutions that improve system responsiveness and data availabilityPartner with engineering teams to improve database design, indexing strategies, and query performanceEstablish data validation, reconciliation, and auditing processes to ensure trusted reporting outcomesInvestigate and resolve complex data discrepancies across source systems and analytical platformsDevelop repeatable controls and monitoring processes that improve confidence in business reportingDefine and maintain data quality standards across the platformDesign and support data models that power reporting and analytics solutionsCollaborate with business stakeholders to understand analytical requirements and translate them into scalable data solutionsSupport Power BI and custom analytics platforms through semantic modelling, data optimization, and performance tuningEnable self-service analytics through well-designed and governed datasetsSkills7+ years of experience in Data Engineering, Data Architecture, or related disciplinesStrong experience designing and implementing enterprise-scale data architecturesExpert-level SQL skills with proven experience optimizing complex queries and large datasetsExtensive experience building ETL/ELT solutions in cloud-based environmentsStrong understanding of data warehousing, dimensional modelling, and analytical data designExperience implementing data quality, governance, lineage, and reconciliation processesStrong analytical and problem-solving skills with the ability to diagnose complex data issuesExcellent written and verbal communication skillsAbility to work independently and collaborate effectively across technical and non-technical teamsAzure SQL DatabaseAzure Data FactoryAzure Synapse Analytics and/or Azure DatabricksSQL Server and advanced SQL optimizationData Warehouse and Lakehouse designETL/ELT architecture and implementationData modelling (Star Schema, Snowflake, Dimensional Modelling)Performance tuning and query optimizationData quality and reconciliation frameworksPower BI data modelling and performance optimizationMicrosoft FabricAzure Data Lake StorageApache SparkPythonCI/CD for data platformsInfrastructure as CodeReal-time and streaming data architecturesAI and machine learning data platform experienceExperience supporting SaaS platforms with large-scale operational and analytical datasetsExperience working in healthcare, workforce management, scheduling, or other data-intensive industriesExperience designing data platforms that support advanced analytics, forecasting, optimization, or AI initiativesExperience delivering enterprise reporting and business intelligence solutionsBenefitsPaid time offMedical benefitsThe potential for an annual performance bonusEquityCompany OverviewEmpowering healthcare to build the right team for tomorrow, today. It was founded in 2021, and is headquartered in Newtown, Connecticut, USA, with a workforce of 11-50 employees. Its website is http://www.teambuilder.io.