Data Analyst - Full Time

Job Responsibilities

The Data Analyst transforms data into insights that drive business value. This position blends hard skills like programming, data modeling and statistics with soft skills like communication, analytical thinking and problem-solving.Through use of data analytics, data visualization and data modeling techniques and technologies, the Data Analyst will identify trends that can help other departments, managers and executives make business decisions to modernize and improve processes in the organization as well as help us tell stories through the results of our many marketing campaigns.

The Data Analyst role is increasingly important as our company moves to capitalize on the volumes of data we collect. The Data Analyst will be responsible for discovering trends across marketing campaigns and identify where improvements can be made to save the client money or increase profits. This will be done by mining complex data using BI software and tools, comparing data to competitors and industry trends and creating visualizations that communicate findings to others in our company or the clients. Job responsibilities include:

• Work with IT representatives to deploy software and hardware upgrades that make it possible to leverage big data use cases.
• Review client files to ensure integrity of data collection and utilization.
• Monitor analytics and metrics results.
• Implement new data analysis methodologies.
• Create or discover new data procurement and processing programs.
• Live into the values of McKinney
• Create and present reports on data trends as requested.
• Review and validate influencer marketing and social media data as it's collected.
• Further establish benchmarks for industry and client programs.
• Develop policies and procedures for the collection and analysis of data.
• Oversee the deployment of data to the data warehouse.
• Perform data profiling to identify and understand anomalies.

Requirements

• Ethics - Treats people with respect; keeps commitments; inspires the trust of others; works with integrity and ethically; upholds organizational values.
• Dependability - Follows instructions and responds to management direction; takes responsibility for own actions; keeps commitments; commits to long hours of work when necessary to reach goals; completes tasks on time or notifies appropriate people with an alternate plan.
• Project Management - Develops project plans and completes work in a timely manner. Strives to increase productivity; works quickly.
• Written Communication - Writes clearly and informatively; edits work for spelling and grammar; varies writing style to meet needs; presents numerical data effectively; able to read and interpret written information.
• Judgment - Displays willingness to make decisions; exhibits sound and accurate judgment; supports and explains reasoning for decisions; includes appropriate people in decision-making process; makes timely decisions.
• Self Starter - Strong desire and enthusiasm to learn and come up with solutions to problems without explicit direction.
• Professionalism - Approaches others in a tactful manner; reacts well under pressure; treats others with respect and consideration regardless of their status or position; accepts responsibility for own actions; follows through on commitments.
• Motivation - Sets and achieves challenging goals; demonstrates persistence and overcomes obstacles; measures self against standard of excellence; takes calculated risks to accomplish goals.
• Analytical - Uses data and logic to form conclusions and make decisions that improve outcomes positively in alignment with campaign goals
• Adaptability - Adapts to changes in the work environment; manages competing demands; changes approach or method to best fit the situation; able to deal with frequent change, delays, or unexpected events.
• Quality Management - Demonstrates accuracy and thoroughness; looks for ways to improve and promote quality; applies feedback to improve performance; monitors own work to ensure quality.
• Organizational Support - Follows policies and procedures; completes administrative tasks correctly and on time; supports organization's goals and values; supports affirmative action and respects diversity.
• Teamwork - Balances team and individual responsibilities; gives and welcomes feedback; able to build morale and group commitments to goals and objectives.
• Planning/Organizing - Prioritizes and plans work activities; uses time efficiently; plans for additional resources; sets goals and objectives; organizes or schedules other people and their tasks; develops realistic action plans.
• Attendance/Punctuality - Ensures work responsibilities are covered when absent; arrives at meetings and appointments on time.
• Oral Communication - Speaks clearly and persuasively in positive or negative situations; listens and gets clarification; responds well to questions; demonstrates group presentation skills; participates in meetings both internally and externally to clients.

TECHNICAL SKILLS, EXPERIENCE, KNOWLEDGE AND COMPETENCIES REQUIRED::

• Google Analytics experience
• Statistical knowledge
• Cativ8 experience
• Mastery of Google Sheets and other capabilities within the Google Suite (Slides, Docs and Gmail)
• Data Visualization experience (Google Data Studio/Tableau/ Looker, etc)
• Comfortable and excited in working in ambiguity.
• Excellent time management skills and ability to prioritize multiple competing projects
• AirFlow or similar data pipelining tools
• Proven organizational skills
• A deep interest in data/analytics
• Google Tag Manager/Publisher tracking implementation
• Advanced Microsoft Excel Proficiency (Vlookup, Sumif, etc)
• Basic stats required
• Basic SQL skills
• Bigquery/Google cloud analytics experience
• Critical thinking skills; both strategic and analytical
• Attention to detail and a strong eye for quality assurance
• BONUS POINTS
• Python analytics stack (Python, numpy, pandas, Jupyter notebooks)
• Ability to learn and explore new and unfamiliar tools proactively.
• Familiarity of social media and influencer marketing
• Git/Source Control
• Experimental knowledge (basic)
• Basic HTML/Javascript
• Basic data modeling proficiency (Basic Joins, best practices)