Senior BI Engineer Jobs in Thiruvananthapuram - Athsan Consulting Services Pvt Ltd

Purpose of the Role

Implement ETL workflows and transformations for on-prem and cloud applications for business initiatives. Deliver value to business by modeling data marts/data warehouses and providing analytics/interactive reports. This enables alignment of company objectives with the Business and Technology team efforts.

Key Responsibilities

• Leverage strong analytical and problem-solving skills to identify and deliver actionable insights.
• Implement data analytics initiatives by working with the Agile team to satisfy stakeholder expectations and the needs of the organization.
• Develop and maintain data models, relationships to enable data access, reporting, integrity and quality.
• Manage internal stakeholder expectations and balances the needs of the company and the client to ensure satisfaction for both.
• Apply Business Intelligence, Structures Query Language, System Analysis, Design, Development and OLTP/OLAP, Data Modeling skills to develop lean and high-performance analytics.
• Ensure data architecture is built for performance, fault tolerance, and security applying reusable patterns.
• Partner with teams across the organization to build, establish, and deliver on requests. 

Measures of Success

• Optimize queries and reporting models enhancing performance by 20%
• Reduce manual data remediation efforts for current KPI targets by 20%
• Visualized data sets related to consultant journeys improving consultant lifetime value by > 5%

Education and Experience

• Bachelor in Computer Science, CIS, or MIS (Not mandatory)
• Expert level in Informatica or Talend and creating Tasks, Subject Areas, Execution Plans, performance tuning, and configuring DAC to execute the ETL process (6+ yrs)
• Skilled in SQL and Oracle PL/SQL (5+ yrs)
• Extensive experience with report development (Analysis/BI Publisher), interactive Dashboards, Security Setup (roles/groups, access/query/report privileges) using OBIEE/MicroStrategy. (5+ yrs)
• Strong experience in data modeling and data optimization
• Expert in designing and developing dashboards in MicroStrategy or similar analytics tools. (5+ yrs)
• Skilled with modeling OLAP databases
• Experience in S3 and AWS Redshift development and implementation is a plus
• Strong analytical, critical thinking, and problem-solving capabilities with the ability to translate data-driven insights and customer needs into business recommendations and solutions
• Strong work ethic and “can do” attitude with a high degree of self-motivation

 Quick Overview for finding suitable candidates immediately

• ETL–Informatica (relevant project experience) or Talend (a plus if they have both) is must. 
• OBIEE (Must)
• PL/SQL (Must)
• AWS Redshift (having this is a plus but not mandatory)
• MicroStrategy (having this is a plus but not mandatory)
• Data modeling
• SQL
• Minimum 6 plus years of experience (6-10 years)
• Role: Permanent
• Location: Work from home
• Notice: Immediate (Max 30 days)
• Package: Max INR 15 LPA (Can consider candidates with reasonable expectation)