Senior Operations Specialist
Puget Sound Energy
Data Operations and Reporting Manager
Association of Women's Health, Obstetric and Neonatal Nurses (AWHONN)
full-time
Posted on:
Location Type: Hybrid
Location: Washington • District of Columbia, Washington • 🇺🇸 United States
Visit company websiteJob Level
JuniorMid-Level
Tech Stack
ETLMySQLSQL
About the role
- Manage the flow of data across platforms, including member databases, e-commerce, finance, CRM, and customer engagement systems.
- Gather, organize, transform, and prepare data from diverse sources such as MS SQL, MySQL, payment gateways, payment processors, JSON, and other structured or unstructured formats.
- Ensure accuracy and consistency of data through established governance and validation practices.
- Develop, maintain, and distribute recurring and ad-hoc reports and dashboards for staff and leadership.
- Translate business questions into clear reporting solutions and provide actionable insights.
- Support system integrations and troubleshoot data synchronization issues.
- Enable reporting and insights related to CRM systems and the sales pipeline, ensuring that membership growth, retention, and revenue goals are data-informed.
- Leverage middleware and automation tools to streamline data flow between platforms, reduce manual effort, and support integrations that keep systems aligned and up to date.
- Continuously improve processes for importing, exporting, and transforming data.
- Collaborate with leadership, analysts, and other stakeholders to ensure data resources meet organizational needs.
- Maintain security, compliance, and appropriate access levels for all reporting resources.
- Document data flows, reporting logic, and procedures to support operational continuity.
- Oversee and maintain the DOMO data warehouse environment.
- Schedule, monitor, and optimize ETL jobs and pipelines.
- Manage dataset connections and ensure stable integrations with external systems.
- Validate data loads, identify discrepancies, and implement corrections.
- Monitor warehouse performance and capacity to support reporting and dashboard demands.
- Archive, refresh, and sunset datasets as systems and requirements evolve.
Requirements
- Bachelor’s degree in Information Systems, Data Science, Business Analytics, or related field (or equivalent experience).
- 2–4 years of experience in data operations, reporting, or business intelligence.
- Strong skills in data preparation, transformation, and integration.
- DOMO data management and reporting experience desired; Power BI or similar experience also welcome.
- Ability to connect and work with varied data sources (SQL, MySQL, APIs, JSON, payment systems, CRM platforms).
- Understanding of data governance, quality, and compliance practices.
- Strong problem-solving, analytical, and communication skills.
- Ability to prioritize multiple tasks and deliver in a fast-paced environment.
Benefits
- *AWHONN provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.*
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
data preparationdata transformationdata integrationETLreportingdata governancedata qualitydata analysisdata warehousingdata synchronization
Soft skills
problem-solvinganalytical skillscommunication skillsorganizational skillscollaborationprioritizationadaptabilityattention to detailtime managementleadership
Certifications
Bachelor’s degree in Information SystemsBachelor’s degree in Data ScienceBachelor’s degree in Business Analytics
