DB - Engineer

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. 

Role Overview :

Join a dynamic team that designs, builds, and supports the Enterprise Data Base (EDB). Our mission is to deliver consistent, reliable data and reporting solutions that revolutionize the business intelligence capabilities for the organization. Delivering, clean, consistent data to leaders of the Consilio eDiscovery business!

The ideal Data Base Engineer will be able to work with stakeholders and engineers without skipping a beat. This person should have a passion for data quality, reliable reporting, and creating robust solutions.

• Data Intelligence & Analysis:
• Study and understand the company’s business processes and applications, including their effect on data and reporting, and apply the knowledge gained in designing data warehouse objects and reports.
• Strong SQL skills, T-SQL preferred.
• Building reports, adding new fields, creating Business Objects filters, measures, and other solutions. Leveraging MS SQL Server.
• Dimensional modeling for new solutions that meet the business needs.
• Creating dashboard proof-of-concepts that elevate data and business intelligence using either PowerBI or Excel.
• Technical writing skills, supporting both engineering and user facing documentation.
• Driving the technical requirement gathering process by working with stakeholders.
• Assist data warehouse users with leveraging the various solutions available.
• Working with peers to find the right solution to any data challenge.
• Occasionally responsible for:
• Supporting ETL processes that involves error and reconciliation handling, utilizing Microsoft SQL Server Integration Services (SSIS).
• Performs capacity planning, supporting, trouble

Minimum Education Requirements:     

• Bachelor’s degree or equivalent experiencerequired

Minimum Experience Requirements:    

• 2 - 4 years of software testing experience
• Keen attention to detail
• Strong analytical and problem-solving skills
• Excellent verbal and written communication skills
• Creative and innovative thinker
• Diligent and meticulous

 Other Preferred Requirements:    

• Experience with JIRA Software
• Proficiency with Relativity preferred
• EDRM awareness preferred
• Strong computer skills and relational databases knowledge
• Experience with Git, Kibana, LINQ pad, T-SQL
• Experience with data manipulation in text editors

Consilio’s True North Values 

• Excellence 
  We strive to make every client our advocate 

• Passion 
  We DO because we CARE 

• Collaboration 
  We win together through teamwork and communication 

• Agility 
  We flex, adapt and embrace change 

• People 
  We value, respect and invest in our teammates 

• Vision 
  We create clarity of purpose and a clear path forward 

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.