Data Warehouse Lead / SQL Server Specialist
This position demands a critical understanding of data warehousing concepts, advanced ETL and BI report development skills, and an in-depth knowledge of SQL Server database.
Primary responsibilities of this senior role include leading development efforts of ETL processes and BI reports using Microsoft BI stack (SSIS, SSRS, SSAS) and Tableau, designing relational database structures, prescribing and implementing database development standards, and some SQL server database administration. Ideal team member should be a self-starter, work with minimal supervision and seek-out opportunities to augment existing processes.
- All candidates will undergo stringent technical interview
A Typical Day As A Data Warehouse Lead / SQL Server Specialist :
Develop and lead development efforts of data integration (ETL) processes and BI reportsDevelop and lead development efforts of SQL queries for ad hoc data analysis, data integration processes, audit purposes and performance tuning of production SQLDevelop and lead development efforts of database objects (tables, views, stored procedures, indexes, etc.,)Implement and administer (Level 1) SQL Server databases across various development and production environmentsImplement and administer standards for development and deployment of database objectsLead implementation efforts of database structures to support enterprise data warehousing activitiesLead implementation efforts of high-availability and disaster recovery environmentsAssist data integration teams with data modeling tasks and maintain an inventory of data definitionsAssist and advise in performance tuning of SQL queriesAssist and advise in organization and standardization of existing database structuresAssist and advise in data migration and test data creationAssist and advise in process automation and schedulingAssist in data integration activities and collaborate with cross functional teamsWhat You Will Need To Bring To The Table :
8+ years experience of working as a data warehouse developerSolid experience with data integration and reporting tools like SSIS, SSRS and procedural coding.Experience with creation of database structures and effective management of all database objectsExperience with implementing database resource governanceExperience with database standards and end user applicationsExperience with data backup, recovery, security, integrity and SQLSubstantial experience with standing up development and testing database environmentsGood knowledge of database design, documentation and codingGood knowledge of data warehouse methodologies and best practicesStrong problem solving skills, with an analytical mindsetBS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidatesKnowledge of working within Agile framework is desiredKnowledge of other relational database systems like Oracle or MySQL is desiredComplimentary skill sets like background in C++, Java, scripting languages, etc., will be a huge bonus