Sr Data Architect (English Required)

Work at DaCodes!

We are a firm of experts in high-impact software and digital transformation.

For 10 years, we have built solutions focused on technology and innovation thanks to our team of 220+ talented #DaCoders, including developers, architects, UX/UI designers, PMs, QA testers, and more.

Our team collaborates on projects with clients across LATAM and the United States, delivering outstanding results.

At DaCodes, you will have the opportunity to accelerate your professional growth, work on diverse projects across multiple industries, and contribute to the design, implementation, and optimization of cloud infrastructures.

Our DaCoders have a big impact on the success of our business and that of our clients.

You will be the expert contributing to our projects and will have access to disruptive startups and global brands.

Are you interested?

Requirements

This project focuses on building and optimizing a robust data infrastructure to support analytics and reporting on Microsoft Dynamics CRM data.

The role involves connecting to MS Dynamics CRM data in Dataverse, leveraging Microsoft Fabric to build ETL pipelines into Azure Data Factory and a Data Lake following a Medallion Architecture.

The Data Architect will model CRM data for analytics and enable Power BI reporting layers to deliver actionable business insights.

Key Responsibilities

• Architect and implement end-to-end data pipelines from Microsoft Dataverse using Fabric and Azure Data Factory (ADF).
• Design and deploy scalable infrastructure components using Terraform for Infrastructure as Code (IaC).
• Develop and optimize Medallion Architecture layers (Bronze, Silver, Gold) within the Azure Data Lake to ensure data reliability, scalability, and reusability.
• Model CRM and sales data for analytical and reporting purposes, ensuring schema alignment and data quality across sources.
• Integrate Power BI for visualization and analytics, enabling business users to derive insights from CRM data.
• Collaborate with cross-functional teams to ensure data solutions meet functional and technical requirements, balancing performance, security, and maintainability.
• Apply best practices for data governance, metadata management, and pipeline optimization.

Core Skills Required

• Microsoft Dataverse – deep understanding of CRM data structures and integration patterns.
• Microsoft Fabric – hands-on experience with modern data engineering and orchestration in Fabric.
• Azure Data Factory (ADF) – strong expertise in pipeline development, orchestration, and performance tuning.
• Medallion Architecture – proven experience in designing layered data lake architectures (Bronze/Silver/Gold)

Familiarity Required

• Terraform – for infrastructure provisioning and automation.
• Power BI – for semantic modeling and dashboard/report design.CRM / Sales Data Modeling – understanding of business logic, entities, and analytical KPIs in CRM systems.Additional Experience (Preferred)
• Exposure to Synapse Analytics and Kafka for advanced data orchestration and event streaming.Experience in optimizing data pipelines for large-scale CRM analytics workloads.
• The ideal candidate combines strong technical expertise in Azure data services with functional knowledge of CRM analytics.
  
  They can not only execute and optimize complex data pipelines but also design data models that translate CRM data into actionable business intelligence.

Benefits

🚀 Integration with global brands and disruptive startups.

🏡 Remote / Home office.

📍 If hybrid or on-site work is required, you will be informed from the first interview.

⏳ Schedule aligned to the assigned project team.

📅 Monday to Friday work week.

🎉 Day off on your birthday.

🏥 Major medical insurance (applicable for Mexico).

🛡️ Life insurance (applicable for Mexico).

🌎 Multicultural work teams.

🎓 Access to courses and certifications.

📢 Meetups with IT special guests.

📡 Virtual team-building events and interest groups.

📢 English classes.

🏆 Opportunities within our different business lines.

🏅 Proudly certified as a Great Place to Work.