For more information, please visit www.vibrantz.com and www.american-securities.com
Location
Houston, TX
Total Rewards
We offer comprehensive total rewards packages including base pay, variable incentive programs, 401K, medical, dental, vision, life & disability and variety of well-being resources that meet the needs of our diverse workforce. Union benefits are governed by the applicable collective bargaining unit agreement.
$15.07 - $18.84
Vibrantz is committed to maintaining pay transparency in accordance with applicable laws and best practices. Compensation for this position will be determined based on a combination of factors, including education, professional certifications, relevant experience, and other job-related considerations permitted by law.
Overview
We’re looking for curious, detail-minded interns who enjoy digging into data and finding answers people can act on. You’ll join our BI team to help build the reports and models the business relies on every day, using data from several ERP and business systems. Working alongside data engineers, analysts and business leaders, you’ll explore trends and develop solutions that go into production. Along the way, you’ll learn how our data is organized and contribute to initiatives that help leaders make informed decisions.
The role is hands-on and technical, spanning the full range of business intelligence, from data sourcing and modeling to reporting and analysis. It covers both modern tools and the established ones we still depend on. Your focus within that range will depend on your skills and interests. The internship lasts 6 months and is hybrid, with 1-2 days a week in the office (schedule may vary).
Responsibilities
Write and tune T-SQL queries, views, and stored procedures.
Develop Power BI reports and DAX measures on top of Microsoft Fabric, and help improve existing semantic models.
Maintain and troubleshoot existing SSIS packages, Fabric pipelines or notebooks. Help identify and plan enhancements or modernization.
Learn how data is structured in our ERP systems (SAP, IFS, Ross, Dynamics, etc.) and help bring it together for cross-system reporting.
Gather, clean, and validate data from multiple source systems, including checking data quality and helping reconcile master data across sources.
Take small projects from request to delivery: clarify what the requester needs, build a first version, gather feedback, and refine.
Help standardize GitHub-based version control across SQL, pipelines, and report assets, including repository structure and team workflows.
Document data sources, report logic, and refresh processes so others can pick them up.
Troubleshoot report, refresh, and data issues, and support users who run into them.
Monitor capacity, usage, and refresh performance, and flag problems early.
Walk business users through new reports and answer their questions.
Qualifications
What We’re Looking For
Pursuing a degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field, or equivalent self-directed learning and project work.
Ability to write SQL queries and procedures independently to retrieve, join, analyze and transform data. You should be able to talk through a query or data project you’ve worked on.
Understanding of relational database design, including keys, relationships, and how transactional data is organized (orders, inventory, finance, and similar).
Experience building reports or visualizations in Power BI, Tableau, or a comparable tool.
Strong analytical and problem-solving skills, including breaking down an unclear request or a data discrepancy and working it through to an answer.
Strong attention to detail, with the discipline to double-check your own work.
Genuine curiosity about how data and business processes connect, and a drive to dig into the “why” behind the numbers.
Strong written and verbal communication skills, including explaining technical work to non-technical users.
Strongly preferred
Experience working with ERP data or a large business system. Familiarity with SAP, IFS, Aptean Ross, or Microsoft Dynamics is especially valuable.
Power BI skills including DAX and Power Query.
Knowledge of Microsoft Fabric (Lakehouse, Warehouse, Dataflows, Pipelines, Notebooks).
Experience with SSIS or another ETL/ELT tool, and orchestrating scheduled jobs.
Exposure to data warehousing concepts and how data moves from source systems into reporting models.
Working knowledge of GitHub.
Python for data work, particularly pandas or PySpark.
Prior use of an AI assistant such as Claude or ChatGPT for analysis or coding.
You don’t need to match every item above. We value a solid understanding of data and BI principles, strong SQL skills, and the ability to contribute and learn quickly.
Vibrantz is committed to protecting your privacy. We provide a Website Privacy Policy located on our www.vibrantz.com site to explain the type of information we collect and inform you of the specific practices and guidelines that protect the security and confidentiality of your personal data. Please read that pocky carefully. If any term in the policy is unacceptable to you, please do not use the Website or provide any personal data. This policy may change from time to time (see Revisions to our Privacy Policy on www.vibrantz.com).
Vibrantz Technologies Inc. ("Vibrantz") is an equal opportunity employer and complies with all applicable federal, state, and local fair employment practices laws. Vibrantz strictly prohibits and does not tolerate discrimination against employees, applicants, or any other covered persons because of race, color, religion, cree, national origin or ancestry, ethnicity, sex gender, age physical or mental disability, genetic information, sexual orientation, or any other characteristics protected under applicable federal, state or local law.