Data Engineer

Tasks

• Design data integration solutions
• Develop SSAS cubes and models
• Develop SSIS ETL packages
• Develop stored procedures and user defined functions
• Implement SSIS data migration validation and archiving
• Implement data modeling with star schema and snowflake schema
• Implement high availability and disaster recovery for BI
• Optimize SQL Server performance
• Perform SQL Server maintenance and automation
• Support BI reporting using SQL and MDX

Perks/Benefits

• N/A

Skills/Tech-stack

Analysis Services | Data Modeling | Data Warehousing | Disaster Recovery | ETL | High Availability | Integration Services | MDX | OLE DB | SQL | SQL Server | SQL Server Analysis | SQL Server Analysis Services | SQL Server Integration Services | SQL Server integration | SSAS | SSIS | SSIS Transformations | SSRS | Server Integration Services | Snowflake Schema | Star Schema | Stored Procedures | User Defined Functions