Data Architect/Data Modeler

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.

Job Overview:

In this Data Architect role, you will focus on designing and governing data architecture to facilitate data-driven decision making. Your responsibilities will include crafting and overseeing the implementation of efficient data ingestion strategies, ensuring robust ETL processes, and maintaining data quality and accessibility. You will leverage your expertise in Snowflake data warehousing, SQL optimization, and data integration technologies to drive the data strategy forward, with a primary emphasis on design and governance rather than hands-on implementation.

You will also have the chance to deliver data-driven organizational transformation, utilizing on-premises and cloud data and applying the best practices and methods in this field.

Your responsibility will be:

• Take the initiative and ownership of work streams and clients
• Design and architect to appropriately safeguard data security, data integrity, and data privacy at the conceptual and logical level.
• Own the definition and implementation of the Data Architecture Roadmap to support the client's strategic and operational roadmap.
• Design and implement data integration solutions to consolidate data from various sources into clients' analytical platforms and develop and manage data ingestion pipelines using modern technologies for timely and accurate data availability.
• Lead the development of efficient, scalable, and maintainable ETL processes and frameworks to extract, transform, and load data into the data artefacts.
• Collaborate with business analysts and stakeholders to create and maintain source-to-target mappings, documenting data lineage and transformation logic to ensure accurate data requirements.
• Implement best practices for data modeling, security, and performance optimization in Data Warehouse systems (Cloud and On-Premises) to design and manage data warehousing solutions.
• Collaborate with data engineers, data scientists, and business stakeholders to provide comprehensive data solutions while offering technical leadership and mentorship to junior team members.
• Provide technical expertise during client meetings, helping to address questions and concerns related to data architecture and management.

Key skillset required:

• Excellent problem-solving, attention to detail, and communication skills (written and spoken)
• Proven technical expertise in Data Architecture, Data Management, or in a similar role.
• Experience in system-level architecture and conducting dimensional modeling.
• Extensive experience in designing performant data warehouse schemas, e.g., star and snowflake schemas, with a deep understanding of the tradeoffs related to normalization/denormalization.
• Extensive experience working with Cloud or On-premises data warehousing systems like Snowflake, Synapse, Big Query, Redshift, Teradata, DB2, Oracle, etc.
• Experience in the management of structured, semi-structured, and unstructured data like tabular, parquet, Avro, JSON, XML, audio, video, etc.
• Experience with any major public cloud, preferably AWS, Azure, and their data services.
• Knowledge of big data technologies such as Hadoop, Spark, Flink, Kafka, Databricks, Synapse, etc.
• Proficient in SQL and experienced in query planning and optimization.
• Strong background in data integration, ETL development, and data ingestion technologies like DBT, SQL Mesh, Spark, Python, Matallion, etc.
• Experience with data profiling, source target mappings, and data quality management with tools like Open Metadata, Datahub, Great Expectations, Atlan, Alation, etc.
• Familiarity with testing methodologies and implementation processes.
• Familiarity with data governance and compliance standards like GDPR, HIPAA, etc.
• Experience with at least one major data visualization/BI platform such as Tableau, Power BI, Qlik, Cognos, etc. is a plus.