What are the responsibilities and job description for the Data Analytics Intern position at Hillpointe?
WHY HILLPOINTE? Hillpointe is a fully integrated real estate development and investment management firm focused on developing market-rate workforce housing across the Sun Belt. Ranked at the top of NMHC's list of Builders and Developers, our team ensures best-in-class execution.
Built on its long and proven track record of real estate development, the firm’s investment approach is centered around its in-house general contracting expertise, enabling direct control of cost and delivery timeframe. For each project, Hillpointe directly controls land acquisition, land development, construction, procurement of building materials, asset management, and capital markets. This is more than just a job - it's a career-defining opportunity! At Hillpointe, you'll be part of a dynamic, innovative team that has tangible impacts on day-to-day operations and contributes directly to overall success.
Data Analytics InternThe Data Analytics Intern will support our team in building and maintaining the data infrastructure that powers reporting and analytics across the organization. This role offers exposure to database design, data integration, and modern cloud platforms. The ideal candidate is technically curious and passionate about building clean, scalable data systems.
KEY RESPONSIBILITIES
- Assist in designing and maintaining data models that serve as the foundation for Power BI dashboards and reports
- Build and optimize semantic models, relationships, and calculated measures to support self-service reporting
- Write and refine SQL queries to extract, transform, and validate data feeding into reporting layers
- Support the development of data pipelines that consolidate information from multiple operational systems
- Respond to ad hoc reporting and data requests from leadership, asset management, operations, and finance teams
- Perform data quality checks and troubleshoot discrepancies between source systems and reports
- Assist in building and maintaining Power BI workspaces, datasets, and refresh schedules
- Research best practices in report performance optimization, data modeling, and platform scalability
QUALIFICATIONS
Required
- Currently pursuing or recently completed a degree in Computer Science, Data Science, Information Systems, or a related field
- Experience with SQL and relational database concepts
- Basic understanding of data modeling principles
- Familiarity with Power BI or similar visualization tools
- Strong attention to detail and organizational skills
- Effective communication skills with the ability to explain data concepts to non-technical audiences
- Ability to work in a collaborative, fast-paced environment
Preferred
- Exposure to DAX, Power Query, or semantic model development
- Familiarity with cloud data platforms or modern analytics tools
- Basic experience with Python or scripting for data tasks
- Interest in data warehousing, Lakehouse architecture, or ETL/ELT concepts
- Prior experience through internships, academic projects, or bootcamps