Data & Analytics - Data Warehouse Director

CFGI is seeking an experienced data-driven team member to join the Data and Analytics team in Business Transformation as a Director. As a member of the team, you will be collaborating with clients by creating, developing, designing, and implementing processes and tools that will change how our clients use their most powerful resource – data. The Data and Analytics team helps clients define data strategies, build automation processes, and develop visualizations + predictive analytics tools to deliver impactful solutions and help our clients achieve business objectives using a data driven approach.

You will be responsible for managing various client projects, communicating business objectives to cross-functional stakeholders and providing input on both business process operations and data analytics tool specifications. You will be expected to work independently yet collaboratively with key stakeholders across a client’s organization to oversee projects and drive transformation. Additional responsibilities include tasks specific to scope development, budget creation and monitoring, as well as development of internal tools and templates to help drive team development.

An effective team member can incorporate a strong CPA/Finance and technical background in building client solutions to address client’s business needs using data analytics tools. The team is tool agnostic in building a customized solution for our clients and uses various tools such as Python or Alteryx for data business process automation and PowerBI or Tableau for dashboarding. Effective communication and organizational skills will be imperative to your success in this role. Requisite working knowledge gained through professional working experience on data analytics projects is foundational to successfully initiate, plan, execute, monitor, control, and close projects.

 Roles and Responsibilities:

·       Design, develop and implement data warehouse strategies that align with the client’s goals and business objectives.

·       Integrate new data platforms with existing data warehouses. Develop and maintain extract, transform, and load (ETL) processes.

·       Build and maintain data warehouse objects and create support documentation.

·       Strong problem-solving skills with ability to work independently, owning and driving projects from requirements through execution by implementing various data analytics solutions.

·       Ensure accuracy, integrity, security, compliance, and backups of data warehouse and create disaster recovery plans.

·       Optimize data warehouses storage, scalability and performance to technical requirements.

·       Implement business logic for reporting and analysis.

·       Work closely with stakeholders to understand their business needs, developing and maintaining strong internal and client relationships to manage cross-functional projects/initiatives.

·       Director-level candidates must have project management experience in cross-functional engagements including accounting/finance, FP&A, modeling, and/or tech implementation.

·       Must be able to effectively communicate complex, technical topics to a novice, non-technical audience with a passion for collaboration, learning new technologies, and client success.

·       Ability to manage individual and supporting staff workflows and task responsibilities.

Skills and Competencies:

·       Data Modeling and Analytics

·       ETL Design and Data Pipelines

·       Data Architecture Design

·       Relational / Non-relational Databases

·       Data warehouse schemas (star, snowflake, and hybrid)

·       Restful APIs and Middleware

·       Programming (e.g., SQL, Java, Python, R)

·       RDMS (relational database management systems) such as SQL Server, Oracle, AWS Redshift

·       Exposure to data platforms (e.g., Snowflake, Databricks)

·       Master Data Management and Data Governance

·       Disaster Recovery, Security, and User Access

·       Data portioning, indexing, and query optimization

·       Solution Architecture

·       Workflow Automation

·       Data Engineering

Qualifications and Capabilities:

We would like individuals to have a balanced breakdown of the following skills:

1)     Must have: The candidate should have strong soft skills and general areas of technical competence, as this is the backbone of the candidate’s day to day work in the Business Transformation group here at CFGI.

2)     ‘Major’ concentration: At least one technical skill that the user is Certified in and has been using on a consistent basis for 4+ years; Considers themselves near ‘fluent’ or ‘super-user’.

3)     ‘Minor’ concentrations:  At least 3+ technical skills that the individual has at the very least.

Must Have (Core Experience):

·       Bachelor’s degree is required; educational backgrounds in quantitative fields like Accounting/Finance, Information Systems, Statistics, and Computer Science is preferred.

·       CPA or other relevant designations are preferred.

·       Analytics background and experience, preferably in a client service environment.

·       Solid communication, teaming, presentation and project management skills.

·       Ability to research and generate ad-hoc solutions to problems.

Major/Minor Competencies:

·       Programming/Scripting: Python, Java (R acceptable but not preferred).

·       Data Query: SQL Server, Oracle, PostgreSQL, MySQL, MongoDB, Cassandra.

·       Relational Data: Database syntax (Table Structure, Joins, Filters).

·       Data Warehouses: Snowflake, AWS Redshift, Google BigQuery, Azure Synapse.

·       Data Pipeline: Apache Airflow, Luigi, Kafka.

·       Analytics: Apache Spark.

·       Automation: Kubernetes, Docker, Terraform.