SQL Developer

Primary Responsibilities:

• Develop the ETL using SSIS and the reporting using Power BI / SSRS/ Tableau
• Develops advanced BI applications using the MS BI stack including SSAS, SSIS, T-SQL/stored procedures as well as MDX
• SSRS report development / deployment
• Analyzes and improves existing dashboards, reports and reporting systems
• Designs and develops Business Intelligence solutions using multidimensional cubes including MOLAP and ROLAP
• Provides training and expertise to business users and other stakeholders on utilizing SSAS cubes for their reporting needs
• Designs functional specs for BI front end applications including dash boards and reporting, considering appropriate data flow and capture
• Works closely with the Data Architecture team and provides technical design recommendations on the data mart structures which support analytical applications
• Works with business users and other stakeholders to understand business processes, and translates them into functional and non-functional specifications for BI solutions
• Identifies problem trends and corrective actions and documenting these through modification of existing best practices guidelines
• Provides expertise and guidance to other developers in the use of the toolset
• Perform the day-to-day functions such as running of existing programs, applications, jobs, reviewing logs for errors, writing or editing software and code, performing testing activities, and updating documentation
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

Required Qualifications:

• 2+ years of experience in in creating SQL scripting from scratch
• 2+ years of experience in building an SSIS script from scratch and connecting SQL to a data source
• 2+ years of experience in building an SSRS report from scratch.
• 2+ years of experience in working on ground up projects.