Data Analyst I

Title: Data Analyst I – Enterprise Software Support

Reports To: Software Solutions Manager

Summary:

The Information Technology Department manages the infrastructure that drives the organization’s technology-based business solutions. These are in support of the Headquarters in Long Island City, NY and approximately 20 administrative and logistics locations in the Americas and Asia.

The Data Analyst I – Enterprise Software Support provides business intelligence solutions, via platforms like Power BI and Phocas, to internal stakeholders. Provides robust understanding of data architectures, table structures, and marrying data from different sources to provide key discission making capabilities to company management and other invested parties. Strong knowledge of SQL and other databases, including MultiValue databases. Database and dataset management and optimization will be leveraged to deliver successful business results.

Responsibilities:

• Design, develop, and support Power Bi reports including for ERP and connected services.
• Meet with stakeholders and translate their challenges regarding data analysis to support their discissions into actionable live dashboards and point-in-time reports.
• Use Excel and PowerPivot and Power Query to mock-up/model full, robust dashboards for larger data sets.
• Also, for providing quick solutions for appropriately scoped tasks.
• Act as the IT Department’s dedicated business intelligence liaison for internal stakeholders and help translate requests for data insight from the business to fellow IT team members.
• Join data from disparate sources, potentially including public sources such as US Census Bureau data and others from data.gov and others.
• Manage, organize and optimize databases and related data structures and sources.
• Keep all associated stakeholders fully informed by collecting, organizing, and appropriately distributing information such as meeting minutes, design concepts, approval/rejections of applicable action items, project stages, and generally collect and organize feedback from business stakeholders into useful documents.
• Create and maintain robust documentation for dashboards and liaise with and guide stakeholders on how to use developed BI dashboard solutions.
• Good understanding of relationship between measures, targets, data sources, performance indicators, key performance indicators and reporting frequency.
• Some exposure to Android and iOS as they are used for the company’s warehouse barcode scan guns.

Qualifications:

· Expert working knowledge of Microsoft Power BI and some experience with Phocas BI and FP&A desired.

· Expert working knowledge of Microsoft Excel.

· Strong working knowledge of databases, particularly SQL and other relational databases and database design, data migration/transformation, and some database administration and optimization.

· Experience with ERP, CRM and eCommerce.

· Knowledge of MultiValue and other NoSQL databases are a major plus.

· Robust understanding of ETL.

· Preferred additional technology exposure: SharePoint, Microsoft Windows, Microsoft Office365, Power Platform tools like Power Apps and Power Automate in a business intelligence role.

· Knowledge and experience with customer service best practices.

· Work with supply chain, warehouse management, or transportation business domains a plus.

· Exposure to Android and iOS used for warehouse scan guns a major plus.

· Fluent English skills, written and verbal.

· Dependable means of transportation.

Education, Experience, Licenses, and Certifications:

· Bachelor’s degree in technology, data analytics, or related field and/or previous equivalent job experience.

Hardware Specialty Co., Inc. does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, political affiliation, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status, military service, or other non-merit factor.

Job Type: Full-time

Pay: $60,000.00 - $65,000.00 per year

Benefits:

• Dental insurance
• Health insurance
• Paid holidays
• Paid sick time
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday
• No weekends

Application Question(s):

• What is your salary expectations?

Ability to Commute:

• Marlborough, MA 01752 (Preferred)

Ability to Relocate:

• Marlborough, MA 01752: Relocate before starting work (Required)

Work Location: In person

Salary : $60,000 - $65,000