ETL Architect

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/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

Qualifications

Additional Information

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