Data Architect

The Data Analyst / Data Architect (hybrid role) is to transform, unify, and elevate the organization's data capabilities by extracting, improving, and integrating data across multiple business systems. The role exists to ensure accurate, accessible, and timely data that supports operational reporting, executive decision-making, and long-term data strategy. Initially focused on hands-on reporting and analysis, the position evolves into designing scalable data models, pipelines, and enterprise reporting solutions that reduce manual effort, improve performance, and enable consistent insights across the business. Key Responsibilities Data Extraction & Analysis Extract, analyze, and validate data from internal systems, including CMS applications and SQL Server databases Quickly learn and navigate complex data structures, particularly CMS Build and maintain Excel-based reports using ODBC connections Partner with business users to define reporting requirements and ensure data accuracy Reporting & Visualization Transition reporting from Excel to scalable platforms such as Power BI and Microsoft Fabric Design and develop dashboards and reports for various business units (Sales, Operations, Finance, etc.) Ensure data consistency, usability, and performance across reporting solutions Data Modeling & Architecture Integrate and model data from systems including SalesPad and Microsoft Dynamics GP (Great Plains) Design and implement a unified data model across multiple business systems Develop executive dashboards to consolidate and transform enterprise data Support the evolution toward a centralized data platform (Fabric/Lakehouse/Warehouse) Data Integration & Engineering Build and optimize data pipelines using SQL and modern data tools Ensure data quality, governance, and consistency across systems Identify and implement opportunities to automate manual reporting processes Collaboration & Continuous Improvement Collaborate with IT, Finance, Sales, and Operations teams Translate business requirements into technical data solutions Recommend improvements to data architecture, reporting, and analytics strategy 4-8 years of experience in data analysis, data engineering, or data architecture Strong proficiency in SQL, including querying, joins, transformations, and performance tuning Experience working with relational databases (SQL Server preferred) Advanced experience with Microsoft Excel, including ODBC-based reporting Experience with Power BI, including data modeling, DAX, and visualization Proven ability to quickly learn and navigate complex data structures Preferred Qualifications Experience with Microsoft Fabric or similar platforms (Azure Data Factory, Synapse, etc.) Experience with ERP/CRM systems such as SalesPad and Microsoft Dynamics GP (Great Plains) Experience designing data models (e.g., star schema, dimensional modeling) Familiarity with ETL/ELT processes and data integration tools Understanding of data warehousing concepts (Lakehouse/Warehouse architecture) Experience with data governance and data quality frameworks