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 prototype 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, 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 snapshots 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
Website: https://motivitylabs.com/
Interview Rounds: 2 Technical Rounds followed by HR Round.
