Sr. Engineer, Data Warehouse

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.  

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. 

About the Role:

Join a dynamic team that designs, builds, and supports the new Enterprise Data Warehouse (EDW). Delivering, clean, consistent data to leaders of the Consilio eDiscovery business.

The EDW engineer will work within the Microsoft Stack, building ETL workflows, data marts, data quality scripts, dimensions, fact tables, aligning with the star schema methodology. This role will report to the Lead data engineer in India, as a member of the data warehouse team and will work closely with business analysts and other project team members.

The right candidate will be an energetic, self-starter. Someone who understands database designs, ETL processes, and experience design & building a data warehouse that is modern, scalable, maintainable, and high performing.

• Data Warehousing design and implementation to support data reporting/analytic initiatives and BI platforms & tools.
• Develop Extract, Transform, and Load (ETL) workflows using SQL Server Integration Services (SSIS), or other languages such as C# and .Net to extract data from transactional databases and cloud APIs.
• Analyze and evaluate the data source and data targets required for the ETL mapping.
• Design, build and support Data marts using SQL Server.
• Build data quality scripts and notifications (either custom or using third party tools).
• Design, build and support dimensions, fact tables and cubes.
• Design and implement scalable and high-performance data and BI solutions.

• 5+ years hands experience in SSIS or other ETL tools like Informatica.
• 5+ years of data warehouse development hands on experience using SSAS for tabular cube modeling.
• Experience in designing & working with star schemas, facts, dimensions (including SCDs).
• Strong database development skills in SQL Server (SQL procedures, functions, etc.)
• Experience with Power BI and/or SSRS.
• Experience in development tools such as Red Gate and Github a plus.
• Experience creating and maintaining EDW artifacts (documentation, guides, etc.) a plus.
• Experience in DAX or MDX a plus.
• Possess excellent communication skills, both written and verbal.
• Thorough knowledge of SDLC.
• Bachelor's degree in Computer Science or Data Analytics or Software Engineering or Mathematics preferred.

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.