carrer.jpg

AI CAREERS

AI Group, LLC is an established, trusted name in business, technology and digital strategy consulting. We provide industry-leading results with particular expertise to leaders in the Insurance, Healthcare and Financial Services.

Data Architect

Key Desired Skills, Experience, and Knowledge:

  • Strong communication skills: ability to be well-organized, clear, and concise in conversations and written communications.

  • Extensive hands-on experience using the Hadoop ecosystem in large enterprise infrastructure, preferably a healthcare payor.

  • Ability to articulate trade-offs, strengths, and weaknesses of various Hadoop architectural patterns to determine the best framework or pattern to use given various use cases and requirements constraints (e.g., required response times, nature of batch vs. real-time flows).

  • Hands-on experience planning migration of legacy data sources to Hadoop-based data lakes.

  • Ability to create clear, expert-level architectural diagrams using Visio, and clear narrative presentations using PowerPoint.

  • Hands-on experience implementing big data pipelines using Hive, HBASE, Spark, and Kafka.

  • Knowledge of data virtualization architectures and Denodo is a bonus.

Key Areas of Responsibility:

  • Understand current state architecture, including pain points.

  • Understand and, where appropriate, contribute to future state guidelines and vision.

  • Create and document future state architectural options to address specific issues or initiatives.

  • Maintain in-depth and current knowledge of the Hadoop ecosystem, its main components, tradeoffs, pros and cons for each, knowledge of when to use each, and how they can be optimally combined to create data patterns and frameworks.

  • Maintain in-depth and current knowledge of client’s strategies, business issues and relationships.

  • Serve as a solutions-based expert, internally and externally, by applying consultative problem-solving skills.

  • Remain current on competitive trends in the healthcare industry (Payer and Provider preferred) to anticipate and identify new business challenges and issues at assigned clients.

Specific Data Architectural Responsibilities:

  • Work with both technical and business stakeholders to understand data needs for projects. Attend requirement sessions when necessary, communicating any concerns to project leadership.

  • Perform any of the following as needed: requirement analysis, data profiling, effort estimation for database and data warehouse design and development.

  • Provide thought leadership around Hadoop ecosystem and data warehouse design by leveraging past experience and current Hadoop ecosystem, data warehouse and healthcare industry trends (preferably both Payer and Provider)

  • Provide thought leadership around the use of healthcare industry standard tools and models (including commercially available models and tools) by leveraging past experience and current healthcare industry trends

  • Provide guidance on the creation and best practices around Data Governance, Data Stewardship and overall Data Quality initiatives and processes as part of the overall data effort

  • Translate complex technical terminology, concepts and issues in terms understandable to technical and nontechnical management and resources staff.

  • Develop and maintain conceptual, logical, and physical Hadoop ecosystem, database and data warehouse architectures.

  • Ensure project adheres to client’s data and database standards and policies.

  • Collaborate with the Enterprise Architect and client IT team as warranted to establish and implement strategic initiatives.

  • Make recommendations and assess proposals for database optimization.

  • Identify operational issues, and recommend and implement strategies to resolve problems.

Specific Data Architectural Responsibilities:

  • Work with both technical and business stakeholders to understand data needs for projects. Attend requirement sessions when necessary, communicating any concerns to project leadership.

  • Perform any of the following as needed: requirement analysis, data profiling, effort estimation for database and data warehouse design and development.

  • Provide thought leadership around Hadoop ecosystem and data warehouse design by leveraging past experience and current Hadoop ecosystem, data warehouse and healthcare industry trends (preferably both Payer and Provider)

  • Provide thought leadership around the use of healthcare industry standard tools and models (including commercially available models and tools) by leveraging past experience and current healthcare industry trends

  • Provide guidance on the creation and best practices around Data Governance, Data Stewardship and overall Data Quality initiatives and processes as part of the overall data effort

  • Translate complex technical terminology, concepts and issues in terms understandable to technical and nontechnical management and resources staff.

  • Develop and maintain conceptual, logical, and physical Hadoop ecosystem, database and data warehouse architectures.

  • Ensure project adheres to client’s data and database standards and policies.

  • Collaborate with the Enterprise Architect and client IT team as warranted to establish and implement strategic initiatives.

  • Make recommendations and assess proposals for database optimization.

  • Identify operational issues, and recommend and implement strategies to resolve problems.

Desired Skills and Experience:

  • Bachelor’s Degree.

  • Healthcare industry experience working with named, large Payers, Providers or, preferably, both either in industry or as a consultant

  • Ability to design Hadoop ecosystem and data warehousing solutions that can take large volumes of structured and unstructured data and rapidly generate meaningful reports and/or support ongoing analytical needs

  • Thorough knowledge of database design and tuning with standard tools.

  • Knowledge of current healthcare industry models and tools available in the marketplace, e.g. Oracle Healthcare Data Model, Teradata Healthcare Model, and IBM Health Plan Data Model (HPDM)

  • Experience implementing operational and dimensional logical and physical design for Data Marts, Data Warehouse and Business intelligence solutions

  • Experience architecting and designing solutions that leverage Master Data Management (MDM), Reference Data Management, Integration solutions, Operational Data Stores (ODS), and Analytic Data Stores (ADS)

  • Experience with healthcare industry (Payer and Provider) data analytics needs and trends

  • Experience in identifying and documenting data integration issues, challenges such as duplicate data, non-conformed data, and unclean data including both internal and external data sources

  • Experience in identifying, analyzing and translating business requirements into conceptual, logical and physical data models in complex, multi-application environments.

  • Excellent data analysis skills using SQL.

  • Experience in creating, reviewing and presenting Source Systems Analysis and Source to Target mapping across Staging, Integration and Presentation layers

  • Experience in Data analysis/profiling and reverse engineering of data.

  • Experience in delivering quality work on time with multiple, competing priorities.

  • Strong communication and teamwork skills to interface with development team members, business analysts, and project management.

  • Excellent communication and analytical skills.

Required Qualifications:

  • Bachelor's degree and at least 7 years of experience in information technology OR,

  • Master's degree and at least 7 years of experience in information technology OR,

  • At least 7 years of experience in information technology.