Conduent needs to design, develop, and deploy BI solutions that support the HCP business and enable the business to serve clients efficiently, aligning with business and IT strategy.
Requirements
- 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)
- 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 analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
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.
Other
- Effectively prioritize and execute tasks in a high-pressure environment
- Must have experience of Agile development methodologies
- Excellent oral and written communication skills.
- Remote work: Enjoy the convenience of working from home and maximize your time by unplugging at the end of your workday.
- Career Growth Opportunities
