Jr-Level Data Scientist

Pinao Consulting, LLC is a consulting company supporting government and public-sector data analytics services. The Junior-Level Data Scientist will support the Vision Center of Excellence by preparing, analyzing, validating, documenting, and visualizing ocular, clinical, vision, and population health data, while assisting with databases, ETL processes, dashboards, and approved artificial intelligence and machine learning activities.

What you'll do:

• Assist with analyzing, verifying, refining, and maintaining data models and component views within VCE systems, including data from Defense Health Agency and Department of Veterans Affairs medical systems
• Support reviews of DVEIVR data models, data logic, business rules, ontologies, and vocabularies by documenting findings, tracing data elements, and helping identify potential gaps
• Clean, transform, integrate, validate, and analyze structured and unstructured data sets using Structured Query Language (SQL), R, Python, flat files, and Extensible Markup Language (XML)
• Write and execute SQL queries under technical guidance to extract, summarize, and validate data for approved data requests, reports, and dashboards
• Assist with developing and testing algorithms for information retrieval, text extraction, classification, entity resolution, link analysis, semantic indexing, and related analytic activities
• Support the development and maintenance of data marts, data structures, tables, views, indexes, extract-transform-load (ETL) processes, and semantic data representations
• Assist with developing, publishing, testing, and maintaining reports, dashboards, templates, and user interfaces using tools such as R, Tableau, Qlik, Microsoft Power BI, and Python
• Perform routine data-quality checks, reconcile results, document anomalies, and elevate programming, metadata, data integration, or reporting issues to senior team members
• Collaborate with clinicians, epidemiologists, data architects, functional analysts, project managers, developers, and end users to clarify data needs and support delivery of usable data products
• Assist with maintaining clinical and vision-related case definitions, algorithms, ontologies, vocabularies, semantic models, data dictionaries, and searchable libraries
• Prepare and update technical documentation, including data maps, data rules, query documentation, data summaries, report design information, data dictionaries, and standard operating procedures
• Create clear tables, charts, visualizations, briefing materials, and written summaries for technical and nontechnical stakeholders

What they're looking for:

• Familiarity with business intelligence and data visualization tools, including Tableau and Microsoft Power BI, for developing interactive dashboards and reports
• Foundational experience in data science, data analytics, statistical programming, database querying, data management, or a closely related field through employment, internships, academic research, or applied projects
• Working knowledge of SQL and at least one analytical programming language, such as R or Python
• Experience cleaning, organizing, transforming, and validating data for analysis
• Ability to develop basic queries, data summaries, visualizations, reports, dashboards, or other analytic products with technical guidance
• Basic understanding of relational databases, data models, business rules, metadata, data mapping, and data quality principles
• Familiarity with one or more business intelligence or visualization tools, such as Tableau, Qlik, or Microsoft Power BI
• Ability to follow documented methods, maintain reproducible work, and clearly document assumptions, code, data transformations, and results
• Strong analytical, problem-solving, organizational, and attention-to-detail skills
• Effective written and verbal communication skills and the ability to collaborate in a multidisciplinary team environment
• Bachelor's degree in statistics, data science, computer science, informatics, mathematics, engineering, public health, or a related quantitative field; or an equivalent combination of education, training, and relevant experience
• Secret Security Clearance or ability to obtain one required

Benefits:

• Medical benefits; Pinao pays 80% for each employee and 50% for dependents.
• Dental plan; Pinao pays 100% for each employee and 50% for dependents.
• Vision plan; Pinao pays 100% for each employee and 50% for dependents.
• Group term and supplemental life insurance.
• Short-term disability insurance; Pinao pays 66.67% of the premium for each eligible employee.
• Long-term disability insurance; Pinao pays 66.67% of the premium for each eligible employee.
• Workman’s compensation.
• FICA/Medicare.
• State unemployment tax and Federal unemployment tax.
• 401K plan through Voya; Pinao pays all administration fees and provides matching funds up to 4% of a participating employee’s gross income.