EY FY19_Knowledge_KS_Data Engineer_Senior Associate in Gurgaon, India

FY19KnowledgeKSData EngineerSenior Associate

Core Business Services

Requisition # GGN000M4

Post Date Oct 29, 2018

Job Summary:

  • The Data Engineer will join a growing team of analytics experts responsible for expanding and optimizing data, data infrastructure, data processing and wrangling. The position will gather and cleanse data, understands the meaning of datasets and dataset compatibility, integrates data and implements business rules

  • The Data Engineer will support data scientists, product managers and analysts on data initiatives and will ensure optimal data delivery is consistent across projects. In addition seek to understand the business problem and contribute to solving it through the use of analytics.

  • They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or even re-designing our data infrastructure to support our next generation of products, services and data initiatives.

  • The outputs of this position leads to insights that support strategic decision-making, along with ideas to automate, innovate, and enhance the measurement and reporting process.

Essential functions of the job:

  • Assemble, gather and cleanse data sets that meet business requirements.

  • Queries and/or integrates data by using SQL, SQL-like tools to perform ELT tasks.

  • Creates data models by delivering calculations, aggregations and derivations from input data.

  • Implements business rules that are required to meet business needs

  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure data platforms.

  • Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.

  • Design, develop and manage analytic dashboards and new reports

  • Analyze, visualize, and provide analytics on data captured daily to build reporting solutions to support various knowledge initiatives

  • Work with stakeholders to assist with data-related technical issues and support data and infrastructure needs.

  • Drives data accuracy, quality and integrity ensuring compliance with data governance.

  • Create data tools for analytics and data scientist team members that assist them in building and optimizing products.

  • Work with data and analytics experts to strive for greater functionality in our data systems.

Analytical Responsibilities:

Database management

  • RDBMS and data processing design and development

  • Data source analysis to refine code / application of pattern and exceptions

  • Catering for data scenarios and failures

  • Unit testing with dev / test / live data

Data wrangling

  • Data source analysis to refine code / application of pattern and exceptions

  • Catering for data scenarios and failures

  • Unit testing with dev / test / live data

Test analysis

  • Test scenario and case preparation and execution

  • Data querying construction and execution

  • Testing framework development and configuration

  • Defect logging and management

Technical Skill Requirements:

  • Strong technical analytics expertise. Good knowledge of data analytics architectures and standards, including data warehouses, master data management, ETL, OLAP, data modelling techniques, meta data management, data quality management, , advanced analytics, reporting and self-service BI ;

  • Experience in data manipulation using Excel, Access, SQL, R/ Python/ Alteryx,

  • Experience in at least one data visualization tools – Power BI/ Spotfire/ Tableau

  • Desired but not essential – machine learning, natural language processing,

Supervision Responsibilities:

  • Works with a geographically dispersed team, highly self-motivated, able to work independently

  • Ability to complete multiple small-sized projects and work with project teams

  • Able to meet deadlines independently

Job Requirements:

Education:

  • Bachelor degree in computer science or computer engineering or STEM subject

Experience:

  • 2 years minimum of relevant experience in a professional data management (ETL, manipulation) role

  • Ideally, experience applying analytics in research, analysis or knowledge measurement within a large organization is an advantage

Certification Requirements:

  • Desired : SQL, data visualization, , Alteryx, information management