Qualifications :
- 5-7 years of Data Warehousing and Data Modeling experience.
- Strong understanding of Normalized / Dimensional model disciplines and similar data warehousing techniques.
- Strong experience working with ETL / ELT concepts of data integration, consolidation, enrichment, and aggregation in petabyte-scale data sets.
- Expert in SQL and / or SQL-based languages and performance tuning of SQL queries.
- Working knowledge of message queuing, stream processing, and highly scalable big data’ data stores.
- Collaborate with the BI and Data Analyst teams on normalizing and aggregating data sets based on business needs and requirements.
- Data auditing skills to verify data integrity, understand discrepancies, and resolve them with the highest sense of urgency.
- Experience with various data storage technologies - e.g. RDBMS, columnar, tabular, document store, NoSQL
- Experience using cloud-based data warehouses - e.g. Snowflake, BigQuery, Synapse, RedShift, etc
- Experience using ETL / ELT tools and technologies e.g. Talend, Informatica, etc.
- Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow.
- Familiarity with Analytical / Reporting Solutions like MicroStrategy is a plus
Additional Requirements
- Bachelor's Degree Library Science, Information Systems, Finance, Information Technology, or equivalent experience
- Work in a progressive environment and perform effectively in a sprint based agile development environment
- Exceptional Communication Skills
- Any Public Cloud certification focused on data warehousing
- Any certification on specific database technology
- Experience developing models in modern public data warehousing environments like Snowflake, Synapse, BigQuery, Redshift
- Experience developing dimensional models and running queries on edge databases such as Oracle, PostgreSQL, or SQL Server
- Proficient in Linux environments
27 days ago