Lead Power BI Developer - Peterson Technology Partners

Job Description

This position will be responsible for tracking digital communications to all constituents within the digital (email, web, social, etc.) ecosystem, providing performance reports and analysis on all email/direct mail appeals, websites, online giving, cross-channel communications, as well as all other aspects of the digital communications systems, with the goal of increasing digital effectiveness and engagement. This position will also be the main point of contact for all IT digital analysis / reporting needs and will work directly with the Product Team for report prioritization, design, and development.

Data Collection and Preparation:

• Gathers data from various sources, both internal and external.
• Cleans, validates, and transforms data to ensure its accuracy and consistency.
• Collaborates with the Development Team, data analytics vendors and the Sr. Enterprise Architect on maintaining enterprise data sources, datasets and the Datalake.
• Supports and collaborates with the Development Services Team on email marketing efforts, reporting, Key Performance Indicators (KPIs), constituent engagement, and measures the success of a digital marketing campaign.

Data Analysis:

• Conducts thorough data analysis to identify trends, patterns, and insights.
• Builds predictive and prescriptive models to support decision-making.
• Provides ongoing analysis to track progress and identify areas for optimization.
• Monitors the performance of key metrics and KPIs.
• Translates data insights into actionable recommendations to improve the success of our email campaigns and other digital communications.
• Collaborates with cross-functional teams to implement data-driven strategies.
• Provides support to third-party vendors for data needs.

Data Visualization:

• Creates visually appealing and informative reports, dashboards, and data visualizations.
• Communicates data findings to non-technical stakeholders in a clear and understandable manner.
• Collaborates with cross-functional teams to tailor reports to specific needs.

Data Quality Assurance:

• Establishes and enforces data quality standards and best practices.
• Identifies and resolves data quality issues as they arise.

Documentation:

• Maintains clear and organized documentation of data sources, methodologies, and analysis results.
• Develops and maintains enterprise-wide report template and Reports Catalog. 

• Leads reporting design and development efforts, in collaboration with the Director for Solutions Advancement and the Sr. Enterprise Architect. Offers technical guidance to the Report Developer III.
• Manages weekly email marketing efforts for the Frontend Developer team to ensure emails are sent according to the marketing calendar. Works closely with the Digital Marketing Manager in Development Services.
• Assists the email marketing team with scheduling emails through BBIS and Engaging Networks.
• Other duties as required. 

Requirements

• 5+ years of experience in a related field. Bachelor's degree in a relevant field (e.g., Data Science, Statistics, Computer Science) or equivalent combination of education and experience as a Data Analyst or similar role. 2+ years of supervisory experience. 
• Strong analytical and problem-solving skills.
• Experience in Agile methodology, with the relevant tools, such as Azure DevOps or JIRA.
• Preferred experience in data analysis tools and software (e.g., Python, R, Excel).
• Preferred experience with Snowflake and/or Sql server, creating complex queries.
• Preferred experience creating reports in PowerBI or SSRS. 
• Knowledge of Workday, Blackbaud products, and Engaging Networks is a plus.
• Effective communication skills to convey complex findings in a clear and understandable manner.
• Ability to estimate and prioritize tasks, meet deadlines, and work well under pressure.
• Attention to detail and a commitment to data accuracy.
• Ability to work independently and in a team.
• Strong interpersonal skills, team player with ability to work independently and efficiently.
• Stay up to date on emerging technologies. Experience with Microsoft Office suite of products.
• Appreciation for the mission, vision, and values. 
• Commitment to diversity, equity, inclusion, and anti-racism.