Role Summary: The Solutions Architect, Data & Analytics serves as a strategic and execution-focused partner
to business leaders, designing and delivering the enterprise data platform and analytics solutions that
improve operational performance, decision-making, and productivity.
Essential Responsibilities
Data Architecture & Engineering
- Own end-to-end design of the enterprise data platform on Microsoft Fabric including OneLake,
lakehouses, warehouses, data pipelines, and notebooks — for enterprise initiatives prioritized on EBITDA and TWC impact.
- Serve as the technical architect on multiple concurrent data projects, setting direction through working
code, reference architectures, and reusable design patterns such as medallion architecture and
dimensional models.
- Take ownership of objectives and drive them forward independently: determine the path, research and
resolve technical and organizational blockers, and engage the right people without needing step-by-step
direction.
- Design and build data pipelines and integrations that ingest, unify, and refresh data from ERP (QAD),
Microsoft 365, and operational platforms in Fabric.
- Develop data transformations, models, and automated data-quality checks using SQL, Python/PySpark,
and Fabric data engineering tools, from prototype through production deployment.
- Establish data governance, security, lineage, and access-control standards, including row-level security
and workspace and capacity management.
- Lead end-to-end delivery of initiatives from concept through pilot to scaled deployment, including
change management and user adoption.
- Define plans to deliver change in 1–3 month increments, using agile methodologies to deliver
incremental improvements in quick time periods.
- Deploy solutions, train end users, and drive adoption.
Analytics & Reporting
- Design and build Power BI semantic models, DAX measures, reports, and dashboards that give site,
vertical, and executive leadership trusted, timely visibility into operational and financial KPIs.
- Define the enterprise reporting strategy, including certified semantic models, self-service standards,
workspace governance, and deployment practices.
- Translate operational pain points into data products, KPIs, and decision-support tools that drive EBITDA
and working capital outcomes.
- Optimize query performance, refresh strategy, and Fabric capacity consumption to balance user
experience with cost.
- Prepare curated, governed enterprise data and semantic models as the foundation for AI use cases,
including Microsoft 365 Copilot and internal agents, in partnership with the Solutions Architect, AI &
Automation.
- Rapidly prototype dashboards and data solutions to demonstrate possibilities to business leaders and
build the case for investment.
- Conduct build-versus-buy analysis and advise leadership on where internal development delivers better
value than third-party engagement.
- Identify technical, delivery, and adoption risks early and develop mitigation strategies that optimize cost
and risk.
- Maintain current expertise in a rapidly evolving technology landscape through industry conferences,
vendor technical briefings, certification programs, and continuous hands-on evaluation of new platforms
and tools.
- Bring external market and technology insight back into the business, assessing new capabilities against
Business Partnership & Process Improvement
- Engage directly with branch teams, functional support, vertical and site leadership, customers, and
suppliers to identify process gaps and simplification opportunities and reporting gaps.
- Gather business requirements independently and translate them into technical requirements and
solution designs without intermediary analysis.
- Drive strategic initiatives aimed at improving business KPIs through defining the issue, analyzing and
prioritizing root causes, making improvements, and verifying results.
- Gather data on existing processes, identify where the top problems are, and demonstrate improvement
results after positive changes are made.
- Build and present business cases, cost-benefit analyses, and solution recommendations to executive
leadership, including the CEO.
- Communicate clearly and proactively, in writing and in conversation, keeping business leaders, IT,
vendors, and delivery partners aligned on status, decisions, risks, and next steps.
- Gain the "hearts and minds" of employees globally to change the way they work, using trusted data to
improve the top/bottom line and customer service.
Vendor & Program Leadership
- Lead technology vendor evaluations and selection processes for data and analytics tooling, including
requirements definition, demonstrations, scoring, and commercial recommendation.
- Own the business case and secure funding approval for technology investments.
- Partner with IT, vendors, and business stakeholders to integrate solutions into existing enterprise
systems.
- Govern third-party delivery partners through the implementation lifecycle, including regular working
sessions, scope management, and acceptance of delivered work against requirements.
- Configure and lead the setup of supporting IT infrastructure required for third-party and internal
solutions.
Technical Leadership & Team Development
- Provide technical mentorship through code review, design review, and pairing; establish the data
engineering and BI standards and practices the team works to.
- Onboard and ramp early-career technical hires, building their capability in data engineering, Microsoft
Fabric, and Power BI.
- Scope and delegate work appropriately, balancing individual delivery against team throughput and
development goals.
Skills, Knowledge, And Education
Required
- At least six years of professional experience spanning data engineering or analytics delivery and business
process improvement.
- Resourcefulness and self-direction: demonstrated ability to take an objective, determine how to move it
forward, and solve problems independently without needing to be guided through every step.
- Hands-on experience designing and building solutions on Microsoft Fabric, including lakehouses or
warehouses, data pipelines, notebooks, and OneLake.
- Advanced Power BI skills, including semantic modeling, DAX, Power Query, report and dashboard
design, and workspace governance.
- Strong SQL and proficiency in Python (PySpark preferred) for data transformation and automation.
- Strong data modeling and warehousing fundamentals, including dimensional modeling and medallion
(bronze/silver/gold) architecture.
- Experience building ETL/ELT pipelines that integrate enterprise sources such as ERP systems and
Microsoft 365 into a central analytics platform.
- Experience leading multiple data, analytics, or data-driven solutions from concept through deployment
with measurable business outcomes.
- Demonstrated experience owning solutions end-to-end: business requirements, solution architecture,
development, integration, deployment, adoption, and ongoing improvement.
- Working knowledge of cloud architecture, security, identity, and cloud-native solution design.
- Working knowledge of enterprise systems (Microsoft 365, ERPs, etc.).
- Experience leading vendor selection and managing third-party delivery partners.
- Strong project and program management capabilities.
- Strong knowledge of process improvement.
- Proven ability to translate ambiguous business problems into actionable technical solutions.
- Experience driving change management and user adoption.
- Experience working cross-functionally within the business and with external partners.
- Strong written and verbal communication skills, including executive-ready presentation and experience
presenting to executive audiences.
- Strong analytical and problem-solving skills, with the ability to communicate effectively and work across
all levels of the organization.
- Demonstrated commitment to continuous learning and the ability to rapidly acquire and apply new
technical skills as the technology landscape changes.
- Team oriented with a hands-on leadership style.
Preferred
- Experience integrating enterprise data into AI solutions, such as semantic models and curated datasets
that ground Microsoft 365 Copilot, RAG, and agentic workflows.
- Experience with broader Azure data services such as Azure Data Factory, Azure Databricks, Azure
Synapse, and Azure Data Lake Storage.
- Experience with CI/CD, Git integration, and deployment pipelines for Fabric and Power BI content.
- Experience with QAD or comparable ERP data structures.
- Relevant Microsoft Fabric, Azure, or Power BI certifications (for example, Fabric Analytics Engineer,
Fabric Data Engineer, or Power BI Data Analyst), including current Microsoft Applied Skills credentials.
- Experience mentoring technical staff or providing technical leadership across cross-functional teams.
- Experience in distribution, supply chain, manufacturing, or other operationally complex environments.
- Lean, Six Sigma, or continuous improvement certification or equivalent process-improvement
experience.