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.
Demonstrated ability to share findings with non-technical or senior executive individuals.
Familiarity with Analytical/Reporting Solutions like MicroStrategy is a plus Job Duties And Responsibilities Work directly with the developers, system architects, and users to review requirements and deliver best-practice database models.
Work with stakeholders including the product, data and architecture teams to assist with data-related technical issues and support their data infrastructure needs.
Provide proactive design, operational support, and governance for privacy and security policy for data.
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 quries on edge databases such as Oracle, PostgreSQL, or SQL Server Proficient in Linux environments