Data Analyst III-Experienced

Database Administration and Application Support

• Maintain and support existing Microsoft Access databases, including tables, queries, forms, reports, and macros.
• Monitor database performance, integrity, security, and usability.
• Troubleshoot and resolve database-related issues, user requests, and system errors.
• Design, modify, and implement database enhancements to support changing business requirements.
• Develop and maintain database documentation, data dictionaries, and standard operating procedures.
• Perform data validation, quality assurance testing, and system audits to ensure data accuracy and reliability.

Workflow Development and Process Improvement

• Analyze business operations and identify opportunities to automate manual processes.
• Design and develop workflow solutions using Microsoft Access and related Microsoft technologies.
• Collaborate with stakeholders to gather business requirements and translate them into technical specifications.
• Test, deploy, and maintain workflow enhancements and system updates.
• Recommend and implement process improvements that increase operational efficiency and reduce manual effort.

Reporting and Business Intelligence

• Design, develop, and maintain reports, dashboards, and data visualizations using Microsoft Power BI.
• Write and optimize SQL queries to extract, transform, and analyze data from multiple sources.
• Create automated and ad-hoc reports to support operational, strategic decision-making.
• Develop data models, relationships, and measures to support enterprise reporting needs.
• Ensure reporting solutions are accurate, scalable, and aligned with organizational goals.
• Present reporting alternatives and modernization recommendations, including migration of legacy reporting processes to Power BI and other business intelligence platforms.

Data Analysis and Technical Consultation

• Analyze complex datasets and provide actionable insights to business leaders.
• Identify trends, anomalies, and opportunities through data analysis.
• Serve as a subject matter expert on data reporting and business intelligence solutions.
• Evaluate emerging technologies and recommend alternatives that improve reporting capabilities, workflow automation, and application support.
• Provide technical guidance and training to system users and business stakeholders.

Knowledge, Skills, and Abilities:

Required Knowledge

• Relational database concepts and database management practices.
• SQL query development, optimization, and troubleshooting.
• Microsoft Access application development and administration.
• Data modeling, data visualization, and business intelligence principles.
• Software development lifecycle and application testing.

• Advanced SQL programming and data extraction techniques.
• Development of interactive dashboards and reports using Microsoft Power BI.
• Microsoft Access development, including forms, queries, reports, VBA, and macros.
• Data analysis, validation, and quality assurance.
• Strong problem-solving and analytical abilities.
• Technical documentation and report writing.

Required Abilities

• Translate business requirements into technical solutions.
• Manage multiple projects and priorities simultaneously.
• Communicate technical concepts to non-technical audiences.
• Work independently while collaborating effectively with cross-functional teams.
• Evaluate and recommend alternative technologies and process improvements., * Bachelor’s degree in Computer Science, Information Systems, Business Information Systems, Data Analytics, or a related field.
• Two years of experience supporting databases, business applications, or reporting systems.
• Experience developing SQL queries and working with relational databases.
• Experience creating reports, dashboards, and data visualizations using Microsoft Power BI.
• Experience administering and enhancing Microsoft Access databases and applications.

• 403(b) matching
• Dental insurance
• Health insurance
• Vision insurance