MS BI Developer - Hybrid

*** Webcam interview***  Long term contract  Hybrid**

Description:

Responsibilities

• Develops new SSRS reports and database objects against complex enterprise databases (both SQL Server and Oracle) and modifies or enhances existing SSRS reports and database objects as assigned.
• Create and maintain .Net Core MVC applications.
• Demonstrates experience with the design of relational and multidimensional database.
• Demonstrates proficiency in performance tuning to ensure quality and performance of SSRS reports.
• Tests the SSRS reports and database objects created and maintained by the service center thoroughly prior to user testing.
• Applies Agile development principles.
• Works with business users to gather and document requirements and ensures solutions meet their business needs.
• Assists in designing reporting database solutions for the service center and configuring report servers and security.
• Researches functionality in new software releases and performs, documents, and assists other staff in the upgrade processes.
• Uses Azure DevOps and work items and provides project statuses and project time estimates to the reporting section supervisor.
• Uses GIT for code repository.
• Adheres to any standards set by the Service Center and the Governor''s Office of Administration.
• Demonstrates analytical and customer service skills.
• Ensures that best practices are maintained and mentors team members on the best practices, standards, and IT processes.
• Documents all work for future reference.
• Independently executes all tasks and work assignments.
• Create, configure and maintain CI/CD pipelines to automate build and deployment.
• Publishing reports to power BI service workspaces and managing pipeline to deploy the reports to different environments.

Skills Required

• 3-5 years of related work experience.
• Excellent verbal and written communication required.
• 4-year college degree or equivalent technical study desired.
• Extensive experience working with Microsoft tools, with in-depth SSRS development knowledge and SQL Server Integration Services to perform ETL operations.
• In-depth experience with .net core, MVC, C#, dependency injection, JavaScript, and jQuery experience.
• Extensive experience handling large datasets and reporting based on various data sources.
• In-depth experience working with Oracle databases and PL/SQL using SQL Developer.
• In-depth experience working with SQL Server databases and T-SQL using SQL Server Management Studio.
• In-depth experience with data modeling and the ability to analyze and understand database design.

Skills/Requirements

• Related work experience Required 3 Years
• Extensive EXP working with Microsoft tools, with in-depth SSRS development knowledge and SQL Server Integration Services to perform ETL operations Required
• In-depth experience with .net core, MVC, C#, dependency injection, JavaScript, and jQuery Required
• Extensive experience handling large datasets and reporting based on various data sources Required
• In-depth experience working with Oracle databases and PL/SQL using SQL Developer Required
• In-depth experience working with SQL Server databases and T-SQL using SQL Server Management Studio Required
• In-depth experience with data modeling and the ability to analyze and understand database design Required
• 4-year college degree or equivalent technical study desired