What are the responsibilities and job description for the Database Administrator position at Legal Aid Society of Greater Cincinnati?
The Legal Aid Society of Greater Cincinnati is seeking a skilled and detail-oriented Database Analyst to develop and maintain Legal Aid’s case management & time keeping system, grant compliance reporting, and data accuracy. The ideal candidate will have strong analytical skills, experience working with multiple data sources, and expertise in Microsoft Power BI, data modeling, and reporting. This is a full-time, on-site position, based at Legal Aid’s downtown Cincinnati office. The position, which reports directly to the Chief Financial Officer, supports the operation of Southwest Ohio’s largest non-profit law firm, including client services, finance, and grant reporting.
The Legal Aid Society of Greater Cincinnati is a non-profit that provides free legal assistance to resolve serious problems for low-income families so they can achieve economic security and family stability. We’ve helped tens of thousands of families stay safe and stable since 1908. Visit www.lascinti.org for more information about Legal Aid.
Position Description
Partnering with practice group managers and functional teams, this position helps Legal Aid to understand reporting needs and key performance indicators (KPIs). In addition to this collaboration, this position is expected to deliver training and support to end users on Power BI tools, dashboards, case management & timekeeping systems and provide help desk & software use support for staff.
- Design, develop, and maintain interactive Power BI dashboards, reports, and scorecards.
- Create intuitive and user-friendly dashboards that support executive, operational, and strategic decision making.
- Optimize report performance and ensure accuracy and consistency of data.
- Gather, clean, validate, and analyze data from multiple sources.
- Develop and maintain data models, relationships, measures, and calculated columns using DAX.
- Identify trends and patterns through data analysis.
- Perform ad hoc analysis to support Legal Aid’s Managing Attorneys, Director of Development & Communications, Executive Director and the Chief Financial Officer.
- Connect Power BI to various data sources including SQL databases, Excel files, cloud applications, APIs, and enterprise systems.
- Monitor data quality and troubleshoot data-related issues.
Qualification
The successful application will meet the following qualifications.
- Bachelor's degree in Business Analytics, Information Systems, Computer Science, Data Analytics, Finance, or a related field.
- Experience developing reports and dashboards using Microsoft Power BI.
- Strong proficiency with DAX, Power Query, and data modeling concepts.
- Experience with SQL and relational databases.
- Strong analytical, problem-solving, and communication skills.
- Experience working with complex datasets.
- Ability to manage multiple projects and deadlines simultaneously.
- Key skills include Microsoft Power BI and dashboard development, Data Modeling and DAX, SQL and ETL, KPI Development and Reporting, Data Analysis, and experience with creating Crystal and Access reports, a plus
Compensation and Benefits
Annual salary is $70,000 or more, depending on experience. The Legal Aid Society offers an excellent benefit package, including health, dental, and vision insurance, pension, and generous PTO.
How to Apply
Applicants should submit all items listed below via Legal Aid’s ADP platform: http://bitly.info/job
- Cover letter explaining the reasons for your interest,
- Current resume, and
- Contact information for three professional references
Interviews will be arranged by Legal Aid Society. Please do not call.
The Legal Aid Society is an Equal Opportunity Employer. We encourage all qualified applicants to apply.
Legal Aid offers reasonable accommodations in the hiring and employment process. If you need assistance, you may request an accommodation by emailing staffing@lascinti.org.
Salary : $70,000