Sr. Data and Reporting Analyst

IEM; Morrisville (NC); A distancia; USD 95.000 - 115.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Salary based on experience

10 paid holidays

Vacation pay

Sick pay

401(k) plan with matching

Company paid STD and LTD

Descripción de la vacante

IEM is seeking a Full Time Sr. Data and Reporting Analyst to provide data analytics and reporting support for disaster recovery programs and management. The role involves building analyses, dashboards and forecasts, and delivering actionable insights to program leadership.

Qualifications include a Bachelor's degree and 4 years of data mining/analysis experience, with advanced SQL and Power BI skills. The position is remote within the United States with travel as needed, and offers competitive

Formación

• Bachelor's degree required in data science, statistics, business analytics or closely related field.
• Four (4) years of experience in data mining, management or analysis consulting.
• Willingness to travel as needed.
• Advanced to proficient use of MS Office applications (Excel, Word, Outlook, Access, PowerPoint).
• Advanced knowledge of SQL coding and reporting.
• Advanced knowledge of Power BI.
• Strong data management competencies and teamwork.

Responsabilidades

• Analyze large and complex data sets to identify trends, relationships and risks.
• Develop analyses, forecasting models and analytical tools for disaster recovery decisions.
• Produce recurring and ad hoc reports, dashboards and performance metrics.
• Interpret results and communicate findings to decision-makers and stakeholders.
• Develop and run SQL queries against the Program Data Warehouse in Azure.
• Identify and resolve data inconsistencies affecting reporting accuracy.
• Gather and define data/reporting requirements from clients and end-users.
• Collaborate with program management and development teams on data solutions.
• Coordinate data requirements with program teams and report expectations.
• Design streamlined data collection and reporting processes to improve access to metrics.
• Optimize database use, reporting design and joint development for scalable solutions.
• Maintain databases and perform routine data-management tasks.

Conocimientos

Excel

Word

Outlook

Access

PowerPoint

SQL

Power BI

Educación

Bachelor's degree in data science/related field

Descripción del empleo

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.