Emergent Software
Your Full Stack Technology Partner
Senior Data Architect
Location
United States
Posted
104 days ago
Salary
$155K - $190K / year
Bachelor Degree10 yrs expEnglishAzureCloudETLSQL
Job 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.
Job 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!
Related Guides
Related Categories
Related Job Pages
More Data Engineer Jobs
Data Engineer
Data SocietyData Society provides industry-tailored data science training solutions for corporations and government agencies.
Data Engineer104 days ago
Full TimeRemoteTeam 11-50H1B Sponsor
Data Engineer building scalable data pipelines for Data Society Group
AirflowCloudETLPythonSQLTerraform
District of Columbia + 1 moreAll locations: District of Columbia, Washington
Snowflake Data Engineer
ResultStackResultStack is a consulting firm that specializes in web & mobile development. We are results obsessed.
Data Engineer105 days ago
Full TimeRemoteTeam 51-200Since 2014
Data Engineer supporting client projects with Snowflake expertise
AWSAzureCloudETLGoogle Cloud PlatformSQL
United States
Data Architect, Microsoft Fabric
Boyle SoftwareHuman-centric digital design and development by passionate, skilled talent who care about clarity, coding, and security
Data Engineer106 days ago
Full TimeRemoteTeam 51-200H1B Sponsor
Data Architect designing solutions using Microsoft Fabric at Beyondsoft
AzureCloudETLJavaScriptSQL.NET
Data Engineer106 days ago
Full TimeRemoteTeam 11-50Since 2020H1B Sponsor
Lead Data Engineer building data infrastructure for blockchain trading platform
AirflowAmazon RedshiftAWSAzureBigQueryCloudETLGoogle Cloud PlatformPythonSQL