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.

• 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

• 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 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 One Lake, 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

• 10+ years of database development & architecture experience
• 5+ years of experience with Azure database projects
• Experience designing lakehouse architectures using ADLS/One Lake, Delta/Parquet, medallion layers, or equivalent patterns
• Expertise in dimensional modeling and normalization for operational data stores
• Demonstrated ability to lead technical discovery sessions, run architecture workshops, and translate ambiguous business requirements into technical designs
• Experience designing semantic models for BI reporting
• Ability to discuss potential data solutions with clients in the pre-sales process
• Data warehouse design using Kimball design patterns and solutions
• ETL development using Azure Data Factory
• Building analytics solutions using Power BI
• Experience optimizing Synapse, SQL pools, Fabric Warehouses, ADF mappings, etc.

• Experience building data solutions in Microsoft Fabric
• Experience building data products or supporting Data Mesh operating models
• Experience with DBT or CI/CD for data pipelines
• Familiarity with…