Job Summary
Data Pipeline / ETL DeveloperYears of Exp Location – Pan India or any constraint HyderabadProject type (Support / Dev / Maintenance / Testing) DevShift involved – If yes please share timing. 7 AM to 16 PM ISTCustomer interview involved – yes / No NoSalary Range SkillMandatoryProficiency Level (1-5) Experience in writing SQL Basic and Advanced SQL queriesYes5Experience in reporting using any reporting tool like Tableau or Qlikview, Power BI. Google Plx dashboard will be added advantageYes3Experience in requirement gathering and analysis of BI projectsYes5Firm understanding of SDLC (software development lifecycle)Yes4Excellent Communication SkillsYes4 Data Analytics ConsultantResponsibilities:Develop and Maintain Dashboards: Design, build, and maintain a comprehensive suite of operations dashboards using various data visualization tools (e.g., Plx,Trix, Looker Studio, etc.) to provide real-time insights into Submarine Networking and Subsea Operations performance.Develop and Maintain Source Data: Develop, discover, and or maintain data sources, including the manual creation of data sets when necessary, to support all reporting and performance management initiatives.SQL Development & Optimization: Write complex, efficient, and optimized SQL queries to extract, transform, and load data from various databases, ensuring data integrity and accuracy for all reporting and tooling.Translate Business Requirements: Work closely with operations stakeholders to meticulously interpret Business Requirement Documents (BRDs) and mock-up designs, ensuring all developed tools and dashboards precisely meet user needs.Build Web Tools: Utilize Google Apps Script (or similar scripting languages) to develop and maintain lightweight web tools, automation scripts, LIA tools, and integrations that enhance operational efficiency and data accessibility.Ensure Data Integrity: Implement robust data validation and quality checks within all SQL queries and tools to guarantee the reliability of reported metrics.Troubleshooting & Support: Provide ongoing support, troubleshoot data discrepancies, and resolve technical issues related to dashboards and tools.Documentation: Maintain clear and concise documentation for all developed dashboards, SQL queries, and web tools, including data sources, logic, and update processes.Vendor Pre-Requisite:Database Development: Advanced proficiency in SQL / Big Query, inclusive of relational database and NO SQL architecture, complex joins, subqueries, window functions, and query performance optimization.Visualization: Documented portfolio of operational dashboards deployed via enterprise-grade data visualization platforms.Scripting & Automation: Technical competency in Google Apps Script (or comparable web scripting languages) for custom web tool development and workflow automation.Design Implementation: Demonstrated capability to translate Business Requirement Documents (BRDs) and high-fidelity mock-ups into functional technical solutions with strict adherence to design specifications.Stakeholder Communication: Proven ability to articulate complex technical constraints, data anomalies, and logic discrepancies to non-technical business stakeholders for rapid resolution.Agile Collaboration: Proficiency in managing iterative feedback loops, specifically interpreting stakeholder feedback during User Acceptance Testing (UAT) to refine deliverables without scope creep.Data Integrity & Precision: Application of rigorous data validation protocols to ensure