Lead, Data Warehouse

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 industry expertise. 

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.

• 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.

• 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 across geography, generations, and teams. Rally around final decisions. 
  • Innovation | Always be curious (ABC). Challenge the status quo. Experiment and fail forward. Build for the future. 
  • Grit | Focus on what matters. Work with passion and persistence. Think like an owner. Deliver results you’re proud of. 

   

  Consilio, LLC is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.