What are the responsibilities and job description for the Data Architect position at Growscape?
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