BI Analyst or Senior Analyst
Boston, MA
Summary:
As an internal Data and Analytics Specialist, you will extract, manipulate, organize, and report data from various sources within CFGI’s ecosystem. These systems currently include NetSuite (ERP), Salesforce (CRM), Pardot (Marketing Automation), and Oracle (EPM). This role requires an understanding of data structures, analytical skills, and proficiency in software tools such as Microsoft Excel and Microsoft PowerBI. Key Responsibilities:
· Extract data from NetSuite, Salesforce, Oracle, and other relevant sources using SQL queries, APIs, or other data extraction tools.· Clean, transform, and manipulate raw data to ensure accuracy, consistency, and reliability. Perform data validation and quality assurance checks.· Organize and structure data in a logical and coherent manner to facilitate analysis and reporting. Develop data models, hierarchies, and taxonomies to streamline data storage and retrieval processes.· Analyze and present data to uncover trends, patterns, and insights that inform business decision-making.· Generate recurring and ad-hoc reports and dashboards to communicate key performance metrics and insights across various levels of CFGI. Customize reports to meet the specific needs and preferences of different departments or teams.· Stay informed of emerging trends, technologies, and best practices in data analytics and reporting. Identify opportunities for process improvement, automation, and optimization to enhance the efficiency and effectiveness at CFGI. Qualifications:
· Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, or a related field.· Three to five years of experience in data analysis, reporting, and visualization.· Proficiency in SQL for data extraction and manipulation.· Strong analytical and problem-solving skills and attention to detail.· Proficiency in Microsoft Excel, including pivot tables, formulas, and macros.· Proficiency with data visualization tools such as Microsoft PowerBI.· Familiarity with data extraction from ERP systems (e.g., Netsuite), CRM systems (e.g., Salesforce), and EPM systems (e.g., Oracle).· Excellent communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams and communicate complex technical concepts in non-technical language.· Strong organizational skills with the ability to manage multiple priorities and meet deadlines in a fast-paced environment.
As an internal Data and Analytics Specialist, you will extract, manipulate, organize, and report data from various sources within CFGI’s ecosystem. These systems currently include NetSuite (ERP), Salesforce (CRM), Pardot (Marketing Automation), and Oracle (EPM). This role requires an understanding of data structures, analytical skills, and proficiency in software tools such as Microsoft Excel and Microsoft PowerBI. Key Responsibilities:
· Extract data from NetSuite, Salesforce, Oracle, and other relevant sources using SQL queries, APIs, or other data extraction tools.· Clean, transform, and manipulate raw data to ensure accuracy, consistency, and reliability. Perform data validation and quality assurance checks.· Organize and structure data in a logical and coherent manner to facilitate analysis and reporting. Develop data models, hierarchies, and taxonomies to streamline data storage and retrieval processes.· Analyze and present data to uncover trends, patterns, and insights that inform business decision-making.· Generate recurring and ad-hoc reports and dashboards to communicate key performance metrics and insights across various levels of CFGI. Customize reports to meet the specific needs and preferences of different departments or teams.· Stay informed of emerging trends, technologies, and best practices in data analytics and reporting. Identify opportunities for process improvement, automation, and optimization to enhance the efficiency and effectiveness at CFGI. Qualifications:
· Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, or a related field.· Three to five years of experience in data analysis, reporting, and visualization.· Proficiency in SQL for data extraction and manipulation.· Strong analytical and problem-solving skills and attention to detail.· Proficiency in Microsoft Excel, including pivot tables, formulas, and macros.· Proficiency with data visualization tools such as Microsoft PowerBI.· Familiarity with data extraction from ERP systems (e.g., Netsuite), CRM systems (e.g., Salesforce), and EPM systems (e.g., Oracle).· Excellent communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams and communicate complex technical concepts in non-technical language.· Strong organizational skills with the ability to manage multiple priorities and meet deadlines in a fast-paced environment.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Computer Science Data analysis Data Analytics Data visualization Excel Mathematics Oracle Power BI Salesforce SQL Statistics
Region:
North America
Country:
United States
Job stats:
9
4
0
Categories:
Analyst Jobs
Big Data Jobs
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Data Engineer II jobs
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Product Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Data Product Manager jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open PhD-related jobs
- Open Finance-related jobs
- Open NLP-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open Consulting-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Snowflake-related jobs
- Open Hadoop-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open DevOps-related jobs