Senior Data Architect

** This is an opportunity to join our dynamic team of data engineering professionals working to design and implement database projects for our clients. This position is fully remote (indefinitely). ** 

Emergent Software is seeking a Senior Data Architect who is intelligent, passionate, detail-oriented, and enjoys working architecting scalable data platforms within the Microsoft suite of data solutions. This role serves as the technical lead for enterprise data platform engagements, guiding data engineers, driving architectural decisions, and ensuring the technical success of the project. This 100% remote position is for self-starters with good communication skills, strong work ethic, and the ability to manage work across numerous clients and priorities. This role requires a technical professional who thrives in dynamic environments, can wear multiple hats, and is passionate about designing, maintaining, and optimizing modern data platforms. 

Highlights & Benefits of working at Emergent Software 

• Work closely with other talented database professionals & software engineers. Our vetting process means you can count on your team members to know what they are talking about. 

• Work from home or work remotely from anywhere 

• Flexible work schedule meaning you can work regular hours or whenever you work best 

• Work-life balance is essential and highly valued at Emergent Software. If you choose to work more than 40 hours, you’ll be compensated for the extra work! 

• Work on interesting projects solving complex business problems with custom software. 

• 100 hours per year to focus on your professional development. We invest in your growth! 

• Profit sharing bonus means as we’re successful, you’re successful 

• Excellent benefits package including medical insurance, dental, vision, 401(k) matching, FSA, disability, life insurance, and paid parental leave 

Responsibilities 

• Architect end-to-end data platforms on Azure, ensuring scalability, resilience, and future-proof design 

• Lead design reviews and architectural decisions for large or complex client data projects 

• Facilitate the design of enterprise data models through the translation of business processes to model-oriented designs. 

• Own the creation and governance of conceptual, logical, and physical data models ensuring alignment across business domains. 

• Apply modern architectural approaches such as domain-driven design, data products, and distributed data ownership where appropriate. 

• Define and enforce modeling standards, naming conventions, and architectural guardrails across client projects. 

• Serve as the technical authority in client delivery, ensuring architectural decisions are followed through implementation with appropriate code reviews and governance. 

• Apply star-schema patterns to deploy iterative Kimball best practices to data warehouse design 

• Mentor and coach junior engineers on advanced Azure services, performance tuning, and cloud-native patterns 

• Drive cloud cost optimization strategies, ensuring clients use the right services at the right scale 

• Evaluate and recommend new Azure tools and technologies for inclusion in Emergent Software’s offerings 

• Lead client advisory on data platform modernization, migration strategies (e.g., on-prem to Azure), and data architecture maturity 

• Contribute to thought leadership, such as blog posts, webinars, or speaking engagements on Azure data topics 

• Architect data storage layers (Azure OneLake, Azure SQL, Synapse Analytics) for structured, semi-structured, and unstructured data 

• Ensure data quality, validation, and lineage using tools like Azure Purview and integrate with governance frameworks 

• Collaborate with BI teams to prepare curated data models and tables for reporting in Power BI or downstream systems 

• Manage data security, privacy, and compliance (RBAC, encryption, sensitive data masking) across Azure services 

• Document data engineering solutions and adhere to Emergent Software’s delivery standards and Agile practices 

Senior Data Architect Required Experience 

• 10+ years of database development & architecture experience