Data Analyst - Power Bi - SQL Developer

Overview

• JOB IDENTIFICATION
  
  

FUNCTION: Business Operations

JOB LEVEL: Analyst

JOB TITLE: Data Analyst - Power Bi - SQL Developer

REPORTS TO

Full line: Manager, Business Intelligence

• GENERAL JOB SUMMARY (1 paragraph overview describing the primary function and focus of this position)
  
  

Join the dynamic team at Aptean, a rapidly growing technology company boasting over 2,700 employees, a diverse range of more than 50 distinct products, and an extensive global client base. We are on the search for a dedicated Analyst to join our Marketing Operations team. This role presents an excellent opportunity to immerse yourself in the world of marketing and sales data, significantly enhancing our data reporting capabilities in a vibrant, opportunity-rich environment.

As a Marketing Operations Analyst at Aptean, your responsibilities will span a variety of tasks aimed at analyzing and reporting on marketing programs across numerous channels. A key part of your role will be leveraging Google Analytics 4 (GA4) to mine insightful data on web performance metrics, crucial for optimizing user experiences and conversion rates. Specifically, your expertise in GA4 will be vital in strategically driving our Account-Based Marketing (ABM) campaign efforts.

You will analyze campaign performance through our CRM (Salesforce) using SQL, helping to craft data-driven narratives that propel the marketing and sales teams forward. Moreover, your role will include enhancing our data infrastructure by identifying new data sources, ensuring our insights are powered by the most comprehensive and relevant data available. This also encompasses helping keep our existing reporting up-to-date and as accurate as possible.

Armed with tools like Salesforce, Marketo, Google Analytics 4, and Bizible, and applying AI strategically, you will play a crucial role in guiding our data-driven marketing strategies. If you have a strong passion for analytics, an innovative spirit, and are eager to apply your skills within a thriving tech environment, Aptean welcomes you to join our team. At Aptean, you're not just finding a job; you're becoming part of a global community leading the future of technology innovation.

• SCOPE (Describe the nature and magnitude of the impact of this positions decisions and/or actions on the division or function. Cite impact in terms of sales volume, capital expense, project scope, throughput, etc. where possible. Add categories and verbiage to fully articulate job scope and impact as needed.)
  
  

Report/Dashboard Creation and Expertise: As an Analyst in Marketing Operations, your role will be pivotal in leveraging your analytical skills and business intelligence acumen to craft and refine reports and dashboards. You will focus extensively on Google Analytics 4 (GA4), along with other core systems like Power BI, SFDC, SQL, and Bizible to draw actionable insights. Your adeptness in data modeling, reporting, and dashboarding, especially with a deep understanding of GA4 data, will be essential in delivering visualizations that cater to our strategic needs, particularly in enhancing our Account-Based Marketing (ABM) campaigns.

Routine Reporting and Strategic Analysis: Your responsibilities will include managing routine reporting with an emphasis on extracting strategic insights from GA4 to inform our ABM initiatives. You will build and implement automated solutions for weekly and monthly reports analyzing the marketing ecosystem's performance, such as funnel metrics, pipeline, and marketing program effectiveness. Your role will extend beyond routine reporting to develop data solutions and KPI tracking for all marketing and sales across the globe. By establishing and nurturing relationships with key stakeholders, you will facilitate insightful communication around reports, focusing on what information best empowers decision makers.

Ad Hoc Analysis and ABM Insight Generation: In this role, you will conduct ad hoc analyses with a strong focus on digital channels and the performance of ABM campaigns, leveraging GA4 data to provide deep insights that lead to action. This includes evaluating cost-per-lead, conversion rates, and performance against objectives. You will maintain effective communication with the Marketing Operations team to keep them informed of progress and any challenges encountered.

Data Source Integration and Interaction: You'll further enhance our data infrastructure by identifying and integrating new data sources. This function is integral to ensuring that our data pool continues to drive robust decisions across our Marketing and Sales departments. You'll interact with internal customers across functions as needed, and over time, your role will evolve to include regular communication with various stakeholders. Your efforts in expanding our data comprehensiveness will ensure that our decisions are data-driven and that our strategies align with our broader organizational goals while staying ahead of the technology curve.

• ORGANIZATION (Indicate the job positions reporting to this role)
  
  

Full line: None

Dotted line: None

• PRINCIPAL DUTIES AND RESPONSIBILITIES (List the key duties and responsibilities and essential functions of the role)
• Utilize professional expertise in business intelligence and creative problem-solving skills to generate and adjust reports and dashboards in core systems such as Power BI, SFDC, and Google Data Studio (Looker).
• Apply deep knowledge of data modeling, reporting, and internal dashboarding to ensure that visualizations and insights meet user needs.
• Identify and execute automated solutions for routine weekly and monthly reports across the entire Marketing Ecosystem, including funnel performance, pipeline, and marketing program performance.
• Develop data solutions and Key Performance Indicator (KPI) tracking measures across Sales and Marketing departments, fostering communication with key stakeholders about reporting and insights that helps improve our performance.
• Handle ad hoc requests related to digital channels and marketing programs, providing critical insights through robust data analysis, such as cost-per-lead, conversion rates, and actual versus planned performance.
• Exercise a high degree of autonomy in determining approaches to critical assignments, while maintaining strong communication with the AVP of Marketing Operations to ensure transparency on progress and issues.
• Enhance data infrastructure and expand the comprehensiveness of our data by identifying and integrating new data sources, which will ensure that our decisions across Marketing and Sales departments are data-driven and align with broader organizational strategies and goals.
• Engage and interact with internal customers across different functions as needed, with an expectation of an evolving role that includes regular communication with various stakeholders.
• JOB SPECIFICATIONS
  
  

Education (Indicate the minimum level of education necessary for this position. Check all that apply and indicate specific degree as applicable to the side (e.g., Bachelors in Computer Science)

Preferred Required

RequiredPreferred Degree/Certification

Bachelors degree (Business Administration, Finance, Economics, Computer Science, Engineering, or related field)

Masters degree (Quantitative discipline)

Ph.D.

J.D. (law)

Certification

Registration:

Licensure

Other:

Work Experience (Indicate the approximate years of relevant work experience necessary for this position)

• Minimum of 2 years of hands-on experience with Google Analytics 4 (GA4) for comprehensive tracking, analyzing, and reporting on user behavior and campaign performance. Experience working in a tech setting or rapidly growing company is a plus.
• Advanced proficiency in data visualization and reporting tools such as Power BI, Salesforce (SFDC), Bizible, acquired over at least 2 years, showcasing a strong ability to derive actionable insights from complex data sets.
• A minimum of 3 years of demonstrated expertise in data modeling and analysis, with a solid background in establishing and monitoring key performance indicators (KPIs) for marketing and sales effectiveness.
• Proven track record, with at least 3 years of experience, in automating routine reports and creating dashboards to assess marketing ecosystem performance, including funnel analytics and pipeline growth.
• At least 2 years of experience handling ad hoc analytical requests, providing deep insights into digital marketing efficiency, lead generation tactics, and conversion rate optimization.
• Strong communication and stakeholder management skills honed over at least 3 years, with a history of effectively aligning data insights with broader business objectives across sales and marketing teams.
• Experience in integrating new data sources into the marketing data infrastructure, enhancing data accuracy and decision-making capabilities across marketing and sales departments.
• Familiarity with marketing and sales CRM systems, with at least 2 years of experience leveraging these tools for efficient ABM or digital campaign tracking and performance analysis.
• A proactive and innovative problem-solving approach, with at least 3 years of experience in proposing and implementing strategies to improve marketing operations and campaign outcomes through data-driven insights.
  
  

Knowledge, Skills And Abilities

• Mastery of GA4 setup, event tracking, conversion analysis, and audience segmentation, with the ability to extract actionable insights to guide marketing strategies.
• Deep understanding of ABM principles, skilled in creating personalized campaigns for key accounts, and measuring their effectiveness using precise metrics and KPIs.
• Advanced proficiency in tools like Power BI, SFDC, and Google Data Studio, capable of crafting interactive dashboards and reports that clearly communicate complex data insights.
• Strong background in data modeling, statistical analysis, and the use of analytical software (e.g., SQL, Python, R) to uncover trends and inform decisions.
• Experience in automating report generation and dashboard maintenance to efficiently track key marketing metrics and performance indicators.
• Ability to quickly respond to ad hoc queries with robust data analysis, providing critical insights for strategic marketing decisions.
• Exceptional communication skills for articulating data insights and recommendations, coupled with the ability to work collaboratively across teams to align marketing efforts with organizational goals.
• Skilled in integrating new data sources and ensuring high data quality, enhancing the comprehensiveness of marketing data for informed decision-making.
• Proficient in using CRM systems to track and optimize ABM campaigns, with a focus on data segmentation and CRM insights for campaign personalization.
• Demonstrated ability to propose and implement innovative solutions to marketing challenges, with a keen eye for improving processes and achieving marketing efficiency.
  
  

DISCLAIMER

The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job.

If you share our mindset, you can share in our success. To find out more about joining Aptean, get in touch today.

Learn from our differences. Celebrate our diversity. Grow and succeed together.

Aptean pledges to promote a company culture where diversity, equity and inclusion are central. We are committed to applying this principle as we interact with our customers, build our teams, cultivate our leaders and shape a company in which any employee can succeed, regardless of race, color, sex, national origin, sexuality and gender identity, religion, disability, age, status as a protected veteran or any other group status protected by law. Celebrating our diverse experiences, opinions and beliefs allows us to embrace what makes us unique and to use this as an asset in bringing innovative solutions to our customer base.

At Aptean, our global and diverse employee base is our greatest asset. It is through embracing and understanding our differences that we are able to harness our individual power to maximize the success of our customers, our employees and our company. - TVN Reddy