Senior Data Platform Engineer - SQL, ETL, DW & BI

Ameya Global; United States; On-site; USD 120,000 - 180,000; Full time

Job summary

Ameya Global seeks a senior data architect to design end-to-end data architectures, model logical and physical schemas, and optimize enterprise databases across SQL Server and Oracle.

You will build data warehouses, develop ETL workflows with SSIS and Informatica, create OLAP cubes and BI reports, and tune performance while supporting the SDLC and collaborating with stakeholders. Proficiency in Python and UNIX scripting is a plus.

Qualifications

• Experience designing enterprise data architectures and data models.
• Strong knowledge of SQL Server and Oracle environments.
• Hands-on with ETL tools and BI platforms.

Responsibilities

• Design end-to-end data architecture and model logical/physical schemas.
• Develop, optimize, and maintain large-scale Data Warehouse systems and ETL workflows.
• Build dashboards and BI reports using OLAP cubes and Cognos tools.
• Perform performance tuning, indexing, partitioning, and monitoring.
• Collaborate with stakeholders to translate requirements into scalable solutions.

Skills

Stakeholder collaboration

Analytical thinking

Problem solving

Teamwork

Requirement analysis

Education

Bachelor – Computer Science or Electrical and Electronic Engineering

Tools

SQL Server

Oracle

SSIS

Informatica

SSAS

SSRS

Cognos

RESTful services

SOAP services

UNIX/Linux shell

Python

Job description

Ameya Global seeks a senior data architect to design end-to-end data architectures, model logical and physical schemas, and optimize enterprise databases across SQL Server and Oracle.

You will build data warehouses, develop ETL workflows with SSIS and Informatica, create OLAP cubes and BI reports, and tune performance while supporting the SDLC and collaborating with stakeholders. Proficiency in Python and UNIX scripting is a plus.