Home
Jobs
Saved
Resumes
Associate Data Strategy Analyst at Prominence Advisors | JobVerse
JobVerse
Home
Jobs
Recruiters
Companies
Pricing
Blog
Jobs
/
Associate Data Strategy Analyst
Prominence Advisors
Website
LinkedIn
Associate Data Strategy Analyst
United States
Full Time
2 hours ago
No H1B
Apply Now
Key skills
AWS
Azure
ETL
Python
SQL
Tableau
VBA
BI
Power BI
CRM
Collaboration
Sales
About this role
Role Overview
Ingest and harmonize healthcare and sales-related datasets in accordance with established rules and data mappings.
Execute and monitor recurring ETL workflows to ensure timely and accurate data processing.
Perform structured quality control checks, including record counts, reconciliations, and trend validation, to ensure data integrity.
Clearly document data issues and escalate risks or inconsistencies to senior team members as appropriate.
Maintain organized file structures, naming conventions, and workflow documentation in alignment with team standards.
Refresh and validate dashboards (e.g., Power BI) to ensure accuracy and alignment with defined reporting standards.
Prepare recurring, stakeholder-ready reports in Excel, ensuring data accuracy and clear presentation of insights.
Support CRM data extracts and incentive compensation reporting processes in collaboration with senior team members.
Assist with web-based tool data imports, performing validation checks to ensure completeness and accuracy.
Contribute to the development and maintenance of reusable scripts and templates (SQL, Python, VBA).
Execute data warehouse refresh routines in accordance with established governance standards and team processes.
Maintain and update runbooks and process documentation as needed.
Participate in client and internal meetings as applicable.
Communicate task completion clearly and efficiently, proactively identifying and escalating blockers or risks to team.
Requirements
Bachelor’s degree
Strong Excel proficiency
Working knowledge of SQL
Python and/or VBA (Preferred)
Power BI or Tableau exposure (Preferred)
Familiarity with AWS/Azure (Preferred)
Understanding of MDM and data privacy concept (Preferred)
Tech Stack
AWS
Azure
ETL
Python
SQL
Tableau
VBA
Benefits
Competitive Compensation Plans
Health Care Plan (Medical, Dental & Vision)
Retirement Plan (401k)
Life Insurance (Basic, Voluntary & AD&D)
Paid Time Off (Vacation/Sick & Public Holidays)
Training & Development Fund
Apply Now
Home
Jobs
Saved
Resumes