Business Analyst III
ReaderLink · Oak Brook, IL · 3 wk ago
Analyst$80k–$96k/yrFull-time
We need to output HTML fragment with sections: About the role? The description includes "Description" then "What You Will Be Doing:" repeated. We need to extract sections: maybe "About the role" from description paragraph. Then "Responsibilities" from bullet list of duties. Then "Requirements" from qualifications. Also "Skills" maybe from list of skills. Benefits and Pay are present: Salary range and benefits list. Schedule not present, so omit. Also need to avoid duplicate sections.
We must preserve all substantive info, not invent. Use for each section heading. Use
for each section heading. Use - for any list of duties/requirements/benefits. Use
for prose.
We need to remove boilerplate: EEO, accommodation, duplicated lines.
We need to include only sections with real content.
Let's parse content:
Description paragraph: "The Business Analyst III partners with departments across the organization to integrate data from multiple sources, develop analytical solutions, and deliver actionable insights that support data-driven decision-making. This role is responsible for defining, developing, and maintaining key performance indicators, leading analytical initiatives, presenting findings and recommendations to stakeholders, and supporting enterprise-wide projects that improve operational and business performance."
That's about the role.
Then "What You Will Be Doing:" appears twice, but content after first includes list of duties/responsibilities. After second appears qualifications list.
Let's extract duties/responsibilities (first occurrence after first "What You Will Be Doing:"): It includes many sentences, many bullet-like statements but not formatted as list. We need to turn into
- items. We must preserve all substantive info; we can split each sentence into list items.
List items from first block:
- Strong analytical skills with ability to explore data, draw conclusions, and develop recommendations.
- Define and present business metrics to Stakeholders.
- Define, develop, and maintain key performance indicators that support business objectives
- Build analytical story from data points
- Ability to prepare comprehensive reports accurately, and present complex ideas clearly and concisely.
- Design and architect advanced data visualizations using various BI tools.
- Design, develop, and support Power BI dashboards and reporting solutions
- Create user-friendly self-service analytics experiences for business users
- Develop and maintain data models, hierarchies, and relationships to support enterprise reporting.
- Perform ad hoc analysis with large data sets to call out and present key actionable insights.
- Discover and communicate actionable patterns and trends.
- Ability to work with transactional level data and create relationships and hierarchies.
- Highlight exceptions and recommend actionable next steps.
- Communicate effectively with internal departments to gather requirements and provide status updates.
- Communicate project status, risks, findings, and recommendations to SMEs and stakeholders.
- Help guide understanding and knowledge of complicated data sets.
- Support post-implementation of self-service analytics.
- Ability to manage multiple projects and adjust quickly to changing business needs.
- Retain business requirements and remain adaptive, utilizing various analytical approaches.
- Produce project documentation and present business user summarizations.
- Ability to work well in team environment and develop close relationships with all areas of the business.
- Possess collaborative work style, while partnering with cross-functional teams.
- Provides analytical leadership on complex business problems while partnering with stakeholders across the enterprise
- Other duties may be assigned, directed, or requested.
We need to ensure no duplication.
Second "What You Will Be Doing:" actually contains qualifications: "Bachelor’s degree in business, analytics, information systems, supply chain, or a related field is required. Four (4) years of experience in business analytics, business intelligence, data analytics is preferred.Experience with Databricks and cloud-based data platforms is preferred.Experience with ERP systems such as Microsoft Dynamics 365 is preferred.Supply chain, logistics, distribution, or inventory analytics experience is preferred. Knowledge of data warehousing and dimensional modeling concepts is preferred. Proficiency in Power BI, Power Query, and SQL is preferred.Knowledge of enterprise reporting and analysis tools.Problem solving skills with ability to think creatively.Team oriented, hardworking, open-minded, and flexible.Strong presentation, communication, and stakeholder management skills.Ability to multi-task and manager multiple projects effectively. Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required,Must have excellent communication skills, both written and verbal.Ability to speak with all levels of the organization and outside partners.Ability to communicate complicated information to others. Must be proficient in basic mathematics: addition, subtraction, multiplication, and division.Ability to do algebra, calculate figures and amounts and apply concepts such as fractions, percentages, ratios, and proportions to practical situations. Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.A methodical and organized approach to problem-solving.The work performed is in an office environment.The noise level in the work environment is usually moderate at low decibels.Must be able to work in a fast-paced, team environment."
We need to separate into Requirements (education, experience) and Skills perhaps.
We can create sections: About the role (description paragraph), Responsibilities (duties list), Requirements (education + experience), Skills (technical and soft skills), Benefits (benefits list), Pay (salary range). Ensure we don't create sections with placeholder.
Now extract Requirements:
- Bachelor’s degree in business, analytics, information systems, supply chain, or a related field is required.
- Four (4) years of experience in business analytics, business intelligence, data analytics is preferred.
- Experience with Databricks and cloud-based data platforms is preferred.
- Experience with ERP systems such as Microsoft Dynamics 365 is preferred.
- Supply chain, logistics, distribution, or inventory analytics experience is preferred.
- Knowledge of data warehousing and dimensional modeling concepts is preferred.
These are requirements/qualifications.
Skills: The rest: Proficiency in Power BI, Power Query, and SQL is preferred. Knowledge of enterprise reporting and analysis tools. Problem solving skills with ability to think creatively. Team oriented, hardworking, open-minded, and flexible. Strong presentation, communication, and stakeholder management skills. Ability to multi-task and manage multiple projects effectively. Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required. Must have excellent communication skills, both written and verbal. Ability to speak with all levels of the organization and outside partners. Ability to communicate complicated information to others. Must be proficient in basic mathematics: addition, subtraction, multiplication, and division. Ability to do algebra, calculate figures and amounts and apply concepts such as fractions, percentages, ratios, and proportions to practical situations. Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. A methodical and organized approach to problem-solving. The work performed is in an office environment. The noise level in the work environment is usually moderate at low decibels. Must be able to work in a fast-paced, team environment.
Some of these are more like work environment; but we can include as skills or general notes. Might be better to put them under Skills.
Benefits list: "Employee Benefits Include But Are Not Limited To: Health Plans - Medical, Dental & Prescription Flexible Spending Accounts - Health & Dependent Care Life and Accident Insurance Vacation Pay & Paid Holidays 401(k) with Company Match"
We need to turn into list.
Pay: Salary: $80,000.00 - $96,000.00
Now produce HTML.
We must not repeat job title as heading. No markdown.
We'll output something like:
About the role
The Business Analyst III partners with departments across the organization to integrate data from multiple sources, develop analytical solutions, and deliver actionable insights that support data-driven decision-making. This role is responsible for defining, developing, and maintaining key performance indicators, leading analytical initiatives, presenting findings and recommendations to stakeholders, and supporting enterprise-wide projects that improve operational and business performance.
Responsibilities
- Strong analytical skills with ability to explore data, draw conclusions, and develop recommendations.
- Define and present business metrics to Stakeholders.
- Define, develop, and maintain key performance indicators that support business objectives
- Build analytical story from data points
- Ability to prepare comprehensive reports accurately, and present complex ideas clearly and concisely.
- Design and architect advanced data visualizations using various BI tools.
- Design, develop, and support Power BI dashboards and reporting solutions
- Create user-friendly self-service analytics experiences for business users
- Develop and maintain data models, hierarchies, and relationships to support enterprise reporting.
- Perform ad hoc analysis with large data sets to call out and present key actionable insights.
- Discover and communicate actionable patterns and trends.
- Ability to work with transactional level data and create relationships and hierarchies.
- Highlight exceptions and recommend actionable next steps.
- Communicate effectively with internal departments to gather requirements and provide status updates.
- Communicate project status, risks, findings, and recommendations to SMEs and stakeholders.
- Help guide understanding and knowledge of complicated data sets.
- Support post-implementation of self-service analytics.
- Ability to manage multiple projects and adjust quickly to changing business needs.
- Retain business requirements and remain adaptive, utilizing various analytical approaches.
- Produce project documentation and present business user summarizations.
- Ability to work well in team environment and develop close relationships with all areas of the business.
- Possess collaborative work style, while partnering with cross-functional teams.
- Provides analytical leadership on complex business problems while partnering with stakeholders across the enterprise
- Other duties may be assigned, directed, or requested.
Requirements
- Bachelor’s degree in business, analytics, information systems, supply chain, or a related field is required.
- Four (4) years of experience in business analytics, business intelligence, data analytics is preferred.
- Experience with Databricks and cloud-based data platforms is preferred.
- Experience with ERP systems such as Microsoft Dynamics 365 is preferred.
- Supply chain, logistics, distribution, or inventory analytics experience is preferred.
- Knowledge of data warehousing and dimensional modeling concepts is preferred.
Skills
- Proficiency in Power BI, Power Query, and SQL is preferred.
- Knowledge of enterprise reporting and analysis tools.
- Problem solving skills with ability to think creatively.
- Team oriented, hardworking, open-minded, and flexible.
- Strong presentation, communication, and stakeholder management skills.
- Ability to multi-task and manage multiple projects effectively.
- Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required.
- Must have excellent communication skills, both written and verbal.
- Ability to speak with all levels of the organization and outside partners.
- Ability to communicate complicated information to others.
- Must be proficient in basic mathematics: addition, subtraction, multiplication, and division.
- Ability to do algebra, calculate figures and amounts and apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
- Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.
- A methodical and organized approach to problem-solving.
- The work performed is in an office environment.
- The noise level in the work environment is usually moderate at low decibels.
- Must be able to work in a fast-paced, team environment.
Benefits
- Health Plans - Medical, Dental & Prescription
- Flexible Spending Accounts - Health & Dependent Care
for prose. We need to remove boilerplate: EEO, accommodation, duplicated lines. We need to include only sections with real content. Let's parse content: Description paragraph: "The Business Analyst III partners with departments across the organization to integrate data from multiple sources, develop analytical solutions, and deliver actionable insights that support data-driven decision-making. This role is responsible for defining, developing, and maintaining key performance indicators, leading analytical initiatives, presenting findings and recommendations to stakeholders, and supporting enterprise-wide projects that improve operational and business performance." That's about the role. Then "What You Will Be Doing:" appears twice, but content after first includes list of duties/responsibilities. After second appears qualifications list. Let's extract duties/responsibilities (first occurrence after first "What You Will Be Doing:"): It includes many sentences, many bullet-like statements but not formatted as list. We need to turn into
- items. We must preserve all substantive info; we can split each sentence into list items.
List items from first block:
- Strong analytical skills with ability to explore data, draw conclusions, and develop recommendations.
- Define and present business metrics to Stakeholders.
- Define, develop, and maintain key performance indicators that support business objectives
- Build analytical story from data points
- Ability to prepare comprehensive reports accurately, and present complex ideas clearly and concisely.
- Design and architect advanced data visualizations using various BI tools.
- Design, develop, and support Power BI dashboards and reporting solutions
- Create user-friendly self-service analytics experiences for business users
- Develop and maintain data models, hierarchies, and relationships to support enterprise reporting.
- Perform ad hoc analysis with large data sets to call out and present key actionable insights.
- Discover and communicate actionable patterns and trends.
- Ability to work with transactional level data and create relationships and hierarchies.
- Highlight exceptions and recommend actionable next steps.
- Communicate effectively with internal departments to gather requirements and provide status updates.
- Communicate project status, risks, findings, and recommendations to SMEs and stakeholders.
- Help guide understanding and knowledge of complicated data sets.
- Support post-implementation of self-service analytics.
- Ability to manage multiple projects and adjust quickly to changing business needs.
- Retain business requirements and remain adaptive, utilizing various analytical approaches.
- Produce project documentation and present business user summarizations.
- Ability to work well in team environment and develop close relationships with all areas of the business.
- Possess collaborative work style, while partnering with cross-functional teams.
- Provides analytical leadership on complex business problems while partnering with stakeholders across the enterprise
- Other duties may be assigned, directed, or requested.
We need to ensure no duplication.
Second "What You Will Be Doing:" actually contains qualifications: "Bachelor’s degree in business, analytics, information systems, supply chain, or a related field is required. Four (4) years of experience in business analytics, business intelligence, data analytics is preferred.Experience with Databricks and cloud-based data platforms is preferred.Experience with ERP systems such as Microsoft Dynamics 365 is preferred.Supply chain, logistics, distribution, or inventory analytics experience is preferred. Knowledge of data warehousing and dimensional modeling concepts is preferred. Proficiency in Power BI, Power Query, and SQL is preferred.Knowledge of enterprise reporting and analysis tools.Problem solving skills with ability to think creatively.Team oriented, hardworking, open-minded, and flexible.Strong presentation, communication, and stakeholder management skills.Ability to multi-task and manager multiple projects effectively. Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required,Must have excellent communication skills, both written and verbal.Ability to speak with all levels of the organization and outside partners.Ability to communicate complicated information to others. Must be proficient in basic mathematics: addition, subtraction, multiplication, and division.Ability to do algebra, calculate figures and amounts and apply concepts such as fractions, percentages, ratios, and proportions to practical situations. Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.A methodical and organized approach to problem-solving.The work performed is in an office environment.The noise level in the work environment is usually moderate at low decibels.Must be able to work in a fast-paced, team environment."
We need to separate into Requirements (education, experience) and Skills perhaps.
We can create sections: About the role (description paragraph), Responsibilities (duties list), Requirements (education + experience), Skills (technical and soft skills), Benefits (benefits list), Pay (salary range). Ensure we don't create sections with placeholder.
Now extract Requirements:
- Bachelor’s degree in business, analytics, information systems, supply chain, or a related field is required.
- Four (4) years of experience in business analytics, business intelligence, data analytics is preferred.
- Experience with Databricks and cloud-based data platforms is preferred.
- Experience with ERP systems such as Microsoft Dynamics 365 is preferred.
- Supply chain, logistics, distribution, or inventory analytics experience is preferred.
- Knowledge of data warehousing and dimensional modeling concepts is preferred.
These are requirements/qualifications.
Skills: The rest: Proficiency in Power BI, Power Query, and SQL is preferred. Knowledge of enterprise reporting and analysis tools. Problem solving skills with ability to think creatively. Team oriented, hardworking, open-minded, and flexible. Strong presentation, communication, and stakeholder management skills. Ability to multi-task and manage multiple projects effectively. Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required. Must have excellent communication skills, both written and verbal. Ability to speak with all levels of the organization and outside partners. Ability to communicate complicated information to others. Must be proficient in basic mathematics: addition, subtraction, multiplication, and division. Ability to do algebra, calculate figures and amounts and apply concepts such as fractions, percentages, ratios, and proportions to practical situations. Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form. A methodical and organized approach to problem-solving. The work performed is in an office environment. The noise level in the work environment is usually moderate at low decibels. Must be able to work in a fast-paced, team environment.
Some of these are more like work environment; but we can include as skills or general notes. Might be better to put them under Skills.
Benefits list: "Employee Benefits Include But Are Not Limited To: Health Plans - Medical, Dental & Prescription Flexible Spending Accounts - Health & Dependent Care Life and Accident Insurance Vacation Pay & Paid Holidays 401(k) with Company Match"
We need to turn into list.
Pay: Salary: $80,000.00 - $96,000.00
Now produce HTML.
We must not repeat job title as heading. No markdown.
We'll output something like:
About the role
The Business Analyst III partners with departments across the organization to integrate data from multiple sources, develop analytical solutions, and deliver actionable insights that support data-driven decision-making. This role is responsible for defining, developing, and maintaining key performance indicators, leading analytical initiatives, presenting findings and recommendations to stakeholders, and supporting enterprise-wide projects that improve operational and business performance.
Responsibilities
- Strong analytical skills with ability to explore data, draw conclusions, and develop recommendations.
- Define and present business metrics to Stakeholders.
- Define, develop, and maintain key performance indicators that support business objectives
- Build analytical story from data points
- Ability to prepare comprehensive reports accurately, and present complex ideas clearly and concisely.
- Design and architect advanced data visualizations using various BI tools.
- Design, develop, and support Power BI dashboards and reporting solutions
- Create user-friendly self-service analytics experiences for business users
- Develop and maintain data models, hierarchies, and relationships to support enterprise reporting.
- Perform ad hoc analysis with large data sets to call out and present key actionable insights.
- Discover and communicate actionable patterns and trends.
- Ability to work with transactional level data and create relationships and hierarchies.
- Highlight exceptions and recommend actionable next steps.
- Communicate effectively with internal departments to gather requirements and provide status updates.
- Communicate project status, risks, findings, and recommendations to SMEs and stakeholders.
- Help guide understanding and knowledge of complicated data sets.
- Support post-implementation of self-service analytics.
- Ability to manage multiple projects and adjust quickly to changing business needs.
- Retain business requirements and remain adaptive, utilizing various analytical approaches.
- Produce project documentation and present business user summarizations.
- Ability to work well in team environment and develop close relationships with all areas of the business.
- Possess collaborative work style, while partnering with cross-functional teams.
- Provides analytical leadership on complex business problems while partnering with stakeholders across the enterprise
- Other duties may be assigned, directed, or requested.
Requirements
- Bachelor’s degree in business, analytics, information systems, supply chain, or a related field is required.
- Four (4) years of experience in business analytics, business intelligence, data analytics is preferred.
- Experience with Databricks and cloud-based data platforms is preferred.
- Experience with ERP systems such as Microsoft Dynamics 365 is preferred.
- Supply chain, logistics, distribution, or inventory analytics experience is preferred.
- Knowledge of data warehousing and dimensional modeling concepts is preferred.
Skills
- Proficiency in Power BI, Power Query, and SQL is preferred.
- Knowledge of enterprise reporting and analysis tools.
- Problem solving skills with ability to think creatively.
- Team oriented, hardworking, open-minded, and flexible.
- Strong presentation, communication, and stakeholder management skills.
- Ability to multi-task and manage multiple projects effectively.
- Strong to advanced experience in Microsoft Excel, Word, PowerPoint, and Outlook is required.
- Must have excellent communication skills, both written and verbal.
- Ability to speak with all levels of the organization and outside partners.
- Ability to communicate complicated information to others.
- Must be proficient in basic mathematics: addition, subtraction, multiplication, and division.
- Ability to do algebra, calculate figures and amounts and apply concepts such as fractions, percentages, ratios, and proportions to practical situations.
- Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.
- A methodical and organized approach to problem-solving.
- The work performed is in an office environment.
- The noise level in the work environment is usually moderate at low decibels.
- Must be able to work in a fast-paced, team environment.
Benefits
- Health Plans - Medical, Dental & Prescription
- Flexible Spending Accounts - Health & Dependent Care