Sr Data Warehouse Analyst

As a Data Warehouse Analyst, you will be part of a dynamic team dedicated to designing, building, and supporting the Enterprise Data Warehouse (EDW) at our company. Your primary mission will be to deliver consistent, reliable data and reporting solutions that enhance the business intelligence capabilities of the organization. Your work will have a direct impact on the leaders of the Consilio eDiscovery business by providing clean, consistent data. - Study and understand the company's business processes and applications to design data warehouse objects and reports that support data and reporting needs. - Build reports, add new fields, and create Business Objects filters and measures using MS SQL Server and PowerBI. - Utilize dimensional modeling to develop new solutions aligning with business requirements. - Create dashboard proof-of-concepts using PowerBI or Excel to enhance data and business intelligence. - Collaborate with stakeholders to drive the technical requirement gathering process. - Assist data warehouse users in effectively utilizing various solutions. - Address data challenges and find appropriate solutions in collaboration with peers. - Support ETL processes involving error and reconciliation handling using Microsoft SQL Server Integration Services (SSIS). - Perform capacity planning, troubleshooting, and ETL/procedure performance modifications. - B.A./B.S. in Computer Science or a related field. - 8+ years of experience working with relational databases in a business intelligence capacity. - 5+ years of experience with traditional Data Warehouse, data modeling, and data mart development. - Strong SQL skills, with a preference for T-SQL. - Experience with PowerBI, particularly in building data visualizations for business constructs. - Proficient in technical writing for engineering and user-facing documentation. - Data analysis skills to identify business trends, insights, inconsistencies, and patterns. - Proficiency in GitHub, JIRA, and Change Management. - Experience with SnapLogic or other integration tools is a plus. - Strong collaboration skills to build effective relationships with colleagues.,