Senior Data Warehouse Developer

Senior Data Warehouse DeveloperIdeal candidate for this role will not only help us procure, curate and model various transactional data but also turn it into information, generating insights and aid in business decisions based on the analytical results. Incumbent's responsibilities will include conducting full development lifecycle — requirements, analysis, development, testing and production deployment whilst managing various everyday data warehouse related processes (SSIS, SSRS, SSAS) and MS SQL Server performance.We expect you to possess analytical mindset with creative approach to tasks and experience in working with entire Microsoft BI stack with sound understanding of SQL Server and advanced SQL tuning for performance.A Typical Day As A Senior Data Warehouse DeveloperDesign and develop ETL and reporting processes using SSIS/SSRS tools based on established enterprise standardsEngage with business units to gather requirements and perform iterative data analysis in a fast paced agile environmentArchitect SQL Server database structures and objects, fine tune SQL queries for performance and monitor latencies during batch processesIdentify, analyze, and interpret trends or patterns in complex data setsDesign and develop reports, and flat file extracts for consumption by business users and external vendorsCollaborate with management to prioritize business and information needsFind and evaluate new process improvement opportunitiesWhat You Will Need To Bring To The Table8+ years' experience of working as a data warehouse developer or ETL specialist with a deep understanding of relational databasesSolid experience of working with data models, database design development, performance tuning techniquesSolid experience in working with voluminous databases, creating database objects and tuning complex SQL queries for performanceSolid experience using ETL and reporting tools like SSIS, SSRS, SSAS, Informatica and Business ObjectsStrong analytical thinking is vital to succeed in this role. You will be constantly asked to understand the business premise before employing your technical skillsAbility to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracyGood knowledge of documentation and code versioningGood knowledge of working with enterprise automation toolsBS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidatesComplimentary skills sets like background in Java programming, Python and/or experience in other databases like Oracle, Netezza, Mongo DB, Teradata is a huge plus!