MRM//McCann Analyst, Global Reporting Operations, MRM//McCann in Birmingham, Michigan

Job Details/

location / Birmingham, Michigan

date posted / 10/09/2017

job description / Analyst, Global Reporting Operations, MRM//McCann

Core Duties/Responsibilities

About the Role:

The Reporting Analyst role will be responsible for executing a wide variety of visualization & database focused development and automation activities in support of a variety of analysts and strategists. In this role, the analyst will also have exposure to a wide variety of data analysis and Business Intelligence tools such as Oracle, SQL Server, Teradata, Tableau and Cognos and will be expected to apply these tools when opportunities arise.

Responsibilities:

  • Serve a multitude of functions including but not limited to: data extractions, file creation, data analysis, data architecture, report/dashboard design/creation

  • Consult and guide team members with database analysis and data management questions

  • Run exception reports and provide results to clients, vendors and peers

  • Research data discrepancies in source enterprise databases and 3rd party data providers

  • Gather data requirements for reports/dashboards, proof-of-concepts for larger enterprise-wide BI initiatives

  • Construct and execute SQL queries based on business needs

  • Execute existing jobs, update dashboards and reports based on a set schedule

  • Develop methodologies for aggregating results from various reporting suites and data environments

  • Confirm data integrity

  • Reconcile disjointed data sources

  • Work with clients and partners to gather data and reporting requirements

  • Continuously look for improvements, monitor quality levels, and manage quality problems

Education and Experience

Highly accountable self-starter with the ability to work well within a group, as well as independently

Bachelor degree in Computer Science, Mathematics, Information Technology preferred

  • Experience in on boarding data and visualizing it within Tableau

  • Must have strong communication skills, both verbal and written

  • Must demonstrate strong analytical skills

  • Intermediate experience with SQL

  • Must be able to handle multiple clients and projects simultaneously.

  • Must be proficient in MS Excel. Advanced Excel skills a plus.

Any physical demands listed are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

NO THIRD PARTY RESUMES ACCEPTED.

MRM//McCann is an EEO/AA employer and does not discriminate on the basis of race, color, religion, creed, gender, sexual orientation, age, gender identity, marital status, citizenship, disability, genetic information or veteran status or any other basis prohibited by applicable federal, state, or local law. MRM//McCann participates in e-Verify.

If you require reasonable accommodation for any part of the application or hiring process, please submit your request through one of the following methods listed below:

  • a) Dedicated Fax - 917-661-6310

  • b) Dedicated E-mail – Careers@mwgdetroit.com

  • c) US Mail – ATTN: Human Resources, 360 W. Maple Birmingham, MI 48009

  • d) Dedicated Phone – 248-203-8000

NOTE: Disability accommodation requests only.

Required Skills/Knowledge/Experience