Senior Cloud BI Architect for AWS Redshift & Matillion

GTN Technical Staffing; Frisco (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

GTN Technical Staffing is seeking an experienced Business Intelligence Architect to lead the design, development, and evolution of its enterprise data warehouse and BI platform.

The role will architect scalable cloud-based data solutions, develop modern ETL/ELT pipelines with Matillion, and optimize AWS Redshift for enterprise reporting and analytics. 7+ years of BI/DW experience, advanced SQL, and ERP integration are highly valued.

Qualifications

• 7+ years of experience designing and developing enterprise BI or data warehouse solutions.
• Advanced SQL development and query optimization skills.
• Experience building modern ETL/ELT pipelines.
• Strong understanding of enterprise data warehouse architecture.
• Experience with dimensional modeling, star schemas, and Slowly Changing Dimensions.
• Experience integrating ERP platforms and other enterprise applications.
• Experience supporting enterprise reporting, analytics, and row-level security.
• Strong analytical, communication, and stakeholder-management skills.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field, or equivalent experience.

Responsibilities

• Design, develop, and maintain enterprise data warehouse solutions.
• Architect scalable ETL/ELT pipelines using Matillion.
• Build and optimize cloud data warehouse solutions within AWS Redshift.
• Translate business and reporting requirements into scalable data architectures.
• Design dimensional data models, including star schemas and Slowly Changing Dimensions.
• Map ERP and enterprise application data into standardized warehouse structures.
• Develop, test, deploy, and support batch and near real-time data pipelines.
• Define metadata, data lineage, transformation logic, and ETL development standards.
• Support Power BI reporting, dashboards, and enterprise analytics initiatives.
• Troubleshoot production issues and improve data quality, reliability, and performance.
• Promote best practices for data governance, security, architecture, and software delivery.
• Evaluate new cloud, data engineering, and business intelligence technologies.

Skills

Advanced SQL

ETL Development

Stakeholder communication

Data analysis

Education

Bachelor's degree in Computer Science or related field

Tools

Matillion

AWS Redshift

Python

Power BI

Informatica

SSIS

ODI

JD Edwards

Job description

GTN Technical Staffing is seeking an experienced Business Intelligence Architect to lead the design, development, and evolution of its enterprise data warehouse and BI platform.

The role will architect scalable cloud-based data solutions, develop modern ETL/ELT pipelines with Matillion, and optimize AWS Redshift for enterprise reporting and analytics. 7+ years of BI/DW experience, advanced SQL, and ERP integration are highly valued.