Technical Business Analyst

Washington, AR - USA

Monthly Salary: Not Disclosed

Posted on: 12 hours ago

Vacancies: 1 Vacancy

Job Summary

Analytica is seeking aTechnical Business Analystthat will serve as the crucial link between clinical/operational stakeholders and the technical development team within the Defense Health Agency. This role involves translating complex healthcare and business needs into detailed technical requirements specifically focusing on data management ETL processes SQL farm development and reporting solutions. The ideal candidate will ensure data integrity and compliance with all federal and DoD healthcare regulations (e.g. HIPAA).

Analytica has been recognized byInc. Magazineas one of the fastest-growing 250 businesses in the US for 3 years. We work with U.S. government clients in health civilian and national security missions to build better technology products that impact our day-to-day lives. The company offers competitive compensation with opportunities for bonuses employer-paid health care training and development funds and 401k match.

Responsibilities:

Requirements Management:Elicit analyze and document complex business and technical requirements from various stakeholders to support data integration and reporting initiatives.

ETL Operations Support:Collaborate with data engineering teams to define test andvalidatedata extraction transformation and loading (ETL) processes from disparate sources (e.g. EHRs claims data clinical systems) into the enterprise data warehouse.

Data Modeling and Database Design:Support the design of data models and database structures including defining primary keys indexing strategies and normalization to ensure efficient data storage and retrieval.

SQL Development Support:Provide specifications andassistin the creation maintenance and optimization of SQL queries stored procedures and scripts used for data analysis and reporting.

Data Flow and Process Documentation:Develop andmaintaindetailed documentation including data flow diagrams source-to-target mapping documents and operational procedures to ensure transparency and reproducibility of data processes.

Reporting and Visualization:Define specifications for reports and dashboards (using tools like Power BI or Tableau) and collaborate with development teams to create visualizations that present complex healthcare data in an easily understandable format for decision-making.

Data Quality and Governance:Perform data profiling quality checks and gap analysis toidentifydiscrepancies and ensure the integrity accuracy and consistency of data across systems adhering to DHA data governance standards.

Testing and Validation:Create test plans and cases and coordinate User Acceptance Testing (UAT) using SQL scripts tovalidatesolutions before deployment.

Stakeholder Communication:Facilitatemeetings and serve as the bridge between technical teams and non-technical personnel (clinicians managers) to ensure alignment and effective communication throughout the project lifecycle.

Required Qualifications:

Education:Bachelors degree in Health Informatics Business Information Systems ora relatedtechnical field.

Experience:Proven experience as a Business Analyst in a healthcare or defense environment with a strong emphasis on data analysis and technical team support.

Technical Proficiency:

Strongproficiencyin SQL for data querying and analysis.

Experience with ETL frameworks and data warehousing concepts.

Familiarity with data visualization tools (e.g. Power BI Tableau) is a plus.

Understanding ofrelational database management system (RDBMS) concepts.

Domain Knowledge:Knowledge of healthcare operations data privacy laws (HIPAA etc.) and a working knowledge of the Military Health System (MHS) or DHA operations is highly desirable.

Soft Skills:Excellent analytical problem-solving and communication skills with the ability to translate complex technical issues to non-technical audiences.

Clearance:Ability to obtain andmaintaina DoD security clearance; Active Secret Clearance preferred

AboutAnalytica:Analyticais a leading consulting and information technology solutions provider to public sector organizations supporting health civilian and national security missions. The company is an award-winning SBA certified8(a) small businessthat hasbeen recognized byInc. Magazineeach of the past three years as one of the 250 fastest-growingcompanies in the U.S. Analytica specializes in providing software and systems engineering information management analytics & visualization agile project management and management consulting services. The companyis appraised by the Software Engineering Institute (SEI) atCMMI Maturity Level 3and is anISO 9001:2008 certifiedprovider.

Analytica LLC is an Equal Opportunity Employer. We are committed to providing equal employment opportunities to all individuals regardless of race color religion sex sexual orientation gender identity national origin age disability or any other characteristic protected by applicable federal state or local law. As a federal contractor we comply with the Vietnam Era Veterans Readjustment Assistance Act (VEVRAA) and take affirmative action to employ and advance in employment qualified protected veterans.

We ensure that all employment decisions are based on merit qualifications and business needs. We prohibit discrimination and harassment of any kind. Analytica LLC also provides reasonable accommodations to applicants and employees with disabilities in accordance with applicable laws

When receiving email communication from Analytica please ensure that the email domain is to verify its authenticity.

Required Experience:

Manager

Requirements Management:Elicit analyze and document complex business and technical requirements from various stakeholders to support data integration and reporting initiatives.

ETL Operations Support:Collaborate with data engineering teams to define test andvalidatedata extraction transformation and loading (ETL) processes from disparate sources (e.g. EHRs claims data clinical systems) into the enterprise data warehouse.

Data Modeling and Database Design:Support the design of data models and database structures including defining primary keys indexing strategies and normalization to ensure efficient data storage and retrieval.

SQL Development Support:Provide specifications andassistin the creation maintenance and optimization of SQL queries stored procedures and scripts used for data analysis and reporting.

Data Flow and Process Documentation:Develop andmaintaindetailed documentation including data flow diagrams source-to-target mapping documents and operational procedures to ensure transparency and reproducibility of data processes.

Reporting and Visualization:Define specifications for reports and dashboards (using tools like Power BI or Tableau) and collaborate with development teams to create visualizations that present complex healthcare data in an easily understandable format for decision-making.

Data Quality and Governance:Perform data profiling quality checks and gap analysis toidentifydiscrepancies and ensure the integrity accuracy and consistency of data across systems adhering to DHA data governance standards.

Testing and Validation:Create test plans and cases and coordinate User Acceptance Testing (UAT) using SQL scripts tovalidatesolutions before deployment.

Stakeholder Communication:Facilitatemeetings and serve as the bridge between technical teams and non-technical personnel (clinicians managers) to ensure alignment and effective communication throughout the project lifecycle.

Required Qualifications:

Education:Bachelors degree in Health Informatics Business Information Systems ora relatedtechnical field.

Experience:Proven experience as a Business Analyst in a healthcare or defense environment with a strong emphasis on data analysis and technical team support.

Technical Proficiency:

Strongproficiencyin SQL for data querying and analysis.

Experience with ETL frameworks and data warehousing concepts.

Familiarity with data visualization tools (e.g. Power BI Tableau) is a plus.

Understanding ofrelational database management system (RDBMS) concepts.

Domain Knowledge:Knowledge of healthcare operations data privacy laws (HIPAA etc.) and a working knowledge of the Military Health System (MHS) or DHA operations is highly desirable.

Soft Skills:Excellent analytical problem-solving and communication skills with the ability to translate complex technical issues to non-technical audiences.