Lil' Drug Store
Business Intelligence Analyst
Lil' Drug Store, Cedar Rapids, Iowa, United States, 52404
Job Title:
Business Intelligence AnalystLocation:
Cedar Rapids, IowaClassification : Exempt SalariedReports To:
Chief Financial OfficerPurpose of the Job:
Design and create data visualizations to provide business insights that aid decision-making across the organization. Interpret and digest complex information while visually summarizing key findings.Supervisory Responsibility:
NoEssential Job Responsibilities and Duties:Design and implement data visualization to support business intelligence initiativesDevelop and maintain tools to present complex data in an understandable mannerIdentify functional requirements through process analysis, review of procedures, and interviews with key stakeholdersInterpret results from multiple structured and unstructured data sources using programming, statistical analysis, and analytical techniques and tools (including Solver, Power BI, Tableau, R, Python, SQL, etc.)Improve and streamline processes regarding data flow and data quality to improve data accuracy, viability, and value (including automation through information enablement, algorithms, AI, and other capabilities)Build code to create connections between various data servicesAutomate delivery of standard reports and dashboards, including proactive solutions and user-driven pull information deliveryCollaborate with Developers and System Architects to use requirements to design from both business and technical perspectivesParticipate in cross-functional projects to support business objectives and initiativesCollaborate with IT to ensure data integrity and accuracy across all systems.Proactively identify and address data quality issuesProvide training and support to team members on data analysis tools and techniquesStay current with BI trends, optimize processes, and promote best practices in data governanceEducation:Bachelor's degree in Data Science, Computer Science, Information Systems, Business Analytics, or a related fieldExperience:Minimum of 5 years of experience in business intelligence, business analytics, data visualization, or a related roleDemonstrated experience using querying languages, scripting languages, and other tools such as Power BI or Denodo to produce reports and perform meaningful quantitative or qualitative analyses addressing impactful business issues or questions (direct experience using Solver, Power BI, Python, R, and SQL is preferred)Advanced knowledge of Power BI and data modelingAdvanced knowledge of statistical analysis tools and modeling techniquesKey Competencies:Ethics, Integrity, Values: Has values aligned with the company and acts accordingly. Ably builds trust.Analytical Skills: Creates insightful and comprehensible reports. Interprets and digests complex information while visually summarizing key findings.Organizing Skills: Puts resources or processes into logical, comprehensible, and aesthetically pleasing order.Detail Orientation/Quality Focus: Is accurate and methodical with details. Reliably verifies all work.Project/Task Management: Demonstrates the ability to work within timelines, company structures, and budgets for successful completion of assigned tasks or projects.Problem Solving: Sees and is able to define problems. Investigates, assesses, and correctly identifies root causes. Devises workable solutions.Research Skills/Information Finding: Identifies, sorts, and categorizes source materials to deliver most pertinent and needed information.Creativity/Innovation: Demonstrates inventiveness and the ability to find information or solutions needed for assignments or projects.Team Orientation: Fulfills own role and can be counted on. Works cooperatively with all levels of company team, establishes rapport.Interpersonal Communication: Relates well to people, verbally and in written form. Asserts with strength, tact and diplomacy. Listens well.Learning/Growth Ability: Enjoys and excels at learning new information or skills.Physical and Working Environment:Working Hours: General office hours, typically 8:00 AM 5:00 PM with flexibility for business and personal needs.Tools and Equipment: Computer, tablet, e-mail, phone, and other standard office equipment.Physical Demands: Ability to lift and carry up to 40 lbs. on occasion; digital dexterity and hand/eye to operate equipment such as computer keyboard, calculator, and standard office equipment. Ability to effectively communicate with customers, suppliers, or employees remotely and in person. Ability to travel by airplane or automobile.No regular travel requirements.Working Environment: Work usually performed in an office setting and distribution center with noise level typical of most office environments with telephones, personal interruptions, and background noises.
Business Intelligence AnalystLocation:
Cedar Rapids, IowaClassification : Exempt SalariedReports To:
Chief Financial OfficerPurpose of the Job:
Design and create data visualizations to provide business insights that aid decision-making across the organization. Interpret and digest complex information while visually summarizing key findings.Supervisory Responsibility:
NoEssential Job Responsibilities and Duties:Design and implement data visualization to support business intelligence initiativesDevelop and maintain tools to present complex data in an understandable mannerIdentify functional requirements through process analysis, review of procedures, and interviews with key stakeholdersInterpret results from multiple structured and unstructured data sources using programming, statistical analysis, and analytical techniques and tools (including Solver, Power BI, Tableau, R, Python, SQL, etc.)Improve and streamline processes regarding data flow and data quality to improve data accuracy, viability, and value (including automation through information enablement, algorithms, AI, and other capabilities)Build code to create connections between various data servicesAutomate delivery of standard reports and dashboards, including proactive solutions and user-driven pull information deliveryCollaborate with Developers and System Architects to use requirements to design from both business and technical perspectivesParticipate in cross-functional projects to support business objectives and initiativesCollaborate with IT to ensure data integrity and accuracy across all systems.Proactively identify and address data quality issuesProvide training and support to team members on data analysis tools and techniquesStay current with BI trends, optimize processes, and promote best practices in data governanceEducation:Bachelor's degree in Data Science, Computer Science, Information Systems, Business Analytics, or a related fieldExperience:Minimum of 5 years of experience in business intelligence, business analytics, data visualization, or a related roleDemonstrated experience using querying languages, scripting languages, and other tools such as Power BI or Denodo to produce reports and perform meaningful quantitative or qualitative analyses addressing impactful business issues or questions (direct experience using Solver, Power BI, Python, R, and SQL is preferred)Advanced knowledge of Power BI and data modelingAdvanced knowledge of statistical analysis tools and modeling techniquesKey Competencies:Ethics, Integrity, Values: Has values aligned with the company and acts accordingly. Ably builds trust.Analytical Skills: Creates insightful and comprehensible reports. Interprets and digests complex information while visually summarizing key findings.Organizing Skills: Puts resources or processes into logical, comprehensible, and aesthetically pleasing order.Detail Orientation/Quality Focus: Is accurate and methodical with details. Reliably verifies all work.Project/Task Management: Demonstrates the ability to work within timelines, company structures, and budgets for successful completion of assigned tasks or projects.Problem Solving: Sees and is able to define problems. Investigates, assesses, and correctly identifies root causes. Devises workable solutions.Research Skills/Information Finding: Identifies, sorts, and categorizes source materials to deliver most pertinent and needed information.Creativity/Innovation: Demonstrates inventiveness and the ability to find information or solutions needed for assignments or projects.Team Orientation: Fulfills own role and can be counted on. Works cooperatively with all levels of company team, establishes rapport.Interpersonal Communication: Relates well to people, verbally and in written form. Asserts with strength, tact and diplomacy. Listens well.Learning/Growth Ability: Enjoys and excels at learning new information or skills.Physical and Working Environment:Working Hours: General office hours, typically 8:00 AM 5:00 PM with flexibility for business and personal needs.Tools and Equipment: Computer, tablet, e-mail, phone, and other standard office equipment.Physical Demands: Ability to lift and carry up to 40 lbs. on occasion; digital dexterity and hand/eye to operate equipment such as computer keyboard, calculator, and standard office equipment. Ability to effectively communicate with customers, suppliers, or employees remotely and in person. Ability to travel by airplane or automobile.No regular travel requirements.Working Environment: Work usually performed in an office setting and distribution center with noise level typical of most office environments with telephones, personal interruptions, and background noises.