Data, Automation & AI Analyst — Power BI & Low-Code

Altarum; Novi (MI); Hybrid; USD 85,000 - 103,000; Full time

Benefits offered by this job

Competitive Medical, Dental and Optic­

Tuition Assistance

401K Plan (3% employer contribution)

Job summary

Altarum seeks a Business Technology Analyst to improve how we use data, automation, and AI to work more effectively. In this role, you will partner with teams across Altarum to translate needs into practical reporting, workflow, and technology solutions.

You will build dashboards, automate repetitive processes, support SharePoint and Microsoft 365 solutions, and help identify responsible, high-value uses for AI.

Qualifications

• Three to five years of experience in data analytics, business intelligence, business systems, reporting, process improvement, or a related area.
• Experience developing Power BI reports and dashboards.
• Experience using Excel, SQL, Power Query, or comparable data tools.
• The ability to analyze and validate data, investigate discrepancies, and clearly communicate findings.
• Experience gathering requirements and translating business needs into reports, workflows, or technology solutions.
• The ability to independently manage defined assignments or small projects from planning through delivery.
• Strong analytical, communication, organizational, and problem-solving skills.
• The ability to explain technical information clearly to nontechnical employees.
• Sound judgment when working with sensitive data and emerging technologies.
• Curiosity, adaptability, and the ability to independently learn and apply new tools.

Responsibilities

• Build and maintain Power BI reports, dashboards, and data models that support informed decision-making.
• Use Excel, Power Query, SQL, and related tools to prepare, analyze, and present business data.
• Partner with internal stakeholders to translate business questions and requirements into useful reporting solutions.
• Validate results, investigate discrepancies, and document data sources, calculations, and reporting logic.
• Support reporting that draws from systems such as Deltek Costpoint, UKG, SQL Server, and SharePoint.
• Identify opportunities to reduce manual work, streamline processes, and improve the employee experience.
• Build and maintain low-code workflows using Power Automate and related Microsoft tools.
• Develop practical solutions involving forms, approvals, notifications, data collection, and information sharing.
• Use approved AI tools to support analysis, research, documentation, and process improvement.
• Test AI-assisted workflows and evaluate outputs for accuracy, privacy, security, and appropriate use.
• Create reusable prompts, AI-assisted tools, and guidance for common business needs.
• Help employees understand and effectively use new automation and AI-enabled solutions.
• Configure and maintain SharePoint lists, libraries, pages, views, and basic permissions.
• Build straightforward solutions that support document management, workflows, collaboration, and information sharing.
• Troubleshoot common issues and maintain clear supporting documentation.
• Assist with the ongoing improvement and adoption of Microsoft 365 tools across the organization.

Skills

Data analytics

Business intelligence

Reporting

Process improvement

Communication

Education

Bachelor's degree

Tools

Power BI

Excel

SQL

Power Query

SharePoint

Microsoft 365

Job description

Altarum seeks a Business Technology Analyst to improve how we use data, automation, and AI to work more effectively. In this role, you will partner with teams across Altarum to translate needs into practical reporting, workflow, and technology solutions.

You will build dashboards, automate repetitive processes, support SharePoint and Microsoft 365 solutions, and help identify responsible, high-value uses for AI.