BI & Data Warehouse Leader & Architect

CGS Business Solutions; Texas; On-site; USD 120,000 - 150,000; Full time

Job summary

CGS Business Solutions is seeking a senior Manager of BI & Data Warehouse to lead the design, development, and operation of the enterprise data and reporting platform for a major client in the financial services space.

The role will manage BI developers and data warehouse engineers, oversee SQL Server and Azure-based architecture, and drive ETL pipelines with Azure Data Factory and SSIS while enabling advanced analytics with Tableau and Power BI.

Qualifications

• 7+ years BI/Data experience.
• 2+ years leadership.
• Strong SQL Server and T-SQL.
• Data modeling experience.

Responsibilities

• Lead and manage BI developers and data warehouse engineers.
• Architect and oversee enterprise data warehouse using SQL Server and Azure.
• Design and maintain ETL pipelines using Azure Data Factory and SSIS.
• Develop dimensional data models for reporting and analytics.
• Build and manage Tableau dashboards and datasets.
• Support Power BI reporting initiatives.
• Optimize SQL queries, stored procedures, and data pipelines.
• Ensure data quality, governance, and security.
• Collaborate with teams integrating LOS, Salesforce, and vendor data.
• Support executive reporting and analytics needs.

Skills

BI/Data experience

Leadership

Data modeling

Tools

SQL Server

T-SQL

Azure Data Factory

SSIS

Tableau

Power BI

Job description

CGS Business Solutions is seeking a senior Manager of BI & Data Warehouse to lead the design, development, and operation of the enterprise data and reporting platform for a major client in the financial services space.

The role will manage BI developers and data warehouse engineers, oversee SQL Server and Azure-based architecture, and drive ETL pipelines with Azure Data Factory and SSIS while enabling advanced analytics with Tableau and Power BI.