# Data Solutions Architect

**Empresa:** toradex
**Local:** Campinas, SP
**Modalidade:** Híbrido
**Publicada em:** 2026-11-18

## Descrição

Toradex is a global company strongly focused on engineering &amp; technology. We’re powered by a diverse &amp; uniquely gifted workforce. We pursue the best people to propel our innovative vision of embedded computing and IoT. If you’re interested in being a driving force at an agile technology company, engineering clever computing solutions &amp; helping other companies bring their products to life, we should talk.We are seeking a Data Solutions Architect to shape our data strategy and elevate our analytical capabilities on Microsoft Fabric and Power BI.This role, part of Finance Business Partnering and FP&amp;A, is responsible for:

Designing and owning the end-to-end data architecture, from ingestion to executive-level reporting.

Translating complex data into actionable business insights.

Delivering data the business can trust from day one by owning end-to-end testing and validation, from source reconciliation to curated Gold-layer output, before anything is handed over for UAT.

Bridging the gap between technical data infrastructure and business decision-making.

You will build scalable, governed data foundations and work closely with other departments to give the company the visibility it needs to optimize performance and drive strategic initiatives.

Key Responsibilities
Data Architecture &amp; Engineering (Microsoft Fabric)

Design, implement and maintain a medallion architecture (Bronze, Silver, Gold) in Fabric Lakehouse/OneLake, ensuring “one version of the truth” across the organization.

Develop and maintain Spark notebooks (PySpark/Spark SQL) and Fabric pipelines to ingest, clean, transform and model data from diverse sources (D365 Finance &amp; Operations, D365 Customer Engagement, Arena PLM, SQL databases, Excel).

Own all data transformation logic in the Silver and Gold layers, so reports consume curated, analysis-ready data and need no transformation in Power Query.

Design dimensional models (star schema) in the Gold layer to support performance and reusability.

Oversee data refresh schedules, pipeline orchestration and monitoring to ensure reliable data delivery.

Define and execute a data testing and validation approach before every business handover: reconciliation against source systems (D365 Finance &amp; Operations, D365 Customer Engagement, Arena PLM), row count and totals checks, referential integrity, and business-rule validation in the Silver and Gold layers.

Build automated data quality checks into the pipelines and notebooks, and troubleshoot discrepancies with root-cause analysis before they reach end-users.

Power BI Development (Frontend)

Design, develop and maintain high-performance Power BI reports and interactive dashboards on top of semantic models built from the Gold layer.

Build and optimize DAX measures for complex business logic and KPIs.

Implement Row-Level Security (RLS) and manage workspaces, apps and permissions in the Power BI / Fabric service.

Business Analysis &amp; Insights

Act as a strategic partner to management across departments and entities to identify reporting needs and define KPIs.

Translate non-technical business requirements into technical specifications for data and BI solutions.

Conduct deep-dive analyses to identify trends, variances, and opportunities for cost reduction or revenue growth.

Provide training and documentation to enable self-service analytics.

Strategy, Governance &amp; Innovation

Establish and maintain best practices, including Git version control, CI/CD and deployment pipelines, documentation and naming conventions.

Establish a release and handover standard: data is signed off technically (with documented test results and reconciliations) before business UAT starts, so business testing focuses on usability and business logic rather than data correctness.

Define the data and analytics roadmap, aligned with the business strategy and IT infrastructure.

Stay current with Fabric and Power BI monthly updates and emerging AI/ML features.

Lead the transition from static reporting to predictive and prescriptive analytics.

Qualifications
Education

Bachelor’s degree in Data Analytics, Computer Science, Finance, Engineering, or a related field.

Preferred certifications: Microsoft Certified: Fabric Analytics Engineer Associate (DP-600), Fabric Data Engineer Associate (DP-700), or Power BI Data Analyst Associate (PL-300).

Experience

Good experience in Data Engineering, Business Intelligence or Data Architecture, ideally in a manufacturing or engineering environment.

Proven track record of delivering end-to-end data solutions, from extraction through a medallion/lakehouse architecture to executive-level Power BI visualization.

Experience with Microsoft Dynamics 365, in particular Finance &amp; Operations (ERP) and Customer Engagement (CRM), is an asset. Experience with other ERP systems (e.g. SAP, NetSuite) is also valued.

Previous “hands-on” senior role within an entrepreneurial or medium-sized global organization.

Skills &amp; Competencies
Technical Skills

Data architecture: medallion architecture, lakehouse and dimensional modeling, Delta Lake.

Spark: strong PySpark and Spark SQL in notebooks.

Microsoft Fabric: Lakehouse, Data Pipelines, OneLake, semantic models (Direct Lake experience is a plus).

Integration: experience extracting data from D365 (e.g. Fabric Link / Synapse Link for Dataverse, F&amp;O export to Fabric) and ingesting data from REST APIs (e.g. Arena PLM) into a lakehouse using Fabric pipelines or PySpark.

SQL: strong ability to write and optimize complex queries.

Data quality &amp; testing: experience with reconciliation, automated data validation and test documentation.

Power BI: advanced DAX and data modeling.

Data visualization: UI/UX principles to create intuitive, clean, impactful dashboards.

Excel: proficiency for ad-hoc analysis (Power Pivot a plus).

Business &amp; Soft Skills

Analytical mindset: connects data points to business outcomes such as margin analysis and product lifecycle analysis.

Communication: explains technical concepts to non-specialists and senior leadership.

Project management: highly organized, able to manage multiple projects in a fast-paced environment.

Problem-solving: proactive in identifying data gaps and proposing creative technical solutions.

Language: strong written English and attention to detail.

Location: hybrid, at the Toradex office in Campinas/SP.

What We Offer

A global, agile, and collaborative corporate culture.

Access to cutting-edge technologies and direct contact with highly skilled engineers.

Freedom to propose ideas, shape processes, and make a real impact.

Flexible work model and a modern, innovative environment.

Concrete opportunities for personal and professional growth.

Meal allowance (flash card)

Health and dental care

Flexible working hours

Parking space

Anniversary day off

Disclaimer: This is not a temporary role. It is a long-term, full-time opportunity. 

Toradex is a leader in embedded computing, serving innovative products to industrial, medical, automotive &amp; IoT companies creating feature-rich &amp; intelligent systems for demanding applications, e.g. supercars, self-driving tractors, patient monitoring systems – to name a few.

We provide effective &amp; robust embedded computing solutions and strive for the best development experience in the industry with a focus on intelligent hardware design, innovative software solutions &amp; free comprehensive support. Our relationship with our customers ensures that we all succeed and it allows us to participate in the realization of incredible new products. Our products are directly sold to more than 3'000 industrial customers in over 70 different countries worldwide.

For more information

Visit our Homepage: www.toradex.com

Connect with us and join our community!: https://community.toradex.com

Our YouTube Channel

## Habilidades

- Data architecture
- medallion architecture
- lakehouse
- dimensional modeling
- Delta Lake
- PySpark
- Spark SQL
- Microsoft Fabric

**Página original:** https://www.123vagas.com.br/vaga/data-solutions-architect-campinas-sp-131549
