Talent.com
GTN Technical Staffing
Business Intelligence ArchitectGTN Technical Staffing • Dallas, TX, US
Business Intelligence Architect

Business Intelligence Architect

GTN Technical Staffing • Dallas, TX, US
5 days ago
Salary
$135,000.00–$150,000.00 yearly
Job type
  • Permanent
  • Quick Apply
Job description


Our client is seeking an experienced Business Intelligence Architect to lead the design, development, and evolution of its enterprise data warehouse and business intelligence platform.

This individual will architect scalable data solutions, build modern ETL/ELT pipelines, and enable enterprise reporting through cloud-based data technologies. The ideal candidate has deep experience with Matillion, AWS Redshift, dimensional data modeling, and enterprise data warehousing best practices.

This role partners with business leaders, developers, analysts, and infrastructure teams to deliver reliable, high-performance data solutions that support strategic business decisions.
Responsibilities

  • Design, develop, and maintain enterprise Data Warehouse solutions.
  • Architect scalable ETL/ELT data pipelines using Matillion.
  • Build and optimize cloud-based data warehouse solutions utilizing AWS Redshift.
  • Analyze business requirements and translate them into scalable data architectures.
  • Design dimensional data models including Star Schemas and Slowly Changing Dimensions (SCD).
  • Map source system data into enterprise data warehouse structures.
  • Develop, test, deploy, and support ETL/ELT processes.
  • Build both batch and near real-time data integration pipelines.
  • Define metadata, data lineage, transformation logic, and ETL standards.
  • Integrate ERP and other enterprise applications into the data platform.
  • Support reporting and analytics initiatives using Power BI and other visualization platforms.
  • Troubleshoot production issues while continuously improving data quality and performance.
  • Partner with business stakeholders to understand reporting and analytics needs.
  • Evaluate emerging BI, cloud, and data engineering technologies to improve the enterprise analytics platform.
  • Promote best practices for data governance, architecture, security, and software delivery.

Required Qualifications

  • Bachelor's degree in computer science, Information Systems, Engineering, or a related technical discipline (or equivalent experience).
  • 7+ years of experience designing and developing enterprise Business Intelligence or Data Warehouse solutions.
  • Expert-level SQL development skills.
  • Strong hands-on experience with Matillion is required.
  • Strong experience with AWS Redshift is highly preferred.
  • Experience building modern ETL/ELT pipelines.
  • Deep understanding of enterprise Data Warehouse architecture.
  • Experience with dimensional modeling including Star Schema design.
  • Experience with Slowly Changing Dimensions (SCD).
  • Experience with row-level security and enterprise reporting solutions.
  • Experience integrating ERP platforms (JD Edwards or similar ERP systems preferred).
  • Strong analytical and problem-solving skills.
  • Excellent communication and stakeholder management abilities.

Preferred Experience

  • AWS technologies including Redshift, EC2, and S3.
  • Python for data engineering and automation.
  • Experience with Power BI or other enterprise visualization platforms.
  • Knowledge of Informatica, SSIS, ODI, or similar ETL technologies.
  • Experience working with structured and unstructured data.
  • Background supporting enterprise-scale cloud data platforms.

Ideal Candidate
We're looking for someone who enjoys solving complex data challenges and building scalable enterprise solutions. You'll be successful in this role if you are:

  • Passionate about modern data architecture
  • Highly collaborative across business and IT teams
  • Comfortable leading technical discussions and solution design
  • Focused on data quality, scalability, and performance
  • Continuously learning new cloud and analytics technologies


Travel: Less than 5%

If you're passionate about building modern cloud-based data platforms and want to make a significant impact within a growing enterprise environment, we'd love to speak with you.

Create a job alert for this search

Business Intelligence Architect • Dallas, TX, US

Similar jobs

CDB AI & Analytics - Agile - Story Author - XAG111

First Soft SolutionsAllen, TX, United States
Full-time

Follow implementation timeline and report progress and impediments to senior management.Work with partner teams to choreograph dependencies and follow program timeline to completion.Expertise in Ag... Show more

 • Promoted

Oracle Generative AI Associate Vice President

DeloitteDallas, TX, United States
Full-time

Oracle Generative AI Architect Associate Vice President.Today's chief financial officers (CFOs) and supply chain executives are being asked to improve business performance and shareholder value, al... Show more

 • Promoted

MES Solution Architect Manager

DeloitteDallas, TX, United States
Full-time

Manufacturing Execution Systems Solution Architect Manager.We are a team of strategic advisors, architects, and implementers who drive business transformations.Our diverse talent energizes clients'... Show more

 • Promoted

Senior Azure Cloud Solutions Architect (Infrastructure)

Argyle InfotechPlano, TX, United States
Full-time

Senior Azure Cloud Solutions Architect (Infrastructure).Type: Full-time In-person Client: Digital Minds/Fisher Investments Location: Plano, TX (or) Tampa, Florida NO C2C.As the Senior Cloud Solutio... Show more

 • Promoted

Solution Architect

TradeJobsWorkForce75074 Plano, TX, US
Full-time

Solution Architect Job Duties: Responsible for assisting in the establishment of an IT Archit... Show more

 • Promoted

Cloud Security Senior Manager Azure Infrastructure & AI

DeloitteDallas, TX, United States
Full-time

Deloitte is committed to providing reasonable accommodations for people with disabilities.If you require a reasonable accommodation to participate in the recruiting process, please direct your inqu... Show more

 • Promoted

MES Solution Architect Manager (iBase-t Solumina)

DeloitteDallas, TX, United States
Full-time

Manufacturing Executions Systems Solution Architect Manager (iBase-t Solumina).We are a team of strategic advisors, architects, and implementers who drive business transformations.Our diverse talen... Show more

 • Promoted

Product Owner / Business Architect

E-SolutionsDallas, TX, United States
Full-time

Product Owner / Business Architect.We are seeking an experienced Business Architect / Product Owner with a strong background in the Life & Annuity Insurance domain.The ideal candidate will act as a... Show more

 • Promoted

Cloud Security Manager Azure Infrastructure & AI

DeloitteDallas, TX, United States
Full-time

Our Deloitte Cyber team understands the unique challenges and opportunities businesses face in cybersecurity.Join our team to deliver powerful solutions to help our clients navigate the ever-changi... Show more

 • Promoted

Azure Data Architect (Dalas)

1872 ConsultingDallas, TX, United States
Full-time

Our client is a technology-driven organization focused on digital and data transformation across enterprise systems.They are building scalable, cloud-based data platforms to enable analytics, AI, a... Show more

 • Promoted

IOS Mobility Architect - Plano, TX

Georgia IT, Inc.Plano, TX, United States
Full-time

US citizen, Green Card and EAD preferred, no visa sponsorship available for this job and no third party agencies C2C.Play advisory role in Mobility space.Years of Mobile Development Experience.Demo... Show more

 • Promoted

Information Architect

TradeJobsWorkForce75398 Dallas, TX, US
Full-time

Information Architect Job Duties: Identifies user requirements by researching and analyzing user needs, ... Show more

 • Promoted

Senior Security Architect

TradeJobsWorkForce75240 Dallas, TX, US
Full-time

Senior Security Architect Job Duties: Enhances security team accomplishments and competence by planning deliv... Show more

 • Promoted

Lead Consultant / Business Intelligence - Reporting / SAP BW

Argyle InfotechRichardson, TX, United States
Full-time

Lead Consultant | Business Intelligence - Reporting | SAP BW.Work Location: Richardson, TX 75082 (Onsite).Target Start Date: 31 Mar 2026.Does this position require Visa independent candidates only?... Show more

 • Promoted

Cloud Security Architect + PM

IntersourcesFrisco, TX, United States
Full-time

Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries.Our history spans over 16 years an... Show more

 • Promoted

Product Manager (or Business Architect)

Syntricate TechnologiesFrisco, TX, United States
Full-time

Product Manager (or Business Architect).Product Manager (or Business Architect) In Bellevue WA, Frisco TX (Day 1 Onsite) Location for a W2 position.In case, if you are not comfortable with this loc... Show more

 • Promoted

CDE II - Apps, Public/Private Cloud, Infra, Security, Workspace, Consulting Focused

NTT DATADallas, TX, United States
Full-time

CDE II - Apps, Public/Private Cloud, Infra, Security, Workspace, Consulting Focused.NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us.If you want ... Show more

 • Promoted

Big Data Architect

Argyle InfotechDallas, TX, United States
Full-time

Skills: Databricks and Pyspark Experience, Migration from Teradata to Databricks using Pyspark. Show more

 • Promoted

Business Intelligence - Project Manager

Sonoma Consulting IncPlano, TX, United States
Full-time

Business Intelligence - Project Manager.Sonoma Consulting is one of the fastest growing national IT Consulting and Executive Search company in the United States, which was founded in 2011 by Mark M... Show more

 • Promoted

Data Governance Architect

KaavDallas, TX, United States
Full-time

Location: Remote position (US).Minimum 13 plus experience in Data Governance architecture.Must have Apparel Industries like Nike, Puma, Amazon, Adidas, etc.Retail experience, MDM experience, catego... Show more