IS&T Consulting Group
Required Skills
| Skill | Years of Experience | Expertise Level | Skill Requirement Level |
|---|---|---|---|
| AWS | 5+ | 4 | Required |
| SNOWFLAKE | 5+ | 4 | Required |
| ETL | 4-5 | 4 | Required |
| DOMO | 4-5 | 4 | Nice to Have |
| DBT | 4-5 | 4 | Nice to Have |
Job Description
Data Quality, Management and Maturing Data Governance is main issue.
There are 4 main Data Warehouse customers – these are the current teams:
• Warehouse / Logistics (Miami) – open job
• Sales
• Merchandizing
• Corp and Membership – Sr Data Engineer (San Diego, CA) - open job
They have been using Domo full stack decentralized analytics tool to pull data from the AS/400 into a centralized data warehouse. They are dumping Domo due to performance and change of the billing fees from flat annual fee to consumption fee model
20,000 tables in Domo
4,000 ETL
Data Warehouse project - Replace Domo with Snowflake in AWS
Transactional data and Data Warehouse database design us a must
DBT and Precisely is replacing Informatica – APL data from AS/400
DBT is a tool used for data transformation and modeling, enabling data analysts and engineers to build and manage data pipelines.
Precisely is a service that provides connectors and support for dbt, enhancing data and metadata access.
DBT migration tool to snowflake in AWS
Fivetran – automated data transfer tool. SQL and Mongo data conversion tool
Fivetran is a leading data movement platform that enables enterprises to automate the transfer of data from various sources, including SaaS applications, databases, and ERPs, to data warehouses and lakes.
Tech Stack:
AWS
Domo - currently on Domo moving to Snowflake
Snowflake
DBT
Precisely
Github
Jira
Agile - Sprints
Microsoft Fabric
PowerBI visualization – nice to have
ETL/ELT
Mimiks
Elysium Data Lake