Job Description
Madison Trust / Broad Financial is an integrated, rapidly growing, Bergen County based Financial Services group comprised of a chartered trust company, an IRA services specialty group, multiple alternative investment fund affiliates, and a real estate group.
We're rated one of New Jersey's best places to work and maintain a superb and upbeat work culture!
We are currently seeking a Paid Marketing Data Analyst with expertise in Power BI and Google Analytics. In this data-driven role, you will leverage these tools to analyze and optimize our PPC campaigns. Your ability to transform complex data into easily digestible data visualization will directly impact the effectiveness of our marketing strategies.
Description:
- Leveraging Power BI to transform raw data across multiple sources, such as Salesforce and Google Analytics (both via AWS Redshift), into relevant insights via interactive dashboards and customized visual reports.
- Working across departmental teams to understand and assess key performance indicators
- Developing accurate visual dashboards with near up-to-date results to aid in decision-making
- Create, test, and deploy Power BI scripts, queries, or functions that collect relevant raw data across multiple sources
- Assess current Power BI data accuracy and execute technical adjustments to improve dashboard relevancy
Requirements:
- An upbeat and can-do attitude is essential!
- Prior experience with Microsoft Power BI
- Strong analytic background with data and other software, including AWS Redshift, Tableau, Salesforce, Google Analytics, MS SQL, etc.
- Strong understanding of how to write, test, and deploy scripts and queries
- Understanding of database (and data warehousing) fundamentals and best practices