Data / BI Architect

Overview

On Site
Accepts corp to corp applications
Contract - W2
Contract - Independent

Skills

UI
Information Technology
Network
Microsoft
Tier 1
Recruiting
Training
Partnership
Communication
Project Scoping
Data Architecture
Business Strategy
Bridging
Decision-making
Collaboration
Data Modeling
Data Marts
Visualization
Meta-data Management
Data Governance
Data Quality
Regulatory Compliance
Organizational Skills
Performance Tuning
IT Management
Mentorship
Data Warehouse
Dimensional Modeling
Amazon S3
Amazon Redshift
Amazon RDS
Remote Desktop Services
Data Lake
Storage
Analytics
Databricks
Snow Flake Schema
Informatica
Database
SQL
Microsoft SQL Server
Oracle
PostgreSQL
MongoDB
Business Intelligence
Microsoft Power BI
Business Objects
Tableau
Crystal Reports
Extract
Transform
Load
ELT
Amazon Web Services
Microsoft Azure
Google Cloud
Google Cloud Platform
Data Flow
Warehouse
Talend
Big Data
Apache Hadoop
Apache Kafka
API
Python
Keras
scikit-learn
R
XML
Machine Learning (ML)
Analytical Skill
TensorFlow
PyTorch
Trillium
Apache Spark
Modeling
Microsoft Visio
ER/Studio
PowerDesigner
Cloud Computing
SaaS
Oracle Linux

Job Details

CCS Global Tech is a rapidly growing Information Technology company with a diverse portfolio of technology products and services and a large network of industry partnerships. With over 22 years of being a successful business with a global talent pool and presence, CCS is a certified Microsoft Gold Partner and specializes in delivering expert Microsoft based solutions for technical and business needs. We have been recognized by Inc. 500 Magazine as one of the fastest growing small companies in the Unites States.
we are a Tier 1 vendor for the City and County of San Francisco for Cloud Services, Staffing Services and Training Services. For this multi-year opportunity with a diverse set of needs to address, we are currently focusing on establishing partnerships with individuals as well as companies who can help us enhance our overall service portfolio, cut lead times, and ultimately help us deliver successfully. We currently hold sizable Government accounts in the San Francisco bay area including City and County of San Francisco, San Mateo County, and Santa Clara County.
We take great pride in our global reach and local influence. Your experience alongside our highly skilled and talented internal team who guide you along the way, offers key insights into what helps you stand out in a competitive job market.
If you are a partner company, please submit resumes with contact information of your own W2 Consultants only. Submitted consultants are expected to have excellent communication skills.

Project Scope:

Data Business Intelligence (BI) Architect role is a hybrid of data architecture, engineering & business strategy, bridging the gap between tech data solutions & business objectives. Designs, develops & maintains the overall data strategy ensuring the County data in scope is accessible, reliable & secure for analysis and

decision-making. The right candidate has experience in architecting data solutions that can be used for descriptive, diagnostic, predictive & prescriptive analytic solutions

Roles/Responsibilities:

Stakeholder Collaboration: Work closely with business & IT stakeholders to gather req & translate business needs into tech specifications, including identification of data sources. Data Arch Design & Data Modeling: Architect & implement scalable, secure & efficient data solutions, including data warehouses, data lakes, and/or data marts. Design conceptual, logical & physical data models. Tool and Platform Selection: Evaluate, recommend & implement tools aligned with recommended architecture, including visualization tools aligned with business needs.

ETL/ELT Pipeline Mgt: Design, develop & test data pipelines, integrations to source mgt & ETL / ELT processes to move data from various sources into the data warehouse. Data Catalog & Metadata Mgt: Design, create & maintain an enterprise-wide data catalog, automating metadata ingestion, establishing data dictionaries, and ensuring that all data assets are properly documented & tagged.

Data Governance and Discovery: Enforce data governance policies through the data catalog, ensuring data quality, security & compliance. Enable self-service data discovery for users by curating & organizing data assets in an intuitive way. Performance Optimization: Monitor & optimize BI systems & data pipelines to ensure high performance, reliability & cost-effectiveness. Technical Leadership: Provide technical guidance & mentorship across the organization, establishing best practices for data mgt & BI development.

Mandatory Skills:

  1. Experience Level: 5+ years
  2. Must be able to be on-site at OCIT Building a MINIMUM of two days a week. Please DO NOT re-submit candidates previously considered for Requisition #462.

Desirable Skills:

Environment: Role incl. defining data platform tech stack. Example tech below; not required to have experience in all.

  1. Data Platforms: DW & lake concepts incl. dimensional modeling & cloud services (S3, AWS Redshift, RDS, Azure Data Lake Storage, Synapse Analytics, BigQuery, Databricks, Snowflake, Informatica);
  2. Databases: SQL & relational/non-relational (SQL Server, Oracle, PostgreSQL, MongoDB); BI Tools: Power BI, Business Objects, Tableau, Crystal, Looker.
  3. ETL/ELT: Cloud native (AWS Glue, Azure Data Factory, Google Cloud Dataflow) & in-warehouse transform tools (Fivetran, Talend, dbt);
  4. Big Data Tech: Hadoop, Spark, Kafka; Programming/API: Python, Keras, Scikit-learn, R, XML; ML/DL/Analytic Engines: TensorFlow, PyTorch, Trillium,
  5. Apache Spark; Modeling Tools: MS Visio, ER/Studio, PowerDesigner; Source systems incl. on-prem, cloud, & SaaS;
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About CCS Global Tech