Data Architect

Growscape•Middlefield Village, OH

5d•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

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