Interns at the Rock Family of Companies gain priceless hands-on experience. Here, they learn how it feels to be in the workplace, participate in events and become a valuable member of our team. We are seeking a curious, analytically minded, and technically driven Data Analyst & Engineer Summer Intern to join our Data Engineering & Analytics team during a pivotal period of platform modernization. This hybrid role blends data engineering fundamentals with hands-on analytics, giving the intern a unique opportunity to both build the data infrastructure and extract actionable insights from it. The intern will play an active role in our organization's migration to Microsoft Fabric, working alongside data engineers, data scientists, and internal business clients to transition legacy reporting assets, build modern data pipelines, leverage AI tools to surface business insights, and help establish a scalable, well-governed data platform. This is an ideal role for someone who wants to develop skills across the full data value chain — from ingestion and transformation through analysis and storytelling. About the role - Report & Dashboard Migration. - Migrate existing Tableau dashboards and SQL Server Reporting Services (SSRS) reports into Power BI, ensuring visual accuracy, data integrity, and alignment with business requirements. - Work with internal clients and report owners to validate migrated dashboards, gather feedback, and implement refinements. - Document report mapping and transformation logic to maintain a clear audit trail throughout the migration process. - Data Pipeline Development & Monitoring. - Build, test, and deploy data pipelines within Microsoft Fabric to connect new and existing data sources across the organization. - Implement data ingestion and transformation workflows following the medallion architecture (Bronze, Silver, Gold layers), ensuring data is properly staged, cleansed, and enriched at each tier. - Write and optimize SQL queries and PySpark scripts to support data transformation, quality checks, and pipeline logic. - Set up automated alerts and monitoring to track data load status, detect pipeline failures, and flag data quality issues in near real time. - Design and implement outlier detection mechanisms to proactively identify anomalous data points, unexpected volume shifts, or deviations from established patterns before they impact downstream reporting and analytics. - Perform unit testing and data validation to ensure pipeline outputs meet accuracy, completeness, and timeliness standards. - Analytics & AI-Driven Insight Generation. - Leverage AI-powered analytics tools to help internal business clients distill insights from complex datasets, including identifying meaningful patterns, explaining underlying reasons and trends, and surfacing actionable findings. - Apply statistical methods and AI-assisted analysis to detect correlations, segment data, and uncover drivers behind key business metrics. - Translate analytical findings into clear, compelling narratives and visualizations that enable stakeholders to make informed decisions quickly. - Collaborate with business clients to understand their analytical questions, frame hypotheses, and deliver data-driven answers that go beyond surface-level reporting. - Explore and evaluate emerging AI tools and techniques for their potential to enhance the team's analytics workflows and accelerate time-to-insight. About you - Currently pursuing a Bachelor's (Senior or Junior Level) or Master's degree in Data Science, Computer Science, Statistics, Mathematics, Engineering, or a related quantitative field. - Intermediate Experience with Tableau, SQL and Power BI. What you’ll get Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We’ve got your back. Check out our full list of Benefits and Perks. About us We are Xome, a subsidiary of Rocket, and a leading innovator in the real estate industry, committed to transforming the way people buy and sell homes. Our company headquarters is in Lewisville, Texas. We leverage cutting-edge technology to streamline the real estate process, making it more transparent, efficient, and user-friendly. Our platform connects buyers and sellers directly, offering comprehensive property data, seamless real estate auction transaction capabilities, and expert support to ensure a smooth experience from start to finish. Now, you might be wondering; how exactly do you pronounce Xome? Simple. ZOM (like home, if it started with a z)! This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the company at any time. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state or federal law. The company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team, at Careers@Rocket.com. Illinois, Maryland, Minnesota, Massachusetts, Colorado, Cleveland, New York City, New Jersey, Jersey City, California, D.C and Washington Candidates only: the compensation for this position is $10.23-$27.82. The position may also be eligible for an annual bonus, incentives, and other employment-related benefits including, but not limited to, medical, dental, and vision benefits, 401K retirement plan, and paid-time off. More information regarding these benefits and others can be found here. The information regarding compensation and other benefits included in this paragraph is the company’s current, good faith estimate at the time of posting. [Compensation and benefits are subject to modification from time to time as the Company, in its sole and exclusive discretion, deems appropriate.] The Company may determine during its future reviews of the proposed compensation and benefits provided for this position, that the compensation and benefits for such position should be reduced. In no event will the Company reduce the compensation for the position to a level below the applicable jurisdictional minimum wage rate for the position. Los Angeles County and San Francisco Candidates only: qualified applicants with arrest or conviction records will be considered for employment per the Fair Chance Ordinance and the Fair Chance Initiative for Hiring.

• Leveraging criminal justice datasets to generate context-responsive insights that expand momentum for policy reform • Adapting analytical methods to evidence detailed policy concepts and quantify policy-design tradeoffs • Contextualizing and communicating key findings to internal and external stakeholders • Collaborating with our Data Science and Implementation Engineering teams to design and execute on targeted roadmaps that drive impact in the states where we work • Collaborating with our Product Management and State Engagement teams to bring analyses and data modeling into administrative and legislative policy processes

• Translate group-level strategy into practical delivery models aligned with business goals and stakeholders commitments • Design and maintain scalable data models that unify disparate data sources into a 'single source of truth.' • Build and oversee sophisticated BI dashboards that monitor organizational KPIs and operational health • Partner with Finance, Product, and Delivery teams to perform exploratory analysis • Act as the 'guardian' of data quality • Identify opportunities to automate manual data collection and reporting tasks

• Collect and analyze supply chain data. • Recommend improvements to boost performance and reduce costs. • Coordinate with other professionals to implement changes and new systems. • Interpret data, analyze results using statistical techniques and provide ongoing reports • Develop and implement databases, data collection systems, data analytics and other strategies that improve statistical efficiency and quality • Acquire data from primary or secondary data sources and maintain databases/data systems • Identify, analyze, and interpret trends or patterns in complex data sets • Filter and “clean” data by reviewing reports, and performance indicators • Work with management to prioritize business and information needs • Locate and define new process improvement opportunities