Sr. Data and Reporting Analyst

iemcareers; United States; Remote; USD 95,000 - 115,000; Full time

Benefits offered by this job

10 paid Holidays

Vacation Pay

Sick Pay

401(k) plan with matching

Company paid STD and LTD

Job summary

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

Ideal candidate will analyze large data sets, develop forecasting models, and produce dashboards for program management and clients, using SQL in Azure and Power BI. Remote work from anywhere in the U.S. with Florida preferred for core hours.

Qualifications

• Bachelor's degree 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.
• 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.

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.

Skills

SQL

Power BI

Excel

Communication

Data analysis

Data mining

Problem solving

Education

Bachelor's degree in data science, statistics, business analytics, computer science, informatics, mathematics, data analytics, or a closely related field

Tools

SharePoint

Tableau

Visio

Microsoft Project

Job description

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

Primary Location:

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

Travel Requirements:

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

Essential Functions:

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

Minimum Qualifications:

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

Preferred Qualifications:

• 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

Additional Information:

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

Benefits and more:

• Salary will be based on experience and location: $95,000 - $115,000
• 10 paid Holidays
• Vacation Pay
• Sick Pay
• 401 (K) plan with matching
• Company paid STD and LTD

Equal Employment Opportunity.

All IEM employment decisions, including recruiting, hiring, placement, training availability, promotion, compensation, evaluation, disciplinary actions, and termination of employment, if necessary, are made without regard to an individual's race, color, religion, creed, sex (including sexual orientation, gender identity, and gender expression), national origin, ancestry, age, physical or mental disability, medical condition, genetic information, pregnancy (including childbirth and related medical conditions), marital status, military or veteran status, citizenship or immigration status, or any other characteristic protected under applicable law.

Reasonable Accommodation.

IEM is committed to providing reasonable workplace accommodations for individuals with disabilities. If you require assistance or reasonable accommodation during any part of the application or employment process, please email [e-mail] with specific details about the requested accommodation. All accommodation requests are reviewed case-by-case in compliance with applicable law.