What are the responsibilities and job description for the IT Data Analyst (ONSITE) position at Keystone Advisors?
Company Overview
Keystone Advisors is a full-service marketing company aligned with Top Health Insurance Carriers to provide our partners and clients a broad and competitive portfolio of Insurance Options. We have over 20 years of experience in Insurance marketing while serving our local communities with Medicare, Individual, Group Health, Life, and Annuity products. Our core values are Customer service, integrity, compassion, tenacity, and collaboration.
Job Summary
The IT System Support Analys plays a crucial role in driving data-driven decision making while ensuring smooth operation of our IT infrastructure. This position primarily focuses on advanced data analysis initiatives using Azure Synapse Analytics and Azure Data Factory, with secondary responsibilities in maintaining and supporting office IT systems. The specialist will collaborate with CIT Solutions and Systems Administrators to develop and implement comprehensive data and IT solutions.
Primary Responsibilities - Data Analytics (75%)
- Design, implement, and optimize data pipelines using Azure Synapse Analytics and Azure Data Factory
- Develop and maintain ETL processes for data warehousing and business intelligence
- Create automated analytics reports using Python, Pandas, and Azure tools
- Monitor and improve data quality, reliability, and processing efficiency
- Conduct quarterly reviews of department-specific data processes
- Build and maintain documentation for data analysis procedures
- Create training materials for analytics tools and processes
- Collaborate with departments to identify and implement data-driven solutions
Secondary Responsibilities - IT Support (25%)
Required Skills & Qualifications Data Analytics Skills (Primary) :
IT Support Skills (Secondary) :
Education & Experience :
Additional Skills :
Working Conditions & Physical Requirements