Lead, Data Warehouse

• 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.
  
  Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.