23 часа назад
Data Architect
Мэтч & Сопровод
Для мэтча с этой вакансией нужен Plus
Описание вакансии
Текст:
TL;DR
Data Architect (SQL Server/Informatica): Designing scalable data infrastructure, warehouses, ETL workflows, data models, and analytics environments with an accent on SQL Server, Informatica, data governance, and business intelligence. Focus on integrating line-of-business data, building ETL mappings and workflows, managing metadata and data dictionaries, and solving access, security, and data quality challenges.
Location: Tampa, Florida, United States; full-time role with possible remote work requirements depending on business needs.
Company
is an independent U.S. third-party administrator serving health and welfare plan administration needs through a nationwide office network.
What you will do
- Design and deliver scalable, durable data infrastructure and enterprise data solutions.
- Integrate line-of-business data into data warehouses and present information through data visualization tools.
- Design, modify, test, and implement data warehouses and related ETL functions.
- Create SQL Server database objects, including tables, views, stored procedures, functions, indexes, triggers, agent jobs, and schedules.
- Build and maintain Informatica ETL mappings, workflows, worklets, and data storage solutions.
- Lead data management, governance, metadata, data dictionary, data modeling, access, and database security efforts.
Requirements
- Associate’s degree in computer science, information systems, or a related business field.
- At least six years of experience designing and delivering enterprise solutions.
- At least eight years of experience with Microsoft tools, including SSIS, SSRS, and SQL.
- Three to four years of Informatica ETL development experience, including reusable transformations, partition techniques, and data modeling.
- Strong knowledge of relational databases, data marts, data warehouses, data modeling, ETL, and data management.
- Experience with or ability to develop expertise in a reporting or visualization tool such as Power BI, Tableau, or Qlik, plus strong communication, problem-solving, organizational, and influencing skills.
Nice to have
- DBA certification.
- Experience with health and welfare plan administration systems, including claims, eligibility, and pensions.
Culture & Benefits
- Health, vision, and dental coverage.
- 401(k) retirement plan with company match.
- Paid time off.
- Opportunities for professional growth.
- Work involves extended periods of sitting and computer use; occasional lifting of up to 15 pounds may be required.
Будьте осторожны: если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого - это мошенники. Обязательно жмите "Пожаловаться" или пишите в поддержку. Подробнее в гайде →