ETL Architect

HealthPlan Services; Tampa (FL); On-site; USD 100,000 - 130,000; Full time

Job summary

HealthPlan Services in Tampa, Florida, is seeking an experienced ETL Architect responsible for developing and maintaining ETL jobs, collaborating with teams on design and development, and ensuring data warehousing best practices. The ideal candidate will have over 12 years in Business Intelligence Development and extensive experience with ETL architecture and BI solutions.

The role requires strong communication skills and initiative to lead complex projects while working independently within a team environment.

Qualifications

• 12+ years of work experience as Business Intelligence Developer.
• 10+ years of experience with End to End ETL architecture and data modeling.
• Strong relationship-building and interpersonal skills.

Responsibilities

• Develop and maintain ETL jobs for data warehouses/marts.
• Collaborate with business partners to understand processes and reporting needs.
• Propose improvements for the performance and operability of data warehouse.

Skills

Business Intelligence Development

Data Warehousing

ETL Architecture

Agile BI Delivery

Data Analysis

Team Collaboration

Effective Communication

Education

Bachelors or equivalent degree in a business, technical, or related field

Tools

Microstrategy

Microsoft BI tools

Tableau

Data Modeling Tools

Job 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

Additional Information

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