- Ensure the EDW is running efficiently performing regular updates backups and troubleshooting any issues that arise.
- Design and implement dimensional models (star and snowflake schemas) to facilitate efficient querying and reporting.
- Implement data validation and cleansing procedures to maintain high data quality and integrity.
- Optimize database performance through indexing query optimization and other techniques.
- Gather business requirements for enhancement customizations and develop technical requirement documents. Should be able to provide solution technically.
- Prepare estimate based upon the custom requirement and prepare project schedule.
- Engage in business meetings to understand and review the feasibility of the business requirements.
- Responsible for gap analysis of functional flows provide solution design perform POCs and demo for the Gaps solution from standard solution sets as well customized solutions.
- Work closely with Microsoft support team and should be able to create service request as and when required for businesscritical issues.
- Should be able to redefine and make technical/strategic changes to enhance existing Business Intelligence systems.
- Involve in post implementation support to provide solution for production issues or for any other maintenance activities which might also involve change management process.
- Maintain comprehensive documentation of data models ETL processes and other relevant procedures.
Qualifications :
- BSc/MSc degree in computer science or any branch of Engineering.
Experience:
- Strong experience with SQL database management systems (e.g. SQL Server Oracle MySQL) and ETL tools (e.g. ADF SSIS Informatica).
- Proven experience in designing and implementing dimensional models for data warehousing.
- Extensive experience in maintaining and optimizing largescale data warehouses.
- Strong analytical and problemsolving skills to troubleshoot data issues and optimize performance.
- Excellent problem solving Critical and Analytical thinking skills.
- Strong tSQL skills with experience in Azure SQL DB
- DevOps CI/CD and Automation experience strongly preferred.
- Able to interact with team members collaboratively.
- Experience handling Structured and unstructured data.
- Ability to manage multiple tasks and projects simultaneously meeting deadlines and delivering highquality work.
- Willingness to learn new technologies.
- Excellent oral & written communication / articulating skills
Preferred:
- Experience working with the Dbt transformation framework (core or cloud)
- Familiarity with business intelligence tools (e.g. Power BI Tableau) for data visualization and reporting.
- Microsoft Certified: Power BI Data Analyst Associate
- Microsoft Certified: Azure Administrator Associate
Additional Information :
Disclaimer
The information about this job description given above has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties responsibilities and qualifications required of employees assigned to this job.
Remote Work :
No
Employment Type :
Fulltime