INTERNSHIP DETAILS

IT Intern - Security Analytics & Data Management

CompanyASSA ABLOY
LocationNew Haven
Work ModeOn Site
PostedMay 27, 2026
Internship Information
Core Responsibilities
The intern will develop an IT Security Metrics Dashboard using Power BI and perform cleanup for the Configuration Management Database (CMDB). Additionally, they will support Customer Master Data Management (MDM) by cleansing and reconciling customer records.
Internship Type
full time
Company Size
12713
Visa Sponsorship
No
Language
English
Working Hours
40 hours
Apply Now →

You'll be redirected to
the company's application page

About The Company
Let’s create a safer and more open world – together! ASSA ABLOY is the global leader in access solutions with sales of SEK 150 billion and 63,000 employees. The Group has operations in over 70 countries and sales worldwide. ASSA ABLOY’s innovations enable safe, secure and convenient access to physical and digital places. Every day, we help billions of people experience a more open world.  We have a feeling of discovery and urge to innovate by working together and telling it like it is, enabling us to be always growing, never boring and leading right. Do you want to be encouraged to act, have responsibilities to grow with and opportunities to explore? Join us!
About the Role

     

 

We are seeking a motivated and detail-oriented IT Intern to support our Information Technology team across three high-impact initiatives. This is a hands-on internship designed for a college student looking to gain real-world experience in IT security analytics, data governance, and enterprise systems management. You will work directly with senior IT professionals and contribute to projects that have measurable impact on the organization's security posture and operational efficiency.

This internship will be based onsite at our ASSA ABLOY Americas headquarters location in New Haven, CT. Candidates must be able to work onsite during the hours of 8:30-5:00. 

Key Responsibilities

IT Security Metrics Dashboard (Power BI)

  • Assist in the design, development, and maintenance of an IT Security Metrics Dashboard using Microsoft Power BI
  • Collaborate with the security team to identify key performance indicators (KPIs) and relevant data sources
  • Connect, transform, and model data from multiple systems to produce accurate, actionable visualizations
  • Document data sources, report logic, and dashboard usage guidelines

Configuration Management Database (CMDB) Cleanup

  • Audit existing CMDB records to identify duplicates, outdated entries, and missing attributes
  • Work with IT infrastructure and operations teams to validate and reconcile asset data
  • Assist in establishing and documenting data quality standards and remediation procedures
  • Support ongoing CMDB governance processes to ensure long-term data accuracy

Customer Master Data Management (MDM) Cleanup

  • Assist in reviewing and cleansing customer master data records to ensure completeness and accuracy
  • Identify and help resolve duplicate, inconsistent, or incomplete customer records
  • Collaborate with business stakeholders to understand data requirements and validation rules
  • Support data migration, deduplication, and enrichment efforts as needed

Qualifications

  • Currently pursuing a Bachelor's degree in Information Technology, Computer Science, Information Systems, Data Analytics, or a related field
  • Familiarity with Microsoft Power BI or similar data visualization tools (coursework or personal projects acceptable)
  • Basic understanding of database concepts, data quality principles, or IT asset management
  • Strong analytical and problem-solving skills with a high attention to detail
  • Proficient in Microsoft Excel; experience with SQL or data querying is a plus
  • Excellent written and verbal communication skills
  • Ability to work both independently and collaboratively in a fast-paced environment
  • Eagerness to learn and take ownership of assigned tasks

Preferred Skills

  • Exposure to ITIL frameworks or ITSM platforms (e.g., ServiceNow)
  • Understanding of data governance or MDM concepts
  • Experience with any ETL or data integration tools
  • Familiarity with IT security concepts and frameworks (e.g., NIST, CIS Controls)

We review applications regularly, so don’t hesitate, apply today!

 

 

#LI-EL1

#LI-OSA

 

 

We are the ASSA ABLOY Group
Our people have made us the global leader in access solutions. In return, we open doors for them wherever they go. With nearly 63,000 colleagues in more than 70 different countries, we help billions of people experience a more open world. Our innovations make all sorts of spaces – physical and virtual – safer, more secure, and easier to access. 

As an employer, we value results – not titles, or backgrounds. We empower our people to build their career around their aspirations and our ambitions – supporting them with regular feedback, training, and development opportunities. Our colleagues think broadly about where they can make the most impact, and we encourage them to grow their role locally, regionally, or even internationally.

As we welcome new people on board, it’s important to us to have diverse, inclusive teams, and we value different perspectives and experiences.

Key Skills
Power BIData VisualizationCMDBMaster Data ManagementSQLMicrosoft ExcelData GovernanceIT Security AnalyticsData ModelingIT Asset ManagementAnalytical SkillsProblem Solving
Categories
Data & AnalyticsTechnologySecurity & SafetySoftware
Benefits
TrainingDevelopment OpportunitiesRegular Feedback