Roles and Responsibilities
Development and creation of data warehouses.
Assist in defining system architecture and capacity planning.
Full ETL / SSIS development
SQL Data Warehouse and downstream data models
Third party / external data integration
Data Warehouse development and integration
Full logging for proper troubleshooting
Build and support OLAP Cubes
Support and assist the BI developers with
Ad-hoc query generation using T-SQL
Assist in troubleshooting issues with reports using Power BI (or other visualization tools)
Performance Tuning and Query Optimization using native SQL Server tools
Qualifications and Skills
4- 7 years of SQL Server Experience building and supporting Data Warehouse structures
Strong SQL Server development experience
Experience building automated Extract Transform and Load (ETL) systems to process incoming data sources
Experience building ETL processes to reconcile and standardize data and eliminate redundant data
Build experience with multidimensional structures (OLAP, etc.) to support the delivery of data to reporting tools
All phases of the modeling process - research design, data extraction and cleaning, model building and validation.
Proficiency with writing stored procedures, triggers, and database jobs.
SQL Server Integration Services experience (SSIS) to load and transform data from various sources into a database staging environment.
Experience building SSIS tasks to perform bulk inserts, execute packages, execute processes, FTPs, Send mails etc.
Strong SQL Coding experience including unions, correlated sub-queries etc. to extract and transform data.
SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), OLAP cubes, Dimensions, Partitions, KPIs and aggregation.
Microsoft BI Stack including Power Query, Power Pivot and Power View.
Experience and Background