Description

You will design, build, and maintain data solutions, databases, and warehouses across the data ecosystem.

Responsibilities

• Analyze business and technical requirements to design and modify data pipelines, stores, and BI solutions.
• Develop and maintain data repositories using Oracle, Microsoft SQL Server, PostgreSQL, and Amazon Redshift.
• Create, maintain, and tune packages, tables, and queries to optimize ETL and ELT processing.
• Provide technical expertise in dimensional modeling and assist with database performance monitoring.
• Troubleshoot application software and hardware problems related to design and installation.

Required Skills

• 5+ years of experience in data warehouse development.
• Proficiency in SQL and one or more of: Shell Scripting, Python, R, or Java.
• Hands-on experience with Microsoft SSIS, SSRS, and SSAS.
• Experience using Power BI for business intelligence solutions.
• Direct experience with Amazon Redshift and AWS services including Lambda, S3, Glue, and Athena.
• Strong knowledge of Oracle and Microsoft SQL Server environments.
• Bachelor's degree in Computer Science or an equivalent degree.

Preferred Skills

• Participation in on-call and overnight production problem resolution activities.

Key Skills

Education

Bachelor's degree