This role includes working with business and development teams to design, and document dashboards, alerts, and reports.
Be able to determine business requirements, priorities, define key performance indicators (KPI), and develop BI and data warehouse (DW) strategy.
You will be responsible for designing solutions and overseeing the development and execution of projects.
Be able to build pilot solutions and proof-of-concepts with minimal direction.
Educate employees on how to use data as an analytical tool.
Conduct analyses of functional business processes and functional business requirements and participate in the development of business cases in the support of process changes and IT projects.
Ability to appropriately architect data solutions utilizing SQL Server architecture. This includes storage, replication, server tuning, upgrading, backup/restore, security, etc.
Ability to write complex SQL queries
TSQL knowledge, DML/DDL, triggers, CTE's, query tuning, etc.
Strong knowledge of SSRS, SSAS, SSIS: script tasks, checkpoints, recordset objects, package vs. project deployment.
Knowledge of SQL Server Reporting Service and Power BI.
Knowledge of Azure SQL, and other Azure offerings centered around Data and Analytics
BS or MS in Computer Science, Engineering or Mathematics or Equivalent field
Must work well in a team environment
Experience with Azure Data Lake Analytics
Experience creating Finance or CRM Power BI dashboards
Experience with multiple data sources such as SharePoint, Dynamics 365, SQL, Exchange, etc.
Who you are:
Excels with ambiguity and able to design a clear path to meet end goals
Have a broad understanding of BI and data technologies and how to match the right technologies to solutions.