Job Closed
This listing is no longer active.
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 IEMhumanresources@iem.com with specific details about the requested accommodation.
Data Analyst and Reporting Specialist
Location
United States
Posted
53 days ago
Salary
$72.8K - $79K / year
Seniority
Mid Level
Job Description
Data Analyst and Reporting Specialist
IEM
Role Description IEM is searching for a Full Time Data Analyst and Reporting Specialist to provide data analytics and reporting support to IEM’s Disaster Response and Recovery management and other IEM staff. The Data Analyst and Reporting Specialist is responsible for transforming complex, multi‑source data into accurate, actionable insights that support operational, financial, and executive decision‑making across the organization. This role designs and maintains scalable Power BI data models, dashboards, and reporting solutions while ensuring strong data quality, governance, security, and performance within the BI environment. Working collaboratively with leadership, technical teams, and client stakeholders, the specialist gathers and interprets business requirements, streamlines data processes, and delivers high‑impact analytical tools that enhance organizational visibility and performance. Essential Functions - Architect, design, and support enterprise‑scale Power BI and Microsoft Business Intelligence solutions. - Work with large, complex, multi‑source datasets to support operational, financial, and executive reporting. - Translate business requirements into data models, semantic layers, dashboards, and analytics solutions. - Design and implement data analysis, forecasting, and performance measurement models. - Analyze data trends and patterns to deliver actionable insights and decision‑ready reports. - Develop dashboards and reports that depict trends across programs, clients, and organizational performance. - Review and validate data for quality issues, inconsistencies, and anomalies. - Define and enforce data governance, security, and access controls, including row‑level security (RLS). - Maintain and oversee Power BI datasets, workspaces, and deployment pipelines to ensure data integrity and performance. - Outline and document data requirements and reporting needs for clients, programs, and business initiatives. - Gather, analyze and validate stakeholder and end‑user business requirements. - Collaborate with client teams, leadership, and internal stakeholders to manage data changes, enhancements, and reporting initiatives. - Partner with technical, program management, and development teams to identify scalable data architectures, streamline data processes, and communicate insights, risks, and recommendations. - Provide technical leadership, guidance, best practices, and training to analysts, developers, and business users. - Communicate effectively—verbally and in writing—with executive leadership, technical teams, and client stakeholders. - Demonstrate advanced proficiency in Power BI and strong skills in Microsoft Office applications, with working knowledge of Visio, Microsoft Project, and Power Platform. - Apply strong analytical and consultative skills to solve complex business and data challenges. - Remain agile and adaptable when responding to shifting priorities, requirements, and project scopes. Qualifications - Three (3) years or more of experience in business intelligence, data analytics, or reporting solutions. - Bachelor’s Degree in Information Systems, Data Analytics, Computer Science, Business, or a related field. - Proven experience designing and delivering Microsoft Power BI solutions. - Strong knowledge of data modeling, SQL, DAX, and Power Query. - Experience translating business requirements into scalable BI solutions. - Solid understanding of data governance, security, and data quality practices. - Advanced proficiency in Microsoft Office (Excel, PowerPoint, Word, Outlook). Preferred Qualifications - Experience with Azure data services and/or Power Platform. - Master’s Degree in Data Analytics, IT, or Business Administration. - Bilingual: Fluent verbal and written communication skills in English and Spanish preferred. - Experience supporting government, public sector, or regulated environments. - Experience mentoring analysts or leading BI initiatives. - Microsoft certifications (Power BI, Azure, Fabric, or related). - Knowledge with FEMA grants portal and FEMA PA/HMGP projects. - Working knowledge of SharePoint, Visio, and Microsoft Project. - Strong consultative skills and experience establishing standardized reporting processes. Benefits - Salary will be based on experience and location: $72,800 - $79,000 - 10 paid Holidays - Vacation Pay - Sick Pay - 401 (K) plan with matching - Company paid STD and LTD
Related Guides
Related Categories
Related Job Pages
More Data Analyst Jobs
• Collaborate with cross-functional teams to understand business objectives and goals related to current OKRs, with a focus on resolution time, operational efficiency, and customer perception. • Partner with team leaders globally by providing analytical insights through accessible business-oriented data sets and visual data dashboards. • Strategic analysis aiming at performance optimization (efficiency and quality of the CX operation). • Think outside the box to consolidate, structure, and analyze data (qualitative and quantitative) related to customer service to identify opportunities and valuable insights to business that help achieve company OKRs. • Communicate with business stakeholders and propose and implement action plans to achieve the area’s targets. • Live the mission: inspire and empower others by genuinely caring for your own wellbeing and your colleagues. Bring wellbeing to the forefront of work, and create a supportive environment where everyone feels comfortable taking care of themselves, taking time off, and finding work-life balance.
• Leverage data to gain insight into trending, user experience and behavior to drive the appropriate digital marketing, mobile and social strategies. • Take various sources of customer and campaign data and condense it down to a coherent story with clear conclusions and actionable insights, acting as the subject matter expert for digital analytics. • Measure site usability/effectiveness, along with monetization of media campaigns, and present actionable insights and recommendations based on data results and best practices. • Visualize data into meaningful presentation decks and dashboards to provide holistic views of site user engagement activity to business stakeholders. • Update and build dashboards, leveraging Power BI or Tableau, integrating Adobe Analytics and other data. • Perform deep dive analysis via Case Studies to tell a comprehensive analytics story with data points and actionable insights to drive recommendations and decision making. • Leverage Agile Delivery methods and processes to effectively track user stories, level of effort estimates, and plan with your Agile team for each Sprint. • Drive data analysis of web projects, A/B and multivariate testing, and ad hoc requests. • Support tag management requirements and documentation services to maintain integrity across multiple sources of data, including providing user acceptance testing and validation of web reporting creating, enhancements, and adjustments. • Partner with multiple vendors to implement analytics requirements and streamline project processes. • Multi-task and self-prioritize work queue to balance work queue and ensure stakeholder expectations are being met. • Engage in analytics delivery re-prioritization discussions as needed with stakeholders to maximize internal team and stakeholder satisfaction.
• Independently — and with our team — investigate complex business problems using a combination of structured and unstructured datasets and analytical tools • Identify, collect, scrape, store, pre-process, manipulate, merge, model, and analyze large datasets from multiple internal and external sources • Develop scalable analytical workflows and automate processes that improve the efficiency, repeatability, and speed of insight delivery • Use Python and modern AI-assisted workflows to rapidly prototype analyses • Identify meaningful trends, anomalies, and strategic opportunities across healthcare and marketing datasets • Translate complex analyses into clear, story-driven insights and data visualizations tailored to all partners • Collaborate with strategists, creative, account, engagement managers, other analysts, and leadership teams • Operate with ownership, curiosity, and accountability
• Measure the impact of BI and Analytics deliveries, including financial gains, operational efficiency and cost reductions; • Define and monitor KPIs related to implemented initiatives, ensuring continuous visibility of performance; • Estimate and model financial return (ROI) of data projects and initiatives; • Identify operational gains (e.g., productivity improvements, reduction of effort/FTEs) resulting from implemented solutions; • Challenge and support prioritization of requests based on the impact generated for the business; • Conduct exploratory analyses to identify opportunities and generate hypotheses for improvement; • Develop ad hoc analyses to support decision-making; • Document methodologies, calculation assumptions and analyses performed, ensuring traceability and consistency; • Work collaboratively with Data, BI and business teams to ensure alignment on metrics, hypotheses and results.




