Data Architect - ETL

Description :

Responsibilities :

- Design and implement high-performance database configurations using Microsoft SQL Server and MongoDB.

- Develop and manage ETL processes with SaaS services, data lakes, and data sources such as Dremio and Databricks.

- Collaborate with reporting and analytics teams to integrate systems like Power BI, Qlik, and Crystal Reports.

- Provide strategic direction for long-term data strategy and architecture.

- Understand and implement AWS cloud services related to database management.

- Identify and implement performance fixes and scalability solutions for existing systems.

- Troubleshoot and resolve performance issues in database systems.

- Develop and maintain data schemas while ensuring compliance with ACID rules.

- Lead hands-on implementation of both SQL Server and MongoDB.

- Optimize system performance and provide recommendations for improvements.

- Understand and implement PaaS, SaaS, and IaaS solutions in both on-premises and cloud environments.

- Manage security, user roles, and access controls within database systems.

- Provide guidance and direction to teams on data strategy and architecture best practices.

- Re-engineer existing databases based on load requirements and implement performance improvements.

- Document database designs, ER diagrams, and publish functional domain documentation.

Requirements :

- Key Skills : Microsoft SQL Server Expertise.

- Proficient in writing and optimizing stored procedures, triggers, and complex queries.

- Strong understanding of indexes and their impact on performance.

- Ability to analyze and optimize execution plans for query performance.

- Experience in high-performance schema design using both bottom-up and top-down approaches.

Database Design and Performance :

- Strong understanding of data schema design and ACID principles.

- Hands-on experience with SQL and NoSQL database implementations, particularly with MongoDB.

- Good understanding of security best practices and user management in database systems.

Cloud and Integration :

- Good understanding of AWS cloud services related to database management.

- Experience with PaaS, SaaS, and IaaS concepts in both on-premises and cloud environments.

Qualifications :

- 15-20 years of experience in data architecture, database design, and implementation.

- Strong experience with ETL processes and data integration using SaaS services.

- Proficiency in reporting and analytics tools such as Power BI, Qlik, and Crystal Reports.

- Strategic mindset with the ability to develop and execute long-term data strategies.

- Excellent communication and leadership skills, with the ability to direct teams effectively.