BUSINESS INTELLIGENCE DATA ANALYST JOB DESCRIPTION

A BI Data Analyst turns raw transactional and operational records into the numbers executives act on. The role owns the full chain from requirements intake through ETL design, data mart configuration, and dashboard delivery, a chain that, when handled poorly, leaves leadership making resource and pricing decisions on stale or contradictory figures. Most practitioners operate inside a data warehouse environment built on dimensional modeling principles, where schema design choices made at the analyst level propagate directly into every downstream report. Dimensional accuracy and stakeholder trust move together.

As the Business Intelligence Data Analyst, you translate business questions into structured data models, recurring dashboards, and ad hoc analyses that give operational and executive stakeholders a reliable, consistent view of performance. You work within a BI or Analytics team, collaborating closely with data engineers, finance leaders, marketing managers, and cross-functional process owners to define KPIs, validate data integrity, and automate reporting pipelines that replace manual workflows.

Career Impact: Owning KPI definition and data mart schema design at this level builds rare technical credibility that transfers directly into senior BI engineering, analytics management, or data architecture roles.

Business Impact: When the dashboards and ETL pipelines this role maintains are accurate, operations teams stop waiting on ad hoc pulls and start making faster, better-supported decisions on pricing, customer retention, and process efficiency.

Growth Opportunity: The exposure to predictive modeling, machine learning integration, and cloud data platforms that this role requires positions analysts to move into data science or BI architecture within two to three years.

• Design and develop recurring and ad hoc dashboards and reports to track KPI trends, anomalies, and performance benchmarks across business functions.
• Configure data mart schemas within the enterprise data warehouse to specification, applying dimensional modeling best practices.
• Develop and validate ETL scripts to extract data from source transactional systems and populate data marts with accurate, complete records.
• Collaborate with business process owners, finance leads, and marketing managers to document data requirements and translate them into technical reporting solutions.
• Monitor data quality across pipelines and reporting environments, identifying anomalies, root causes, and corrective actions.
• Conduct statistical analysis and predictive modeling to surface trends and provide actionable recommendations to operational and executive stakeholders.
• Support end users through training on new dashboards, documentation of report logic, and responsive handling of ad hoc analysis requests.
• Identify and implement automation opportunities that eliminate manual reporting workflows and reduce data reload latency.

• Bachelor's degree in Business, Computer Science, Mathematics, Statistics, Information Systems, or equivalent work experience.
• 5 or more years of business intelligence or data analytics experience, with demonstrated ownership of dashboard development and data warehouse reporting.
• Proficiency in SQL, including complex joins, subqueries, and performance optimization for large relational datasets.
• Demonstrated experience with ETL design, data modeling, and data mart development using dimensional modeling principles.
• Ability to communicate complex analytical findings to non-technical audiences through clear visualizations and written narratives.
• Experience conducting statistical analysis, including trend identification, forecasting, and regression modeling.
• Familiarity with Agile or Scrum delivery methodologies, including backlog management and iterative sprint cycles.
• Strong data governance practices, including documentation of data lineage, metadata management, and quality assurance protocols.

• Experience with cloud-based data platforms and pipeline orchestration tools in a production analytics environment.
• Background in a specific vertical such as healthcare, retail, or financial services, with understanding of domain-specific compliance or reporting standards.
• Professional certification in data analytics, business intelligence, or a related discipline such as the AICPA Data Analytics Certification or a Microsoft analytics path.
• Exposure to machine learning concepts or experience supporting data scientists in translating ML outputs into operational dashboards.

• Dashboard adoption rate, measuring the percentage of targeted stakeholder groups actively using published reports rather than manual extracts.
• ETL pipeline error rate per run cycle, reflecting the reliability and accuracy of data moving from source systems into the warehouse.
• Ad hoc report turnaround time in business days, measuring responsiveness to stakeholder analysis requests.
• Data mart schema defect rate post-deployment, reflecting the accuracy of dimensional model configurations before production release.
• KPI coverage ratio, measuring the share of defined business objectives backed by a live, validated dashboard view.
• Typical tools: BI platforms (commonly Power BI or Tableau); query and pipeline tools (commonly SQL Server, Python, or Azure Synapse).

• Base Salary Range: $80,000 to $115,000 annually, depending on experience and location
• Bonus: Annual performance bonus of 5% to 10% of base salary
• Equity: Not typical at this level; offered selectively at senior or lead tiers
• Health Benefits: Medical, dental, and vision coverage; employer contribution varies by company size
• PTO: 15 to 20 days annually, plus standard federal holidays
• Common Perks: Remote or hybrid work flexibility, professional development budget, and access to data certification programs

Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.

Work authorization in the United States is required for this position. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, or any other characteristic protected under applicable federal, state, or local law. Reasonable accommodations are available to individuals with disabilities throughout the application and employment process upon request. Employment in this role is contingent on the successful completion of a background check.

The Business Intelligence Data Analyst owns the end-to-end development of Power BI dashboards, ETL pipelines, and data marts that transform raw transactional data into actionable marketing and sales insights. Reporting to the analytics leadership team, this analyst collaborates with business and technical stakeholders to automate reporting, validate data quality, and drive continuous refinement of data-driven engagement strategies.

Key Responsibilities

• Partner with business teams to consult on and implement data solutions, KPIs, automated reporting, and process improvements.
• Design, develop, and evaluate recurring and ad hoc reports and dashboards in Power BI using best practices in data visualization.
• Present recommendations to identify BI-related workflows and sequencing events for automating and streamlining reports.
• Configure data mart schemas within the data warehouse per BI development specifications.
• Identify source data in transactional systems.
• Lead analytics for the marketing team by developing KPIs and analyzing and reporting on key growth and marketing metrics to gauge trends, benchmarks, and performance.
• Derive value by analyzing customer data and identifying marketing opportunities.
• Document data characteristics, including size, cardinality, completeness, and quality, to ensure product delivery meets requirements.
• Support sales and client service by studying product usage patterns, proactively identifying under-utilizing customers, and identifying new customers.
• Develop and deploy ETL scripts to extract data from source systems and populate data marts according to predefined specifications.
• Synthesize current business intelligence and trend data to support recommendations for action.
• Analyze existing customer characteristics and campaign performance data to enable continuous refinement of data-driven engagement marketing strategies.
• Perform queries to validate the accuracy and completeness of ETL scripts and BI applications.
• Develop optimization strategies to minimize data reload time and monitor data quality, analytics, and metrics results.

Required Qualifications

• Bachelor's degree in Mathematics, Marketing Analytics, Information Systems, Business Information Technology, Economics, Computer Science, Statistics, or a related quantitative field from an accredited university; master's degree in a related discipline preferred.
• 6+ years of professional data analysis experience, including data warehousing and BI projects.
• Proven experience in ETL scripting with advanced knowledge of SQL, R, and Python.
• Experience in both entity-relationship and dimensional data modeling.
• Experience developing data marts for BI applications.
• Expertise in data mining, forecasting, simulation, and predictive modeling.
• Experience with database synchronization, incremental and periodic data reload processes, data cleansing, database audit logs, and metadata management.
• Strong knowledge of AI and machine learning, data architectures, statistical techniques, and statistical computer languages.
• Thorough knowledge of Tableau, SQL, Python, MS Power BI, and business intelligence and data warehousing tools, including the ability to query databases and identify performance opportunities.
• Experience with data visualization platforms such as Microsoft Power BI, Tableau, or DAX.
• Familiarity with Agile development methodology and Kimball SDLC.
• Experience with or knowledge of QlikView, Qlik Sense, Azure Databricks, Azure Data Factory, Data Lake Analytics, SSRS, SSIS, and Power BI (plus).
• Strong written, presentation, and verbal communication skills; technical writing experience is a plus.
• Strong analytical, interpersonal, and project management skills, with a proven ability to identify problems, collaborate with stakeholders, and implement sustainable solutions.

Embedded within the business intelligence function, the Business Intelligence Data Analyst delivers support for senior leadership by expanding reporting tools, resolving process bottlenecks, and supplying demand forecasting analytics to aid S&OP implementation. Working closely with regional teams and cross-functional stakeholders, this analyst translates raw data into compelling visualizations that drive faster, better-informed operational decisions across the organization.

Core Functions

• Support senior leadership in the development of new business reports, dashboards, and tools.
• Expand current tools to accommodate growing data and business needs.
• Identify bottlenecks in current processes and recommend remediation changes.
• Interrogate raw data and compile ad hoc reports to promptly answer queries from senior leadership.
• Support the demand forecasting process to aid S&OP implementation.
• Efficiently convey statistical analysis insights through engaging data visualizations and presentations.
• Ensure accuracy of information shared with third parties and conduct root-cause analysis when issues arise.
• Support regional teams on their BI and analytics requirements.

Qualifications & Experience

• Bachelor's degree in Business, Finance, Economics, or a related field.
• Advanced Microsoft Excel skills, including array formulas, VBA, PowerPivot, Power Query, and DAX.
• Experience in data project delivery and presenting findings to varied seniority levels using data visualization and compelling storytelling.
• Good knowledge of descriptive and predictive analytics, including time series and regression analysis.
• Proficiency in dashboard and interactive report building principles and techniques, with familiarity with a professional BI tool such as Power BI, Tableau, QlikView, Arkieva, or AWS QuickSight.
• Knowledge of supply chain planning principles and functions, and familiarity with an integrated planning process such as S&OP or IBP.
• Proficiency in a programming or analytical language such as R, Python, or Scala.
• Knowledge of Retail Link or MicroStrategy (plus).
• Highly motivated self-starter with a sense of ownership and the ability to thrive in a fast-paced environment.

Reporting to the data management leadership team, the Business Intelligence Data Analyst leads the reporting environment design, data warehousing support, and master data management for a BI-driven organization. Partnering with IT, quality assurance, and vendor teams, this analyst shapes accurate, governance-aligned reporting systems that enable informed decision-making across departments.

Primary Duties

• Provide technical expertise on data storage structures, data mining, and data cleansing.
• Gather business requirements for data collection, retention, processing, and reporting.
• Lead and assist with reporting and analysis projects.
• Manage and design the reporting environment, including data sources, security, and metadata.
• Assess, test, and implement new or upgraded software and assist with strategic decisions on new systems.
• Support the data warehouse in identifying and revising reporting requirements.
• Support initiatives for data integrity, normalization, and reporting automation.
• Provide quality assurance of imported data, working with other quality assurance personnel as necessary.
• Manage or assist in managing vendors providing data warehousing or management services.
• Manage master data, including creation, updates, and deletion, as well as user and user role management.
• Commission and decommission data sets and process confidential data and information according to guidelines.
• Generate reports from single or multiple systems and troubleshoot the reporting database environment and reports.
• Evaluate changes and updates to source production systems.
• Train end users on new reports and dashboards.

Skills & Qualifications

• Bachelor's degree with five years of experience, or associate's degree with six years of experience, in fields requiring a high degree of data analytics and business intelligence.
• At least five years of expertise in SQL-based database products such as MS SQL, Access, MySQL, or Oracle.
• Demonstrated use of Agile/SCRUM or Waterfall SDLC methodologies.
• Project lead or project management experience using standard planning tools such as MS Project, Asana, or OpenProject.
• Experience in requirements gathering, analysis, and business analysis.
• Knowledge of cybersecurity concepts and practical application as they relate to data management and information assurance.
• Knowledge of cloud-based business intelligence systems such as Domo or Tableau, with familiarity with Power BI.
• Knowledge of the Cybersecurity Maturity Model Certification, NIST 800-53, or NIST 800-171 (preferred).
• Professional certification, or ability to obtain one, centered on data analysis or business intelligence, such as the AICPA Data Analytics Certification or MCSE: Data Management and Analytics (preferred).
• Knowledge of network management protocols, network architecture, and server virtualization (preferred).
• Experience working with government agencies and responding to their reporting requirements (preferred).

Sitting at the intersection of information management and organizational technology strategy, the Business Intelligence Data Analyst shapes Power BI reporting dashboards, cross-contractor data solutions, and process automation initiatives that translate complex data into actionable insight for both technical and non-technical audiences. Operating across program teams, IT infrastructure projects, and the management tier, this analyst delivers timely reporting and multi-project coordination that advance organizational efficiency.

Duties

• Analyze complex business problems and serve as a liaison between business and technical personnel to define and implement proposed solutions, integrating input from all stakeholders.
• Stay current with technological developments and provide recommendations on how to leverage new advancements for assigned processes.
• Design and implement reporting dashboards, charts, graphs, and reports that track key metrics and performance trends and provide actionable insights.
• Explain complex modeling approaches in simple terms and develop compelling narratives that connect data analysis with business problems.
• Respond promptly to multiple organizational and data-driven ad hoc report requests.
• Represent the information management department during company initiatives and projects involving software and technology infrastructure solutions.
• Participate in cross-contractor teams to identify, develop, and implement joint information management solutions.
• Manage multiple program projects and activities at varying levels of complexity to improve, streamline, and automate work processes.
• Support the management team in the timely and quality closure of actions.
• Manage priorities, special projects, deadlines, and routine workloads successfully.
• Present technical information effectively to both technical and non-technical audiences in oral and written formats.

Requirements

• BA/BS degree, or equivalent combination of education and experience.
• 5 years of related experience.
• Minimum 5 years of experience in business intelligence and reporting packages, including Microsoft Power BI, SAP Crystal Reports, and SQL or Oracle databases.
• Excellent command of SQL and direct experience working with large datasets joined from multiple sources.
• Strong knowledge of the Microsoft Office Suite, with a high level of proficiency in Microsoft Excel and Microsoft Access.
• Foundational understanding of software lifecycle, software engineering, and software quality assurance practices.
• Experience in information technology programs at a government agency or equivalent environment (preferred).

A key member of an Agile analytics team, the Business Intelligence Data Analyst leads requirement-gathering sessions, hypothesis validation, and ML/AI-focused business case development to connect data-driven insights with measurable outcomes. Collaborating across delivery teams, business stakeholders, and junior analysts, this role builds governance-ready stories and pilot solutions that extend advanced analytics capabilities throughout the healthcare organization.

Functions

• Lead requirement-gathering sessions using interviews, documentation analysis, surveys, site visits, and shadowing to understand and document current business processes, with a focus on identifying ML/AI opportunities.
• Validate current-state understanding using data in the data platform and conceptualize future-state processes with ML/AI.
• Present advanced analytics and ML/AI capabilities to business stakeholders and support the development of business cases.
• Execute project phases, including hypothesis validation and pilot, and use data to determine and present success stories of delivered solutions.
• Lead Agile practices, including backlog grooming, creation of testable requirements, and Gemba walks.
• Define detailed, granular, and development-ready stories that align to product goals and success metrics.
• Participate in and contribute to release planning and iteration planning ceremonies.
• Mediate across delivery and project teams using knowledge of business, technology, and organizational roles and responsibilities.
• Assist in testing, logging, and tracking defects as needed.
• Create documentation and complete knowledge transfer for business process and data analytics components of AI/ML solutions.
• Guide and support junior business and data analysts on the team.

Experience & Qualifications

• Bachelor's degree in a related field, or equivalent work experience.
• Experience working as a business and data analyst in Agile teams, including creating and managing a pipeline of work with a prioritization framework.
• Experience analyzing data using SQL, R, or Python against data models in GCP (BigQuery) and producing concepts in data visualization tools such as Tableau.
• Experience developing creative and innovative analytical insights with high business value and presenting complex data and metric relationships to users.
• Experience in the healthcare industry, especially in the US (plus), and experience in advanced analytics and ML/AI (plus).
• Strong verbal and written communication skills and strong organizational skills.

Informed, customer-centric operational decisions depend on the Business Intelligence Data Analyst, who owns bespoke data models, statistical performance analyses, and stakeholder-facing presentations that turn complex operational data into clear strategic guidance. Serving as a cross-functional data authority, this analyst adheres to the organization's data governance strategy while anticipating bottlenecks and helping business units explore technology possibilities to optimize ways of working.

Accountabilities

• Work with operations subject matter experts to map out business processes and identify datasets for all business processes and outcomes.
• Identify customer impact data relating to inbound communications and construct bespoke data models incorporating views of desired operational processes and customer contact.
• Validate and test data models with subject matter experts.
• Ensure the accuracy, completeness, and timely delivery of reports and analysis.
• Communicate conclusions and implications of statistical and performance analyses to a wide range of stakeholders, guiding informed decisions.
• Convey statistical concepts clearly and develop and deliver formal presentations to individuals and groups.
• Adhere to data governance and best practices aligned with the data strategy for the area.
• Experiment and test solutions for problems, validate assumptions, and associate ideas to reach solutions.
• Anticipate process bottlenecks and scaling possibilities, and account for vulnerabilities caused by improper design.
• Document business requirements from multiple stakeholder groups, propose tooling solutions, and coordinate prioritization activities.
• Maintain a deep awareness of how business operations work and help stakeholders explore technology possibilities to optimize ways of working.

Technical Qualifications

• Experience working with technical products that have multiple stakeholders.
• Experience writing queries in BigQuery and, preferably, experience with other programming languages such as Python or R to interrogate large datasets and identify actionable insights.
• Experience with data preparation methodologies and visualization tools such as Tableau.
• Experience working in a fast-paced, customer-focused environment with the ability to adapt to change.
• Ability to provide clarity in a complex and changing environment, see the bigger picture, and understand how a wide range of analytical outputs link together.
• Excellent interpersonal skills with outstanding verbal and written communication abilities.

As the Business Intelligence Data Analyst, this role builds data visibility solutions, maintains the data warehouse, and executes data stewardship initiatives that ensure accurate, governance-aligned reporting for business operations. The data operations team relies on this work to translate stakeholder reporting needs into scalable, customer-satisfaction-driven insights that fuel continuous improvement across business functions.

Activities

• Maintain an understanding of the data visibility needs of the business and collaborate with data analysts and business leaders across multiple functions to understand reporting needs.
• Identify and deliver solutions to provide required data visibility for the business.
• Create engaging, accurate, and effective visibility into key business metrics, prioritizing efficiency and speed to delivery.
• Ensure accuracy of data reporting and visibility tools.
• Aid in the creation and growth of the data warehouse.
• Understand the data collection needs of the business and collaborate with the data quality analyst to provide feedback on datasets and potential inaccuracies.
• Collaborate with members of business operations to create new data collection endpoints.
• Monitor and provide solutions to issues submitted through the business operations ticketing system, maintaining a high customer satisfaction score on all engagements.
• Perform the role of data steward to improve data health, quality, and governance, and execute within established data quality metrics.
• Assist data quality initiatives by creating solutions to enforce data governance policies and automate the transformation of errant data.
• Maintain an understanding of the data-creating business processes and collaborate with data analysts to create innovative ways to deliver data and insights to internal customers.

Position Requirements

• Bachelor's degree in Science, Engineering, Technology, Mathematics, or a related field, or a combination of relevant experience and education.
• Experience in a customer-centric environment.
• Ability to synthesize many requests into a solution that addresses all needs.
• Experience in the creation of data reports and visibility solutions for business functions (preferred).
• Experience leveraging visual data analysis tools such as Domo or Tableau (preferred).
• Experience with systems and data analysis (preferred).
• Fluency in English with strong communication skills and a highly organized, detail-oriented work style.

Business Intelligence Data Analyst delivers Azure-platform data modeling, SQL-based pipeline development, and Power BI reporting solutions that automate manual workflows and improve organizational performance across multiple departments. The work directly supports IT administration teams, key stakeholders, and business groups in adopting data modeling best practices and leveraging enterprise information systems to generate sustainable operational improvements.

Operational Focus

• Collaborate with business process owners to help solve data needs, including architecting and building solutions to automate existing manual workflows.
• Collaborate with IT administration and data analysts to support pipeline development and develop data pipelines and workflows for reporting and analytics.
• Consult on process and data profiling, data mining, data validation, and analysis, and query data to answer ad hoc questions as they arise.
• Serve as a subject matter expert on the Azure platform and SQL.
• Identify and summarize business requirements and manage workload spread across multiple departments.
• Create conceptual data models to identify key business entities and develop detailed logical models identifying all entities, attributes, and relationships.
• Establish and maintain relationships with key stakeholders and deliver a high level of service and accuracy.
• Promote software adoption and data modeling best practices.
• Utilize information systems to identify new and better ways of performing jobs and produce changes for the overall improvement of the organization.

Knowledge Skills & Abilities

• Bachelor's degree in Computer Science, Data Science, Database Administration, or equivalent professional experience.
• 3–5 years of experience in data cleansing, data wrangling, and data modeling.
• Experience working with databases, automating manual workflows, and building complex data models for analytics and reporting enablement.
• Ability to work on data modeling, metric development, data prototyping, and insight generation.
• Knowledge of the Azure platform and Synapse Data Management, or another data management platform (preferred).
• Knowledge of Microsoft 365 Power Platform, including Power Automate, Power Query, and Power BI (preferred).
• Knowledge of ERP systems such as D365 F&O and CRM systems such as Salesforce (preferred).
• Experience with scripting or programming languages such as JavaScript, HTML, CSS, R, or Python (plus).
• Professional certifications in Microsoft Power Platform, Agile, or Project Management (plus).
• Ability to work with multiple business groups and IT to drive data workflow solutions.

The Business Intelligence Data Analyst oversees dashboard visualization, data quality reporting, and requirements definition for Procurement and Payment data sources that safeguard enterprise data integrity. Reporting to business stakeholders and IT leadership, this analyst establishes checks and balances, identifies data owners, and develops SLAs that ensure accurate, timely reporting across sourcing and contract management functions.

Key Deliverables

• Understand business processes, tools, and the data collected in those processes.
• Support reporting requests and the development and validation of dashboards and data visualizations.
• Work with business stakeholders and IT to analyze, define, and document data and reporting requirements.
• Provide data oversight by establishing checks and balances, identifying business data owners, and establishing SLAs to address issues.
• Support reporting and dashboard development requests from stakeholders and perform validation of reports and dashboards.

Professional Experience

• 3+ years of experience in a business data analyst role, including reporting and dashboard development.
• Minimum 2 years of experience in sourcing, contract management, and purchasing (preferred).
• Experience with dashboard development and data visualization within a business intelligence platform such as Power BI, Tableau, or Qlik Sense.
• Advanced Microsoft Excel skills, including advanced formulas, pivot tables, and macros, as well as proficiency in the Microsoft Office Suite.
• Familiarity with SAP, Ariba, and Fieldglass applications.
• Experience working with data warehouses, auditing data, and identifying data anomalies and root causes.
• Strong negotiation, analytical, decision-making, problem resolution, and organizational skills.

Embedded within the network transformation and commercial operations division, the Business Intelligence Data Analyst develops Power BI dashboards, vendor contract analytics, and KPI frameworks that support data governance architecture and revenue enablement across the telecommunications business. Working closely with operational teams, product managers, and senior leadership, this analyst refines cost-benefit business cases and performance metrics that underpin strategic network and customer experience decisions.

Areas of Ownership

• Identify KPIs with clear objectives and consistent monitoring, and act quickly to identify drivers of underperforming initiatives.
• Support contract digitization and the storage and management of vendor contracts and SLAs within a contract lifecycle management tool.
• Modify existing and develop new analytic solutions, and perform data quality and cleansing for vendor-related data.
• Create dashboards and interactive visual reports with simple user interfaces using Microsoft Power BI.
• Resolve data and reporting issues from business partners.
• Identify, analyze, develop, document, and lead complex projects for overall customer experience and revenue enablement.
• Support operational and commercial enablement of network transformation activities.
• Develop comprehensive business cases detailing cost-benefit analysis of proposed initiatives to help drive product and program strategy.
• Strengthen focus on data governance architecture and ecosystem strategy.
• Study operational needs and interface with stakeholders across the organization.

Education & Experience

• Bachelor's degree in Business Administration, Computer Information Systems, Analytics, Data Science, Business Intelligence, or a related field.
• 5+ years of related experience.
• Operational experience in telecommunications, including service assurance, service delivery, project management, and contract management.
• Expert knowledge in analytics with close attention to detail, accuracy, and consistency.
• Experience utilizing metrics to influence and drive decisions, and ability to communicate strategic plans to management based on analytical findings.
• Expert ability in designing, configuring, and presenting insightful reports and findings.
• Knowledge of relational database concepts and design, with strong Microsoft Suite skills, especially in Excel and Power BI.

Reporting to project leadership, the Business Intelligence Data Analyst produces system test plans, user acceptance documentation, and sprint-cycle reporting solutions that ensure BI objectives are met through structured SDLC methodology. Partnering with business users, end-user teams, and cross-functional stakeholders, this analyst advances accurate, process-aligned reporting capabilities across financial accounting, sales, procurement, and manufacturing functions.

Role Responsibilities

• Work with business users to define and document high-level and detailed requirements.
• Perform testing and data validation as assigned.
• Create system test plans and test applications to ensure successful test cycles.
• Create, review, and deliver end-user documentation, including user guides, process flow charts, and training materials.
• Monitor enhancements and system integrity with end users during upgrades.
• Participate in sprint cycles of agreed-upon solutions and ensure documentation is updated when change requests are approved.
• Develop project sprints, user acceptance test plans, and communication plans for knowledge transfer to end users.
• Support key business intelligence objectives.

Background & Experience

• Undergraduate degree plus 3+ years of relevant experience.
• Working knowledge of system development methodology and SDLC, along with analytical and problem-solving skills.
• Working knowledge of requirements-gathering and documentation methods to follow end-to-end business processes.
• Basic knowledge of commonly used project management methodologies, including Waterfall and Agile.
• Working technical knowledge of data visualization, analysis, and reporting.
• Working knowledge of business functions and processes, including financial accounting, general accounting, sales and distribution, procurement, cost accounting, and manufacturing concepts for proper reporting.
• Basic knowledge of the Oracle R12 Enterprise Business Suite data model to ensure effective and optimal design of Oracle-based reporting solutions.
• Working knowledge of data profiling, quality analysis, and verification.
• Basic knowledge of Power BI, Power Apps, Tableau, or similar tools.

Sitting at the intersection of higher education operations and data-driven student success strategy, the Business Intelligence Data Analyst develops business and operational metrics, single-variate analyses, and actionable reporting that measure organizational performance and student outcomes. Operating across analytics teams, internal business clients, and academic partners, this analyst refines data storytelling approaches and advises stakeholders on analytical methodologies that align with institutional goals.

Job Functions

• Develop business and operational metrics to measure student success and organizational performance.
• Gather and analyze data from multiple databases and other sources to perform single-variate analyses on business and operational trends.
• Present qualitative and quantitative analyses to partners, including actionable recommendations.
• Deliver concise and applicable insights through effective data storytelling.
• Work with partners to interpret analysis results with a focus on relevant next steps.
• Develop reports to support analytics activities.
• Advise partners on appropriate analytical methodologies to address business questions, problems, and goals.
• Provide consultation, training, and technical assistance to internal clients.
• Design and help implement process improvement projects.

Required Qualifications

• Bachelor's degree in business, mathematics, data analytics, or a related field.
• Master's degree preferred.
• Six years of experience working in a data-driven business environment.
• One or more years of experience in the higher education industry or sector.
• Experience in report building and working directly with partners from initial request through deployment.
• Experience using relational databases.
• Experience with Product Backlog Items (PBI) and Data Analysis Expressions (DAX).
• Proficiency in SQL, including writing joins and subqueries.
• Proficiency in Microsoft Excel for analysis purposes, including maintaining complex spreadsheets.
• Ability to design rich data visualizations to communicate complex ideas.

A key member of the marketing analytics organization, the Business Intelligence Data Analyst advances data accuracy, ETL pipeline management, and BI solution development to help marketers identify new opportunities and expand customer reach cost-effectively. Collaborating across engineering, product management, and analyst teams, this role integrates third-party data systems and produces query-driven insights that inform marketing channel strategy.

What You'll Do

• Partner across teams to ensure marketing data accuracy and resolve any issues.
• Build BI solutions that enable marketers to analyze marketing channels, identify new opportunities, and reach more customers cost-effectively.
• Assess marketing data quality, perform root cause analysis, and create insights using industry tools.
• Partner with engineers, product managers, and other analysts to integrate with third-party systems.
• Manage current data integrations across multiple heterogeneous data sources.
• Write queries and scripts to assess data quality and alert for any issues.

Qualifications & Experience

• Bachelor's degree in a technical, business, or quantitative field, including computer science, engineering, business, statistics, or a related field.
• Two or more years of experience in business intelligence, analytics, or data engineering.
• One or more years of experience working with marketing data.
• Experience with data modeling and data from third parties.
• Experience writing and scheduling ETL jobs using tools such as Scala, Spark, Azkaban, or Airflow.
• Experience explaining data-driven decisions to both technical and non-technical team members and leadership.
• Proficiency in SQL and ETL.
• Experience with a scripting language such as Python.
• Experience with data visualization tools such as Tableau or Sisense/Periscope.

Operational excellence across the service operations domain depends on the Business Intelligence Data Analyst, who refines inventory health dashboards, defect monitoring processes, and performance analytics to surface issues and improvement opportunities across tools and workflows. Serving as the in-house expert on data structure and visualization, this analyst collaborates with the Operations Excellence team to guide process improvements and support data-driven decision-making in healthcare operations.

Day-to-Day Responsibilities

• Gain a thorough understanding of service operations processes, workflows, and internal tools.
• Intake, scope, and complete data-related requests within the service operations domain.
• Identify areas of opportunity for improvement in tools, technical processes, and performance.
• Serve as an in-house expert on data structure and visualization for service operations team members.
• Analyze performance, identify issues and areas of opportunity, and collaborate with the Operations Excellence team on process improvements.
• Take ownership of monitoring, tracking, and reporting on inventory health, including developing dashboards and defect monitoring and maintenance.
• Support the team lead or manager by guiding decisions and implementation on an ongoing basis.

Skills & Qualifications

• Bachelor's degree or four or more years of experience in data analytics.
• Two or more years of related work experience in healthcare, analytics, or operations.
• Experience using data visualization tools such as Periscope or Tableau.
• Experience analyzing processes and driving improvement.
• Experience in a call center environment.
• Some coding experience or exposure to database languages.

As the Business Intelligence Data Analyst, this role oversees multi-request data analysis, Power BI reporting, and predictive modeling that connect financial and operational data to measurable business outcomes. The finance team and department leaders rely on this work to evaluate future scenarios, identify process efficiencies, and receive clear, actionable quantitative insights that support strategic planning.

Scope of Work

• Collaborate with the finance team and department leaders to understand and document goals and objectives, and identify measurable key results.
• Generate insights connecting analytical results with business problems or objectives.
• Utilize predictive modeling and statistical analysis to determine analytical approaches and evaluate scenarios and potential future outcomes.
• Present findings and provide recommendations to key stakeholders.
• Support and recommend business process improvement efficiencies.
• Manage multiple analysis requests simultaneously while delivering outcomes on time.

Requirements

• Minimum five years of experience in data analytics.
• Knowledge of advanced analysis and reporting using Microsoft Excel.
• Knowledge of relational databases and SQL, with T-SQL preferred.
• Familiarity with data modeling for reporting purposes.
• Proficiency in Power BI.
• Ability to communicate complex quantitative analysis in a clear, precise, and actionable manner.
• Curiosity, a research mindset, and comfort working on open-ended problems.
• Ability to multitask and change direction quickly.

Business Intelligence Data Analyst produces monthly CX region report reviews, NPS analyses across product, customer, and dealer dimensions, and data-driven recommendations that identify areas for customer experience improvement. Success in the position means translating statistical analysis and visualization outputs into clear, actionable findings that internal regional teams and leadership can act on to elevate the customer experience.

Work Activities

• Conduct monthly reviews of CX region reports.
• Perform analysis on product NPS, customer NPS, and dealer NPS.
• Identify areas for CX improvement by analyzing data, identifying trends, and partnering with internal regional teams.
• Perform statistical analysis and apply visualization techniques to provide data-driven insights and actionable recommendations.
• Present findings and recommendations accurately with clear takeaways.

Experience & Qualifications

• Bachelor's degree in business, statistics, or marketing with a concentration in market research.
• Three years of experience.
• Qualitative and quantitative research experience.
• Experience working with business intelligence tools such as Qlik Sense.
• Strong analytical and report-writing skills.
• Proficiency in the MS Office suite, including Word, PowerPoint, Excel, and Access.
• Strong organizational skills with the ability to manage multiple priorities.
• Excellent team player with the ability to interact proactively with internal stakeholders at all levels.

The Business Intelligence Data Analyst creates KPI frameworks, Power BI reporting tools, and metric-driven analyses that support Professional Services, eAdoption, Credit, and Collections teams in achieving departmental goals. Reporting to management and executive leadership, this analyst coordinates cross-departmental data workflows, builds rapport with stakeholders, and presents findings in formats that drive operational efficiency and performance visibility.

Performance Expectations

• Compile and analyze project data and other business metrics.
• Create and maintain meaningful reports for various departments using Microsoft Excel.
• Acquire a solid understanding of data, data collection systems, and reporting processes.
• Suggest and implement solutions to optimize reporting and processes, including building KPIs and streamlining data migration through APIs.
• Understand project management software workflows and serve as a platform administrator as necessary.
• Carry out performance analysis and reporting in collaboration with management.
• Understand departmental functions and how data points demonstrate efficiency and performance.
• Collaborate and build rapport with teams across departments.
• Partner with end users to understand and support their reporting requirements.
• Present data to management in a consumable format that provides insight without unnecessary complexity.
• Communicate reporting and data findings at the appropriate level of detail for the audience, including executives and end users.

Technical Qualifications

• Bachelor's degree in finance, business, accounting, or a related field preferred.
• Three or more years of relevant experience creating, maintaining, analyzing, and reporting on business data.
• Experience with Power BI is a plus.
• Strong Excel skills, including the ability to create pivot tables, lookup tables, and dynamic formulas.
• Knowledge of project management and CRM software such as Clarizen and Salesforce is a plus.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate large volumes of information with attention to detail and accuracy.
• Strong written and verbal communication skills.
• Critical thinking ability with a drive to investigate root causes and understand underlying issues.
• Ability to thrive in a fast-changing work environment with a strong desire to learn.

Embedded within the NAVAIR support environment and responsible for 24/7 application availability, the Business Intelligence Data Analyst coordinates SAP Business Objects reporting, system operability monitoring, and DOD security compliance activities that underpin mission-critical data access for defense customers. Working closely with management, process owners, and IT service teams, this analyst guides the translation of business goals into technical database and reporting solutions aligned with government requirements.

Core Responsibilities

• Create and maintain customer-requested metrics, reports, and data analyses to identify issues and trends.
• Provide support for application upgrades, access changes, functionality changes, external interfaces, and data integrity.
• Monitor system operability and respond to vulnerabilities in accordance with DOD Security Technical Implementation Guidelines.
• Coordinate resolution of product and service issues, upgrades, and problems.
• Apply a wide range of data administration skills, including in a business process reengineering context.
• Understand data from the perspective of data processing and across different lifecycle phases.
• Work with management and process owners to analyze business goals and needs, and translate them into technical database and reporting solutions.
• Manage and maintain Business Objects Universes and custom objects, including organizing objects and optimizing for performance.

Position Requirements

• Associate degree in computer science, information systems, engineering, or a relevant discipline.
• Six years of demonstrated relevant experience instead of a degree.
• Active Top Secret clearance required; Interim Secret is acceptable to start.
• Security+ Certification required within three months of hire.
• ITIL v3 Foundation Certification.
• Experience with SAP Business Objects 4.0 or later, Web Intelligence, and SAP Universe Design Tool or Information Design Tool, with version 4.2 strongly preferred.
• Experience with help desk tools and IT service management platforms such as Remedy, HEAT, or ServiceNow, and the Service Delivery Life Cycle.
• Ability to learn quickly, maintain workflow, and prioritize tasks to meet goals and deadlines.
• Strong project management skills with excellent written and verbal communication skills.
• Outstanding attention to detail, accuracy, and quality of work, with excellent troubleshooting skills.

Reporting to USFF HQ leadership, the Business Intelligence Data Analyst executes AI and machine learning analytics, SQL-driven data exploration, and Agile-managed BI reporting across big data environments that support Navy Fleet Readiness and Homeland Security missions. Partnering with mission-area process owners and technical advisors, this analyst guides projections, trend analyses, and emerging technology recommendations that advance warfighter operational effectiveness.

Key Responsibilities

• Perform data exploration and analytics.
• Create BI reports and dashboards.
• Utilize Python, R, and SQL to perform artificial intelligence and machine learning tasks on big data.
• Gather data from various sources and transform it into usable information.
• Interpret data to draw conclusions, projections, forecasts, and trend analyses using statistical techniques.
• Develop a plan of action and milestones for all projects and tasks using Agile concepts and best practices.
• Participate in regularly scheduled meetings to discuss projects, tasks, and requirements.
• Provide technical advice and recommendations on current and emerging technologies and their potential use and benefit.

Knowledge, Skills & Abilities

• Bachelor's degree in computer science, engineering, mathematics, or statistics.
• Must maintain current CompTIA Security+ certification.
• Microsoft Certified Solutions Associate (MCSA) Machine Learning Certification.
• Six years of experience in interpreting and analyzing data for data-driven solutions, including predictive data modeling and data mining algorithms.
• Experience and in-depth knowledge of Microsoft Excel Analysis ToolPak, Minitab, MS SQL Analysis Services, Python, and R for artificial intelligence and machine learning.
• Proficiency in Agile concepts and best practices.
• Experience in Microsoft Windows and Linux operating systems.
• Experience with MS SQL, MySQL, C, C++, C#, Java, JavaScript, JSON, IIS, Apache Web Server, Ruby, PHP, and MySQL.
• Experience writing technical manuals and user guides.

Sitting at the intersection of healthcare business intelligence strategy and technical infrastructure development, the Business Intelligence Data Analyst creates ETL processes, enterprise BI reporting solutions, and data integrity audits that transform cross-functional data into insight for a growing healthcare company. Operating across business units, subject matter experts, and systems teams, this analyst coordinates KPI definition, governance processes, and information-sharing methods that expand business users' independent data capabilities.

Core Functions

• Lead the strategic design and maintenance of business intelligence infrastructure.
• Analyze and evaluate reporting and storage processes, and recommend and implement improvements, including writing ETL processes and reports.
• Work with cross-functional teams, including business subject matter experts and systems experts, to transform data into insight.
• Coordinate across business units to define key performance metrics and ensure that reporting technologies consistently measure and report on these KPIs.
• Create methods for sharing information across departments and increasing business users' ability to leverage data independently.
• Identify opportunities for enhancing available data and processes for business intelligence.
• Audit and uncover data integrity issues, and work with business managers to resolve them.

Professional Experience

• Bachelor's degree or higher in software development, information systems, engineering, mathematics, or an applicable discipline.
• Five years of demonstrated experience in business intelligence analyst or data analyst positions, with emphasis on Microsoft Business Intelligence Stack, including SSIS, SSRS, and SSAS, SQL Server 2014 or 2016, Tableau, and Microsoft Azure.
• Five years of relevant experience working with large datasets.
• Deep understanding of SQL for ad hoc reporting and data mining.
• Knowledge of data modeling and data warehouse development best practices.
• Intermediate knowledge of data ETL processes and tools.
• Experience with data governance processes.
• Experience with scripting languages such as Python.
• Experience transforming user requests into technical and functional specifications.
• Excellent documentation skills with strong verbal and written communication skills.
• Ability to manage multiple priorities and projects simultaneously and operate independently with limited supervision.