IT Solution database engineer
- Analyze execution plans
- Build and maintain data warehouses
- Create stored procedures
- Create technical documentation
- Create views
- Design ETL processes
- Develop BI optimized data models
- Develop SSIS packages
- Develop snowflake schema
- Develop star schema
- Implement data cleansing
- Implement data validation
- Integrate data from multiple sources
- Maintain metadata documentation
- Optimize query performance
- Participate in architecture reviews
- Support Power BI datasets
- Support SSRS reports
- Support Tableau datasets
- Support data governance
- Support production deployments and troubleshooting
- Tune indexing and partitioning
- Write T-SQL queries