Data Analyst

Description To be considered for this position applicants must be authorized to work for ANY employer in the U.S. We are unable to support any kind of sponsorship or take over sponsorship of an employment visa at this time. Crain is looking for a Data Analyst to join our team. The Data & Analytics team supports all the Crain brands with actionable intelligence that helps drive revenue. The team supports brands like AdAge, Automotive News, and Crain’s Chicago—among others. Data is the lifeblood of our business. It helps ensure we’re tracking towards our goals and is the foundation of our decision making. As a data analyst, you’ll be a steward for our data so we can extract actionable insights and drive the business forward. As we continue to evolve the data and analytics role at Crain, we are in the process of building a data warehouse to allow for deeper analyses and more sophisticated reporting. We’re looking for someone that’s excited to be a part of this new evolution in data and analysis here at Crain. The perfect candidate will be able to analyze data and discuss that analysis in a concise, impactful way to ensure it's well received and implemented. Join a team that’s constantly identifying ways to leverage our best-in-class content to continue the expansion of our fast-growing subscription business. Responsibilities Develop ad hoc reports, dashboards & visualizations from multiple data sources to support business operations using Tableau and Excel Ensure clear definition of reporting and data requests before beginning implementation Analyze trends to identify experiments for our optimization team Help drive a data-first culture that builds data literacy and curiosity throughout the company Assist in the advancement of data governance principles and initiatives with various stakeholders Be a thought partner for all matters related to data and overall strategy for those brands Troubleshoot and analyze reporting and data warehouse issues' root causes Requirements 5 years experience in analyzing data and communicating insights in a clear, concise way without sounding like a robot Experience creating dashboards in Tableau Must be fluent in Microsoft Excel Familiarity with a subscription-model business (traffic, conversion rate, churn, etc.) is a plus Stellar written and verbal communication skills Ability to tell the story in a clear, compelling way Exceptional attention to detail Experience working with a centralized data warehouse, including data mining and extraction Basic SQL skills; experience with Postgres (PostgreSQL) preferred Exposure or working knowledge of Alteryx is a plus Experience manipulating data; joining multiple sourced data, basic “cleaning” of data, creating metrics from multiple fields, etc. Ability to manage multiple priorities Experience with a “consultative” approach and drawing from the fact that you are the data subject matter expert Ability and desire to be proactive with data insights Ideal candidate would get excited about data and technology 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 $50,000-$80,000. The final salary offering will take into account a wide range of specific and relevant 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. #data #LI-Remote #LI-KL1 #associate #full-time Visit 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) Crain is one of the largest privately-owned business media companies with more than 20 leading business, trade and consumer brands in North America, Europe and Asia. Crain’s uncompromising journalists, industry experts and business insiders share one vision: to produce stories, communities and platforms that empower our audiences’ success. Our Brands Ad Age Automotive News Automotive News Europe Automotive News Canada Automotive News China Automobilwoche Crain’s Chicago Business Crain’s Cleveland Business Crain’s Detroit Business Crain’s New York Business Creativity European Rubber Journal GenomeWeb Modern Healthcare Pensions & Investments Plastics News Plastics News China Rubber & Plastics News Staffing Industry Analysts Sustainable Plastics Tire Business Urethanes Technology International Reasonable Accommodation Notice Federal law requires employers to provide reasonable accommodation to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job or to perform your job by emailing Careers@Crain.com.