Sr Data Warehouse Analyst

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. 

Data Warehouse Analyst 

Join a dynamic team that designs, builds, and supports the Enterprise Data Warehouse (EDW). 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 Warehouse Analyst 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.  

As most of the Data Warehouse stakeholders are in the U.S. working U.S. hours is necessary. 

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

• Building reports, adding new fields, creating Business Objects filters, measures, and other solutions. Leveraging MS SQL Server and PowerBI.  

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

• Collaboration:  

• 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, troubleshooting, and ETL/procedure performance modification. 

Skills & abilities this individual should possess:  

• B.A./B.S. in Computer Science or related field.  
• 8+ years of experience working with relational databases in a business intelligence capacity. 
• 5+ years with traditional Data Warehouse, data modelling / data mart development. 
• Strong SQL skills, T-SQL preferred. 
• PowerBI experience, particularly building data visualizations to describe business constructs.  
• Technical writing skills, supporting both engineering and user facing documentation. 
• Data analysis skills with a proven ability to identify business trends and insights as well as data inconsistencies and patterns. 
• Proficiency with GitHub, JIRA, and Change Management.  
• Experience with SnapLogic or other integration tools a plus. 
• Strong ability to collaborate and build effective relationships with your colleagues 

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 

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.