Position: Data Engineer Architect
Roles and Responsibilities
- 10+ years of relevant work experience, including previous experience leading data-related projects in the field of Reporting and Analytics.
- Design, build & maintain scalable data lake and data warehouse in cloud (AWS/Azure/GCP)
- Expertise in gathering business requirements, analyzing business needs, and defining the BI/DW architecture to support and help deliver technical solutions to complex business and technical requirements.
- Creating solution prototypes and participating in technology selection. Perform POC and technical presentations.
- Architect, develop, and test scalable data warehouses and data pipelines architecture in Cloud Technologies (AWS/Azure/GCP)
- Experience in SQL and No SQL DBMS like MS SQL Server, MySQL, PostgreSQL, DynamoDB, Cassandra, and MongoDB.
- Design and develop scalable ETL processes, including error handling.
- Expert in Query and program languages MS SQL Server, T-SQL, PostgreSQL, MY SQL, Python, R.
- Preparing data structures for advanced analytics and self-service reporting using MS SQL, SSIS, SSRS
- Write scripts for stored procedures, database snapshot backups, and data archiving.
- Experience with any of these cloud-based technologies:
- PowerBI/Tableau, Azure Data Factory, Azure Synapse, Azure Data Lake
- AWS RedShift, Glue, Athena, AWS Quicksight
- Google Cloud Platform
Good to have:
- Agile development environment pairing DevOps with CI/CD pipelines.
- AI/ML background
Interview Rounds: 2 Technical Rounds followed by HR Round.