Sr.MS BI Developer

Conduent•Gates, NY

36d

About The Position

As a Senior MS BI Developer, you will be responsible for design, development and deployment of BI solutions that support HCP business and enable business to serve our clients efficiently. You will be collaborating with Conduent shared services teams and business teams during the product roadmap and design phases to ensure solutions align with the business and IT strategy.

Requirements

Bachelor’s/Master’s degree in Computer Science / Computer Engineering or equivalent experience
9+ years’ experience with SQL Server database systems including complex warehouse design, experience with designing ETL extracts from various data sources.
8+ years of SQL / TSQL development and fine-tuning experience.
4+ years Microsoft BI Stack (SSRS, SSIS, SSAS), including development of reports (RDLs, complex stored procedures, subscriptions, ETL packages using SSIS & T-SQL queries)
Effectively prioritise and execute tasks in a high-pressure environment
Must have experience of Agile development methodologies
Excellent oral and written communication skills.

Responsibilities

Manage end to end implementation of Datawarehouse and ETL on premise/cloud.
Expert skills and ability to work and provide guidance to team on Database Design/Modelling
In-depth skills to design, write and modify SSIS packages
In-depth skills on SQL/TSQL (performance tuning and troubleshooting)
Advanced knowledge on SSAS to develop cube and tabular models with MDX/DAX Query Skills
Advanced Skills in SSRS to Create reports, data and analysis based on business needs and available data elements.
Expert knowledge in developing parameterized, Chart, Graph, drill down reports using SSRS.
Intermediate Skills in Power BI with ability to create Dashboards for Data Analysis based on the business needs
Setup TFS CI/CD for SQL Automation and Automation via scripting tools such as PowerShell (in addition to T-SQL)
Performance tuning of DB Objects, ETL and SSRS Reports.
Independently analyse, solve, and correct issues in real time, providing problem resolution end-to-end.