Titile: SQL Developer
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
Process Skills:
Able to coordinate with developers and stakeholders on database dev issues
Able to proactively search for solutions from knowledge bases, support documentation and other information sources
Strong initiative; self-driven; ability to multi-task
Should be responsible, accountable, and work independently
Behavioral Skills:
Excellent English communication, able to comprehend and express
Hands on mentality and has experience to engage and handle challenges
Good at communication and interact with the business users well