Business Intelligence (BI) Jobs in Bangalore (Bengaluru)

Power BI Experience: 2-3 years Skills: Power BI Start date : Looking out for Immediate Joiners Contract position for 3 months Location Bangalore Job Designation Power BI Developer : 1. To Develop Power BI reports & effective dashboards after gathering and translating end user requirements. 2. To have Ability to turn large amounts of raw data into actionable information. 3. Be responsible for the performance and usability of the system 4. To Perform optimization of MS SQL Queries and SSIS packages 5. To Provide solutions using SSAS cubes (Tabular/Multidimensional Models) 6. Must have excellent experience in MS SQL Server - writing queries, joints, stored procedures, functions etc Candidate should have the knowledge of: Power BI with DAX query, Multiple Data Sources and Relationships of data Power BI Architecture Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power BI Desktop Hands-on professional with thorough knowledge of scripting, data source integration and advanced GUI development in Power BI. Familiar with Power BI custom add-on development & deployment. Connecting Power BI with on-premise and cloud computing platforms. To provide optimized SQL Scripts for complex scenarios Business Intelligence Systems & Tools (Microsoft Power BI, SQL Server Reporting Services) Good understanding of the processes of data quality, data cleansing and data transformation

Lets discuss - govind@affairal.com / +919972668335

Critical Tasks and Expected Contributions/Results : The role will be primarily focused on the design, development and testing of ETL workflows (using Talend) as well as the batch management and error handling processes. Build Business Intelligence Applications using tools like Power BI. Additional responsibilities include the documentation of technical specifications and related project artefacts. - Gather requirement and propose possible ETL solutions for in-house designed Data Warehouse - Analyze & translate functional specifications & change requests into technical specifications. - Design and Creating star schema data models - Design, Build and Implement Business Intelligence Solutions using Power BI - Develop, implement & test ETL program logic. - Deployment and support any related issues Key Competency : - A good understanding of the concepts and best practices of data warehouse ETL design and be able to apply these suitably to solve specific business needs. - Expert knowledge of ETL tool like Talend - Have more than 8 years experience in designing and developing ETL work packages, and be able to demonstrate expertise in ETL tool- Talend - Knowledge of BI tools like Power BI is required - Ability to follow functional ETL specifications and challenge business logic and schema design where appropriate, as well as manage their time effectively. - Exposure to Performance tuning is essential - Good organisational skills. - Methodical and structured approach to design and development. - Good interpersonal skills.

• Proactively assist customers with technical issues that may arise with their solution implementation. Troubleshoot and perform root cause analysis. Identify and provide timely workarounds and solutions when possible, to meet customer’s business needs. • Reproduce in house when possible and file engineering tickets. Work with engineering and product management to prioritize as customer advocate to get resolutions in next release. When possible, analyze code and participate in engineering processes to develop and deploy defect fixes as service packs/hot fixes. • Constantly stay ahead in communicating with customers. Manage expectations properly to avoid escalations. Be a strong voice of customers during engineering planning. • Assist through release cycles in testing new features, enhancements and defect fixes. • Work with client business areas to design, build, enhance, and deliver enterprise wide data analytic dashboards and reports supporting multiple business units. • Collaborate with key business users to identify needs and opportunities for improved data management and delivery. • Design and build ETL processes and scripts. • Provide technical knowledge and business support to the BI team. Candidate fitment: • 6-8 years experience in Cognos Business Analytics Reporting and Analytical roles; proficiency in SQL, Excel, Relational Databases, Oracle, SQL Server • Ability to manage multiple timelines and priorities. • Experience in manufacturing industry is a PLUS. • Highly developed analytical, problem-solving, and consulting skills, with a proven track record of using data to provide actionable business results. • Experience in validating an overall solution from the perspective of performance, scalability, security and capacity. • The ideal candidate is dedicated to making it easy for customers to use our product by leveraging business expertise and using rigorous logic and creative methods to solve difficult problems with effective solutions.

Required Skills :- Detailed understanding and experience with the SAP HANA technology Minimum of 2 full life cycle implementations in SAP HANA SAP HANA modeling and scripting experience which includes ability to write complex stored procedures and scripted HANA views using SQL. Implement data models with SAP HANA using analytical and calculation views. Monitor, investigate and optimize these models and reporting performance on SAP HANA. Administer data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models. Evaluate the impact of different implementation options such as table joins, aggregation, or filters and understand the implication on performance of the various reporting tools and connection types. Apply advanced data modeling techniques, including currency conversion, variables and input parameters. Implement decision automation using business rules. Working knowledge of various data loading and replication methods so to load data into SAP HANA from different data sources (e.g. SAP Landscape Transformation (SLT), SAP Data Services, or Direct Extractor Connection (DXC)) is desirable. Apply SQL Script to enhance the data models in SAP HANA using AFL, CE functions, and ANSI-SQL Understand and implement HANA Security model. Refer the JD above. APPLY if you have min.1.5 yrs+ experience into SAP HANA Expertise - with end to end implementation handled for SAP HANA.

Sr BI Analyst / Lead BI Analyst Must Have: At least 3 to 6 years of techno functional / technical experience in delivering projects for Large Enterprises Strong background in data analysis, data sources, data warehouse and business intelligence Progressive experience in areas of ETL, Data Modelling, Data Visualization, Reporting and Analytics Familiarity with database concepts, SQL queries, joins and programming Experience in system administration, problem debugging, and solution design Formal education in technology, engineering and programming Ability to demonstrate strong technical aptitude Experience in handling customer communication Ability to manage individual contribution and workload, setting expectations and self-learning Familiarity with self-service BI products such as Tableau, Qlikview, Spotfire, Power BI, MSBI Additional Requirements (Nice to have): Understanding of data challenges encountered by business users Domain expertise to any of the following domains highly desired - Finance, Banking, Insurance, Healthcare, Pharmaceuticals