Lead, Data Warehouse

Consilio LLC; Hyderabad; On-site; INR 2,600,000 - 5,200,000; Full time

Benefits offered by this job

Competitive salary

Benefits package

Professional growth

Job summary

Consilio, LLC is seeking a highly experienced Senior SQL Engineer to join its Enterprise Data Warehouse team. This role emphasizes advanced data analysis, prototype dataset development, data mart design, and investigative SQL across enterprise source systems.

The ideal candidate will demonstrate curiosity, judgment, and ownership, with the ability to work with incomplete documentation and partner with Data Engineering, Data Analysis, and Product leadership to deliver reliable, explainable

Qualifications

• 10+ years of hands-on SQL development and data analysis experience.
• Strong experience with enterprise databases, data warehouses, data marts, and analytical datasets.
• Expert-level SQL skills including complex joins, CTEs, window functions, and query optimization.
• Proven ability to investigate unfamiliar databases and infer relationships without complete documentation.
• Strong data intuition to recognize incomplete, duplicated, or incorrect results.
• Experience building prototype datasets or analytical models from raw source data.

Responsibilities

• Analyze complex enterprise data across multiple source systems to support reporting and data warehouse development.
• Build prototype datasets, proof-of-concept queries, and exploratory data models.
• Design and develop SQL-based data marts, analytical datasets, and reusable query logic.
• Investigate undocumented databases to identify table relationships, keys, joins, and data lineage.
• Validate data outputs using reconciliation techniques and business judgment.
• Document findings, data relationships, and reusable query patterns for future team use.
• Mentor team members on advanced SQL analysis and data validation techniques.

Skills

SQL development

Data analysis

Data warehousing

Tools

SQL Server

Azure SQL

Snowflake

Databricks

Synapse

Oracle

Job description

Overview

About the company

Consilio stands as the global leader in eDiscovery, document review, flexible legal talent, and legal advisory & transformation consulting services. With its Consilio Complete suite of capabilities, the company empowers multinational law firms and corporations using innovative software, cost-effective managed services, and deep legal and regulatory industryexpertise.

Work Model - 3 days WFO/2 days WFH(Hybrid)

Shift - 2 PM - 11 PM

Benefits - Free pick & drop, free meals & more

We are seeking a highly experienced Senior SQL Engineer to join our Enterprise Data Warehouse team. This role will focus on advanced data analysis, prototype dataset development, data mart design, and investigative SQL work across enterprise source systems.

The ideal candidate is not simply a SQL developer. This person must have deep curiosity about data, strong analytical instincts, and the ability to determine whether query output “looks right” based on business context, source system behavior, data patterns, and reconciliation logic. This role requires someone who can work effectively even when documentation is incomplete or unavailable.

This position is expected to work closely with Data Engineering, Data Analysis, Business Systems Analysis, Product, and Engineering leadership.

Critical Success Factors

This role requires more than only years of SQL experience. The successful candidate must demonstrate:

• Curiosity: Actively investigates data rather than waiting for perfect documentation.
• Judgment: Can determine whether results make sense based on patterns and business context.
• Persistence: Will search through tables, relationships, and outputs until the data story is clear.
• Ownership: Takes responsibility for producing reliable, explainable datasets.
• Analytical depth: Understands not just how to write SQL, but how to reason through data.
• Practical prototyping ability: Can quickly build usable datasets that help shape future warehouse or reporting solutions.

Responsibilities

• Analyze complex enterprise data across multiple source systems to support reporting, analytics, and data warehouse development.
• Build prototype datasets, proof-of-concept queries, and exploratory data models to support new business requirements.
• Design and develop SQL-based data marts, analytical datasets, and reusable query logic.
• Investigate undocumented databases to identify table relationships, keys, joins, business rules, and data lineage.
• Validate data outputs by applying business judgment, reconciliation techniques, and analytical reasoning.
• Identify data quality issues, inconsistencies, gaps, duplicates, and unexpected trends.
• Translate ambiguous business questions into structured SQL analysis and actionable findings.
• Partner with Product Owners, Business Systems Analysts, Data Analysts, and Data Engineering teams to clarify requirements and validate assumptions.
• Support enterprise data warehouse design by helping define source-to-target mappings, transformation rules, and analytical models.
• Document findings, data relationships, assumptions, and reusable query patterns for future team use.
• Mentor other team members on advanced SQL analysis, data investigation, and validation techniques.

Qualifications

• 10+ years of hands-on SQL development and data analysis experience.
• Strong experience working with enterprise databases, data warehouses, data marts, and analytical datasets.
• Expert-level SQL skills, including complex joins, CTEs, window functions, aggregation logic, performance tuning, and query optimization.
• Proven ability to investigate unfamiliar databases and infer relationships without complete documentation.
• Strong data intuition: ability to recognize when results are incomplete, duplicated, inflated, missing, or logically incorrect.
• Experience building prototype datasets or analytical models from raw operational source data.
• Strong understanding of data warehouse concepts, dimensional modeling, fact and dimension structures, and source-to-target mapping.
• Ability to work with ambiguous requirements and independently drive analysis toward clear conclusions.
• Strong communication skills, including the ability to explain data findings to technical and non-technical stakeholders.

Preferred Qualifications

• Experience in enterprise data warehouse environments.
• Experience with healthcare, legal, financial, or other complex operational data domains.
• Familiarity with ETL/ELT processes and modern data platforms.
• Experience supporting BI/reporting teams with curated datasets and data marts.
• Experience documenting data lineage, transformation rules, and business logic
• Exposure to tools such as SQL Server, Azure SQL, Snowflake, Databricks, Synapse, Oracle, or similar platforms.
• Why Join Us:
  • Be part of a collaborative and innovative work environment.
  • Opportunity for professional growth and development.
  • Competitive salary and benefits package.
  • Contribute to shaping the future of our software development processes.

Consilio’s True North Values

• Client Experience| Listen for the “why”.Clearly define success. Be accountable. Go the extra distance to create moments that matter.
• Collaboration| Treat everyone with respect. Welcome diverse views. Partner acrossgeography, generations, and teams. Rally around final decisions.
• Innovation| Always be curious (ABC).Challenge the statusquo. Experiment and fail forward.Buildfor the future.
• Grit| Focus on what matters. Work with passion and persistence. Think like an owner. Deliver resultsyou’reproud of.

Consilio, LLC isan EEO/Affirmative Action Employer and does not discriminateon the basis ofrace, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status,disabilityor any other legally protected status.