Data Architect/Data Modeler Job at California Creative Solutions Inc., Remote

cEtSSHRVU2lVWGlXQVdvVjl1blk0b0RsaUE9PQ==
  • California Creative Solutions Inc.
  • Remote

Job Description

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.

Job Tags

Full time, Part time, Seasonal work,

Similar Jobs

Nueces County Community Action Agency

Janitorial/Maintenance Specialist Job at Nueces County Community Action Agency

 ...eater, and blower, etc. Upkeep presentation of buildings by cleaning and sanitizing all common areas such as furniture, windows, walls...  ...rooms, and thruways. Performs all janitorial/cleaning services on a daily basis. Delivers equipment and supplies. Runs errands... 

Kelly Services

Bookkeeper, QuickBooks Online Job at Kelly Services

 ...Job Description \nKelly Servicesis working with a well-branded clientand seeking a Bookkeeper,QuickBooks Online in Buffalo NY. The role will supportfinancial reports, data entries, G/L and banking services using QuickBooks software. \n \nSee the job details... 

Maxion Research

Virtual Part-time Study Assistant (Hiring Immediately) Job at Maxion Research

 ...Description This gig is perfect for those looking for temporary, remote, part-time work. The hours are flexible and no previous experience is needed. Participants will have the option to choose particular studies based on their ability to participate either online,... 

MRINetwork Jobs

Wireless Network Engineer Job at MRINetwork Jobs

 ...Engineer (F/T & Remote)- Company: Solid fast-growing award winning Cisco Gold Partner - Location: Remote from anywhere Mid Atlantic to...  ...Data Center arena. keywords: cisco sales engineer ccnp ccna ccie route switch, troubleshooting wireless ehahau meraki nexus... 

Infinity Natural Resources LLC

Gas Marketing Commercial Manager Job at Infinity Natural Resources LLC

 ...company located in Morgantown, West Virginia with operations throughout the Appalachian Basin. We are seeking a highly motivated Commercial Manager to join our team and play a pivotal role in managing our crude oil, natural gas, and natural gas liquids exposures through...