Data Analyst

At LERETA, we are committed to delivering accurate, efficient, and innovative tax and flood services to our clients. The Data Analyst will play a critical role in enhancing the capabilities of our Enterprise Data Warehouse (EDW) to better serve both internal stakeholders and external partners. The role is central to expanding our Business Intelligence (BI) and Advanced Analytics offerings through the identification of new opportunities and the development of data-driven solutions.

Key Responsibilities: 

• Contributes to the EDW Subject Area Knowledge Base
• Supports deep dives for Executive Committee
• Profile data looking for anomalies, bad keys, missing data, etc.
• Provides analytical support on all FP&A reporting projects
• Provides Product support for all work within Data Services
• Requirements gathering for datasets, reports, scorecards and more
• Supports reporting evolution at LERETA (from grid style to dashboarding)
• Serves as a true team member within the Agile framework

Core Competencies:

• Strong understanding of data structures, security, performance, optimization and usability
• Strong understanding of star schema and Kimball Dimensional Modeling
• Strong understanding of data modeling
• Strong understanding of Master Data Management (MDM) concepts
• Organized and strong documentation skills 

Required Education and Experience: 

• Bachelor’s in Computer Science or related fields
• 3+ years experience in data centric technology groups such as Data Services, Business Intelligence, Advanced Analytics, FP&A or Data Warehousing.
• Proficient in SQL syntax for data profiling and query writing for requirements
• 3+ years experience working with BI focused reporting tools such as PowerBI, Tableau, Domo, etc.
• Experience with MS 365 and additional MS Products
  • Microsoft AzDo (Dev Ops)
  • MS 365 / SharePoint

Preferred Education and Experience: 

• • Power Automate
  • Power Apps
  • Power Query

    Understanding of the Microsoft Power Platform 

Salary range: $68,437 - $80,000

Position may be remote or hybrid.