Infometry, Inc.
Data Warehouse Architect with Snowflake
Infometry, Inc., California City, California, us, 93504
Job Description:Data Model, SQL, Snowflake, Data modeling, Data warehouse, Data warehouse architecture, ELT
Employment Type:
Full Time
Salary:
Depends on Experience
Work Arrangement:
Work from home available, Travel not required
Responsibilities:
Lead analysis, architecture, design, and development of Snowflake Data Warehouse and Business Intelligence solutions.
Work with customers to understand and execute their requirements.
Build Data Flows mapping Source systems and Process flows.
Build Data Warehouse Architecture including Data Ingestion, Transformation, Security, and Aggregate layers.
Build a denormalized Data Model with Dimensional modeling to meet customer analytics and performance criteria.
Build an optimal data pipeline approach to extract data from Mainframe systems to Snowflake.
Experience designing highly scalable ETL processes with complex data transformations, and data formats including error handling and monitoring.
Provide coaching and guidance to team members and data analysts across the organization.
The Essentials:
3+ years of experience in building Snowflake Data Warehouse solutions from scratch.
10+ years of experience designing and consuming enterprise data warehouses that can scale.
Deep experience in traditional Data Warehousing & Cloud data warehousing.
Excellent ability to establish and maintain collaborative relationships with analytic and non-analytic business partners, including executive leadership, to elicit business needs and formulate, propose and refine analytic solutions.
Mastery of Dimensional Model, Snowflake architecture, and proficiency with SnowSQL.
Experience in delivering ELT solutions using tools like Matillion or Fivetran.
Understanding the competitive ETL space in cloud data warehousing.
Excellent written and verbal communication skills.
Strong understanding of business KPIs and Go to Market Engines.
Understanding of reporting systems such as Tableau.
Ability to dig into the data using systems such as Snowflake, especially for the Retail and Banking industry.
About the Company:Infometry Inc is a pure-play Business intelligence company, located in Bay Area (Fremont, CA). We also have offshore locations in Bangalore and Singapore. We are a leading Data Analytics company, certified engineering and implementation partner for Informatica, Tableau, Snowflake, Matillion, Talend, Google Cloud (GCP), Dell Boomi, Adaptive Insights, and Callidus Cloud. We help in BI Strategy, Cloud Data Integration, Big Data, AI/ML, Enterprise Reporting, Executive Dashboards, Vertical Solutions, Cloud Strategy, Cloud Data Warehouse migration, PowerCenter to Cloud migration, Snowflakes Migration, and optimizing the IICS infrastructure. It is both a service and product-based company. We have developed products like Informatica Google connectors and Infofiscus based on Informatica Technology. We have developed more than 14+ Connectors for Informatica and currently own IP for Google Sheets, Google Drive, Google PubSub, Google BigTable, Adaptive Insights, and HubSpot.
For more details, you can visit the company website:
www.infometry.net
or can reach out at 8247277422.
#J-18808-Ljbffr
Employment Type:
Full Time
Salary:
Depends on Experience
Work Arrangement:
Work from home available, Travel not required
Responsibilities:
Lead analysis, architecture, design, and development of Snowflake Data Warehouse and Business Intelligence solutions.
Work with customers to understand and execute their requirements.
Build Data Flows mapping Source systems and Process flows.
Build Data Warehouse Architecture including Data Ingestion, Transformation, Security, and Aggregate layers.
Build a denormalized Data Model with Dimensional modeling to meet customer analytics and performance criteria.
Build an optimal data pipeline approach to extract data from Mainframe systems to Snowflake.
Experience designing highly scalable ETL processes with complex data transformations, and data formats including error handling and monitoring.
Provide coaching and guidance to team members and data analysts across the organization.
The Essentials:
3+ years of experience in building Snowflake Data Warehouse solutions from scratch.
10+ years of experience designing and consuming enterprise data warehouses that can scale.
Deep experience in traditional Data Warehousing & Cloud data warehousing.
Excellent ability to establish and maintain collaborative relationships with analytic and non-analytic business partners, including executive leadership, to elicit business needs and formulate, propose and refine analytic solutions.
Mastery of Dimensional Model, Snowflake architecture, and proficiency with SnowSQL.
Experience in delivering ELT solutions using tools like Matillion or Fivetran.
Understanding the competitive ETL space in cloud data warehousing.
Excellent written and verbal communication skills.
Strong understanding of business KPIs and Go to Market Engines.
Understanding of reporting systems such as Tableau.
Ability to dig into the data using systems such as Snowflake, especially for the Retail and Banking industry.
About the Company:Infometry Inc is a pure-play Business intelligence company, located in Bay Area (Fremont, CA). We also have offshore locations in Bangalore and Singapore. We are a leading Data Analytics company, certified engineering and implementation partner for Informatica, Tableau, Snowflake, Matillion, Talend, Google Cloud (GCP), Dell Boomi, Adaptive Insights, and Callidus Cloud. We help in BI Strategy, Cloud Data Integration, Big Data, AI/ML, Enterprise Reporting, Executive Dashboards, Vertical Solutions, Cloud Strategy, Cloud Data Warehouse migration, PowerCenter to Cloud migration, Snowflakes Migration, and optimizing the IICS infrastructure. It is both a service and product-based company. We have developed products like Informatica Google connectors and Infofiscus based on Informatica Technology. We have developed more than 14+ Connectors for Informatica and currently own IP for Google Sheets, Google Drive, Google PubSub, Google BigTable, Adaptive Insights, and HubSpot.
For more details, you can visit the company website:
www.infometry.net
or can reach out at 8247277422.
#J-18808-Ljbffr