Data Analyst

About the Opportunity

We are seeking a highly skilled Data Analyst to join our team at The Greentree Group. As a Data Analyst, you will have the opportunity to work with cutting-edge technologies and collaborate with a talented team of professionals in support of a client in the Tallahassee, FL area.

This role will serve as the principal line of communication for the project team in a state-wide implementation effort. You will be responsible for implementing data modeling and design techniques to build scalable and efficient data structures to meet the Departments accounting and budgeting reporting needs.

Key Responsibilities:

Implement data modeling and design techniques to build scalable and efficient data structures to meet the Departments accounting and budgeting reporting needs.

Design and create data dashboards, visualizations, and reports using Power BI, providing critical insights to stakeholders.

Troubleshoot any issues that arise in the data warehouse and implement solutions.

Collaborate with other team members, stakeholders, and data users to ensure the new data warehouse meets the needs of the Department.

Continuously monitor, refine, and report on the performance and capacity of the data warehouse.

Configure and administer data warehouse security settings. Work closely with the Information Security team to ensure the best practices are in place.

Stay up to date on new data warehousing technologies and approaches.

Train and mentor less experienced team members.

Coordinate with other IT teams to ensure smooth data warehouse operations.

Handle incident management and problem resolution for data warehouse issues.

Develop data mining models to identify trends and patterns within large datasets.

Ensure that data is accurate and clean, using statistical methods such as data profiling and data quality analysis to identify potential problems with data quality before using it in reports or analyses.

Develop and thoroughly document the processes and procedures for the warehouse's day-to-day operations, including creating backup plans for disaster recovery in case of equipment failure or data loss.

Design and implement data warehouse solutions that meet the Department's needs while ensuring compliance with industry regulations regarding security of sensitive data.

Work collaboratively with stakeholders' teams to compile audience profiles, insights, and measurement plans.

Create simple, easy-to-follow reports and dashboards that key department heads will utilize on a regular basis to make informed business decisions.

Work with multiple Project Managers to deliver capabilities/projects/data sets/reports that have been prioritized by the Business Product Owners.

Works with the Manager of the Department's Research & Data Team and other stakeholders to accurately integrate collected data into the data warehouse.

Using descriptive analytics, researches and performs statistical analysis to identify actionable insights.

Ensures that reporting and key institutional metrics are regularly updated, available, and accurate.

Provides expertise to the Data Governance team.

Create ad-hoc reports as needed.

Stays current of technology and best practices. Regularly attends training and proactively conducts research when available.

Assist in overseeing the work of several other individuals.

Must be able to motivate team members, delegate tasks, perform knowledge transfer and mentor staff.

Must be able to handle all duties and information in a confidential manner.

Must have the ability to simplify information systems and make sound business decisions.

Perform other job-related duties as assigned.

Requirements

We are looking for a highly skilled Data Analyst with a Master's or Bachelor's Degree in Computer Science, Information Systems, or other related field, or four (4) years of equivalent work experience. The ideal candidate will have seven (7) or more years' experience in a Business Intelligence (BI), Data Engineer, or Extract, Transform, and Load (ETL) role.

Key Requirements:

Proven experience working with SQL databases and Microsoft Structured Query Language (SQL) Server.

Proven track record of successful data warehouse implementations.

Proven experience in data warehouse design and development.

Proven experience in ETL tools and processes, and in data migration projects.

Proficient understanding of data warehousing methodologies.

Proven proficiency with Microsoft Power BI for creating dashboards and reports.

Proven experience with data modeling, data architecture, and data quality concepts.

Proven proficiency in SQL and other data languages.

Excellent troubleshooting and problem-solving abilities.

Strong communication skills, capable of explaining complex concepts to non-technical stakeholders.

Must be able to clearly convey information and ideas in both written and verbal forms to share information and ideas and resolve issues.

Strong written and verbal communication skills required.

Ability to communicate/interact professionally and tactfully with people of different levels of education, cultural backgrounds, and life experiences, and to exhibit respect to others.

Organizational skills with strong attention to detail including the ability to adequately establish time frames and deadlines, to meet deadlines, and to follow through on tasks and assignments.

Preferred Qualifications

Experience working in the corrections or public safety sector.

Experience working with financial systems.

Previous involvement in public sector IT projects.

Experience working with large datasets and data lakes.

Experience with other data visualization tools.

Familiarity with Databricks SQL.

Experience with Big Data technologies.

Familiarity with Machine Learning and Artificial Intelligence concepts and their application in data analysis.

Experience in implementing ML and AI solutions in data warehouse environments.

Experience with security technologies around cloud solutions, preferably Azure.

Experience managing projects using Scrum and Kanban.

Preferred Licensing or Certifications

ASCM Warehousing Certification

Data Warehousing and BI Certification Training

Data Warehousing for Business Intelligence Specialization

BI Foundations with SQL, ETL and Data Warehousing Specialization

Enterprise Data Management

About The Greentree Group

We believe in fostering a positive, inclusive culture that values diversity, teamwork, and personal growth. With opportunities for advancement and a supportive community of colleagues, The Greentree Group is the perfect place to build your career. Learn more about us at https://www.thegreentree.com/.

Compensation / Salary Range

Greentree adheres to federal, state, and local regulations. This is a Full-Time, Salary, Exempt position. The following salary range is what we reasonably expect to pay but is contingent and subject to a variety of factors, including but not limited to years of experience, education, certification(s), training, specialized skills, responsibilities, etc.

Bonuses

Greentree has an employee referral bonus, as well as employee bonuses based on employee contributions and Greentree's yearly performance.

Benefits

Core Benefits 100% paid by Greentree: Employee Medical Premium on the High Deductible Health Plan (HDHP), Basic Life Insurance and AD&D, Short-Term Disability (STD), Long-Term Disability (LTD), Health Reimbursement Account (HRA), 401(k) Match, Job-Related Certifications, and Training Programs

Elected Benefits

Medical, Dental, Vision, HSA, FSA, Voluntary Term Life, 401(k) (Roth and Pretax available)

Time Off

PTO, Flexible Schedules, Holidays and

Paid Parental Leave

Work-life balance is important – we all enjoy some time off for rest and relaxation Employees receive a very generous amount of PTO which is granted on start date, plus the ability for quick escalation to the next tier. Flexible/hybrid working schedules and 11 paid holidays, in addition to paid parental leave round out the work-life balance benefits.

Paid Training and Development

We encourage and support ongoing employee learning and development, consistent with needs of the company, its clients, and markets. Greentree is committed to paying the cost for job-related certifications and/or training programs. In conjunction with management/employee communication and discussions regarding performance and goals, employees are expected to seek out and pursue development opportunities to meet emerging organizational skill requirements in combination with their own personal growth needs. Greentree also makes job-related tuition reimbursement contributions for those in higher-level education programs.

---