Manager, Business Intelligence & Data Warehouse (REMOTE)

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 committed to helping you, as an esteemed IT Professional, find the next right step in your career. We match professionals like you to rewarding consulting or full-time opportunities in your area of expertise. We are currently seeking Technical Professionals who are searching for challenging and rewarding jobs for the following opportunity:

Position Summary

CGS is hiring for one our long time customer in the Financial Services space who is seeking a FULL-TIME Manager of Business Intelligence & Data Warehouse. This opportunity will lead the design, development, and operation of the enterprise data and reporting platform. This role is responsible for managing BI developers and data warehouse engineers while driving the architecture and delivery of scalable data models, ETL pipelines, and advanced analytics solutions. The ideal candidate has deep experience in SQL Server, Azure Data Factory, and BI tools such as Tableau and Power BI.

Key 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.

Qualifications

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

Preferred

• Power BI experience

About CGS Business Solutions:

CGS specializes in IT business solutions, staffing and consulting services. With a strong focus in IT Applications, Network Infrastructure, Information Security, and Engineering. CGS is an INC 5000 company and is honored to be selected as one of the Best IT Recruitment Firms in California. After five consecutive Fastest Growing Company titles, CGS continues to break into new markets across the USA. Companies are counting on CGS to attract and help retain these resource pools in order to gain a competitive advantage the rapidly changing business environments.