Day to day: 

• Working with SQL Stack e.g. SQL Server 2016 or higher, SSAS, SSIS, SSRS, MDM, Power BI. 
• Use of data model concepts, master data management, operational process, SDLC, project management, data profiling, data cleansing/de-duplication processes. 
• Create and maintain DAX and MDX queries and perform performance tuning on SSAS. 
• Troubleshooting/support - will have to dig in to the backend of databases and troubleshoot issue areas 
• Implement data warehousing and associated architecture. 
• Data migration with source database to target database mapping. 
• Database design with multidimensional modeling. 
• Working directly with the business clients. 
• Extensive use of written and oral communication skills, particularly the ability to synthesize complex issues/scenarios into easy-to-understand concepts. 
• Works closely with the business team, development team, analysis team, and the users to enhance quality and product delivered. 
• Responsible for precisely communicating impact, status, priority, progress, and road blocks to management 
• Provides guidance in terms of priority and ownership of issues and requests. 

Requirements

• Education 
• Requires a bachelor's degree, preferably in Computer Science, Information Systems, Business, Mathematics, or related field, or equivalent business experience as a SQL Developer. 
• Experience 
• 4+ years of direct experience as a SQL Developer. 
• Experience in managing software requests, projects, and internal customers. 
• Experience with every phase of the System Development Life Cycle. 
• Experience with being the technical liaison between the business users and development. 
• Experience with Azure DevOps is desired. 
• 1 to 2 years of retail energy related experience is highly desired. 
• Skills/Knowledge/Abilities 
• Ability to convey technical information in a clear and concise manner to other less technically oriented customers. 
• Ability to manage multiple duties at the same time. 
• Advanced Proficiency in the Office suite and Office 365 
• Demonstrated ability to work in ambiguous situations and across organizational boundaries. 
• SQL Technologies 
• SQL Server stack (Reporting Services, Integration Services, Analysis Services and Power BI). 
• Advanced proficiency in SSAS cubes 
• Relational Database Management Systems 
• SQL Server 2016 or newer. 

Salary range: 90-125K base