Back to jobs

Business Intelligence (BI) Solutions Lead

Houston, Texas, United States

48forty Solutions is the largest pallet management services company in North America. We provide end-to-end pallet solutions, from supply to retrieval, on-site services, reverse logistics, and packaging materials. 48forty Solutions is truly Pallet Management Made Simple. Our operations workforce is the heart and soul of our business. We are currently looking for a Business Intelligence Solutions Lead to join our IT team!

Summary

As a Business Intelligence Solutions Lead, you will be crucial in collecting, processing, designing, analyzing, and visualizing data to provide actionable insights. You will play a vital role in shaping data models and reporting systems to enhance data accessibility and bring innovative methods to optimize Power BI semantic models and reports performance. You will work closely with executive leadership, IT, and other departments to ensure data integrity and optimize data systems and reports delivery models. Your data analysis and Power BI development expertise will drive informed decision-making and enhance business operations.

Essential Duties and Responsibilities

  • Work with management to prioritize business and information needs.
  • Collect, clean, interpret, and validate data from various sources.
  • Collaborate with IT and other departments to ensure the integrity of the data systems and to translate complex data requirements into optimized, scalable dimensional models that support operational and integrated reporting.
  • Present data findings to management and other stakeholders.
  • Develop and implement data collection systems and strategies that optimize statistical efficiency and data quality.
  • Create logical and physical data models for enterprise-wide data warehouse initiatives.
  • Leverage and regularly update data modeling tools (Visio, Erwin, etc.) to create efficient and scalable data models.
  • Develop data mapping documents to trace data flows and lineage across systems.
  • Conduct ad hoc analysis, answering specific business questions or provide support in solving data pipeline related challenges.
  • Prepare reports for executive leadership that effectively communicate trends, patterns, and predictions using relevant data.
  • Design and maintain data systems and databases, including fixing coding errors and resolving data-related issues.
  • Create visualizations and dashboards to make complex data more accessible, understandable, and actionable using Power BI.
  • Provide support to team members and other departments in the use of data analysis tools and methods.
  • Acquire, transform, and model data from various sources to create a unified dataset suitable for analysis.
  • Use Power Query within Power BI Desktop to perform ETL (Extract, Transform, Load) operations, clean and shape data, and establish relationships between different data tables.
  • Select appropriate data visualizations such as charts, graphs, maps, and tables to represent insights effectively.
  • Implement features like slicers, filters, bookmarks, and drill-through actions to enhance user interactivity and navigation.
  • Leverage analytical skills to explore data, identify trends, patterns, and anomalies, and extract actionable insights.
  • Apply statistical functions, advanced calculations, and machine learning algorithms within Power BI to uncover valuable business insights.
  • Publish reports to the Power BI service, manage access permissions, configure data refresh schedules, and set up data-driven alerts.
  • Collaborate with stakeholders by sharing reports, dashboards, and datasets via the Power BI service or embedding them into other applications.
  • Engage in custom development activities, such as creating custom visuals, implementing custom data connectors, or developing custom solutions using Power BI Embedded or Power BI APIs to address specific business requirements.

Qualifications and Skills

  • Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field.
  • 5 or more years of experience as a Business Intelligence Lead, with a strong background in data warehousing and dimensional modeling.
  • Strong experience working across cloud environment such as Azure/AWS/GCP and cloud databases such as SQL Server/Snowflake/Google Big Query/RedShift.
  • Proficiency in data modeling tools (such as Visio, Erwin) to design efficient, scalable data models.
  • Advanced SQL/PLSQL skills, capable of conducting complex ad hoc analysis and supporting data-driven decision-making.
  • Understanding of Spark SQL or Python languages is plus
  • In-depth knowledge of Power BI, including Power Query, DAX, and Power BI Service, to create interactive, visually engaging reports and dashboards.
  • Working knowledge on advanced data analysis utilizing Statistics and its methods

 Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions. 

  • The employee will be working at the corporate office and will be required to sit for long periods of time at a desk working on a laptop
  • The noise level in the work environment is usually moderate

Benefits  

  • Competitive Pay 
  • Holiday Pay
  • Referral Bonuses
  • Long-Term Career Advancement  
  • Great Team Environment
  • PTO
  • Full-time employees eligible for Medical, Dental, Vision, Basic Life, AD&D and Short-Term & Long-Term Disability insurance on the 1st of the month following 60 days of employment  

 

48forty Solutions is an equal opportunity employer. 

 

Salary is dependent on experience and can shift; however, this is our starting target range.

Targeted Salary Range

$150,000 - $175,000 USD

Apply for this job

*

indicates a required field

Resume/CV*

Accepted file types: pdf, doc, docx, txt, rtf

Cover Letter

Accepted file types: pdf, doc, docx, txt, rtf

Education

Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...
Select...

Voluntary Self-Identification

For government reporting purposes, we ask candidates to respond to the below self-identification survey. Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

As set forth in Salary Openings’s Equal Employment Opportunity policy, we do not discriminate on the basis of any protected group status under any applicable law.

Select...
Select...
Race & Ethnicity Definitions

If you believe you belong to any of the categories of protected veterans listed below, please indicate by making the appropriate selection. As a government contractor subject to the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA), we request this information in order to measure the effectiveness of the outreach and positive recruitment efforts we undertake pursuant to VEVRAA. Classification of protected categories is as follows:

A "disabled veteran" is one of the following: a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or a person who was discharged or released from active duty because of a service-connected disability.

A "recently separated veteran" means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.

An "active duty wartime or campaign badge veteran" means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.

An "Armed forces service medal veteran" means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.

Select...

Voluntary Self-Identification of Disability

Form CC-305
Page 1 of 1
OMB Control Number 1250-0005
Expires 04/30/2026

Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Select...

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.