"Alerted.org

Job Description

Develop, enhance, and migrate Excel-based dashboards to Smartsheet/Power BI dashboards.

Develop and maintain reporting to ensure timely completion, verify the accuracy of completed reports, and identify any pending tasks to facilitate efficient data delivery.

Identify and correct inconsistencies, duplicates, and errors in datasets.

Collaborate with internal teams to optimize the weekly/monthly dashboard process and develop automated data entry and retrieval systems.

Perform data validation across multiple platforms, ensuring accuracy and consistency.

Export, edit, and analyze reports from Salesforce to support business needs.

Work cross-functionally with Operations to support reporting and analytics.

We are a company committed to creating inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity employer that believes everyone matters. Qualified candidates will receive consideration for employment opportunities without regard to race, religion, sex, age, marital status, national origin, sexual orientation, citizenship status, disability, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to Human Resources Request Form (https://airtable.com/app21VjYyxLDIX0ez/shrOg4IQS1J6dRiMo) . The EEOC "Know Your Rights" Poster is available here (https://www.eeoc.gov/sites/default/files/2023-06/22-088\_EEOC\_KnowYourRights6.12ScreenRdr.pdf) .

To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/ .

Skills and Requirements

Advanced proficiency in Excel, including VBA/Macro development, Power Query, Pivot Tables, and complex formulas.

Strong knowledge of SQL for querying and managing large datasets.

Familiarity with ETL (Extract, Transform, Load) processes and integrating data from multiple sources.

Strong attention to detail and ability to identify, troubleshoot, and resolve data inconsistencies.

Analytical mindset to interpret trends and patterns from large datasets.

Strong experience in Smartsheet and Power BI, including dashboard creation and workflow automation.

Familiarity with Salesforce reporting and the ability to export and manipulate reports.

Excellent collaboration skills and ability to work effectively cross-functionally Experience with data analysis, visualization, and communication, with prior work experience strongly preferred.

Experience in Operations/ Data Analytics/ Project Management preferred.

Ability to collaborate with cross-functional teams to derive insights to improve overall business performance.

Ability to work under pressure and meet tight deadlines. null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].