Job Description :
Skills and Experience Required:
Required:
Experience with data architecture – setting up transaction systems vs reporting systems
Solid understanding of Query & Function Optimization (Functions, Stored Procedures)
ETL expertise
Understanding of capacity planning
Experience with structuring data - Ability to untangle bad correlations to create a usable data product
Experience setting up & optimizing a data warehouse/store/mart for reporting and analysis purposes in SQL Server
Experience with Design Data; warehouse, lake, operational reporting data model
Data visualization and analytics experience
SQL architecture knowledge – work within the SQL data architecture & understand it
High Availability [Always On] Experience
Transactional Data Analysis – be able to understand data as it flows within an application or system