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.
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