Customer & Marketing Data Analyst

Electrify America is a large open DC fast charging network committed to advancing electric mobility and sustainability. The contracted Customer & Marketing Data Analyst will support marketing performance reporting, dashboard development, predictive modeling, data management, and analytical projects to drive data-informed customer acquisition, growth, and optimization decisions.

Responsibilities:

• Provide automated reports on growth performance to key stakeholders
• Perform deep-dive and ad-hoc analyses on marketing initiatives, campaign performance, audience behavior, and utilization data
• Proactively monitor and track marketing KPIs (e.g., CTR, CPA, ROAS, Conversion Rates)
• Translate findings into actionable insights and optimization opportunities for stakeholders through reports and presentations
• Build analyses / models that enable decision making oriented on customer acquisition and growth
• Extract and clean data across multiple platforms (e.g., Google Analytics 4, Social Media Platforms, Salesforce Marketing Cloud, EA Utilization Data) for analysis and database storage
• Write, optimize, and document SQL queries to retrieve data from databases
• Support the development of marketing/customer tables and views in database schemas
• Build and maintain marketing reporting dashboards using BI tools (Tableau, Power BI)
• Apply visualization best practices for clarity and usability
• Conduct routine quality assurance checks to ensure data accuracy and consistency
• Work closely with marketing and sales teams to collect business requirements and documentation
• Create clear, concise reports and presentations for stakeholders to inform decision-making with data-driven recommendations
• Work cross-functionally with other analyst(s) and data engineers to support analysis and data integration

Requirements:

• 2-5 years of relevant experience
• Undergraduate degree
• Structured problem solving
• Relational database programming (SQL, Python)
• Business analysis and insights generation
• Machine learning modeling
• Statistical analysis
• Data validation
• Data visualization and presentation
• Cross-functional coordination and a consultative mindset
• Project management and scoping
• Collaborative
• Self-Starter
• Strong business sense – understand abstract business needs as well as business analysis metrics across various business areas
• Strong analytical skills - ability to collect, organize, and analyze data with attention to detail and accuracy
• Strong skills in statistical analysis, regression analysis, hypotheses testing, probability concepts, correlation analyses, and time series analyses
• Strong skills in supervised & unsupervised machine learning modeling
• Strong skills in working with cloud data warehouses such as Snowflake
• Strong skills in developing and running queries for relational databases, such as SQL
• Strong visualization and analysis tools such as Tableau, Looker, or PowerBI
• Strong skills in Python (Pandas, numpy, scikit-learn)
• Presentation skills – ability to turn data into actionable information
• Experience with Agile workflow, project scoping, timeline estimation, process documentation
• Experience with version control tools, such as Git or Bitbucket
• Knowledge of NoSQL databases and MongoDB query languages
• Experience using cloud-based data managed in AWS S3, Aurora, and DocumentDB
• Experience managing and improving cross-functional processes
• Experience with developing & maintaining data ingestion pipelines into Snowflake
• Experience with retrieving data from APIs