Senior Data Warehouse Analyst

Description As a Senior Data Warehouse Analyst, you will work with business users to define new data requirements, build/maintain data models, map data from transaction systems to the data warehouse, maintain data catalogs, and help maintain data quality by working with customer service and operations to address business process issues that impact the quality of data. The ability to communicate across a broad set of stakeholders, solicit requirements, define solutions, document and implement new data governance processes, and measure outcomes will be key to the success of this role. Responsibilities: Work with stakeholders throughout the organization to identify opportunities for leveraging data & analytics to drive business outcomes. Communicate across a wide range of audiences with specialized subject matter expertise including Marketing, Sales, Finance, Product, Brand Leaders, and Technology. Define and maintain data models to represent core objects of the business and their relationships. Help resolve inconsistencies across business units and drive standardization where possible. Maintain Data Catalog to ensure common understanding of data assets and map source data to data warehouse tables. Query, manipulate, and validate data across multiple database technologies and querying languages. Work with Project Managers to help manage stories / use cases in Jira backlog. Core Skills: 5-10 years of experience Data Requirements Analysis Data Modeling and Table Design Data Governance processes including working with Data Catalogs Accessing data in AWS Redshift using general SQL queries Managing and prioritizing multiple concurrent requests Additional Skills/Knowledge that might help: Understanding of Agile methodology and principles Experience with Talend ETL tool Experience with building Tableau reports Experience with Subscription Businesses Bachelor's Degree This position is exempt under the Fair Labor Standards Act and is not eligible for overtime pay. Pay Transparency Disclosure: The estimated base salary range for this position is $100,000 to $135,000. The final salary offering will take into account a wide range of factors, including experience, accomplishments and location. The salary range provided should not be considered as a salary limit or cap. In addition to base salary, Crain also offers competitive benefits including retirement plan savings contributions and bonus opportunities based on individual and company performance. LI-Remote LI-KL1 mid data full-time Visit Environmental Demands Where you work matters. The job posting will provide specific information on where and when your amazing work would be performed. Employee work location is determined by the needs of the specific team and may include on-site, hybrid or remote. An "in-office" role would require the employee to come into the office most days with occasional flexibility to work remotely if tasks can be performed elsewhere and if the manager approves. A "remote" role would allow an employee to work from a home office that is in one of the states Crain does business in. See list accompanying this job posting. We cannot employ a work from home employee unless they reside in one of these states. A "hybrid" role would be a mix of in-office and remote work. There may be a specified schedule for coming into the office or it could be at the discretion of the employee with the manager's approval. Many positions will also include work donein "the field." Depending on the role, this may include conducting in-person interviews, attending work-related events, meeting with sources or clients. Specifics will be noted in the job posting.Employees may be exposed to adverse environmental conditions, specifically during field work. Oth

Created: 2024-11-01