Description

You will design, build, and optimize data pipelines and warehousing solutions for complex business requirements.

This role is on-site.

Responsibilities

• Analyze complex datasets to identify anomalies and resolve data integrity issues.
• Design and implement ETL processes, including tuning for SQL and data flows.
• Lead data conversion strategies from legacy systems to new platforms.
• Develop technical specifications, ER diagrams, and documentation for data flows.
• Validate requirements with Data Leads and QA analysts to ensure business logic alignment.

Required Skills

• 8+ years in ETL/Data transformation projects using Informatica, Talend, or SSIS.
• 8+ years in business intelligence and data warehousing initiatives.
• Advanced SQL proficiency with Oracle, MS SQL Server, or Vertica.
• Strong understanding of data warehousing concepts (Star/Snowflake schemas) and normalization.
• Experience with AWS infrastructure (S3, SNS, EC2, CloudWatch, RDS).
• Bachelor’s degree in Mathematics, Computer Science, or related technical field.

Preferred Skills

• 1+ years with Matillion ELT and Snowflake.
• Building AWS data pipelines using Python, Spark, or SparkSQL.
• Experience with NoSQL databases (ElasticSearch, MongoDB, DynamoDB, Cassandra).

Key Skills

Education

Bachelor's degree