Senior Data Analyst

, IL, United States

Description As a Senior Data 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.#mid#data#full-timeVisit us at www.Crain.com@CrainComm 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 done in “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. Other typical job functions are performed under conditions such as those found in general office work.Travel to cover news stories/events, meetings with clients, and to our geographically separated offices may be required. It is the nature of many positions to experience non-standard working hours and be on-call when needed for responding to email, meeting with clients, attending work-related events, story development or breaking news. Most employees perform work Monday through Friday, although early-morning, evening or weekend shifts may be required. Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of many Crain jobs.Physical activities will include frequent in-person or virtual interactions. For most positions, it is essential to be able to remain at a desk/computer workstation for prolonged periods, perform computer-related tasks, and create/maintain documents within filing systems. Must have close visual acuity to perform an activity, such as preparing and analyzing reports and information, transcribing, viewing a computer terminal, or extensive reading. The typical physical requirements are light work—exerting up to 25lbs of force occasionally and/or up to 10lbs of force frequently and may include climbing, pushing, standing, hearing, walking, reaching, grasping, kneeling, stooping, and repetitive motion. Some positions will have additional physical requirements, including exerting up to 50lbs of force to move and/or carry equipment, supplies, files, or other materials as the role requires.Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions and meet the environmental and physical demands of the role. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)

#J-18808-Ljbffr