Sr. Data warehouse analyst

Overview:

Data Warehouse Analyst

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.

Responsibilities:

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

Qualifications:

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