Data, AI & Automation Analyst — Business Tech

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

Benefits offered by this job

Medical, Dental, Optical plans

Paid time off & holidays

Tuition assistance

401K with gainsharing

Life/AD&D & Disability

Flexible work environment

Job summary

Altarum Institute in Novi, MI (Hybrid) seeks a Business Technology Analyst to turn data into practical reporting, automation, and AI solutions. You’ll build dashboards, automate processes, and support SharePoint and Microsoft 365.

With 3–5 years in data analytics or BI, you’ll translate requirements into reports and workflows, validate data, and help colleagues adopt new tools, driving efficient business outcomes.

Qualifications

• Bachelor’s degree or equivalent combination of education and experience.
• Three to five years of experience in data analytics, business intelligence, business systems, reporting, or process improvement.
• Experience developing Power BI reports and dashboards.
• Experience using Excel, SQL, Power Query, or comparable data tools.
• Ability to analyze and validate data and communicate findings clearly.

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 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

Power BI

Excel

SQL

Analytical thinking

Communication

Problem solving

Education

Bachelor's degree or equivalent

Tools

Deltek Costpoint

UKG

SQL Server

SharePoint

Microsoft 365

Job description

Altarum Institute in Novi, MI (Hybrid) seeks a Business Technology Analyst to turn data into practical reporting, automation, and AI solutions. You’ll build dashboards, automate processes, and support SharePoint and Microsoft 365.

With 3–5 years in data analytics or BI, you’ll translate requirements into reports and workflows, validate data, and help colleagues adopt new tools, driving efficient business outcomes.