Data Architect - Azure Synapse

Data Architect - Azure Synapse

Data Ideology 
At DI, we provide Data & Analytics expertise to drive measurable business outcomes, often solving complex business problems for our clients. Our data analytics advisory services enable our customers to transform data into insights by driving a culture of empowerment and ownership of results. Our team consists of highly motivated individuals passionate about learning, understanding, collaborating, and intellectually curious.  For more information about Data Ideology, visit  

Data Architect - Full-time 
We are looking for a Data Architect to join our growing team. The Data Architect will leverage their business and technical knowledge to develop production-ready data models by integrating multiple data sources. You will collaborate with both business and technical teams to comprehend business strategies and objectives, gather pertinent information, and verify that business requirements are met at every stage of the data and analytics lifecycle. 

Key Responsibilities 
To perform in this position successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. Other duties may be assigned to meet business needs.

  • Ability to collect and understand business requirements and translate those requirements into an actionable data warehouse design and implementation plan. 
  • Knowledge of multi-dimensional and tabular design patterns and ability to identify solutions that leverage these modeling techniques. 
  • Ability to work within the SDLC framework in multiple environments and understand the complexities and dependencies of the data warehouse built within those constraints. 
  • Ability to define and implement best practices across database design and ETL. 
  • Ability to direct the work of others, including but not limited to directing ETL development, demonstrating an understanding of key concepts of ETL/ELT, including best practices for optimization and scheduling. 
  • Evaluate and recommend appropriate Azure services and technologies to optimize data architecture, performance, scalability, and cost-effectiveness. 
  • Lead the implementation of data pipelines, ETL/ELT processes, and data integration solutions using Azure Data Factory, Azure Synapse, and other relevant tools. 
  • Collaborate with infrastructure teams to design and implement robust and scalable Azure data architectures, including networking, security, and high availability considerations. 

Supervisory Responsibilities: None

Education and Experience:

  • Proven experience as a Data Architect or similar role, with a focus on designing and implementing data solutions on the Azure platform. 
  • Proven understanding of Data Warehousing, Data Architecture, and BI. 
  • Proven experience in Azure Synapse. 
  • Experience with data pipelines and architecture/engineering in Azure Data Factory. 
  • Strong knowledge in cloud-based project implementation. 
  • Knowledge of modern applications and data platforms. 
  • Hands on experience in programming languages such as SQL, Python, or Scala. 
  • Excellent analytical, problem-solving, and communication skills. 
  • Microsoft Fabric understanding is a plus. 
  • Azure certifications such as Azure Solutions Architect Expert or Azure Data Engineer Associate are a plus. 

Knowledge, Skills, and Abilities:

  • BI/Data Warehousing (4+ years)  
  • Cloud platforms (2+ years)  
  • Dimensional Data Modeling (3+ years) 
  • ETL (3+ years)  
  • SQL (3+ years) 
  • Business Intelligence (1+ years) - Power BI a plus 
  • Python or Scala (1+ years) 

Work Environment:

  • Remote work from home. 
  • Hours of work and days are generally Monday through Friday. Specific business hours will depend on client needs. 

Physical Demands:

  • Must be able to remain in a stationary position 50% of the time. 
  • The person in this position must occasionally move about inside the office to access file cabinets, library stacks, office machinery, etc. 
  • Constantly operates a computer and other office productivity machinery, such as a calculator, copy machine, and printer. 
  • The person in this position frequently communicates with clients and coworkers. Must be able to exchange accurate information in these situations. 


  • Flexible Time Off Policy
  • Insurance (medical, dental, vision) for employees 
  • 100% company paid - short and long-term disability insurance for employees 
  • 100% company paid - life insurance and AD&D insurance for employees 
  • 100% company paid – employee assistance program 
  • Retirement plans with company match 
  • Training and Certification Reimbursement annually 
  • Performance-based incentive program 
  • Commission incentive program 
  • Profit Sharing Plan 
  • Referral Bonuses 

Data Ideology is an EEO Employer

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.