Browse
Employers / Recruiters

Data & Analytics - Data Warehouse Director

cfgi · 30+ days ago
United States
Negotiable
Full-time
Continue
By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.
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.
 

Last updated on Jan 3, 2025

See more

About the company

More jobs at cfgi

Analyzing

Manchester, England

 · 

30+ days ago

Birmingham, Alabama

 · 

30+ days ago

Scotland

 · 

30+ days ago

Scotland

 · 

30+ days ago

Birmingham, Alabama

 · 

30+ days ago

Developed by Blake and Linh in the US and Vietnam.
We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord
Changelog
🚀 LaunchpadNov 27
Create a site and sell services based on your resume.
🔥 Job search dashboardNov 13
Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.
🫡 Cover letter instructionsSep 27
New Studio settings give you control over AI output.
✨ Cover Letter StudioAug 9
Automatically generate cover letters for any job.
🎯 Suggested filtersAug 6
Copilot suggests additional filters above the results.
⚡️ Quick applicationsAug 2
Apply to jobs using info from your resume. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.
🧠 Job AnalysisJul 12
Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.
© 2024 RemoteAmbitionAffiliate · Privacy · Terms · Sitemap · Status