Data Information Architect

Kapili Services, LLC; Orlando (FL); Remote; USD 80,000 - 110,000; Full time

Job summary

An established industry player is seeking a Data Information Architect to enhance military healthcare operations through data-driven analytics. This role involves building data warehouses, developing ETL processes, and ensuring data accuracy. The ideal candidate will have a strong background in SQL and Python, along with excellent communication skills to present findings to senior leadership. Join a dynamic team that values innovation and offers competitive salaries, comprehensive benefits, and opportunities for professional growth. If you're passionate about leveraging data to improve healthcare, this is the perfect opportunity for you.

Benefits

401K plan with company match

Medical insurance

Dental insurance

Disability insurance

Life insurance

Tuition reimbursement

Paid time off

11 paid holidays

Qualifications

• Experience in developing ETL processes and data modeling.
• Strong SQL and Python skills required for data analysis.
• Ability to communicate findings to senior leadership.

Responsibilities

• Build data warehouses and improve data solutions.
• Lead design and implementation of data models.
• Ensure accuracy of data and manage ETL applications.

Skills

ETL processes

SQL development

Data modeling

Python coding

Data warehousing

Data analysis

Communication skills

Project management

Education

Bachelor's degree in information systems

Equivalent experience in analytics

Tools

SQL Server Integration Services (SSIS)

Microsoft SQL Server Management Studio (SSMS)

SAS

Business Objects

Job description

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 of individuals with disabilities and veterans. We are proud to state that we do not illegally discriminate in employment decisions on the basis of any protected categories. 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

"EOE, including Disability/Vets" OR "Equal Opportunity Employer, including Disability/Veterans"

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