Data Analyst II

It's fun to work in a company where people truly BELIEVE in what they're doing!

We're committed to bringing passion and customer focus to the business.

SUMMARY

The Data Analyst II provides support to the Department of Health and Human Services, Indian Health Services (IHS). This position defines and improves the software architecture of IHS applications through industry standard design patterns across the technical stack. The primary focus of this position is to implement data analysis, data validation, reporting projects and solutions based on Microsoft SharePoint, Dynamics 365 and ServiceNow.

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Assists in developing and maintaining Microsoft SQL server instances used by DPMB for data management.
2. Performs data extraction, transforms it, and loads it into MS SQL databases.
3. Analyzes existing MS SQL queries, views, stored procedures, and custom functions and recommends performance improvements.
4. Assists in designing, developing, and maintaining MS SQL database tables, views, stored procedures, and custom functions.
5. Assists in the evaluation and solution implementation to maintain data quality.
6. Assists in developing and maintaining an IT Service database that will contain cost models and service cost estimates.
7. Assists in developing and maintaining other databases as needed to manage IHS data.
8. Assists with developing and creating dashboard interfaces in Microsoft Power BI and other dashboarding tools to provide information to various stakeholders.
9. Assists with Microsoft SharePoint development and enhancements, data table management, and workflow design as required.
10. Assists with Microsoft Power Apps and Power Automate development, enhancements, and workflow design as required.
11. Develops automated data import and normalization tools to provide data in a standard format regardless of source formatting.
12. Prepares and processes bulk user info and service data updates to external vendor portals.
13. Review and analyze ongoing business requirements.
14. Assists with ServiceNow data table management, workflow design, and interface enhancements to meet new or changing processes or business models.
15. Assists in creating quarterly billing reports for cost recovery from internal IHS customers.
16. Assists in creating and maintaining monthly inventory reports for issued equipment and services for OIT programs.
17. Generates custom and ad hoc reports as required by IHS.
18. Generates custom, templated, and ad hoc reports as required by IHS, HHS, and OMB.
19. Plans daily activities within the guidelines of company policy, job description and supervisor’s instruction in such a way as to maximize personal output.
20. Responsible for keeping own immediate work area in a neat and orderly condition to ensure safety of self and co-workers. Will report any unsafe conditions and/or practices to the appropriate supervisor and human resources. Will immediately correct any unsafe conditions as the best of own ability.

CNI CORE COMPETENCIES

Responsible for the integration of CNI Core Competencies into daily functions, including: commitment to integrity, knowledge / quality of work, supporting financial goals of the company, initiative / motivation, cooperation / relationships, problem analysis / discretion, accomplishing goals through organization, positive oral / written communication skills, leadership abilities, commitment to Affirmative Action, reliability / dependability, flexibility and ownership / accountability of actions taken.

COMPLIANCE

Promotes and encourages a culture of compliance with all applicable rules (federal, state, local, Federal Acquisition Regulations, Code of Federal Regulations, Prime Contract requirements, etc.) for themselves and the company as a whole. Fosters an environment in which they will report any violations or reasonably suspected violation of CNI policy, FAR, and/or CFR and are comfortable discussing the myriad compliance, conflict, FAR, CFR, etc. issues that arise during the performance of a government contract.

EDUCATION/EXPERIENCE

Bachelor's degree in Computer Science, Computer Engineering or a related field of study and a minimum of eight (8) years’ relevant experience; or equivalent combination of education / experience / training.

CERTIFICATES, LICENSES, REGISTRATION

Ability to obtain a Public Trust Security Clearance

JOB SPECIFIC KNOWLEDGE / SKILLS / ABILITIES

1. Working knowledge of SQL / PLSQL and database capability in Oracle or SQL Server environments.
2. Working knowledge of HTML, XML / XSLT, CSS2, DHTML, Qliksense, and Microsoft PowerBI.
3. Proficient knowledge and understanding of software testing concepts, practices and procedures.
4. Operational knowledge and understanding of the various phases of Java development with ability to apply to government documentation standards.
5. Experience in developing Oracle database applications using SQL, PL/SQL, perform database logical and physical design.
6. Ability to work independently on modules, large subroutines, or small applications.
7. Excellent general computer skills with proficiency in Microsoft Windows / Office.
8. Solid analytical and problem-solving skills with ability to assess business requirements.
9. Ability to learn and apply new knowledge in a fast-paced environment.
10. Excellent organization skills with ability to manage multiple projects and priorities.
11. Excellent verbal, written and graphics communications skills.
12. Excellent customer service skills and ability to effectively interact with management and staff at all levels within a multi-level organization.
13. Ability to work both independently and in a team environment for the successful achievement of goals and objectives.

LANGUAGE SKILLS

Ability to read, analyze and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports,