Technical Skills:
5+ years of Strong experience in MS BI Stack SQL Server Integration Services (SSIS) and Analysis Services (SSAS), Azure Data Factory (ADF), SSRS and Power BI.
5+ years practical experience with business intelligence solution including building/supporting data-intensive systems, data warehouses and data marts with clear understanding of industry standard concepts (star schema, snowflake, ER)
Ability to design and develop dashboards, scorecards and KPIs using SSRS
Solid T-SQL knowledge using MS SQL 2014 or later and experience with query performance optimization
Solid experience creating/updating/optimizing/troubleshooting -- Stored procedures/functions, tables, views, triggers, indexes, and constraints.
2+ years of experience in analyzing large datasets in MS SQL Server and creating data visualizations utilizing SSRS or Power BI
Collaborate with development teams to design, develop, maintain, and deploy SQL database systems, Azure SQL, and Power BI
Collaborate and plan project tasks within an agile development environment.
Working and collaborating with business partners, product owners, developers, and data engineers to maintain and develop new solutions.
Maintain the support work queue and addressing requests in a timely manner
Excellent analytical & troubleshooting and remediation capabilities
Strong ability to multi-task and balance multiple priorities in a fast-paced environment
Experience working in an Agile work environment
Experience with documentation tools. Jira, Confluence, ServiceNow (SNOW) etc.
Would be a plus to have experience with o Reporting tools - Power BI, SSRS, etc. o Cloud technology - Azure, AWS o Payment processing industry experience o MDS (Master Data Services) o Power Shell scripts o DBA Admin Skills o Azure Devops/TFS