Data Architect

American Benefit Plan Administrators, Inc.

Tampa, Northern (FL, KY)

Hybrid

USD 120,000 - 160,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Health benefits

Retirement plan

Paid time off

Job summary

Zenith American Solutions is seeking a Data Architect to design data infrastructure for extraction, organization, and BI readiness. You will identify internal data sources, optimize storage, and support data governance initiatives.

Role requires PHI/PII access aligned with job duties. The ideal candidate will lead data integration from multiple sources into a data warehouse, develop ETL processes in Informatica, and implement data models and governance while collaborating across teams.

Qualifications

Associate’s degree in computer science, Information Systems, or another business-related field.
Six years of experience designing and delivering enterprise solutions.
Mastery of relational and foundational database structure.
Eight years of experience with Microsoft Tools (SSIS, SSRS, and SQL) and 3-4 years of Informatica ETL.
Hands-on experience with Informatica concepts like reusable transformations and data modeling.
Strong knowledge of data modeling, data mart, and data warehouse architecture.
Experience with at least one reporting/visualization tool (Power BI, Tableau, Qlik).
Excellent communication skills and ability to interact with all levels of the organization.
Ability to lead through influence and negotiation.
Knowledge of project management methodologies.
Excellent data management skills.
Ability to explain complex concepts clearly.
Strong time management and attention to detail.
Ability to work in a diverse team.

Responsibilities

Design and deliver scalable data solutions.
Integrate data from line of business to data warehouse and present data visually.
Create database objects, views, stored procedures, and scheduling in SQL Server.
Develop ETL mappings and workflows using Informatica.
Design and maintain data storage with Informatica.
Establish data standards and governance across the organization.
Develop data dictionaries and data models.

Skills

Communication skills

Data modeling

Analytical thinking

Leadership by influence

Project management

Detail oriented

Team collaboration

Education

Associate’s degree in computer science or Information Systems

Tools

SQL Server

SSIS

SSRS

SQL

Informatica ETL

Power BI

Tableau

Job description

Position Summary The Data Architect is responsible for designing data infrastructure to extract and organize data. This role identifies the Company’s internal data sources to determine storage needs and optimize utilization of the information to create and maintain data infrastructure for business intelligence needs. "Has minimum necessary access to Protected Health Information (PHI) and Personally Identifiable Information (PII) by Job Description/Role."

Key Duties and Responsibilities

Responsible for the design and delivery of solutions for longevity and scalability.
Integrates data from line of business to data warehouse; presents the data using data visualization software.
Provides expertise in creating database objects, tables, views, stored procedures, functions, indexes, triggers, agent jobs and scheduling in SQL Server.
Creates ETL Mappings, Workflows and worklets using Informatica.
Using Informatica software to design and maintain data storage.
Develops data definition and process standards across the organization.
Creates product and project level data artifacts.
Leads the data management effort including ownership and maintenance of data dictionaries and data models.
Determines the optimal approach for parsing data from various systems and moving it to the data analytics environment.
Designs, modifies, tests, and implements data warehouse and all related ETL functions.
Develops procedures for meta data management and creates data mapping documents.
Performs problem assessment, resolution, and documentation in existing ETL, mapping and workflows as assigned.
Provides day-to-day user support and administration on database access and security.
Champions data governance adoption and continued definition and common use of data dictionary.
Supports conceptual, logical, and physical data modeling efforts for strategic initiatives.
Performs other duties as required.

Minimum Qualifications

Associate’s degree in computer science, Information Systems, or another business-related field.
Six years of experience designing and delivering enterprise solutions.
Mastery of relational and foundational database structure.
Eight years of experience working with Microsoft Tools (SSIS, SSRS, and SQL). 3-4 years of development background in Informatica ETL Systems is required.
Good hands on experience in informatica concepts like reusable transformations, partition techniques and data modeling.
Strong knowledge of data modeling, data mart, and data warehouse architecture.
Need to have/develop skills with at least one reporting/visualization tool like Power BI, Tableau, Qlik etc.
Proven ability to learn business processes and concepts.
Excellent communications skills in writing, speaking, and listening.
Confident interacting and effectively communicating with all levels of an organization and outside vendors.
The ability to lead through influence and negotiation.
Good understanding of project management methodologies.
Excellent data management skills.
Ability to explain complicated concepts in simple terms.
Excellent organizational and time management skills with an attention to detail.
Demonstrated problem-solving skills.
Ability to work in a team and respect diversity.

Preferred Qualifications

DBA Certification.
Business knowledge and experience in Health and Welfare Plans Administration systems working in Claims, Eligibility and Pensions.

*Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee of this job. Duties, responsibilities, and activities may change at any time with or without notice.

Working Conditions/Physical Effort

Prolonged periods of sitting at a desk and working on a computer.
May be required to work remotely.
Must be able to lift up to 15 pounds at times.

Disability Accommodation

Consistent with the Americans with Disabilities Act (ADA) and other applicable federal and state law, it is the policy of Zenith American Solutions to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process. If reasonable accommodation is needed, please contact the Recruiting Department at recruiting@zenith-american.com, and we would be happy to assist you.

Company Culture & Benefits

Zenith American Solutions Real People. Real Solutions. National Reach. Local Expertise. We are currently looking for a dedicated, energetic employee with the necessary skills, initiative, and personality, along with the desire to get the most out of their working life, to help us be our best every day. Zenith American Solutions is the largest independent Third Party Administrator in the United States and currently operates over 44 offices nationwide. The original entity of Zenith American has been in business since 1944. Our company was formed as the result of a merger between Zenith Administrators and American Benefit Plan Administrators in 2011. By combining resources, best practices and scale, the new organization is even stronger and better than before. We believe the best way to realize our better systems for better service philosophy is to hire the best employees. We're always looking for talented individuals who share our dedication to high-quality work, exceptional service and mutual respect. If you're interested in working in an environment where people - employees and clients - really matter, consider bringing your talents to Zenith American! We realize the importance a comprehensive benefits program to our employees and their families. As part of our total compensation package, we offer an array of benefits including health, vision, and dental coverage, a retirement savings 401(k) plan with company match, paid time off (PTO), great opportunities for growth, and much, much more! At Zenith American Solutions, we take immense pride in fostering a positive, respectful, and supportive work environment that provides challenging opportunities while supporting a healthy work/ life balance. Our organizational culture is founded on principles of integrity, honesty and respect for all stakeholders, including our employees, clients, and business partners. With a low employee turnover rate and a high rate of internal promotions and transfers, the Zenith team is proud to be a part of an 80-year legacy of excellence. Our employees embody a spirit of integrity, take immense pride in their work, and are enthusiastic about referring others to join our team.

Benefits