Business Intelligence Architect - Kansas City, MO

Posted 15 Days Ago
Be an Early Applicant
Kansas City, MO
Senior level
HR Tech
The Role
Lead design and implementation of BI solutions, optimizing ETL processes, and mentoring junior team members while ensuring data integrity and compliance.
Summary Generated by Built In

Hillenbrand is advancing its Business Intelligence capabilities, and we’re looking for a BI Architect to lead the design and implementation of scalable, high-impact data solutions. In this role, you’ll shape the way we integrate and transform raw data into actionable insights, driving business strategy through robust data models, reports, and dashboards. You’ll oversee the full BI development lifecycle, optimize ETL processes, and ensure data integrity and security while mentoring junior team members and supporting key BI initiatives like POM and modernization. Your expertise in the Microsoft tech stack, Power BI, Azure, and data modeling will play a crucial role in enhancing analytics capabilities, accelerating BI programs, and empowering business users with the insights they need to make informed decisions.

Essential Duties and Responsibilities:

  • Design and architect scalable BI solutions that effectively integrate data from disparate IT source systems.
  • Collaborate with business stakeholders to gather requirements and translate them into technical specifications for BI architecture.
  • Oversee the development and optimization of ETL processes to ensure efficient data extraction, transformation, and loading.
  • Create and maintain data models that support reporting and analytics needs, ensuring data integrity and security.
  • Develop and implement dashboards and reports that provide actionable insights to business users.
  • Ensure compliance with data governance policies and best practices in data management.
  • Evaluate and recommend BI tools and technologies to enhance the organization’s analytics capabilities.
  • Participating in BI projects from conception to deployment, ensuring alignment with business objectives and timely delivery.
  • Mentor and provide technical guidance to junior BI team members and other stakeholders.
  • Stay updated on industry trends and emerging technologies in business intelligence and data analytics.

Education:

  • Bachelor’s degree in computer science, Information Technology, Data Science, or a related field

Experience Needed:

  • 5+ years of experience in business intelligence, data warehousing, or data architecture roles, specifically within the Microsoft tech stack.
  • Strong proficiency in Microsoft Power BI for data visualization and reporting.
  • Extensive experience with SQL Server, including SQL Server Integration Services (SSIS) for ETL processes and SQL Server Analysis Services (SSAS) for data modeling.
  • Familiarity with Azure Data Services, including Azure Data Factory for data integration and Azure SQL Database for cloud-based data storage.
  • Knowledge of data modeling techniques and methodologies (e.g., star schema, snowflake schema) within the Microsoft ecosystem.
  • Experience with cloud-based BI solutions and data storage (e.g., AWS, Azure, Google Cloud).

#LI-EP2
#LI-REMOTE

#IND123

Who we are: 
Hillenbrand (NYSE: HI) is a global industrial company that provides highly-engineered, mission-critical processing equipment and solutions to customers in over 100 countries around the world. Our portfolio is composed of leading industrial brands that serve large, attractive end markets, including durable plastics, food, and recycling. Guided by our Purpose — Shape What Matters For Tomorrow™ — we pursue excellence, collaboration, and innovation to consistently shape solutions that best serve our associates, customers, communities, and other stakeholders. To learn more, visit: www.Hillenbrand.com.
EEO: The policy of Hillenbrand Inc. is to extend opportunities to qualified applicants and employees on an equal basis regardless of an individual's age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity/expression or veteran status.  Additionally, Hillenbrand Inc. and our operating companies are committed to being an Equal Employment Opportunity (EEO) Employer and offers opportunities to all job seekers including individuals with disabilities.  If you need a reasonable accommodation to assist with your job search or application for employment, email us @[email protected] .  In your email, please include a description of the specific accommodation you are requesting as well as the job title and requisition number of the position for which you are applying.  At Hillenbrand, everyone is welcome to apply and "Shape What Matters for Tomorrow".

Top Skills

Azure
Azure Data Factory
Azure Data Services
Azure Sql Database
Microsoft Tech Stack
Power BI
SQL Server
Sql Server Analysis Services
Sql Server Integration Services
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Pittsburgh, PA
35 Employees
On-site Workplace
Year Founded: 2016

What We Do

Founded by Jessica Eberley in 2016, HRT Solutions’ mission is to ensure that every organization we partner with has a laser focus on its organization’s greatest asset: people. HRT Advisors work directly with your team to understand your mission, vision, and values. We make your priorities our priorities. Through this partnership we customize our service offerings to bridge gaps and develop solutions that are right for you. HRT Solutions service offerings include Recruiting Process Outsourcing, University Relations Outsourcing, and Human Resource Process Outsourcing.

Similar Jobs

Spectrum Logo Spectrum

Software Engineer VI

Information Technology • Internet of Things • Mobile • On-Demand • Software
St Louis, MO, USA
100000 Employees

Spectrum Logo Spectrum

Software Engineer VI

Information Technology • Internet of Things • Mobile • On-Demand • Software
St Louis, MO, USA
100000 Employees

Spectrum Logo Spectrum

BI ETL Developer II (AWS Redshift)

Information Technology • Internet of Things • Mobile • On-Demand • Software
St Louis, MO, USA
100000 Employees

JumpCloud Logo JumpCloud

Senior Software Engineer, Device Management - United States

Cloud • Information Technology • Security • Software
Easy Apply
Remote
8 Locations
800 Employees
140K-180K Annually

Similar Companies Hiring

Apploi Thumbnail
Software • HR Tech • Healthtech
New York, NY
126 Employees
Addition Wealth Thumbnail
HR Tech • Fintech • Financial Services
New York, NY
15 Employees
Personio Thumbnail
Software • HR Tech
Munich, DE
1800 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account