The Alaka 'Ina Foundation Family of Companies (FOCs) is looking for a Data Modeler to support our government customer located in Falls Church, Virginia, San Antoino, Texas or can be remote.

The Alaka 'Ina Foundation Family of Companies has partnered with the Defense Health Agency (DHA) to deliver world class, data-driven decision science analytics of military healthcare operations and the delivery of healthcare services worldwide. Alaka 'Ina and its partners will lead with way for DHA to expand its current analytical services to incorporate leading-edge technologies and advanced skills.

The Senior Data Modeler will have an extensive background in the Military Healthcare System (MHS). Successful candidates will have in-depth knowledge of data warehousing, as well as expert communication skills. Ultimately, a top-notch data modeler should be able to design models that reduce data redundancy, streamline data movements, and improve enterprise information management.

DESCRIPTION OF RESPONSIBILITIES:

• Access, validate and analyze information about the MHS population by developing, validating, and linking various medical, safety, environmental, occupational and personnel databases.
• Aggregate and analyze population health data to respond to questions from the various Congressional inquiries, DoD senior leaders, Service-specific Headquarters agencies, and the MTFs.
• Collaborate with DHA and other applicable agencies to link program data with other health and personnel data to support a longitudinal database.
• Coordinate and arrange for program data transfer from DHA, MCSCs, MTFs, and other users of various programs.
• Identify and troubleshoot data import, analysis, and display errors from multiple data sources.
• Perform clinical and business analytical studies using accepted data science techniques to provide insight into areas of trending/improvement for prevention, managed care, medical readiness issues, health promotion, clinical safety and quality, and other health Service-related issues.
• Provide analytical tools and resources to assess the health of the MHS beneficiary population
• Provide data analysis and decision support using research expertise as well as literature review/evidence-base to develop clinical and business measures and prototypes of health information technology (IT) tools, programs, procedures, services, or databases to support DHA's goal of building a managed healthcare system that considers and optimizes safety, quality, cost, and access.
• Provide evaluation of program operations and consultation for questions/concerns across regions, from Managed Care Support, contractors (MCSC), MTFs, DHA, and other users of the applicable program.
• Provide exploratory and meta-data analysis and prepare reports as needed.
• Provide program data queries and analyses, integrating medical knowledge and analytical software applications as available.
• Provide program management to refine the business and clinical measures and prototypes for optimal implementation by DHA and other agencies/MHS as appropriate.
• Provide programming and coding subject matter support for refining the development of new systems and for optimal implementation by the DHA, DoD and other agencies as needed.
• Provide response/work to support ad-hoc analytics requests, including briefs to Senior Leadership in the DHA.
• Provide technical consultation and customer support for implementation, troubleshooting and management for these and other public health, primary care and health promotion activities.
• Provide technical expertise in the areas of prevention, managed care, medical readiness issues, health promotion, clinical safety and quality, and other health Service-related issues in order to support the DHA's vision of becoming the healthiest and highest performing segment of the U.S.
• Provide technical expertise in clinical and business metrics and areas including population health, managed care, medical readiness, provider productivity, clinical services, and other health service-related issues.
• Provide technical knowledge to customers, internal and external to DHA, regarding study design and methodologies.
• Provide the investigative and research expertise to develop prototypes of tools, programs, procedures, services, or databases to support the DHA goal to build a managed healthcare system that integrates quality, cost and access.
• Provide/contribute technical expertise to other DOD services in analyzing program data.
• Research, identify and apply, when available, national/standardized benchmarks and thresholds to DHA/MHS metrics as appropriate or shall identify reasons why the established benchmarks/thresholds/methods are not appropriate/relevant.
• Support the Government as the lead clinical and business information resource in the documentation, plan, design, build, implementation, and maintenance of clinical and business information systems for the DHA and its internal/external customers.
• Support the specialized senior level functional and clinical/business domain experts and provide clinical and business expertise to successfully incorporate clinical systems within departmental and organizational environments.
• Use established and updated data science and analytical/statistical techniques/ methodologies, tools (e.g., software).
• Other duties as assigned by Supervisor.

REQUIRED DEGREE/EDUCATION/CERTIFICATION:

• Bachelor's or master's degree in related IM/IT/Data Science Field or related experience
• Lean Six Sigma Certified
• Security Plus certification

REQUIRED SKILLS AND EXPERIENCE:

• Minimum of five (5) years' experience within the MHS Data Warehouses
• High Degree of experience in data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. These solutions support enterprise information management, business intelligence, machine learning, data science, and other business interests. Be responsible for the development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
• Advanced SQL Server, Redshift and/or Cerner Electronic Health Record HealtheIntent
• Five plus (5+) years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
• Five plus (5+) years Team lead experience to include team management, communication, and presentation.
• Experience with data warehouse, data lake, and enterprise big data platforms in multi-data-center contexts required.
• Advanced knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.
• Data query design and implementation including automation, performance, and completeness surveillance across M2 (Business Objects), MDR (SAS), or Redshift/AWS, Cerner Discern and HealtheIntent Query author, data author experience CHCS Cache, SQL, MDR, SAS, HL7, ETL and HealtheAnalytics experience Advanced Relational Database and Modeling experience.
• Experience and ability to oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
• Experience and ability to implement business and IT data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL) and data tools (reporting, visualization, analytics, and machine learning).
• Experience and ability to work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models
• Experience and ability to define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.
• Experience and ability to identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
• Experience and ability to conduct hands-on modeling, design, configuration, installation, performance tuning, and sandbox POC.
• Experience and ability to work proactively and independently to address project requirements and articulate issues/challenges to reduce project delivery risks.
• Ability to acquire skills/capabilities necessary to meet growing needs/demands of systems/software/hardware.
• Ability to critically examine and evaluate, problem-solve.
• Ability to deliver products on time, on schedule, within budget. Flexibility and ability to adapt to rapidly changing and often time constrained environment.
• Demonstrated ability to communicate analytical discoveries and appropriate recommendations/mitigation strategies effectively and clearly to all levels of customers including Senior DHA leadership.
• Demonstrated ability to organize/participate/lead working groups to develop analytic products and byproducts or to develop/understand processes leading to effective optimization of analytic efforts.
• Demonstrated ability to provide accurate and timely analytical products containing well-reasoned and cogent discussion points providing leadership with substantiated options or courses of action.
• Demonstrated ability to undertake and complete multiple tasks with multiple deadlines simultaneously.
• Demonstrated advanced proficiency in Microsoft Office products PLUS additional software/hardware skills and capabilities.
• Proven ability to synthesize disparate data from multiple sources and coalesce into an accurate and useful analytic product, incorporating Service and MHS strategic goals for use by leadership in both tactical and strategic decision making.

REQUIRED CITIZENSHIP/SECURITY CLEARANCE:

• U.S. Citizenship Required
• Must have an Active Secret (T3) Security Clearance

The Alaka`ina Foundation Family of Companies (FOCs) is a fast-growing government service provider. Employees enjoy competitive salaries. Eligible employees enjoy a 401K plan with company match; medical, dental, disability, and life insurance coverage; tuition reimbursement; paid time off; and 11 paid holidays.

We are an Equal Opportunity/Affirmative Action Employer. We are proud to state that we do not discriminate in employment decisions on the basis of race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. If you are a person with a disability and you need an accommodation during the application process, please click here to request accommodation. We E-Verify all employees.

The Alaka`ina Foundation Family of Companies (FOCs) is comprised of industry-recognized government service firms designated as Native Hawaiian Organization (NHO)-owned and 8(a) certified businesses. The Family of Companies (FOCs) includes Ke`aki Technologies, Laulima Government Solutions, Kpono Government Services, and Kapili Services, Po`okela Solutions, Kkaha Solutions, LLC, and Pololei Solutions, LLC. Alaka`ina Foundation activities principally benefit the youth of Hawaii through charitable efforts which includes providing innovative educational programs that combine leadership, science & technology, and environmental stewardship.

For additional information, please visit www.alakainafoundation.com

#LI-JS1

#ClearanceJobs