Senior Data Architect

3 days ago

Apply Now

Receive Emails with Similar Jobs

Emergent Software

WebsiteLinkedInAll Job Openings

SaaS • B2B • Cloud

Emergent Software is a software development and consulting company based in Minneapolis, Minnesota. The company specializes in custom software development, including websites, web applications, mobile apps, and business process automation. Emergent Software also offers services in database and analytics, Azure cloud consulting, and DevOps. The company acts as a full-stack technology partner for businesses, providing services from design to deployment, with a focus on long-term client partnerships. Additionally, Emergent Software provides staffing services through its sister company, Emergent Staffing, for roles in software development, cloud engineering, and more.

51 - 200 employees

Founded 2003

☁️ SaaS

🤝 B2B

📋 Description

• 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!