Centena International Services Private Limited | Jobs | Opening For Business Analyst in our IT Team | BigDataKB.com | 31-03-22

Job Location: Chennai

We have job opening for Business Analyst in our IT Team.

Key Responsibilities and Accountabilities:

• Develop and maintain interactive and operational reporting solutions for the enterprise and prepare code for production deployment
• Develop and maintain enhancements to the data warehouse, master data services models, data integration layer, and enterprise data services (stored procedures, views, functions) shared across applications and reporting
• Provide evidence for the quality and accuracy of solutions by executing unit and integration test plans and present results for sign-off
• Support intra-day, weekly, monthly and year-end reporting cycles
• Comply with the data management principles, policies, standards and best practices as defined by the Data Governance policies
• Adhere to all documentation standards, development lifecycle tasks, and status reporting requirements
• Design, develop, implement and maintain business intelligence data visualizations using Microsoft Power BI
• Creating and maintaining reports from various sources of data like Oracle Data Warehouse, Oracle EBS, MS SQL, Cloud Solutions, Flat files.
• Expertise in building data visualizations to highlight patterns in the data from unstructured and structured data sets
• See/understand the end to end architecture of this project from source system to EDW to data model to Power BI
• Provide input/guidance on how to improve/update EDW architecture to be scalable/flexible to accommodate additional metrics/requirements for future sprints
• Hands-on experience, building/updating/extending EDW architecture and data

Minimum Qualification/Education:

• Bachelor’s Degree in Computer Science, Information Systems or Data Science.

Minimum Experience Required:

• 3-4 years of experience in the BI & Analytics domain, minimum 2 years developing and building visualizations using Power BI Desktop and Power BI Service.
• Should have basic knowledge of Finance fundamentals.
• Should have working experience on ERP and CRM systems.
• Should be able to define a data model, create and customize visualizations, hierarchies and drill-down in Power BI.
• Should have the knowledge of publishing, sharing and exploring data.
• Should be able to define model with calculated columns, measures, calculated tables using DAX, clean and transform data with the Query Editor.
• Should be able to customize and design advanced visualizations and optimize Power BI dashboards with a focus on usability and performance.
• Should be able to configure and setup gateways, developing, maintaining, publishing and supporting dashboards.
• Should have excellent verbal and written communication skills, strong analytical and problem-solving skills. Should analyse functional/non-functional requirements and seek clarifications for better understanding of requirements.
• Very strong on database concepts, data modelling, stored procedures, complex query writing, performance optimization of SQL queries.
• Must have developed and deployed 15 code enhancements of reports and/or data integration solutions to production over a 12-month period
• Min 1 years of experience with Microsoft Visual Studio & BI Development Studio
• Min 1 years of experience troubleshooting existing SQL code to resolve accuracy and performance problems
• Min 2 years of experience developing basic report table / database schemas using consistent naming standards and effective use of primary and foreign key constructs
• Proven hands-on experience on the tools / technologies below is a must:
• Data Warehouse:
• Oracle Data Warehouse
• Microsoft SQL Server
• Microsoft SQL Server Analysis Services

ETL:

• Oracle Data Integrator
• Informatica
• Microsoft SQL Server Integration Services

Reporting:

• Oracle Business Intelligence Enterprise Edition
• Microsoft Power BI
• TableauRoles and Responsibilities

If you found your profile Eligible kindly share your resume to [email protected]

Apply Here

Submit CV To All Data Science Job Consultants Across India For Free