Altarum Institute

Business Technology Analyst - Data, Automation and AI

Altarum Institute$85K — $103K *
Novi, MI 48375In-Person
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Bachelor's degree in a related field or equivalent experience.
  • 3-5 years in data analytics, business intelligence, or process improvement.
  • Experience with Power BI, Excel, SQL, or similar tools.
  • Ability to analyze and validate data effectively.
  • Experience gathering requirements and creating reporting solutions.
  • Strong communication skills, especially for non-technical audiences.
  • Curiosity and adaptability in learning new tools.

Responsibilities

  • Build and maintain Power BI dashboards for decision-making.
  • Analyze business data using Excel, Power Query, SQL.
  • Translate business requirements into reporting solutions.
  • Verify data accuracy and document reporting logic.
  • Support reporting from Deltek Costpoint and SharePoint.
  • Identify and automate manual processes for efficiency.
  • Assist with SharePoint and Microsoft 365 configurations.

Benefits

  • Competitive medical, dental, and optical plans.
  • Generous paid time off and holidays.
  • Tuition assistance for further education.
  • 401K plan with employer contributions.
  • Life, AD&D, and disability coverage.
  • Flexible work environment with remote options.
Full Job Description


About the Role

Altarum is seeking a Business Technology Analyst to help improve how our organization uses data, automation, and artificial intelligence to work more effectively.

In this role, you will partner with teams across Altarum to understand their needs and turn them 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.

This is an ideal opportunity for someone with three to five years of experience in data analytics, business intelligence, business systems, reporting, or process improvement who enjoys solving business problems and learning new tools. While this is not a traditional software development role, you should be comfortable working with data and technology, managing defined assignments independently, and translating technical concepts for nontechnical colleagues.

What You'll Do

Data & Reporting
  • 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.

Automation and AI
  • 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.

SharePoint and Microsoft 365
  • 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.


What You'll Bring

  • A bachelor's degree in a related field or an equivalent combination of education and experience.
  • 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.


What Will Set You Apart

These qualifications are helpful but not required:
  • Experience with Power Automate, Power Apps, SharePoint, or another low-code platform.
  • Hands-on experience using generative AI for analysis, research, documentation, or workflow improvement.
  • Experience supporting Finance, Accounting, Human Resources, project management, or other corporate functions.
  • Familiarity with data governance, information security, privacy, or responsible AI practices.
  • Experience with Deltek Costpoint, UKG, Microsoft Fabric, or similar platforms.
  • Experience working in a nonprofit, healthcare, research, federal contracting, or other regulated environment.
  • Experience developing user guidance, documentation, or training for new technology solutions.


Where You'll Work

  • This position will be located in Novi, MI or Silver Spring, MD. If you're near one of our offices (Silver Spring, MD; or Novi, MI), you'll be Hybrid and will join us in person one day every other month (6 times per year) for a fun, purpose-driven Collaboration Day. These days are filled with creative energy, meaningful connection, and team brainstorming. You will be working remotely on the other days and may be asked to travel occasionally.
  • Non-local employees will join these days virtually and may be asked to join us occasionally in-person.


Work Eligibility & Requirements

  • Candidates must be currently eligible to work in the United States; sponsorship is not available.
  • All work must be performed within the continental U.S. for the duration of employment, unless required by contract.
  • Ability to work core hours aligned with Eastern Time, unless otherwise approved by your manager.
  • Remote employees must maintain a dedicated, ergonomically appropriate workspace free from distractions, with reliable internet and a mobile device that supports efficient work.
  • Travel Requirements:


$85,354 - $103,013.40 a year

At Altarum, we carefully consider a wide range of compensation factors and rely on market indicators to get it right. Individual compensation packages are based on numerous factors unique to each candidate, including skill set, experience, qualifications, and other job-related reasons. This salary range is not a guarantee of compensation, as the final offer amount will vary based on these factors.

In addition to base salary compensation, Altarum Enterprise employees enjoy the following benefits:

- Competitive Medical, Dental and Optical plans

- Generous Paid Time Off, 8 Company observed holidays plus 3 floating holidays

- Tuition Assistance

- 401K Plan (3% employer contribution plus opportunity for gainsharing)

- Life, AD&D & Disability coverage

- A flexible work environment and more!

About Altarum Institute

Altarum Institute is a nonprofit health systems research and consulting organization. It was founded in 1946 and is headquartered in Ann Arbor, Michigan. Altarum Institute works to improve health and healthcare by providing objective research and consulting services to government, nonprofit, and private sector clients. The organization focuses on a wide range of health-related topics, including healthcare delivery, public health, health policy, and health information technology. Altarum Institute is committed to advancing health equity and improving health outcomes for all people.
Learn more about Altarum Institute
Size
400 employees
Industry
Founded
1946

Similar Jobs

More Jobs at Altarum Institute

More Information Technology Jobs

Find similar Business Technology Analyst - Data, Automation and AI jobs: