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 sinthasha.pakkir@centena.com
Submit CV To All Data Science Job Consultants Across India For Free
๐ Explore All Related ITSM Jobs Below! ๐
โ
Select your preferred “Job Category” in the Job Category Filter ๐ฏ
๐ Hit “Search” to find matching jobs ๐ฅ
โ Click the “+” icon that appears just before the company name to see the Job Detail & Apply Link ๐๐ผ

Leave a Reply