Digital Design and Visualization Lead (W2 position)

Job Title:- Digital Design and Visualization Lead

Warren MI – hybrid 3-4 days a week on site

Possible contract to hire

The Digital Design & Visualization Lead possesses a strong understanding of business intelligence development, with a focus on Power BI and Power Query. This person will work cross-functionally to support project life cycles, ad-hoc analysis, documentation, and future proofing the reporting experience.s

This is a client embedded position, at a single client site, that requires a highly consultative skill set and personality.

PRINCIPAL DUTIES & RESPONSIBILITIES:

•        Support business team in requirements gathering.

•        Work with data integration team to define and load data sources from multiple data warehouse systems.

•        Liaison between business team and IT to support projects.

•        In-source and manipulate metadata in Power Query for optimal Power BI report performance.

•        Build Power BI reports and dashboards based on requirements.

•        Build out UAT scripts and run test sessions to support “ready to go” state for reporting.

•        Ad-hoc reporting from Power BI and/or other reporting tools.

•        Document projects and new learnings for cross-collaboration among Performance-Driven Marketing team.

KNOWLEDGE, SKILLS, ABILITIES:

•        Power BI (1+ Year)

•        Power Query (1+ Year)

•        Querying SQL Server, Teradata, or Hadoop (1+ Year)

•        Software development life cycle (1+ Year)

•        Microsoft Office with a focus on Excel and Power Point (3+ Years)

•        Understanding of website and digital media analytics and digital marketing concepts such as cookies (1st & 3rd party), pixel tags, privacy standards, SEO, social media, advertising attribution methods & models

Qualifications:

•        Ability to demonstrate business intelligence development skills.

•        Ability to demonstrate database query skills.

•        Strong understanding of waterfall and agile project management concepts.

•        Automotive or comparable experience.

•        Proactive in finding solutions to support Performance-Driven Marketing initiatives.

•        Ability to deliver results in a fast-paced environment.

•        Ability to manage multiple, complex projects and deadlines.

•        Strategic and critical thinker.

•        Strong presentation, people and documentation skills