Sr. Data and Reporting Analyst

IEM is searching for Full Time- Sr. Data and Reporting Analyst to provide data analytics and reporting support for disaster recovery programs and management.

• Live anywhere in the United States.
• Work from a home or personal office location that meets IEM standards.
• Preferred candidates will live in Florida to better support core business hours.

• This position may require travel to complete work assignments or attend meetings.

• Degree: 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.
• Experience: Four (4) years of experience in data mining, management or analysis consulting.
• Degree and/or Experience Substitution: 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.
• Willing and able to travel if needed. 
• 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

• 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.

• Office Locations:Often, these offices are either owned by the client we work with or by IEM. All candidates are expected to follow any rules and regulations of the office in which they are required to work for that project.
• Personal Office / At Home Locations: All personal office / at home work environments require the ability to maintain minimum Internet speeds of 25 Mbps upload and 3 Mbps download, as well as a ping rate of 100 ms or less during working hours, regardless of the type and number of devices using your Internet connection. You must also have account privileges and access to your Internet service provider account during working hours for the purposes of maintaining the Internet connection, if needed.