Manager Business Intelligence Data Warehouse

CGS Business Solutions; Dallas (TX); On-site; USD 140,000 - 150,000; Full time

Job summary

CGS Business Solutions is seeking a seasoned Manager of BI & Data Warehouse for a long-time client in the Financial Services sector. This full-time role leads the enterprise data and reporting platform, managing BI developers and data warehouse engineers.

You will drive architecture, design scalable data models, ETL pipelines, and advanced analytics using SQL Server, Azure Data Factory, Tableau, and Power BI, ensuring data quality, governance, and secure reporting across the organization.

Qualifications

• 7+ years of BI and data warehousing experience.
• 2+ years in a leadership role overseeing BI teams.
• Strong SQL Server and T-SQL skills.
• Experience with Azure Data Factory and ETL development.
• Experience with Tableau and Power BI.

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

SQL Server / T-SQL

Azure Data Factory

Tableau

Power BI

Data modeling

Tools

SSIS

Azure Synapse

Azure Fabric

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
• Azure Data Factory / ETL experience
• Tableau expertise
• Data modeling experience

Preferred

• Power BI experience
• Azure Synapse or Fabric
• Financial services 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.

Compensation

Compensation: $140,000-$150,000 per year