Data Analyst

About the role

The IT Data Analyst will document external data acquisition policies and procedures, define and document data needs and ad-hoc analysis requirements, identify business practice workflow and process issues, provide leadership and guidance to define system and process requirements, and design information systems and technologies.

Responsibilities

• Document external data acquisition policies and procedures
• Interface with other business units to define and document data needs and ad-hoc analysis requirements
• Identify business practice workflow and process issues and concerns
• Provide leadership and guidance to define system and process requirements that will optimize system performance and technology utilization by system users
• Design information systems and technologies that ensure access and transparency
• Develop, implement, organize, and maintain information and reports to document operational and financial performance
• Collaborate with the quality team, administrators, etc., to design the ad hoc and other relevant routine reports
• Maintain, store, map and analyze data in compliance with policies and procedures
• Coordinate with LAN and IT Security teams in order to utilize PGP encryption software and File Transfer Protocols
• Use software such as SAS, Access, and Excel to provide data mapping for integration using Business Objects, and SQL

Requirements

• Possess knowledge and experience in basic statistical concepts, identifying trends, business opportunities, and relevant issues
• Identify commonly-used demographics and databases, definitions of fields, and how data is entered and processed
• Have knowledge and experience in data mining/intelligence, statistically-valid analysis and measurement methodologies, packaging data, infographics, and other data display techniques, and report design options
• Have knowledge and experience in data interpretation and validation, Ad Hoc analysis/performance evaluation principles, common demographic data bases, SQL coding and report services, data warehouse design, web-based application design, PC skills (e.g. Microsoft Office, Word, Excel, PowerPoint, SAS, Access and Excel)
• Be able to work independently as well as a leadership role in creating process documentation and interfacing with other team members to obtain this information
• Have detailed-oriented, excellent interpersonal, oral and written communication skills, ability to handle multiple tasks, and problem solving and troubleshooting skills

Preferred Skills

• Solid knowledge in Microsoft Database architecture, including MS SQL Servers, Azure SQL, Azure Managed Instances
• Work experiences in Database administration, ensuring data availability, data quality, and security
• Extensive experience in database development, including design and developing databases, views, functions, and stored procedures
• Innovative - employ creativity to devise effective and efficient solutions
• Demonstrated critical thinking - including abilities in analysis and problem solving
• Experienced in "Systems Thinking" - the ability to break problems into manageable pieces, and to see how the pieces interact with one another and can be assembled into an integrated, functioning, "whole" system
• Excellent verbal and written communication capabilities
• Effective team player with strong emotional intelligence - self-awareness, confidence, ability to manage conflict, and empathy
• Passion for technology, with an ability to understand and assess new technologies, and their potential applicability to business needs in an efficient, effective manner

Experience Required

• Minimum of two (2) years of experience in processing, management, and retrieval of information
• Minimum of two (2) years of developing data integration processes including secure Web services and APIs
• Minimum of two (2) years of developing Microsoft Power Automate or Logic Apps or PowerApps
• Minimum of three (3) years of Database development experience with Microsoft SQL Server, Stored Procedures using T-SQL
• Minimum of two (2) years of developing data reports using Microsoft SSRS, PowerBI, Power BI Report Builder
• Minimum of two (2) years of DevOps experience

Education Required

This classification requires the possession of a bachelor’s degree in an IT-related or Engineering field. Additional qualifying experience may be substituted for the required education on a year-for-year basis.