Technical Data Analyst

Lawley Services Inc•Buffalo, NY

13h•$51,498 - $85,830•Hybrid

About The Position

This role involves collaborating with Applications and IT teams to enhance functionality, analyze business needs, and maintain system documentation. The analyst will evaluate business processes, identify areas for improvement, and implement solutions. A key part of the role includes providing technical assistance to over 600 end-users and supporting the BI Developer with QlikView requests, including dashboards, reports, and user training. Responsibilities also encompass QlikView administration, optimizing dashboards and reports, data quality initiatives, and analyzing data from various sources like QlikView, Salesforce, Epic, Excel, and SQL. The analyst will work with end-users to gather reporting requirements, translate them into system specifications, and utilize data models for data transformation and script writing. A deep understanding of agency positions and critical software is essential, as is supporting software upgrades and changes.

Requirements

At least 3-5 years proven experience as a BI Developer or Data Analyst
Bachelor’s degree in related field or equivalent experience
Strong understanding of databases/database relationships including SQL
Advanced MS Excel skills a must!
Proven analytical and problem‐solving abilities
Positive attitude, even in a fast‐paced environment
Ability to effectively multi‐task, work quickly and efficiently
Strong analytical and critical thinking to evaluate data from multiple sources
Precise verbal and written communication skills

Nice To Haves

Epic, Salesforce and/or QlikView/QlikSense knowledge a plus
Financial background or experience in Accounting or Accounting Information Systems desirable

Responsibilities

Collaborate with Applications and IT Team to improve functionality, analyze business needs and create and maintain documentation of all systems across the footprint
Evaluate business processes, anticipating requirements, uncovering areas for improvement and developing and implementing solutions
Assist with supporting all current business applications including technical assistance to over 600 end users
Support BI Developer with internal QlikView requests such as dashboards, reports, and provide end user training
Administration of QlikView: adding/editing/disabling users; securing data and reports; troubleshooting technical issues under advisement of BI Developer
Optimize and maintain dashboards and reports for all systems, assist with data quality initiatives / cleanup and identify process improvement opportunities
Analyze data from multiple sources (QlikView, Salesforce, Epic, Excel, SQL) for report and dashboard requests, to determine best system for reporting and verify structure and quality of data to ensure report integrity and accuracy
Work with end users to gather specifications for data and report requirements and effectively translate end user reporting requirements into best system
Utilize and interpret data models including data transformation, generating QVDs and writing scripts
Develop understanding of each position in the agency and critical software and integrations used to support the position
Support software upgrades and software confirmation changes by reviewing release notes and implementing necessary database changes within multiple systems
Expand and grow in your role when supporting miscellaneous duties as requested
Continue QlikView, SQL, Epic and Salesforce education including various certifications