Data Analyst

Hamilton Storage provides automation solutions to customers in life science and clinical research. The company develops modular, scalable systems that automate sample storage, management, and processing. Hamilton provides all the benefits of advanced automation without the complexity associated with installing, operating, and maintaining large-scale custom systems. Acquired in 2007, Hamilton Storage is headquartered in Franklin, Massachusetts, USA with R&D facilities co-existing in both Franklin, MA and Bonaduz, Switzerland. The decentralized R&D organization benefits both production and marketing and allows Hamilton to stay close to the local markets and respond quickly to market needs.

Hamilton Storage Technologies is looking for a Data Analyst who will be responsible for creating and managing PowerBi reports, backup support for API team and tier II IT support.  This role is an onsite position located in Franklin, MA

 

Responsibilities include: 

• Create and manage PowerBi reports

  • Report Generation
  • Report development
  • Report maintenance
  • Data Visualization
  • Data Analysis
  • Data Cleaning
  • SQL trimming
  • SQL Querying
  • Data Gathering
  • BI Cloud Connectivity and management
• API and SQL database Support
  • Supporting API integration
    
  • Troubleshooting API issues
    
  • Remote Support
    
  • Database repair
    
  • Database trimming
    
  • Database management
    
  • SMTP configuration
• Level II IT ServiceDesk
  • Client support
    
  • Advanced troubleshooting
• Application Administration
  • Software deployment
    
  • License assignment
    
  • Application support
    
  • Application troubleshooting

Job may include up to 20% travel, foreign and domestic

• Proficient in Microsoft Office Suite
• Proficient in PowerBi
• Expert in SQL databases, queries and management
• Experience in RDP tools/Teamviewer
• Familiarity with Database structures
• Familiarity with Microsoft Dynamics 365 ERP
• Familiarity with Windows Licensing (Preferred)
• Familiarity with Always on availability clusters (preferred)
• Familiarity with ITSM/ServiceNow (Preferred)
• Familiarity with Virtualization (Preferred)
• Communication Skills
• Analytical Thinking
• Attention to detail
• Statistical knowledge

• 2+ (5 preferred) years’ experience in Information technology, Software development or data analysis (preferred)
• Bachelors degree in Computer information systems, Management information systems, data analytics, software engineering or computer science
• Must be eligible to work in the US

• Established, stable, and reliable company.
• Comprehensive benefits package: medical, dental, vision insurance; paid vacation and sick time; disability insurance; 401(k); tuition reimbursement; and more.
• Engaging and innovative design projects.
• Strong opportunities for professional growth.
• Commitment to sustainable design practices.
• Personal Protective Equipment (PPE) may be required (provided by employer).
• Drug and background screenings required.