The Alaka`ina Foundation Family of Companies (FOCs) is looking for a Data Information Architect to support our government customer located mainly in San Antonio, Texas, or Falls Church, Virginia or can be worked 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 the way for DHA to expand its current analytical services to incorporate leading-edge technologies and advanced skills.

Alaka`ina seeks a Data Information Architect with strong Extract, Transform, and Load (ETL) skills, and a background in the Military Healthcare System.  Successful candidates will have knowledge of the Military Healthcare data marts, and experience developing ETL processes in the healthcare market.

DESCRIPTION OF RESPONSIBILITIES:

• Builds data warehouses for the organization's internal departments utilizing various data warehousing ideas.
• Creates and improves data solutions that enable smooth data delivery and oversees gathering, processing, maintaining, and analyzing enormous amounts of data.
• Leads the logical data model design and implementation and the construction and implementation of operational data stores and data marts.
• Designs, automate, and supports sophisticated data extraction, transformation, and loading applications.
• Ensures the accuracy of data.
• For ETL applications, creates logical and physical data flow models.
• Data access, transformation, and mobility needs are translated into functional requirements and mapping designs.
• 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.
• 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.
• Other duties as assigned.

REQUIRED DEGREE/EDUCATION/CERTIFICATION:

• Bachelor’s degree in information systems, Computer Science, Biostatistics, Informatics, Mathematics or similar/related field.
• The Government may consider significant clinical/medical/health data experience such as previous participation in an analytics/quantitative field fellowship/training as an appropriate substitute for education, but minimum of Bachelor’s degree in above areas are required unless otherwise specified and with few exceptions.

REQUIRED SKILLS AND EXPERIENCE:

• Prior experience developing databases and understanding of data modeling concepts.
• Knowledge and experience with the Software Development Life Cycle (SDLC)
• Strong background developing Extract Transform Load (ETL) processes.
• Strong SQL development skills: experience with SQL Server Integration Services (SSIS), and Python coding are required.
• Knowledge of different SQL/NoSQL data storage techniques and Big Data technologies.
• Three (3) years experience with Microsoft SQL Server Management Studio (SSMS).
• Three (3) years experience of ETL development experience Knowledge of ETL ideas, tools, and data structures.
• Three (3) years experience in development of product support documentation.
• Three (3) years experience in workflow development and documentation of workflow processes.
• Two (2) years experience developing, testing, and maintaining ETL processes. 
• Security Plus certification
• Able to read, write, speak and understand English.

DESIRED SKILLS AND EXPERIENCE:

• Minimum of 3 years experience data mining and conducting detailed analysis within the Military Health System (MHS) Data Warehouses and software, i.e., M2, Business Objects, CHCS Cache, SQL, MDR, SAS, HL7, ETL and HealtheAnalytics.
• One plus year in experience with Transact-SQL or ANSI SQL.  SAS programming experience is an acceptable alternative.
• Familiarity with Application Programming Interface (API) data pipeline integration with the R or Python languages.
• Preferred familiarity with Jenkins and/or other CI tools experience for monitoring and establishment of data pipelines and task automation.
• Outstanding verbal and written communication abilities
• Outstanding interpersonal skills
• Excellent project management abilities
• Strong conceptual abilities
• Excellent multitasking abilities
• Exceptional analytical abilities

REQUIRED CITIZENSHIP AND CLEARANCE:

• U.S. Citizenship Required
• Active Secret Clearance or Tier III background check

​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, Kūpono Government Services, and Kapili Services, Po`okela Solutions, Kīkaha 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