Data Consultant

Job Title: Data Consultant

Location- Bangalore

Exp- 6-10 yrs

We are seeking a Data Consultant who will be responsible for guiding data strategy, analytics, and data management initiatives for our clients. This role will involve collaborating with cross-functional teams to design and implement data solutions that drive business outcomes. The Data Consultant will conduct data analysis, interpret trends, and provide actionable insights that inform decision-making. The ideal candidate will possess a strong combination of technical expertise and business acumen, helping organizations leverage data effectively.

Main Responsibilities:

• Maintain data warehouse schemas located in Oracle and Google Big Query.
• Ensure procedures are running on schedule and resolve bugs as they arise.
• Random validation to ensure accuracy of the reporting views.
• Complete audits for data governance and process.
• Create and maintain python scripts utilized for automated reporting and ETL.
• Create and manage complex reporting views, tables, and procedures including ETL work within Oracle DBMS.
• Transition Oracle schemas to GCP
• Create and maintain data dictionaries and warehouse documentation.
• Locate and source new data as needed.
• Capture, develop, and document data definitions, business rules, and data quality requirements.
• Maintain code in Git repositories.
• Work in Azure ADO for intake management and sprint planning
• Ad hoc reporting and analysis
• Create ad hoc reporting and analysis as requested by stakeholders to solve business problems or hypothesis test business questions

Technical Skills:

• Bachelor's Degree or equivalent experience in Business Intelligence, Computer Science, Mathematics, Statistics, or related field.
• Ability to translate business needs to technical specifications.
• Advanced to Expert database development and management, preferably in Oracle utilizing stored procedures, complex nested statements, schedules, and functions in the capacity of golden reporting layer reporting, schema maintenance, ETL across data warehouses, requirements gathering, and QA/QC.
• Intermediate to Advanced python development in the capacity of automation of recurring reporting, ETL, API, process automation.
• Advanced GCP data architecture, ETL, procedures, schedules, functions, ETL, and complex queries designed for efficiencies and cost optimizations.
• Informatica Cloud experience.
• Experience transitioning from Oracle or similar warehouse structure to GCP for reporting layers.
• Data Governance, data integrity, QC experience.
• Ability to manipulate and summarize large data sets.

Lumen connects the world. We are igniting business growth by connecting people, data and applications quickly, securely, and effortlessly. Together, we are building a culture and company from the people up committed to teamwork, trust and transparency. People power progress. We're invested in providing the flexibility you need to thrive and deliver lasting impact. Apply now to continue digitally connecting the world and shaping the future.

We are an equal opportunity employer committed to fair and ethical hiring practices. We do not charge any fees or accept any form of payment from candidates at any stage of the recruitment process. If anyone claims to offer employment opportunities in our company in exchange for money or any other benefit, please treat it as fraudulent and report it immediately.