Sr Data Warehouse Analyst
Sr Data Warehouse Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Overview
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.
Responsibilities
- Data Intelligence & Analysis:
- Study and understand the companys 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 proofofconcepts 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 TSQL 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
Required Experience:
Senior IC
Employment Type
Unclear
