Sr. Data and Reporting Analyst

IEM is seeking a Senior Data and Reporting Analyst to provide data analytics and reporting support for disaster recovery programs and management. The role analyzes complex datasets, develops forecasting models and dashboards, communicates findings to stakeholders, and creates scalable data and reporting solutions using SQL, Azure, Power BI, and related tools.

Responsibilities:

• Analyze large and complex data sets to identify trends, relationships, risks, and actionable conclusions
• Develop data analyses, trend assessments, forecasting models, and other analytical tools that support disaster recovery program decisions
• Produce recurring and ad hoc business reports, dashboards, and performance metrics for program management, clients, and other stakeholders
• Interpret analytical results and communicate findings, recommendations, and potential impacts to key decision-makers, team members, and client stakeholders
• Develop and run SQL queries against the Program Data Warehouse in Azure to retrieve, evaluate, and organize program data
• Identify, investigate, and resolve data inconsistencies or anomalies that could affect reporting accuracy or analytical results
• Gather and define client, program, and end-user data and reporting requirements for business analysis projects
• Collaborate with disaster recovery program management and system development teams to evaluate business needs and develop data and reporting solutions
• Coordinate with program teams regarding data requirements, definitions, changes, reporting expectations, and related impacts
• Design and recommend streamlined data collection, reporting, and analytical processes that improve access to reliable program metrics
• Optimize database use, reporting design, and joint development efforts to support efficient and scalable solutions
• Maintain databases and perform routine data-management activities necessary to preserve data quality and integrity
• Perform other duties as assigned that are consistent with the knowledge, skills, experience, and responsibilities outlined in this job description

Requirements:

• Bachelor's degree from an accredited college or university in data science, statistics, business analytics, computer science, informatics, mathematics, data analytics, or a closely related field
• Four (4) years of experience in data mining, management or analysis consulting
• Four (4) additional years of relevant experience may substitute for the required bachelor's degree
• A master's degree may substitute for two (2) years of the required experience
• Advanced to proficient use of all Microsoft Office applications including Excel, Word, Outlook, Access, and PowerPoint
• Advanced knowledge of SQL coding and reporting
• Advanced knowledge of Power BI
• Demonstrated strong data management competencies and characteristics such as integrity, accountability, excellent communication skills and commitment to teamwork
• Knowledge of federally funded grant programs such as CDBG/CDBG-DR, FEMA HMGP, Treasury ARPA, and CARES Act grants
• Basic to intermediate use of SharePoint
• Strong use of internal controls, policies and processes
• Intermediate to advanced use of Tableau, Microsoft project and Visio
• Agile and ability to be flexible and adapt quickly to changes during each assignment