RedShift Data Modeler

4 weeks ago

San Francisco, California, United States Saxon Global Full time
Job Description

The Data Modeler must have extensive knowledge in the areas of data modelling, cross-application data standards, data distribution standards, and tuning strategies.

Define and implement data models to manage the way we collect, use, and share data throughout the organization. Lead the implementation of data models and be responsible for ensuring the models scale for broader enterprise.

  • Drive the build out of enterprise data models where applicable working closely with enterprise stakeholders, define data elements and establishes policies and procedures related to the collection and accuracy of models.
  • Develop the insight to understand complex systems and processes and the imagination to find solutions.
  • Work with users of data with excellent communication skills to influence decisions.
Responsibilities:
  • Work with the business, users, lead architect, and designers to define the data requirements and structure for the application(s).
  • Evaluate existing database and create conceptual, logical and physical data models and data flows.
  • Model and design DW schema for redshift based on the current use cases.
  • Evaluate existing Postgres DB model and design and build an Olap model and data flows.
  • Lead the database analysis and design optimized for all consumption patterns.
  • Ensure that the database designs fulfill the requirements, including data volume, frequency needs, and longterm data growth.
  • Assist in determining the crossapplication data standards, data distribution standards, and tuning strategies.
  • Establishes and maintains a data modeling repository and ensures that it is implemented according to standards and that all required personnel have appropriate access to it.
  • Ensuring compliance of data with regulations and identify training needs for all data users.
  • Minimum of bachelor's or equivalent experience is required.
  • 7+ years of Data modelling experience within data and analytics domain including experience in automation.
  • Ability to develop relational, hierarchical and dimensional data models including graph technologies.
  • Ability to develop or revise the database architecture per data requirements.
  • Able to convert data and related techniques to acquire data needed to support testing, training, and other application development activities.
  • Strong capabilities to review project deliverables for completeness, quality, and compliance with established architecture standards.
  • Proficient in documenting and communicating progress against plans, taking corrective action as necessary.
  • Experience with Amazon AWS EC2/S3/RDS/Redshift.
  • Strong experience with multiple database technologies for relational and unstructured data.
  • Experience working with data verification, data management, and data maintenance and experience of remediation data gaps.
  • The ability to perform work with a high degree of independence in terms of selfmanagement of a large variety of tasks and initiatives regarding Quality.
  • Previous experience working in an Agile environment.
  • Excellent communication (written and verbal) and interpersonal skills.
  • Integrations with Data catalogs (business, functional, technical and operational).

  • Cloud Data Engineer

    4 weeks ago

    San Francisco, California, United States Software Guidance & Assistance Full time

    Job Title: Cloud Data Engineer - Data Warehouse SolutionsJob Summary:Software Guidance & Assistance, Inc. is seeking a Cloud Data Engineer to design, develop, and implement data warehouse solutions using AWS Cloud Data Warehousing Technologies. The ideal candidate will have expertise in developing and analyzing complex SQL, data modeling, and ETL tools, as...

  • Business Intelligence Data Analyst

    4 weeks ago

    San Francisco, California, United States Amazon Full time

    About the Role:We are seeking a highly skilled Business Intelligence Engineer to join our Monetization Data Science and Engineering team as a contractor. The successful candidate will be responsible for delivering end-to-end data engineering and business reporting projects for various stakeholders internal to Amazon.The contractor will report to the Director...

  • Data Model Evaluator

    4 weeks ago

    San Francisco, California, United States CUBES Corporate Governance Full time

    CUBES Corporate Governance is seeking a highly skilled professional to fill the role of Data Model Evaluator.This position involves ensuring the accuracy and effectiveness of our models used in various business processes.The ideal candidate will have a strong background in data analysis and modeling, with a keen eye for detail and the ability to work...

  • Senior Data Engineer

    1 month ago

    San Francisco, California, United States Tubi Full time

    About the Role:Tubi, a division of Fox Corporation, is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will play a critical role in building and maintaining our data infrastructure, ensuring the accuracy and reliability of our data pipelines.Key Responsibilities:Design and implement scalable data pipelines using Spark and...

  • Cloud Data Engineer

    4 weeks ago

    San Francisco, California, United States Varite Full time

    Job Title: Cloud Data EngineerJob Summary:We are seeking a highly skilled Cloud Data Engineer to join our team at Varite. As a Cloud Data Engineer, you will be responsible for designing, developing, and implementing complex data warehouse and business intelligence solutions using AWS Cloud Data Warehousing Technologies.Key Responsibilities:* Design and...

  • Senior Data Architect

    1 month ago

    San Francisco, California, United States Storm3 Full time

    Data Architect/Engineering Lead - AI/MLStorm3 is seeking an experienced Data Architect/Engineering Lead to join their fast-growing AI/ML team. This role will design and develop data model/lakehouse and work alongside ML architects/scientists to scale data curation and pipelines for ML on a modern tech stack.Responsibilities:Design, implement, and support...

  • Senior Data Architect

    1 month ago

    San Francisco, California, United States Saxon Global Full time

    Job DescriptionSaxon Global is seeking a highly skilled Data Engineer to join our team. As a key member of our data engineering team, you will be responsible for designing, implementing, and operating large-scale data systems that support our business needs.Key Responsibilities:Design and develop data pipelines using cloud-native services such as AWS S3,...

  • Data Architect

    3 weeks ago

    San Francisco, California, United States Unreal Gigs Full time

    Job Title: Data ArchitectAt Unreal Gigs, we're seeking a highly skilled Data Architect to join our team. As a Data Architect, you'll play a critical role in designing, building, and maintaining our data architecture to support the needs of our organization.Key Responsibilities:Data Architecture Design: Design and architect scalable and efficient data...

  • Data Engineer

    4 weeks ago

    San Francisco, California, United States Trucksmarter Full time

    Transforming the Logistics Industry with DataAt TruckSmarter, we're revolutionizing the logistics industry by harnessing the power of data. As a Data Engineer, you'll play a critical role in designing and building scalable data pipelines that drive business growth and efficiency.Key Responsibilities:Design and implement data pipelines using DBT and AWS...

  • SAP HANA Data Modeler

    4 weeks ago

    San Francisco, California, United States Diverse Lynx Full time

    Job Title: SAP HANA Data ModelerJob Summary: We are seeking a highly skilled SAP HANA Data Modeler to join our team at Diverse Lynx LLC. The successful candidate will be responsible for designing, developing, and implementing data models that meet the needs of our business.Key Responsibilities:Design and develop data models using SAP HANA tools and...

  • SAP HANA Data Modeler

    4 weeks ago

    San Francisco, California, United States Diverse Lynx Full time

    Job DescriptionWe are seeking a highly skilled SAP HANA Data Modeler to join our team at Diverse Lynx LLC. As a key member of our analytics team, you will be responsible for designing, developing, and migrating data analytics solutions using SAP HANA.Key Responsibilities:Design and develop data models for SAP HANADevelop and migrate data analytics...

  • Cloud Data Engineer Position

    4 weeks ago

    San Francisco, California, United States Stefanini Full time

    Job DetailsStefanini is seeking a skilled Cloud Data Engineer to join our team in San Francisco, CA. As a Cloud Data Engineer, you will contribute to the design, development, and implementation of complex data warehouse and business intelligence solutions.Key ResponsibilitiesDesign and develop complex data warehouse applicationsDevelop software from...

  • Cloud Data Engineer

    4 weeks ago

    San Francisco, California, United States Varite Full time

    Job SummaryVarite is seeking a highly skilled Cloud Data Engineer to join our team. The ideal candidate will have expertise in developing and analyzing complex SQL on various RDBMS, as well as experience with ETL tools and AWS Cloud Data Warehousing Technologies.Key Responsibilities Contributes to the design, development, testing, implementation, and review...

  • Data Warehouse Architect

    4 weeks ago

    San Francisco, California, United States Unreal Gigs Full time

    Job Title: Data Warehouse ArchitectAt Unreal Gigs, we're seeking a highly skilled Data Warehouse Architect to join our team. As a key member of our data engineering team, you'll be responsible for designing, building, and maintaining our data warehouse infrastructure and systems.Key Responsibilities:Design and architect scalable and efficient data warehouse...

  • Data Engineer

    4 weeks ago

    San Francisco, California, United States Diverse Lynx Full time

    Data Engineering RoleWe are seeking a skilled Data Engineer to design, build, and maintain scalable and efficient data platforms using data engineering technologies such as Glue, EMR, Athena, Redshift, Lake Formation, Apache Spark, Hive, HDFS, and Trino.Key Responsibilities:Design and develop data pipelines and common data-related cross-cutting concerns like...

  • Senior Data Engineer

    4 weeks ago

    San Francisco, California, United States Capital One Full time

    Transformative Data Engineer Role at Capital OneAre you passionate about harnessing data to drive business growth? Do you thrive in a collaborative environment where innovation meets technical expertise? At Capital One, we're seeking a seasoned Data Engineer to join our team of pioneers in the technology space.Key Responsibilities:Collaborate with Agile...

  • Lead Data Scientist for Marketing Transformation

    4 weeks ago

    San Francisco, California, United States Pendulum Full time

    About PendulumPendulum is revolutionizing the world of health and wellness by harnessing the power of the human microbiome. Our cutting-edge probiotic pipelines and discovery platform are unlocking the secrets of bacterial strains and prebiotics, transforming the consumer probiotics market into a new category of therapeutic offerings.We are seeking a Lead...

  • Data Engineer for Large Language Models

    4 weeks ago

    San Francisco, California, United States Acceler8 Talent Full time

    About Acceler8 Talent: We are a pioneering company at the forefront of AI and ML technology, where human-computer collaboration is not just a concept but a reality. Our team is dedicated to revolutionizing user experiences by innovating at every level, from user interfaces down to the most efficient models. Our founders have already published one of the most...

  • Enterprise Data Engineer

    23 hours ago

    San Francisco, California, United States Forhyre Full time

    Job DescriptionWe are seeking a highly skilled Enterprise Data Engineer to join our team at Forhyre.The ideal candidate will have expertise in designing and developing ETL processes based on functional and non-functional requirements using Python/Pyspark within the Azure platform.In this role, you will be responsible for understanding the full end-to-end...

  • Senior Data Science Engineer

    7 days ago

    San Francisco, California, United States Robotics Prcocess Automation, LLC Full time

    We are seeking an experienced Senior Data Science Engineer to join our team in developing cutting-edge algorithm solutions. The ideal candidate will have a strong background in computer science, machine learning, and data analysis.Job Description:Design and implement scalable data processing pipelines for analytical and predictive platform...