Advanced Data Engineer

Advanced Data Engineer - Job Responsibilities include:

• Generate and prepare reports to track KPI metrics along with data analysis and insights for Engineering Program execution and monthly revenue reporting
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Design, build and maintain scalable data pipelines using DataBricks
• Implement data models to support analytics, BI and downstream consumption
• Automate data workflows using Databricks Job and Workflows
• Represent data using PowerBI and advanced visualization tools.
• Prepare ad hoc reports pulling data from multiple data sources and applications
• Identify and automate operational tasks through process/technical automation
• Data analysis, gap identification and drive efficiency on day-to-day reporting
• Prepare Monthly operations reporting along with Portfolio analysis coordinating with engineering, Product Operations and Project Management Leaders.
• Supporting the GBE to drive efficiency in business operations and to achieve their Annual operating plan targets.
• Coordinate the Monthly Operations Report for the GBE and provide reporting of financial, cost, quality, and schedule metrics.
• Enable leaders to make informed decisions using metrics and reports to improve the program performance and customer satisfaction.
• Assist with Impact assessments with respect to changes in program scope, schedule, and priority.
• Coordinates affordability analysis used for census and program planning. 
• Effective communication and Business Presentation skills. 
• Ability to build data models using statistical methods

You must have:

• BTech or equivalent
• Minimum of 6 to 10 years’ experience in Data Engineering and data operations
• Proficiency in python and Strong SQL skills with data modelling experience
• Working experience in databricks pipeline development
• Strong working knowledge of excel and Power BI for data representation
• Power BI Advanced excel skills VBA scripting, Power queries, V-look up, creating slicers.
• Direct experience in creating Chatbots and Automation.
• Knowledge of statistics and experience using statistical packages for analyzing datasets 
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with diligence and accuracy.
• Experience working directly with business users to build reports, dashboards and solving business questions with data.
• Experience in creating projects and assisting resources in SAP system.
• Proficient Microsoft Office package skills e.g. Excel, Project, Outlook, PowerPoint etc.
• Experience working in an engineering, finance and/or program management organization is also preferred.