• Principal Engineer-BI

    Job Locations IN-MH-Mumbai
    Job ID
    2018-1574
    Category
    Engineering
  • Overview

    This position is responsible for development, support and ongoing enhancements for one or more complex business system applications.  The ideal candidate for this position will have an in-depth knowledge in the full life cycle of Enterprise Data Warehouse (EDW), Business Intelligence (BI)

    Responsibilities


    • Collaborate with Product Management to understand business requirements and design appropriate solutions

    • Assessment of current business processes and current technologies.

    • Documentation of logical solution architecture and advising on strategic improvements including Enterprise Data Warehouse, lightly customized Customer Relationship Management system.

    • Create data model and implementation.

    • Review of architecture, data models, and segments of ETL design

    • Defines and maintains the integrity of the overall corporate data model on which the BI is based.

    • Designs, codes, tests, and document all new BI systems, applications, and programs. Develops the views, packages, metadata, reports, and report definitions

    • Innovate tooling that support Business intelligence and analytics goals

    • Evaluation of the technology stack for ETL & Reporting if required

    • Works with cross functional team to ensure the necessary data and analysis environments are available

    • Responsible for writing technical user stories for sprint.

    • Designs the overall data transformation workflows in consultation with the application modules

    • Establish and enforce technical standards for deliverables of projects.

    • Have very good understanding of Continued integration to drive the DevOps pipe implementation on respective projects using tools - Github, Jenkins .

    • Not Looking for a Team manager or Team leader

    Qualifications

    Technical Skills/Experience Requirements



    • 8+ year’s professional experience in Dimensional Modeling/Visualization.

    • Must have a high degree of initiative to implement solutions in a fast-paced, dynamic environment.

    • Expertise in the design, data modeling methodologies and development for data warehouses.

    • Candidate must have an advanced knowledge of databases such as SQL server, Oracle, MySQL and Cloud datastores like Redshift, Snowflake Datawarehouse, as well as various BI tools like IBM Cognos / SAP Business Objects, Microsoft SSRS, Qlikview / Tableau, Looker. Knowledge of programming languages and experience in software development can be a strong asset.

    • Experience across - Openstack technologies Cassandra, PostGreSQL and Hadoop Database technology.

    • Thorough understanding of Data modeling i.e. Kimball/Inmon strategies , Data Lake, Hb-Spoke, Data Vault

    • ETL Technology: SSIS, Talend, any other Open source ETL tool.(at least 2 years of experience in any of these tools)

    • Visualization Technology: Tableau, Jasper, Qlikview, MSBI, spotfire.(at least 2 years of experience in any of these tools)

    • Knowledge on Predictive Analytics, ML, Data Mining models

    • Demonstrated experience in dealing with large datasets from variety of different sources, each with varying degrees of data quality and cleanliness.

    • Hands on working knowledge of current and pipeline technologies; BI Semantics, Data Quality Services, metrics\KPI\scorecard driven analytics and management.

    • Knowledge in database administration functions such as performance, security, backup & restores, schema migrations, and normal maintenance.

    • Demonstrated skills in data modeling. Must be able to understand business requirements and translate them into technical deliveries.

    • Performance tuning experience related to reporting queries required

    • Requires strong analytical, conceptual and problem-solving abilities

    • Familiarity with Agile concepts, and experience practicing SCRUM.

    • Experience working with remote teams.

    • Must have excellent communication skills.

    • Strong oral and written communication skills.


    Educational Qualifications



    • E/B.Tech in Electrical Engineering, Computer Science or related field required

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed