Technical Data Analyst – Buffalo, NY (Hybrid)

Lawley

Buffalo (NY)

Hybrid

USD 51,000 - 86,000

Full time

7 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Competitive benefits
Generous PTO & holidays
Paid parking
Hybrid schedules

Job summary

Lawley seeks a Technical Data Analyst in Buffalo, NY, hybrid work arrangement. You will participate in the creation and maintenance of QlikView dashboards and related BI solutions, collaborating with the Applications Team to analyze business needs and deliver data-driven insights.

The ideal candidate has 3–5 years as a BI Developer or Data Analyst, strong SQL and Excel skills, and knowledge of Epic/Salesforce is a plus. The role offers competitive benefits and a supportive team culture.

Qualifications

  • 3–5 years as BI Developer or Data Analyst with strong SQL and data modeling.
  • Bachelor’s degree in a related field or equivalent experience.
  • Solid understanding of databases and SQL, plus advanced Excel skills.
  • Experience with Epic, Salesforce and QlikView/QlikSense is a plus.
  • Strong analytical and problem-solving abilities with clear communication.

Responsibilities

  • Collaborate with Applications and IT to analyze business needs and document systems.
  • Evaluate processes, implement improvements, and support BI dashboards and reports.
  • Support end users and provide technical assistance for BI tools.
  • Develop and maintain QlikView dashboards, reports, and data models.
  • Translate end-user requirements into effective data/report solutions.

Skills

BI/Data Analyst
SQL
Excel
QlikView/QlikSense
Epic/Salesforce
Data visualization

Education

Bachelor’s degree or equivalent

Tools

QlikView
QlikSense
Salesforce
Epic
SQL
Excel

Job description

Technical Data Analyst – Buffalo, NY (Hybrid)

Lawley is hiring a Technical Data Analyst developer in our Buffalo, NY office! This position is responsible for participation in the establishment and implementation of new and/or revised QlikView applications and other programs in coordination with our Applications Team. We are looking for a highly communicative professional that will also provide technical analysis or requirement, front and back-end development, testing, deployment and sustainment. Lawley is a family-owned organization with strong core values. We offer competitive benefits, generous PTO and holiday time, paid parking and more.

Fundamental Components of the Job:
  • 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

Other functions of the job:

  • Expand and grow in your role when supporting miscellaneous duties as requested
  • Continue QlikView, SQL, Epic and Salesforce education including various certifications
Skills/Traits That We Value for This Role:
  • 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!
  • Epic, Salesforce and/or QlikView/QlikSense knowledge a plus
  • 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
  • Financial background or experience in Accounting or Accounting Information Systems desirable
  • Precise verbal and written communication skills
What’s in It for You?

A bit about Lawley!

  • We are not a call center environment
  • We achieve success by building genuine relationships together, with our teams and clients
  • We are a family owned insurance broker (70+ years!)
  • We are deeply committed to the communities we serve and love to get involved
  • We work hard and play hard!!!

Why Lawley?

  • Competitive salary and referral bonuses!
  • Expansive Benefits (Medical, Dental, Vision—and SO many more)
  • 3 weeks of PTO (prorated based on start date) AND a generous holiday schedule – available 1 st day!
  • Company 401K contribution received starting Day 1 (for participants 21+ years old)
  • Educational support, career development, and growth opportunities
  • Job Security (we’ve never had a lay-off, even during the pandemic)
  • Flexibility, including hybrid schedules! Business hours 8am-4:30pm
  • Comfortable, family-oriented culture, with an emphasis on work life balance
  • Unlimited Volunteer Time Off opportunities (so you can assist in serving our communities)
  • Fulfilling opportunities that align with your career path and our business needs

The compensation range for this position takes many factors into consideration including but not limited to: years of experience/training, skill set, and licenses/designations. It is not typical for an individual to be hired near the top of the range for a position as circumstances and location can vary in every hiring situation. A reasonable estimate of the current range is $51,498.15 to $85,830.25.

Lawley is a dynamic, independent regional firm of insurance professionals specializing in property and casualty, employee benefits and risk management consulting. We protect assets and minimize risk to help our clients avoid hardship. We strive to be the partner of choice built on a foundation of trust. We have been successful because of our values and our ability to offer Lawley caliber service!We are a sales organization that prides itself on our core values, including:

  • Relationship building
  • Respect and integrity
  • Passion
  • Accountability
  • Commitment to our Community
Wellness At Lawley

At Lawley, the Lawley Strong Wellness Program offers and implements innovative, best-practice wellness initiatives to enhance and improve overall health and well-being of our associates. The culture at Lawley will include living a healthy lifestyle with regard to all dimensions of wellness. Associates are encouraged to take health education and skills learned back to the home in order for family members to also live a healthy lifestyle.

Lawley provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.

Lawley provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Employee Benefits Operations Analyst- Buffalo, NY (Hybrid)
Employee Benefits Operations Analyst- Buffalo, NY (Hybrid)

Lawley • Buffalo (NY)

Hybrid
USD 45,000 - 73,000
Competitive salary
Expansive Benefits
3 weeks PTO
+3
Corporate Wellness Consultant- Buffalo, NY (Hybrid)
Corporate Wellness Consultant- Buffalo, NY (Hybrid)

Lawley • Buffalo (NY)

Hybrid
USD 51,000 - 86,000
Health benefits
Paid time off
Hybrid schedule
+2
Employee Benefits Client Relationship Manager- Mahopac, NY or Connecticut
Employee Benefits Client Relationship Manager- Mahopac, NY or Connecticut

Lawley • Mahopac (NY)

Hybrid
USD 72,000 - 120,000
Competitive salary
Generous benefits
PTO and holidays
+2
Commercial Insurance Assistant Account Manager (Hybrid to Florham Park, NJ)
Commercial Insurance Assistant Account Manager (Hybrid to Florham Park, NJ)

Lawley • Florham Park (NJ)

Hybrid
USD 45,000 - 63,000
Competitive salary
Referral bonuses
Expanded benefits
+7
Medical Professional Liability Marketer & Account Manager- Buffalo, NY (Hybrid or Remote)
Medical Professional Liability Marketer & Account Manager- Buffalo, NY (Hybrid or Remote)

Lawley • Buffalo (NY)

Hybrid
USD 67,000 - 112,000
Benefits package
Hybrid/Remote flexibility
Paid parking
+2
Commercial Insurance Account Technician- Buffalo, NY (Hybrid)
Commercial Insurance Account Technician- Buffalo, NY (Hybrid)

Lawley • Buffalo (NY)

Hybrid
USD 51,000 - 86,000
Competitive benefits package
Medical, Dental, Vision
3 weeks PTO
+5
Retirement Sales / Financial Advisor – Connecticut
Retirement Sales / Financial Advisor – Connecticut

Lawley • Connecticut

Hybrid
USD 85,000 - 141,000
Hybrid schedules
Medical, dental, vision benefits
401K starting Day 1
+3
Insurance Advisor – Farm and Crop – Batavia, NY
Insurance Advisor – Farm and Crop – Batavia, NY

Lawley • City of Batavia (NY)

On-site
USD 57,000 - 101,000
Commission-based earnings
Residuals potential
Ownership in book of business
+1
Insurance Producer/Advisor – Florham or Parsippany, NJ
Insurance Producer/Advisor – Florham or Parsippany, NJ

Lawley • Florham Park (NJ)

On-site
USD 85,000 - 141,000
Competitive salary
Educational support
401K starting Day 1
+2
Medicare and Individual Health Consultant (Genesee or Orleans County)
Medicare and Individual Health Consultant (Genesee or Orleans County)

Lawley • New York (NY)

On-site
USD 85,000 - 141,000
Competitive salary
Referral bonuses
Extensive benefits (Medical, Dental, V
+3