Data Warehouse Engineer-SQL

Key R&R-

• Collaborate with analytics and business teams to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
• Build and implement scalable solutions that align to our data governance standards and architectural roadmap for data integrations, data storage, reporting, and analytic solutions.
• Design and develop data integrations and a data quality framework. Write unit/integration/functional tests and document work.
• Perform data analysis required to troubleshoot data-related issues and assist in the resolution of data issues.

Required Skills:

• Experience with a variety of database technologies and data warehouse schema design patterns (snowflake and star in particular).
• Design and Development experience of an EDW,
• Experience with cloud-based databases, specifically AWS technologies (e.g., Redshift, RDS, S3, EMR, EC2, Kinesis) is a plus. Experience using SQL queries as well as writing and optimizing SQL queries in a business environment with large-scale, complex datasets.
• Experience creating ETL and/or ELT jobs.
• Experience with Agile software development methodologies.
• Excellent problem solving and troubleshooting skills.
• Process oriented with great documentation skills.
• Proficient in object-oriented programming (Python in particular).
• Experience with DevOps methodologies and tools (e.g., Git, Artifactory, etc.).
• Experience developing in a Unix/Linux environment.
• Experience a plus developing integrations across multiple systems and APIs .
• Experience a plus with Big Data tools like Spark, Hadoop, Kafka, etc