Data Warehouse Engineer Athlete Hub (Remote) at Dicks Sporting Goods in Remote
At Dicks Sporting Goods, we are creating the future of sport driven by powerful data products and platforms that serve our Athletes and Teammates. We are looking for a Data Warehouse Engineer with customer relationship management experience to focus on improving the availability and quality of data that is made available throughout the organization with specific attention to a particular domain critical to the success of the organization. In this role, you will develop deep knowledge and understanding of the data assets available within our data platforms and act as the subject matter expert on the data and its utility for operational use. While joining forces with the busines, data engineering teamates and product development partners, your expertise in petabyte scale data in data lakes, data warehouses or data marts - in structured, semi-structured and unstructured formats - will deliver on the DICK'S Data and Analytics organization's mission to enable data-driven decisioning within any action. Joining you along this journey to the best-in-clase data footprint will be teammates across data science, platform engineering and software development, all with a unified strategy and supporting goals. This role models, implements and nurtures data which ultimately becomes certified or the 'single source of truth' for the organization. As such, data stewardship, governance and compliance routines will depend on succefull delivery against these objectives. What you will bring:
3-5 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 Product and analytics teams on normalizing and aggregating large 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 with cloud-based data warehouses - e.g. Snowflake, BigQuery, Synapse, RedShift, etc Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. Demonstrated ability to share findings to non-technical or senior executive individuals. Familiarity with Analytical/Reporting Solutions like Qlik Sense, PowerBI is a plus Job Duties & 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. Bachelor's Degree in Library Science, Information Systems, Finance, Information Technology or equivalent experience 3 - 5 years of experience in Data Engineering, Data Modeling, ETL/ELT, SQL Any Public Cloud certification focused on data warehousing Any certification on specific database technology Experience developing models in modern public data warehosing environments like Snowflake, Synapse, BigQuery, RedShift Proficient in Linux/Unix environments Experience developing dimensional models and running quries on edge databases such as Oracle , PostgreSQL, MariaDB/MySql, or SQL Sever
Salary Range:
$80K -- $100K
Minimum Qualification
Data Science & Machine Learning, Systems Architecture & EngineeringEstimated Salary: $20 to $28 per hour based on qualifications.
3-5 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 Product and analytics teams on normalizing and aggregating large 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 with cloud-based data warehouses - e.g. Snowflake, BigQuery, Synapse, RedShift, etc Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow. Demonstrated ability to share findings to non-technical or senior executive individuals. Familiarity with Analytical/Reporting Solutions like Qlik Sense, PowerBI is a plus Job Duties & 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. Bachelor's Degree in Library Science, Information Systems, Finance, Information Technology or equivalent experience 3 - 5 years of experience in Data Engineering, Data Modeling, ETL/ELT, SQL Any Public Cloud certification focused on data warehousing Any certification on specific database technology Experience developing models in modern public data warehosing environments like Snowflake, Synapse, BigQuery, RedShift Proficient in Linux/Unix environments Experience developing dimensional models and running quries on edge databases such as Oracle , PostgreSQL, MariaDB/MySql, or SQL Sever
Salary Range:
$80K -- $100K
Minimum Qualification
Data Science & Machine Learning, Systems Architecture & EngineeringEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
