Manager, Business Intelligence & Data Warehouse

Job Description

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.