ETL Architect

Health Plan 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.

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/marts
• Design ETL via source-to-target mapping and design documents that consider security, performance tuning and best practices
• Collaborate with delivery and technical team members on design and development
• Collaborate with business partners to understand business processes, underlying data and reporting needs
• Conduct data analysis in support of ETL development and other activities
• Assist 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 Tableau
• Experience 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 insights
• Strong team player
• Ability to understand information quickly, derive insight, synthesize information clearly and concisely, and devise solutions
• Inclination to take initiative, set priorities, take ownership of assigned projects and initiatives, drive for results, and collaborate to achieve greatest value
• Strong 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 SLA
• Experience 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 goals
• Perform 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

All your information will be kept confidential according to EEO guidelines.