Candidate Must Have:
- 6+ years experience in core database design, development, performance tuning, and optimization
- Strong experience with SQL Server 2016/Azure databases
- ETL (Extraction, Transformation and Loading) Design & Development (Microsoft SSIS/ADF & T-SQL)
Preferred Skills:
- Knowledge of Data Marts / Data Warehouse Solution Design, Dimensional Modeling (Kimball Methodology)
Primary responsibilities:
- Understanding of database architecture, security, and deployment strategies
- Demonstrate good knowledge and skills in designing and implementing Data Marts, Data Warehouse, BI and Dashboard solutions
- Exhibit hands-on skills in data modelling
- Data components development using SQL Server T-SQL, SQL stored procedures, triggers, views, and SQL Agent Jobs
- ETL Design & Development using Microsoft SSIS / Azure Data Factory (Optional)
- Connect to multiple datasets to bring all the relevant data together in one place
- Uploading of Power BI reports to Power BI online service, implement security and audit # scheduling of Power BI data sets in online version and knowledge of viewing dashboards in Power BI mobile version
- Designing, developing and testing data transformations for reporting and interfaces between systems
- Ability to develop systematic testing plans for unit testing
Soft Skills:
- Ability to read, analyze, and interpret general business documentation, technical specifications, and project management documentation
- Data gathering, research, and analytical abilities to develop insightful conclusions and generate solutions to address user needs
- Good analytical, logical reasoning, and problem-solving skills
- Good interpersonal, written, and oral communication skills
- Self-motivated and directed, with keen attention to detail
- Able to prioritize and execute tasks in a high-pressure environment # Experience working in a team-oriented, collaborative environment
BE/BTECH in Information Technology, Computer Science, or related field
All your information will be kept confidential according to EEO guidelines.
