Description

You will design databases and develop dashboards to support customer requirements using large-scale datasets.

Responsibilities

• Translate raw data from multiple sources into aggregate datasets via ETL processes.
• Optimize data grouping, filtering, and sorting for improved presentation and performance.
• Provide production support by analyzing customer queries and adjusting processes to meet demands.
• Collaborate with Business Analysts to acquire necessary information for product design.
• Resolve business process conflicts related to project specifications and report status to management.

Required Skills

• 8+ years of programming experience in large relational database environments.
• 6+ years of strong SQL experience, preferably using Oracle dialect.
• 3+ years of SQL using Hadoop-based technologies including Hive, Spark, and Impala.
• 3+ years of experience in data analysis, modeling, and technical documentation.
• 3+ years of scripting experience in Linux shell, Python, or Perl.
• Deep understanding of relational database concepts and performance design impacts.
• Expertise in large database optimization practices such as indexing and partitioning in Hadoop.
• Proficiency with version control systems like CVS, SVN, or Git.
• Strong knowledge of data warehousing concepts and data modeling best practices.

Preferred Skills

• Experience developing data pipelines for large-scale datasets.
• Experience with streaming technologies like Kafka and Spark Streaming.
• Experience with Drill, Tableau, or advanced MS Excel.

Key Skills

Education

Bachelor's degree