BI Architect – Data & Analytics (C-571)

SMASH; Villa Rica (GA); On-site; USD 140,000 - 190,000; Full time

Job summary

SMASH is seeking an experienced BI Architect to design scalable data architectures for enterprise analytics. You will work on data warehousing, dimensional modeling, and ETL pipelines, leveraging SQL, cloud platforms, ADF, and BI tools such as Power BI or Tableau.

The role emphasizes governance, security, and collaboration with Data Engineers, Analysts, and business stakeholders in a remote, LATAM-friendly setup for a US company. This is a one-year contract with LATAM work-permit requirements.

Qualifications

• Experience with enterprise data warehousing and database architecture.
• Strong SQL proficiency for analytics and data transformation.
• Knowledge of NoSQL technologies and suitable use cases.
• Hands-on experience with cloud-based data platforms for enterprise storage and management.
• Experience designing dimensional data models (star/snowflake schemas).
• Experience building data pipelines and ETL/ELT workflows.
• Familiarity with Azure Data Factory (ADF) or equivalent tools.
• Experience integrating data across multiple systems and sources.
• Proficiency with Power BI, Tableau, or similar BI tools.
• Familiarity with Python or R for data manipulation and automation.

Responsibilities

• Design scalable enterprise data and BI architectures to support reporting and analytics.
• Architect and optimize data warehouses and database solutions.
• Design dimensional models using star and snowflake schemas.
• Define data structures transforming raw data into analytics-ready datasets.
• Oversee data pipelines and ETL workflows for reliable data movement.
• Develop complex SQL queries for integration, analytics, and reporting.
• Work with SQL and NoSQL databases across enterprise environments.
• Design data integration solutions using tools like ADF.
• Collaborate with Data Engineers, BI Developers, and stakeholders to translate requirements.
• Support enterprise reporting with Power BI, Tableau, or similar platforms.
• Use Python or R for data manipulation and automation when appropriate.
• Evaluate architectures for performance, scalability, and governance.

Skills

Data warehousing

SQL

NoSQL

Cloud data platforms

Dimensional modeling

ETL/ELT

Azure Data Factory

Power BI

Tableau

Python

R

Data governance

Data security

Tools

Azure Data Factory

Power BI

Tableau

Python

R

Job description

SMASH, Who we are?

We are agents for tech professionals in Costa Rica and Colombia that help them build careers in the United States.

We believe in long-lasting relationships with our talent. We invest time getting to know them and understanding what they seek as their professional next step.

We aim to find the perfect match. As agents, we pair our talent with our US clients, not only by their technical skills but as a cultural fit. Our core competency is to find the right talent fast.

This position is Remote to work with a US Company; you will require to have Citizenship or a work permit from LATAM to apply for this role.

• This is a temporary position with a one-year contract.**

Role Summary

We are looking for an experienced BI Architect with a strong background in enterprise data architecture, data warehousing, database technologies, data integration, and business intelligence.

This role will be responsible for designing scalable data architectures that transform raw enterprise data into reliable, secure, and accessible information for reporting and analytics. The ideal candidate will bring advanced expertise in SQL, data warehousing, cloud data platforms, dimensional modeling, and ETL/data pipelines, along with experience with technologies such as Azure Data Factory (ADF), Power BI or Tableau, and Python or R.

Responsibilities

• Design scalable and efficient enterprise data and BI architectures supporting reporting, analytics, and business intelligence requirements.
• Architect and optimize enterprise data warehouse and database solutions.
• Design dimensional data models using star schemas, snowflake schemas, fact tables, and dimensions.
• Define data structures that transform raw information into organized, analytics-ready datasets.
• Design and oversee data pipelines and ETL workflows for reliable movement and transformation of data between systems.
• Develop and optimize complex SQL queries supporting data integration, analytics, and reporting workloads.
• Work with both SQL and NoSQL databases across enterprise environments.
• Design data integration solutions using tools such as Azure Data Factory (ADF).
• Establish scalable patterns for integrating data from multiple enterprise applications and data sources.
• Collaborate with Data Engineers, BI Developers, Data Analysts, and business stakeholders to translate business requirements into technical architecture.
• Support enterprise reporting and dashboarding solutions using Power BI, Tableau, or similar BI platforms.
• Use Python or R for advanced data manipulation, scripting, and automation when appropriate.
• Evaluate and optimize data architectures for performance, scalability, reliability, and maintainability.
• Define architectural standards and best practices for data modeling, data integration, storage, and business intelligence.
• Incorporate data security, compliance, access controls, and governance into architecture decisions.
• Identify technical risks, architectural gaps, and opportunities to modernize enterprise data platforms.
• Document architecture decisions, data flows, integrations, models, and technical standards.

Requirements – Must-haves

• Advanced experience with enterprise data warehousing and database architecture.
• Advanced proficiency with SQL.
• Strong understanding of NoSQL technologies and their appropriate enterprise use cases.
• Hands-on experience with cloud-based data platforms for enterprise data storage and management.
• Intermediate to advanced experience designing dimensional data models.
• Strong understanding of star and snowflake schema architectures.
• Experience designing data pipelines supporting reporting and analytical workloads.
• Strong understanding of ETL/ELT concepts and workflows.
• Experience with enterprise data integration technologies such as Azure Data Factory (ADF) or equivalent.
• Experience designing solutions that integrate data across multiple systems and sources.
• Experience with Power BI, Tableau, or another enterprise BI/reporting platform.
• Familiarity with Python or R for data manipulation, scripting, and automation.
• Strong understanding of cloud data architecture principles.
• Knowledge of data security, compliance, access management, and data governance practices.
• Ability to design scalable, reliable, and maintainable enterprise data solutions.
• Strong analytical, architecture, and problem-solving skills.
• Ability to communicate technical architecture and recommendations to both technical and business stakeholders.

Nice-to-haves (optional)

• Strong experience within the Microsoft Azure data ecosystem.
• Advanced hands-on experience with Azure Data Factory.
• Experience with Microsoft Power BI in enterprise environments.
• Experience designing cloud-native or hybrid enterprise data architectures.
• Experience modernizing legacy data warehouse and BI environments.
• Experience defining enterprise data architecture standards and governance frameworks.
• Experience with large-scale or high-volume enterprise datasets.
• Exposure to modern Microsoft data technologies such as Microsoft Fabric.

Languages

• English C1
• Spanish C1