ETL Architect
- Full-time
Company Description
HealthPlan Services (HPS) is the nation’s largest independent provider of sales, benefits administration, retention, reform and technology solutions to the insurance and managed care industries.
Headquartered in Tampa, Florida, HPS was founded in 1970 and employs 1,500+ associates. HPS stands at the forefront of the insurance industry, providing exchange connectivity, administration, distribution and technology services to insurers of individual, small group, voluntary and association plans, as well as valuable solutions to thousands of brokers and agents, nationwide.
Job Description
Position: ETL Architect
The ETL Architect will have experience delivering BI solutions with an Agile BI delivery methodology.
Essential Job Functions and Duties:
Develop and
maintain ETL jobs for data warehouses/martsDesign ETL
via source-to-target mapping and design documents that consider security,
performance tuning and best practicesCollaborate
with delivery and technical team members on design and developmentCollaborate
with business partners to understand business processes, underlying data and
reporting needsConduct data
analysis in support of ETL development and other activitiesAssist with data architecture and data modeling
Preferred Qualifications:
12+ years of work experience as Business Intelligence Developer
Work experience with multiple database platforms and BI delivery solutions
10+ years of experience with End to End ETL
architecture, data modeling BI and Analytics data marts, implementing
and supporting production environments.10+ years of experience designing, building and implementing BI solutions with
modern BI tools like Microstrategy, Microsoft and TableauExperience as a Data Architect
Experience delivering BI solutions with an Agile BI delivery methodology
Ability to communicate, present and interact comfortably with senior leadership
Demonstrated proficiency implementing self-service solutions to empower an organization to
generate valuable actionable insightsStrong team player
Ability to understand information quickly, derive insight, synthesize information clearly
and concisely, and devise solutionsInclination to take initiative, set priorities, take ownership of assigned projects and
initiatives, drive for results, and collaborate to achieve greatest valueStrong relationship-building and interpersonal skills
Demonstrated self-confidence, honesty and integrity
Conscientious of Enterprise Data Warehouse Release management
process; Conduct Operations readiness and environment compatibility review of
any changes prior to deployment with strong sensitivity around Impact and SLAExperience with data modeling tools a plus.
Expert in data warehousing methodologies and best practices
required.Ability to initiate and follow through on complex projects of
both short and long term duration required.Works independently, assumes responsibility for job development
and training, researches and resolves questions and problems, requests
supervisor input and keeps supervisor informed required.Proactive recommendation for improving the performance and
operability of the data warehouse and reporting environment.Participate on interdepartmental teams to support organizational
goalsPerform other related duties and tasks as assigned
Experience facilitating user sessions and gathering requirements
Education Requirements:
Bachelors or equivalent degree in a business, technical, or related field
Additional Information
All your information will be kept confidential according to EEO guidelines.