Data Integration and Reporting Lead Jobs in Bangalore,India - 25179023

Job Description:

WE are Self-starters, WE are Passionate, WE are Relationship builders, WE are Innovative, WE are Nimble, and WE are TransparentWE are SPRINTers! We believe in challenging you, then providing you the room and flexibility to deliver

EFI is looking for a Data Integration and Reporting Lead to join our IS & T Business Unit in our Bangalore office The IS&T BI group at EFI is looking for a highly motivated individual to join our team in this role

Responsibilities include, but are not limited to

Design, develop, test, and deliver self-service infrastructure and business intelligence (BI) content including reports and dashboards to business professional using the IBM Cognos BI and Qlikview

Gather requirements from business users, build out process analysis, schedules and assignments, communicate status updates, and coordinate user acceptance testing and issue management

Develop best practices for solutions that help end users access and analyze data in data warehouse, data marts, and operational systems

Assist business users with Ad-Hoc reporting and troubleshooting post-production issues

Provide training and data warehousing space to business users

Promote and provide support for BI solutions/capabilities to the business user community as well as executives

Interact with other BI team members, and cross-IT staff on support and project activities

Perform early stage analysis of reporting requests to formulate high level approach and estimates

Design and support the data model required for reports

Work primarily with Data Architect, Data Integration Engineer, and BI Manager to design business intelligence and operational reporting solutions

Articulate data sourcing and data model requirements to ETL and database resources and collaborates on development

Optimize query performance as needed for ETL jobs

Contribute to the ongoing development and improvement of BI reporting processes and standards

Execute rapid prototyping for new report requirements using open source, Hadoop, etc

Design, develop, and implement data-integration jobs to effectively process high-volume disparate data sources

Define and develop scalable, maintainable & innovative data-integration solutions

Build new data pipelines based on business requirements and input from the rest of the team

Maintain existing data pipelines into our data warehouse

Develop and Document all ETL jobs and processes according to ETL standards and best practices

Define and implement monitoring and self-recovery strategies for ETL and Scheduled reports

Interact closely with business partners and Engineering teams to determine analytics needs and translate those needs into efficient & scalable ETL processing needs

Ensure ETL requirements are clearly understood and documented

Proactively focus on data integrity, data hygiene and performance improvement of existing processes

Validate and enforce integration standards and best practices that meet the needs of the business and guarantee consistent results across projects

Provide technical leadership for solution development and review data integration architecture design

Implement automated data quality checks, as part of ETL, and iteratively improve upon them as needs evolve

Write scripts to retrieve data from non-proprietary systems using APIs (ie SOAP, REST, etc) and build pipelines into the DW for the same

Minimum Requirements

4 year degree in Computer Science, Information Systems, or in a related discipline

10 years of relevant work experience in data warehousing, data modeling and reporting services

At least 5 years experience with Cognos with excellent development skills, including Framework Manager

At least 4 years of experience supporting Data Warehouse, Data Integration and Business Intelligence reporting

At least 4 years working with ETL Pipeline tools such as Data Manager, Data Services and SSIS

At least 4 years experience with Extract, Transform, Load/ETL best practices and cutting edge Data Integration tools, technologies, and techniques is required

At least 3 years experience developing ETL and/or reports based on SAP data in a manufacturing company

At least 3 years experience developing ETL and/or reports based on Salesforce data

At least 2 years working experience with SAP BODS

Strong problem solving and analytical skills even with no business requirements

Strong presentation skills including the ability to interact with top-C level business leaders

Must exemplify leadership and salesmanship qualities to promote BI solutions throughout the organization

Strong competence in gathering and documenting business requirements, defining optimal BI solutions to business problems

Strong understanding of SDLC best practices with an emphasis on DW/BI practices and excellent at SQL Skills

Excellent verbal and written communication skills with the proven ability to multitask, prioritize work

Hands on Framework Manager Dimensional Modeling, Dashboard and report development experience

Proficient in Microsoft Office

Proven and strong Oracle and MS SQL development

Very strong analytical and SQL skills

Strong shell scripting experience

Strong Data Architecture background

Flexibility to work with customers and peers across time zones (India, Europe, APAC and Latin-American)

We are a global company and require overlap hours on regular basis is expected to interact with business and peers

On call availability to address job failures

Preferred/Nice to Have

Experience with Power BI, SharePoint, Performance Point, Excel Services, PowerPivot, Qlikview, SSIS, Crystal Reports

Experience with Informatica Cloud Services and integration with solutions such as Callidus Commissions, Salesforce and Marketo

Proven experience with SQL and advanced database topics including performance tuning, partitioning, data warehousing, server maintenance

Strong understanding of OLAP database/cube architecture, Normalization & Data mining

Excellent working knowledge of Oracle, SAP FICO, SD, MM, or equivalent modules

High level understanding of the NET framework and NET technologies including C#, VBNET, ASPNET, Web Services, JavaScript

Experience with Machine Learning, Predictive analytics, Azure BI and Data Services

Rapid prototyping and agile methodology

Other Requirements

Adaptability, creativity, versatility, self-starter and a collaborative attitude
Solid communication skills must enjoy working with stakeholders, eliciting requirements and solving problems around data / reporting automation
Hands one experience with multiple Data Integration tools and technologies, some examples include Domo, Hadoop, Amazon RedShift, Talend, Apatar, CloverETL, GoKettle, KETL, and Pentaho Data Integration for Big Data The team looking for individuals with a strong blend of knowledge, tell us about what you have done
This is a full time position reporting directly to the Director of BI within an extraordinary organization The team is looking for someone to evolve with them long term, and they are interested in keeping you once you join the team by reminding you of how valuable you and your talents are to their mission

We move quickly, with the purposeful intention of solving a problem, accomplishing a goal, and ultimately making a difference for our customers, partners, colleagues and shareholders, EFI SPRINTers take action and adapt to changes in order to transform our customers businesses to be more productive and profitable through innovation in a digital print business

Profile Summary:

Key Skills: