Marketing Consultant - Offshore

1. Experienced in Big Query Data 2to3years experience.
   
1. Technical Skills: Proficiency in SQL and experience with Google Big Query or other data warehousing technologies.
   
2. Data Modeling: Understanding of data modeling concepts and experience in designing data schemas and structures.
   
3. Programming Skills: Knowledge of programming languages such as Python Java or JavaScript for scripting and automation tasks.
   
4. Analytical Skills: Strong analytical and problemsolving skills for interpreting data identifying patterns and deriving insights.
   
5. Communication Skills: Excellent verbal and written communication skills for collaborating with crossfunctional teams and presenting findings to stakeholders.
   
6. Attention to Detail: Ability to work with large datasets and ensure accuracy and integrity of data analysis results.
   
7. Querying Data: Writing SQL queries to extract transform and analyze data stored in Big Query.
   
8. Data Loading: Loading data into Big Query from various sources such as Google Cloud Storage Cloud Storage or streaming data sources.
   
9. Data Exporting: Exporting data from Big Query to external storage or services.
   
10. Data Transformation: Transforming data using SQL or other tools to meet business requirements.
    
11. Performance Tuning: Optimizing SQL queries and data processing pipelines for better performance and efficiency.
    

1. Experienced in Google Analytics 2 to 3years experience.
   
1. Data Analysis: Analyzing data collected through Google Analytics to identify trends patterns and insights. Generating reports and dashboards to present findings to stakeholders.
   
2. Optimization: Using data insights to optimize website and marketing performance. Conducting A/B tests and multivariate tests to improve conversion rates and user experience.
   
3. Training and Support: Providing training and support to team members on how to use Google Analytics effectively. Answering questions and troubleshooting issues related to data tracking and reporting.
   
4. Integration: Integrating Google Analytics with other tools and platforms such as Google Ads Google Tag Manager and CRM systems to streamline data collection and analysis.
   
5. Continuous Improvement: Staying updated on new features and best practices in Google Analytics. Making recommendations for improvements to tracking setup reporting processes and data analysis techniques.
   
6. Data Governance: Ensuring data accuracy consistency and compliance with privacy regulations such as GDPR and CCPA. Implementing data governance policies and procedures to maintain data integrity.
   

1. Knowledge/Experience on below applications will be added advantage.
   
1. SAP Emarsys
   
2. Bloomreach
   
3. SAP CDP
   

Experienced in Big Query Data 2-to-3-years experience. Technical Skills: Proficiency in SQL and experience with Google Big Query or other data warehousing technologies. Data Modeling: Understanding of data modeling concepts and experience in designing data schemas and structures. Programming Skills: Knowledge of programming languages such as Python, Java, or JavaScript for scripting and automation tasks. Analytical Skills: Strong analytical and problem-solving skills for interpreting data, identifying patterns, and deriving insights. Communication Skills: Excellent verbal and written communication skills for collaborating with cross-functional teams and presenting findings to stakeholders. Attention to Detail: Ability to work with large datasets and ensure accuracy and integrity of data analysis results. Querying Data: Writing SQL queries to extract, transform, and analyze data stored in Big Query. Data Loading: Loading data into Big Query from various sources such as Google Cloud Storage, Cloud Storage, or streaming data sources. Data Exporting: Exporting data from Big Query to external storage or services. Data Transformation: Transforming data using SQL or other tools to meet business requirements. Performance Tuning: Optimizing SQL queries and data processing pipelines for better performance and efficiency. Experienced in Google Analytics 2 to 3-years experience. Data Analysis: Analyzing data collected through Google Analytics to identify trends, patterns, and insights. Generating reports and dashboards to present findings to stakeholders. Optimization: Using data insights to optimize website and marketing performance. Conducting A/B tests and multivariate tests to improve conversion rates and user experience. Training and Support: Providing training and support to team members on how to use Google Analytics effectively. Answering questions and troubleshooting issues related to data tracking and reporting. Integration: Integrating Google Analytics with other tools and platforms such as Google Ads, Google Tag Manager, and CRM systems to streamline data collection and analysis. Continuous Improvement: Staying updated on new features and best practices in Google Analytics. Making recommendations for improvements to tracking setup, reporting processes, and data analysis techniques. Data Governance: Ensuring data accuracy, consistency, and compliance with privacy regulations such as GDPR and CCPA. Implementing data governance policies and procedures to maintain data integrity. Knowledge/Experience on below applications will be added advantage. SAP Emarsys Bloomreach SAP CDP