Data Pipeline Analyst

Job Advert

Internal Job Title: Data Pipeline Analyst

Business: Lucy Electric Manufacturing & Technologies India

Location: Halol, Vadodara, Gujarat

Job Reference No: 3940

Job Purpose

To support the provision of key business insights by building and maintaining data pipelines and structures, using programming tools and languages including Python and MS SQL

Job Context

• Working closely with the Data & Analytics Development Lead and cross-functional teams to ensure a coordinated approach to Business Intelligence delivery
• The role involves providing information across multiple businesses for comparative and predictive analysis, highlighting opportunities for business process improvement

Job Dimensions

• The role is an onsite role, with flexible attendance at our office in Vadodara, India, to support business engagement
• There is an occasional need to visit other sites and business partners at their premises to build stakeholder relationships or to attend specific industry events, globally

Key Accountabilities

These will include:

• Capturing requirements and preparing specifications for Data pipelines and reporting
• Developing prioritised BI outputs to agreed quality and security standards
• Assisting the Data & Analytics team with technical integration of data sources
• Conducting training and coaching sessions to support business users’ understanding of data
• Collaborating with the wider business to promote appropriate use of data & analytics tools
• Maintaining operational and customer-facing documentation for support processes and defined project deliverables
• Improving analytics capabilities for BI services in an ‘evergreen’ ecosystem
• Troubleshooting production issues and coordinate with wider IT Team to resolve incidents and complete tasks using IT Service Management tools, as part of a cross-functional team

Qualifications, Experience & Skills

• A bachelor’s degree (or equivalent professional qualifications and experience) in a relevant stream
• Effective communication skills in the global Business Language, English
• 1.5 - 4 years of experience in data transformation and/or creating Data pipelines, including Python.
• Good understanding of Microsoft data storage tools such as Azure Blob and Data Lake
• Working knowledge of statistical methods to validate findings, ensure data accuracy and drive data-driven decision making
• Knowledge on Exploratory Data Analysis to identify key insights, potential issues, and areas for further investigation
• Conduct design reviews against existing guidelines, propose enhancements, conceptualise and design the best fit solution against requirements
• Providing Business as Usual support (BAU), and support Ad-Hoc reporting requirements while working on projects and workstreams at the same time
• Identify opportunities for process improvement and efficiency through data analysis and provide recommendations for automation or optimisation
• General understanding of a company’s ‘value chain’ and basic manufacturing industry terminology
• Good to Have Skills: ETL using Data Pipeline tools (e.g. SSIS, Azure Data Factory or similar), Microsoft SQL, Dynamics 365 (D365), Microsoft Dataverse, REST API’s, CI/CD on Azure DevOps, Data Quality, Data Sensitivity, Near Time and Real Time data processing

Behavioral Competencies

• Good interpersonal skills to enable process improvement through positive interaction with internal and external parties
• Keen problem solver with desire to share knowledge and support others, demonstrating active listening and empathy towards their views and concerns
• Customer-oriented, able to work flexibly in a changing business landscape, striving for stakeholder satisfaction

Does this sound interesting? We would love to hear from you. Our application process is quick and easy. Apply today!