Sr. Data warehouse analyst 

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