Senior Data Architect
Emergent Software
full-time
Posted on:
Location Type: Remote
Location: Remote • 🇺🇸 United States
Visit company websiteSalary
💰 $155,000 - $190,000 per year
Job Level
Senior
Tech Stack
AzureCloudETLSQL
About the role
- 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.
- 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.
- 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
- 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.
Requirements
- 10+ years of database development & architecture experience
- 5+ years of experience with Azure database projects
- Experience designing lakehouse architectures using ADLS/OneLake, 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.
Benefits
- Excellent benefits package including medical insurance, dental, vision, 401(k) matching, FSA, disability, life insurance, and paid parental leave
- 100 hours per year to focus on your professional development.
- Profit sharing bonus means as we’re successful, you’re successful.
- Work-life balance is essential and highly valued at Emergent Software.
- Work closely with other talented database professionals & software engineers.
- Work from home or work remotely from anywhere.
- Flexible work schedule meaning you can work regular hours or whenever you work best.
- If you choose to work more than 40 hours, you’ll be compensated for the extra work!
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data architecturedata modelingdimensional modelingETL developmentcloud cost optimizationdata warehouse designAzure serviceslakehouse architectureperformance tuningsemantic models
Soft skills
leadershipmentoringcommunicationclient advisorytechnical discoveryworkshop facilitationthought leadershipgovernancecollaborationproblem-solving