Senior Data Warehouse Engineer

- Required Skills :

- Experience working with OLTP databases and data warehouses (Snowflake, Redshift)

- Knowledge of Data warehouse Design Methodologies

- 3 to 6 years experience in Python programming and application development using Python

- Ability to create and manage Pipelines using Python

- Hands-on experience with database design

- Experience working on Cloud Platforms (e.g. AWS, Azure, GCP)

- Experience working on CI/CD processes and source control tools such as GitHub and

GitLab

- Experience with Agile/Scrum methodology and iterative practices in a service delivery

lifecycle

- Excellent communication and interpersonal skills with a demonstrated ability to influence

a large organization

- Bachelor's or Masters's Degree in Computer Science, Information Systems, or related

field

Duties & Responsibilities:

- Responsible for developing and supporting data pipelines that enable the overall

the strategy of expanded data programs, services, process optimization, and advanced

business intelligence

- Design and develop scalable data warehousing solutions, building ETL pipelines in Big

Data environments (cloud, on-prem, hybrid)

- Leading data discovery sessions with business teams, comprising product owners, data

analysts and cross-team technologists to understand enterprise data requirements of

analytics projects

- Ensure proper testing and monitoring are in place to provide trusted and reliable data

Partner with business domain experts, system analysts, data/application architects, and

engineering teams to ensure data design is aligned with business strategy and direction

- Exercise best practices in software development and documentation

- Participating in a shared on-call rotation monitoring the health of the team's systems

Bonus Points:

- Experience working with orchestration tools (AirFlow Preferred), file storage systems(AWS

- S3, Google Cloud Storage), partitioning, and real-time processing of data

- Experience working with reporting tools such as Tableau

- Experience with event streaming with modern event streaming toolings like Kafka or

Kinesis.

- Experience with subscription service products

- Knowledge of accounting, FP&A, and marketing functions