• Partner with business stakeholders to gather, analyze, and document data requirements. • Perform data profiling, data mapping, and data quality assessments across multiple source systems. • Develop complex SQL queries and data models to support reporting, reconciliation, and analytical initiatives. • Work with Snowflake and Databricks to design, transform, and manage large-scale datasets. • Build and maintain Python-based data processing and validation workflows. • Analyze financial reconciliation data, including transactions, general ledger, accounts payable, procurement, and related financial datasets. • Identify data discrepancies and support reconciliation processes through root cause analysis. • Collaborate with business, data engineering, and technology teams to ensure data accuracy and consistency. • Support data governance, metadata management, and documentation activities.

• Build and maintain client-facing dashboards and data views in response to stakeholder requests, translating business questions into clear visual outputs. • Write and optimise SQL queries to extract, transform, and analyse data from LiveLike's Redshift and PostgreSQL environments. • Collaborate with senior engineers on data architecture decisions — contributing to pipeline design, schema thinking, and data model improvements. • Own and deliver weekly and monthly client reports, covering widget performance, user engagement, and gamification outcomes across the LiveLike product suite. • Proactively surface new insights from data — identifying trends, anomalies, and opportunities that go beyond standard reporting requests. • Develop a deep understanding of the LiveLike data system — platform events, user journeys, gamification logic — and use that knowledge to suggest improvements to how we measure and report. • Partner with internal stakeholders (PMs, CSMs, engineers) and client teams to gather requirements, align on metric definitions, and ensure deliverables meet expectations.

Role Description ECS is seeking a Junior Data Support Analyst to support a growing business intelligence and data analytics team supporting DHS HQ. The Junior Data Support Analyst supports the effective use of an enterprise data analytics platform by serving as an initial point of engagement for platform users. This role focuses on: - Analyzing user inquiries and translating needs into well-defined requests. - Performing preliminary investigation of common issues. - Coordinating with technical teams to enable timely resolution. This position requires analytical thinking, strong communication skills, and the ability to work independently within established operational processes. Key responsibilities include: - Serve as an initial point of engagement for analytics platform users, assessing and triaging incoming data and platform-related inquiries. - Analyze user requests to determine root causes, required actions, and appropriate resolution paths. - Translate user needs into clearly defined requests and records within ServiceNow. - Perform preliminary investigation and analysis of common platform issues, including access, data availability, and usage questions. - Partner with senior data support analysts, data engineers, and platform teams to coordinate resolution of complex requests. - Develop and maintain user-facing documentation, FAQs, and knowledge articles to improve platform adoption and reduce recurring issues. - Support data users in understanding platform capabilities, best practices, and available datasets. - Track trends in user inquiries to identify recurring issues and recommend process or platform improvements. Salary Range: $60,000 - $70,000 Qualifications - Must be a US Citizen - Ability to successfully maintain a DHS Entry on Duty (EOD)/Public Trust - 1+ years of experience working in IT. - Familiarity with data analytics platforms, reporting tools, or data systems. - Experience documenting requirements and requests clearly and accurately. - Strong troubleshooting approach and problem-solving skills. - Strong written and verbal communication skills, especially in conveying technical information to non-technical users. - Experience working with service management or intake systems (e.g., ServiceNow). - Ability to manage multiple requests and priorities. - Experience in Agile environments.

• Perform deep-dive analyses across diverse data sources to identify trends, patterns, and opportunities. • Write and optimize custom SQL queries to extract, transform, and analyze data. • Use advanced Excel techniques (pivot tables, formulas, data modeling) to explore and visualize findings. • Create user-friendly Tableau reporting to illuminate critical business insights, analysis, and recommendations for senior stakeholders. • Proactively identify gaps, anomalies, and emerging patterns that may impact business performance. • Partner with cross-functional teams to support strategic and operational decision-making.