Data Architect

Data ArchitectThe 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 ResponsibilitiesResponsible 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 InformaticaUsing 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 QualificationsAssociate'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 structureEight 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 termsExcellent organizational and time management skills with an attention to detail.Demonstrated problem-solving skills.Ability to work in a team and respect diversity.Preferred QualificationsDBA CertificationBusiness knowledge and experience in Health and Welfare Plans Administration systems working in Claims, Eligibility and Pensions.Working Conditions/Physical EffortProlonged 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 AccommodationConsistent 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 , and we would be happy to assist you.