Azure Data Architect

2 weeks ago

Sacramento, CA, United States Northern Base Full time
Modern Data Platform
  • Excellent written and verbal communication
  • Must have worked on several (5+) projects building solutions for Data Pipelines, Data warehousing, Data Modelling on Azure Data Platform
  • Expertise in design and development of Data pipelines and ETL using ADF, Databricks to move data from relational/structured/unstructured data from source to data lake to data warehouse, on Azure
  • Creating Pipelines and integrations of multiple data sources
  • Data processing and transformation using Databricks (Scala/Python)
  • Expertise in optimizing cost and performance of data pipelines
  • Experience working with Data Lake, Synapse on Azure
  • Designing Data Lake storage layer (Landing/staging, raw, trusted/curated zones)
  • Designing data storage DB schema, data models and processing on Azure Synapse DW
  • Experience with Synapse Spark Pool
  • Experience in Data Modelling
  • Building Data Models from structured and semi-structured data (Data Model, Common Data Model etc.)
  • Performance optimization of data model for high performance analytical and reporting workloads
  • Expertise with SQL Server and extensive experience with SQL programming
  • Programming and optimizing DB objects Views, Stored Procs, Functions
  • Good experience in defining data access policy and security for azure data services
  • Experience with Oracle EDW
  • Knowledge/Experience migrating from Oracle EDW to any cloud DW
  • Experience integrating AI skills/ML models with Data and reporting solutions
  • Experience in building API layer for downstream consumption
Reporting - Good to have
  • Expertise in building scalable high performance reporting solution using Power BI, in both shared and dedicated capacity
  • Designing Reports against cloud and on-prem data sources
  • Performance analysis and optimization of slow performing reports/visuals
  • Import models and Direct Query
  • Expertise in integrating Power BI reports with custom applications using Power BI Embedded or Premium
  • Experience working with Power BI Paginated reports
  • Building data models in Power BI
  • Hands-on with DAX
  • Migrating reports from Tableau to Power BI

  • BI Data Architect

    1 week ago

    West Sacramento, CA, United States DCI Donor Services Full time

    DCI Donor Services (DCIDS) is looking for a dynamic and enthusiastic team member to join us to save lives!! Our mission at DCI Donor Services is to save lives through organ donation and we want professionals on our team that will embrace this important work!! We are currently seeking a BI Data Architect. The BI Data Architect will design, deploy, and...

  • BI Data Architect

    2 days ago

    West Sacramento, CA, United States DCI Donor Services Full time

    DCI Donor Services (DCIDS) is looking for a dynamic and enthusiastic team member to join us to save lives!! Our mission at DCI Donor Services is to save lives through organ donation and we want professionals on our team that will embrace this important work!! We are currently seeking a BI Data Architect. The BI Data Architect will design, deploy, and...

  • Data Architect

    2 weeks ago

    Sacramento, CA, United States Oracle Full time

    Job Description This platform will integrate diverse data sources and leverage AI/ML solutions for industry-specific challenges, enabling Oracle Industry Applications to unlock value from their data. We are looking for a visionary technical leader with experience developing enterprise data architectures in cloud environments (OCI, AWS, Azure), delivering...

  • Data Architect

    2 weeks ago

    Sacramento, CA, United States Oracle Full time

    Job Description This platform will integrate diverse data sources and leverage AI/ML solutions for industry-specific challenges, enabling Oracle Industry Applications to unlock value from their data. We are looking for a visionary technical leader with experience developing enterprise data architectures in cloud environments (OCI, AWS, Azure), delivering...

  • Data Architect

    1 week ago

    Sacramento, CA, United States Oracle Full time

    Job Description This platform will integrate diverse data sources and leverage AI/ML solutions for industry-specific challenges, enabling Oracle Industry Applications to unlock value from their data. We are looking for a visionary technical leader with experience developing enterprise data architectures in cloud environments (OCI, AWS, Azure), delivering...

  • Data Architect

    6 days ago

    Sacramento, CA, United States State of California Full time

    If you have a passion to be a part of a team that works to serve, aid and protect needy and vulnerable children and adults in ways that strengthen and preserve families then is this is the place for you! The Information Systems Division works in collaboration with programs and county agencies, to provide solutions to systems that assist families access...

  • Data Architect

    1 week ago

    Sacramento, CA, United States State of California Full time

    If you have a passion to be a part of a team that works to serve, aid and protect needy and vulnerable children and adults in ways that strengthen and preserve families then is this is the place for you! The Information Systems Division works in collaboration with programs and county agencies, to provide solutions to systems that assist families access...

  • Data Architect

    1 week ago

    Sacramento, CA, United States State of California Full time

    If you have a passion to be a part of a team that works to serve, aid and protect needy and vulnerable children and adults in ways that strengthen and preserve families then is this is the place for you! The Information Systems Division works in collaboration with programs and county agencies, to provide solutions to systems that assist families access...

  • Data Architect

    2 weeks ago

    Sacramento, CA, United States State of California Full time

    If you have a passion to be a part of a team that works to serve, aid and protect needy and vulnerable children and adults in ways that strengthen and preserve families then is this is the place for you! The Information Systems Division works in collaboration with programs and county agencies, to provide solutions to systems that assist families access...

  • Data Architect

    2 weeks ago

    Sacramento, CA, United States State of California Full time

    If you have a passion to be a part of a team that works to serve, aid and protect needy and vulnerable children and adults in ways that strengthen and preserve families then is this is the place for you! The Information Systems Division works in collaboration with programs and county agencies, to provide solutions to systems that assist families access...