Marketing Analyst Summary PenFed is hiring a Marketing Analyst in our McLean, Virginia headquarters. The primary purpose of this job is to evaluate and report on marketing initiatives and media campaign performance to help drive brand and product growth. The Marketing Analyst will work closely with the brand management team to deliver insights to the business units, to help make predictions and plan spend. Essential Functions Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. This is not intended to be an all-inclusive list of job duties and the position will perform other duties as assigned. Perform statistical analysis techniques and models to discover insights, make predictions, and optimize campaigns. Analyze online and offline consumer behavior, demographic data, creating digital tracking codes, normalizing and transforming data. Creates and maintain regularly scheduled reports and dashboards, and finding the story in the performance data and making recommendations to brand, product and cross-functional teams. Understands brand and each business unit objectives to be proactive in recommending additional types of analysis. Diagnose and report on campaign trends to brand managers and product owners. Work closely with product analytic teams to analyze marketing spend and performance and how it translates to business performance and goals. Collaborate with brand, digital, CRM, data management and UX teams to structure raw data into database tables to be used with visualization software (such as Tableau and excel) and SQL queries. Retrieve and schedule data feeds from multiple campaign sources including Adobe Analytics, Salesforce Marketing Cloud, DoubleClick, Google AdWords, Bing Ads, Facebook, etc. Identify implementation issues or gaps in tagging/tracking for various web analytics platforms (Google Analytics, Adobe Analytics). Maintain and update regular weekly and monthly reports for brand and product teams. Complete ad hoc queries and questions from brand, digital and analytics team. Education and Experience Equivalent combination of education and experience is considered. Bachelor's Degree in Marketing, Media, Statistics, Mathematics, Information Systems, etc. required. MBA or Master's Degree preferred. Minimum of five (5) years' experience in marketing or media analytics role. Ability to use data to tell the campaign performance story for any type of marketing campaign and present in a visual, clear manner. Experience tracking key performance indicators. Knowledge of Data Visualization best practices, experience using data visualization software like Tableau and Excel. Experience with database and data warehouse structure including SQL queries. Skilled in data manipulation and reporting in excel (vlookups, if statements, pivot tables, pivot charts). Excellent communication and presentation skills, with ability to convey complex ideas in an understandable way. Experience with Business Intelligence processes and tools. Ability to work in a fast-paced environment while maintaining strong attention to detail. Ability to accomplish a task with knowledge of the end goal but with little direction on how to achieve it (self-directed, creative problem solver). Supervisory Responsibility This position will not supervise employees. Licenses and Certifications There are no additional licenses and/or certifications required. Work Environment While performing the duties of this job, the employee is regularly exposed to an indoor office setting with moderate noise. *Most roles require working in an office setting with moderate noise and the ability to lift 25 pounds.* Travel Ability to travel to various worksites and be on-call is required. About Us Established in 1935, PenFed today is one of the country's strongest and most stable financial institutions with over 1.6 million members and over $23 billion in assets. We serve members in all 50 states and the District of Columbia, as well as in Guam, Puerto Rico, Okinawa, and Portugal. We are federally insured by NCUA and we are an Equal Housing Lender. We are available to members worldwide, via the web, seven days a week, twenty-four hours a day. Our mission isn't simply to help our members get by. We exist to help them realize every ounce of their potential. We exist to educate, and to encourage. We exist to usher their dreams into the land of reality. We provide our employees with a lucrative benefits package including robust medical, dental and vision plan options, plenty of paid time off, 401k with employer match, on-site fitness facilities at our larger locations, and more. Equal Employment Opportunity PenFed management will maintain and observe personnel policies which will not discriminate or permit harassment or retaliation against a person because of race, color, creed, age, sex, gender, gender identity, gender expression, religion, national origin, ancestry, marital status, military or veteran status or obligation, the presence of a physical and/or mental disability or medical condition, genetic information, sexual orientation, and all statuses protected by applicable state or local law in all recruiting, hiring, training, compensation, overtime, position classifications, work assignments, facilities, promotions, transfers, employee treatment, and in all other terms and conditions of employment. PenFed will also prohibit retaliation against individuals for raising a complaint of discrimination or harassment or participating in an investigation of same. PenFed will also reasonably accommodate qualified individuals with a disability so that they can apply for a job or perform the essential functions of a job unless doing so causes a direct threat to these individuals or others in the workplace and the threat cannot be eliminated by reasonable accommodation or if the accommodation creates an undue hardship to PenFed. Contact human resources (HR) with any questions or requests for accommodation at 571-289-4710.