Business Intelligence Analyst

? Create and maintain reports & dashboards for internal stakeholders, providing clear visualizations and explanations of findings. ? Use BI tools and data analytics software to analyze data, identify trends, and provide actionable insights. ? Conduct data analysis to generate meaningful insights from data sets ? Writing, executing and analyzing SQL queries ? Create ad-hoc and standard SSRS reports to document results of data analysis ? Utilize data analysis tools such as SQL, MS Excel, Google Sheets, Power BI to work with huge volumes of Data. ? Collaborate with cross-functional teams to understand business data analysis needs and goals. ? Develop, analyze, and evaluate business needs to improve workflow processes, troubleshoot Business Intelligence tool problems and tune for performance optimization and usability. ? Ensure accuracy and validity of data sets and reports. ? Organize, classify and synthesize the data into fundamental issues from the information provided ? Identify the logical outcomes from the analysis of the data collected and identify the options & solutions for addressing the problems analyzed ? Develop and maintain applications and automation scripts using Visual Basic (VB) to streamline reporting and data analysis tasks. ? Perform additional tasks as assigned by the supervisor.

? Bachelor’s degree in Computer Science, a related field, or equivalent experience is required. ? Any training, coursework, and work experience relevant to the assignment.

Knowledge ? Knowledge and understanding of software development processes, including requirements and technical design analysis, development, system and user testing, problem resolution, and planning ? Knowledge of Relational Database Management Systems (RDBMS) ? Knowledge of using PC in a Windows environment; using MS Office Applications such as Outlook, Word and Excel, VB, PowerPoint; and using Google Suite applications such as Gmail, Sheets, Docs, and Drive, ? Effective organization and time management skills with the ability to manage multiple projects simultaneously and work in high-pressure situations ? Proficient in the use of tools & technologies such as MS Excel, MS Access, SQL ? Strong interpersonal and relationship-building skills, fostering a collaborative and constructive team environment. ? Effective verbal, written, and listening communication skills ? Effective in the skill of synthesizing feedback and adjusting accordingly ? Visual Basic (VB) skills preferred ? Interest in AI tools and an aptitude for working in environments that leverage AI technologies

Abilities ? Ability to work both independently or collaboratively with minimal supervision ? Ability to work in a confidential manner, ensuring information is shared with internal and external individuals in an appropriate manner ? Ability to understand and solve problems by applying analytical skills to include collecting all the relevant information and data needed to address the problem ? Ability to prioritize tasks and duties based on importance and urgency level ? Willingness and ability to embody ADOR’s core values of Do the Right Thing,

Required Skills

• Experience with SQL and excel
• Data Analytics experience