MRM//McCann Analyst, Global Reporting Operations, MRM//McCann in Birmingham, Michigan
location / Birmingham, Michigan
date posted / 10/09/2017
job description / Analyst, Global Reporting Operations, MRM//McCann
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.
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.