The Analytica Business Intelligence interview guide, interview questions, salary data, and interview experiences.

Analytica Business Intelligence Interview Guide

<p>Getting ready for an Business Intelligence interview at Analytica? The Analytica Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:</p>
<ul>
<li>Know what skills are necessary for Analytica Business Intelligence roles.</li>
<li>Gain insights into the Business Intelligence interview process at Analytica.</li>
<li>Practice real Analytica Business Intelligence interview questions.</li>
</ul>
<p>Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Analytica Business Intelligence interview.</p>


Getting ready for an Business Intelligence interview at Analytica? The Analytica Business Intelligence interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Analytica Business Intelligence roles.
- Gain insights into the Business Intelligence interview process at Analytica.
- Practice real Analytica Business Intelligence interview questions.

Interview Query regularly analyzes interview experience data, and we've used that data to produce this guide, with sample interview questions and an overview of the Analytica Business Intelligence interview.
        

Overview

<p>We've gathered this data from parsing thousands of interview experiences sourced from members.</p>

We've gathered this data from parsing thousands of interview experiences sourced from members.

Analytica Business Intelligence Interview Process

<p>Suppose your company needs to cut costs due to an economic downturn. During a coffee break, you hear a rumor that a lot of money goes to employees who don’t do their work, and you decide to find out if the rumor is true.</p>

<p>Given two tables: <code>employees</code> and <code>projects</code>, find the sum of the salaries of all the employees who didn’t complete any of their projects.</p>

<p>Clarification:</p>

<p>We will consider a project unfinished if it has no end date (its <code>End_dt</code> is <code>NULL</code>).</p>

<p>Given this, we’ll say an employee didn’t finish any of their projects when:</p>

<ul>
<li>They were assigned at least one project.</li>
<li>None of their projects have an <code>End_dt</code>.</li>
</ul>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>employees</code> table</p>

<table>
<thead>
<tr>
<th>id</th>
<th>salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
<p><code>projects</code> table</p>

<table>
<thead>
<tr>
<th>employee_id</th>
<th>project_id</th>
<th>Start_dt</th>
<th>End_dt</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
<td>INTEGER</td>
<td>DATETIME</td>
<td>DATETIME</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>total_slack_salary</th>
</tr>
</thead>

<tbody>
<tr>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Find the total salary of slacking employees.

Slacking Employees Salaries

<p>You’ve been asked to analyze the player’s behaviors at a gaming company.</p>

<p>Write a query to get the number of players who played between 5 and 10 games (5 and 10 excluded), and the number of players who played 10 games or more.</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><strong><code>players</code></strong> table</p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>games_played</td>
<td>INTEGER</td>
</tr>

<tr>
<td>registered_at</td>
<td>TIMESTAMP</td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>players_more_than_5_to_10_games</td>
<td>INTEGER</td>
</tr>

<tr>
<td>players_10_plus_games</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>


Obtain count of players based on games played.

Player Analysis

<p>You have been given a table <code>tbl_numbers</code> with only one column: <code>int_numbers</code>.  It can have one integer number value per row in a sequential manner.</p>

<p>Write a query to return the number repeated by one times its own value.</p>

<p>For example, the integer number 5 would appear five times in the output (1 times 5).</p>

<p><strong>Example:</strong></p>

<p><strong>Input:</strong></p>

<p><code>tbl_numbers</code> table</p>

<table>
<thead>
<tr>
<th>int_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>
<p><strong>Output:</strong></p>

<table>
<thead>
<tr>
<th>seq_numbers</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>1</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>2</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>3</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>

<tr>
<td><code>4</code></td>
</tr>
</tbody>
</table>


Sequentially Fill in Integers

Analytica Business Intelligence Interview Questions

<p>Analytica is seeking a <strong>Data Engineer</strong> to support a complex data program for the Defense Health Agency. This role will work closely with reporting and analytics developers, data governance and data architects to build robust, high quality data pipelines that enhance productivity and operational efficiency. This position is for US Citizens only and candidate will hold (or be able to hold) a US Secret Clearance. The position is a remote position with occasional onsite meetings in at San Antonio, TX as required.<br><br>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.<br><br><strong>Responsibilities:</strong><ul><li>Support the Military Health System (MHS) by supporting data engineering that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset</li><li>Ensure data interoperability, governance, and quality to support enterprise-wide decision-making and healthcare optimization play a critical role in designing and implementing data architecture frameworks that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset.</li><li>Design and build robust and scalable data pipelines for managing structured and unstructured data using traditional databases (Oracle, PostgreSQL, etc.) or cloud Databases such as Amazon Redshift or AWS Vertica</li><li>Translate business needs into:<ul><li>data architecture solutions development within supported data systems.</li><li>data orchestration pipelines (source to target analysis & recommendations), data sourcing, cleansing, augmentation and quality control processes within supported data systems.</li><li>Prototype, test and integrate new data tools (i.e. data features and functionality) as defined by the product owners and business teams</li></ul></li><li>Monitor and troubleshoot data import, analysis, and display errors.<br></li></ul><strong>Required Qualifications:</strong><ul><li>Bachelors degree in information technology, Computer Science, Engineering or equivalent technical field</li><li>3+ years creating data pipelines using cloud based ETL tools, like AWS Glue (AWS preferred)</li><li>2+ years experience with Python and SQL (Java and Python preferred)</li><li>Experience working on relational NoSQL and SQL databases</li><li>Experience designing and implementing various data pipeline patterns and strategies</li><li>Strong knowledge of data security principles</li><li>Prior experience with DHA M2 or MDR databases, CERNER EHR a strong plus</li><li>Must be a US Citizen and must possess or be eligible for a SECRET clearance</li></ul><p><br>AboutANALYTICA: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD., the company is an established8(a) small businessthat has been recognized byInc. Magazineeach of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) atCMMI Maturity Level 3and is anISO 9001:2008 certifiedprovider.<br></p></p><h3>Seniority level</h3><ul><li><h3>Seniority level</h3>Mid-Senior level</li></ul><h3>Employment type</h3><ul><li><h3>Employment type</h3>Full-time</li></ul><h3>Job function</h3><ul><li><h3>Job function</h3>Sales, General Business, and Education</li><li><h3>Industries</h3>Wireless Services, Telecommunications, and Communications Equipment Manufacturing</li></ul><p>Referrals increase your chances of interviewing at Analytica by 2x</p><h3>Sign in to set job alerts for Data Engineer roles.</h3><p>Washington, DC $80,000.00-$100,000.00 15 hours ago</p><p>Washington, DC $65,000.00-$185,000.00 10 months ago</p><p>Sterling, VA $90,000.00-$185,000.00 2 weeks ago</p><p>Washington, DC $140,000.00-$170,000.00 2 months ago</p><p>Arlington, VA $150,000.00-$200,000.00 2 days ago</p><p>Reston, VA $75,000.00-$100,000.00 3 months ago</p><p>Arlington, VA $90,000.00-$100,000.00 1 week ago</p><p>Washington, DC $80,000.00-$100,000.00 15 hours ago</p><p>Washington DC-Baltimore Area 2 months ago</p><p>Fairfax, VA $135,000.00-$160,000.00 15 hours ago</p><p>Washington DC-Baltimore Area 16 hours ago</p><p>Sterling, VA $90,000.00-$185,000.00 3 weeks ago</p><p>Chevy Chase, MD $80,000.00-$160,000.00 2 days ago</p><p>Washington DC-Baltimore Area 2 months ago</p><p>Washington DC-Baltimore Area 2 months ago</p><p>Washington, DC $110,000.00-$125,000.00 4 months ago</p><p>Washington, DC $80,000.00-$100,000.00 3 months ago</p><p>Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.</p><br/>#J-18808-Ljbffr

Analytica is seeking a  Data Engineer  to support a complex data program for the Defense Health Agency. This role will work closely with reporting and analytics developers, data governance and data architects to build robust, high quality data pipelines that enhance productivity and operational efficiency. This position is for US Citizens only and candidate will hold (or be able to hold) a US Secret Clearance. The position is a remote position with occasional onsite meetings in at San Antonio, TX as required.

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:   Support the Military Health System (MHS) by supporting data engineering that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset
Ensure data interoperability, governance, and quality to support enterprise-wide decision-making and healthcare optimization play a critical role in designing and implementing data architecture frameworks that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset.
Design and build robust and scalable data pipelines for managing structured and unstructured data using traditional databases (Oracle, PostgreSQL, etc.) or cloud Databases such as Amazon Redshift or AWS Vertica
Translate business needs into:  data architecture solutions development within supported data systems.
data orchestration pipelines (source to target analysis & recommendations), data sourcing, cleansing, augmentation and quality control processes within supported data systems.
Prototype, test and integrate new data tools (i.e. data features and functionality) as defined by the product owners and business teams

Monitor and troubleshoot data import, analysis, and display errors.

Required Qualifications:   Bachelor’s degree in information technology, Computer Science, Engineering or equivalent technical field
3+ years creating data pipelines using cloud based ETL tools, like AWS Glue (AWS preferred)
2+ years experience with Python and SQL (Java and Python preferred)
Experience working on relational NoSQL and SQL databases
Experience designing and implementing various data pipeline patterns and strategies
Strong knowledge of data security principles
Prior experience with DHA M2 or MDR databases, CERNER EHR a strong plus
Must be a US Citizen and must possess or be eligible for a SECRET clearance

AboutANALYTICA: Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD., the company is an established8(a) small businessthat has been recognized byInc. Magazineeach of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) atCMMI Maturity Level 3and is anISO 9001:2008 certifiedprovider.

Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Full-time
Job function    Job function Sales, General Business, and Education
Industries Wireless Services, Telecommunications, and Communications Equipment Manufacturing
Referrals increase your chances of interviewing at Analytica by 2x
Sign in to set job alerts for “Data Engineer” roles.  Washington, DC $80,000.00-$100,000.00 15 hours ago
Washington, DC $65,000.00-$185,000.00 10 months ago
Sterling, VA $90,000.00-$185,000.00 2 weeks ago
Washington, DC $140,000.00-$170,000.00 2 months ago
Arlington, VA $150,000.00-$200,000.00 2 days ago
Reston, VA $75,000.00-$100,000.00 3 months ago
Arlington, VA $90,000.00-$100,000.00 1 week ago
Washington, DC $80,000.00-$100,000.00 15 hours ago
Washington DC-Baltimore Area 2 months ago
Fairfax, VA $135,000.00-$160,000.00 15 hours ago
Washington DC-Baltimore Area 16 hours ago
Sterling, VA $90,000.00-$185,000.00 3 weeks ago
Chevy Chase, MD $80,000.00-$160,000.00 2 days ago
Washington DC-Baltimore Area 2 months ago
Washington DC-Baltimore Area 2 months ago
Washington, DC $110,000.00-$125,000.00 4 months ago
Washington, DC $80,000.00-$100,000.00 3 months ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Join to apply for the  Data Scientist  role at  Analytica
Join to apply for the  Data Scientist  role at  Analytica
Analytica is seeking a Junior  Data Scientist  to remotely support a high-profile financial regulatory client with a data and analytics program. The ideal candidate will provide hand-on support in developing data pipelines and analytics solutions within an AWS environment.

Analytica has been recognized by Inc. for 3 consecutive years as one of the 250 fastest growing business. We offer competitive compensation with opportunities for bonuses, employer paid health care, training and development funds, and 401k match.

Responsibilities include:   Provide statistical analysis and model development using programming languages
Develop analytics solutions that are scalable, repeatable, effective, and meet the expectations of the decision-makers and stakeholders
Perform data analysis, research and data manipulation tasks
Perform queries and interpret business data requests to create efficient queries
Directly support users by developing advanced reporting and analytics
Work with project stakeholders and the software development team to develop data analysis
Assisting users in choosing data sources and discovering new methods for achieving goals
Qualifications:
Bachelor’s degree in Math, Statistics, Economics, Computer Science, or any other quantitative field
3+ years’ experience in data analysis or analytical field
Ability to extract data, transform data, manipulate data and perform analysis
Demonstrated knowledge of data concepts and experience working with data architects in the design of database schemas
Strong skills in various data analysis and visualization tools including SQL Server, Tableau, Python, R, SAS, Excel and PowerPoint
Proficiency with statistical tools (SAS, R) and analysis is preferred
Experienced in machine learning, deep learning, and natural language processing (NLP) are a plus
Must be a US citizen
Must be able to obtain and maintain a Public trust security clearancefor the supported agencies
AboutANALYTICA:Analytica is 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 8(a) small businessthat hasbeen recognized byInc. Magazineeach of the past three years as one of the 250 fastest-growingcompanies in theU.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services.The companyis appraised by theSoftware Engineering Institute (SEI) atCMMI Maturity Level 3and is anISO 9001:2008 certifiedprovider.

Seniority level    Seniority level Entry level
Employment type    Employment type Full-time
Job function    Job function Sales, General Business, and Education
Industries Wireless Services, Telecommunications, and Communications Equipment Manufacturing
Referrals increase your chances of interviewing at Analytica by 2x
Sign in to set job alerts for “Data Scientist” roles.  Washington, DC $80,000.00-$120,000.00 1 week ago
Washington DC-Baltimore Area $120,000.00-$130,000.00 2 weeks ago
Silver Spring, MD $109,600.00-$127,406.00 2 weeks ago
Senior Public Sector Research Scientist, Machine Learning  Washington DC-Baltimore Area $180,000.00-$220,000.00 3 weeks ago
Data Scientist (Secret Clearance required)  SCA Data Scientist/Analyst (AI/Automations)  Washington, DC $120,000.00-$145,000.00 1 week ago
Washington DC-Baltimore Area 44 minutes ago
Geospatial Scientist, Data Collection and Quality  Columbia, MD $170,000.00-$230,000.00 5 days ago
Washington, DC $170,000.00-$230,000.00 1 week ago
AI Research Scientist: AEC. Remote US or Canada  A&A Data Scientist/Analyst (AI/Automation) (REMOTE)  Maryland, United States $94,000.00-$182,250.00 1 week ago
Washington DC-Baltimore Area $220,000.00-$230,000.00 1 month ago
Maryland, United States $80,000.00-$160,000.00 7 months ago
Washington, DC $200,000.00-$265,000.00 2 weeks ago
Lead Consultant, Machine Learning Engineer  Washington, DC $150,000.00-$300,000.00 1 week ago
College Park, MD $90.00-$105.00 2 months ago
Principal AI Research Scientist (remote)  McLean, VA $170,000.00-$185,000.00 3 days ago
Washington DC-Baltimore Area $184,000.00-$250,000.00 3 weeks ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Join to apply for the  Senior Data Architect  role at  Analytica
Continue with Google Continue with Google
Join to apply for the  Senior Data Architect  role at  Analytica
Get AI-powered advice on this job and more exclusive features.
Sign in to access AI-powered advices  Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
This range is provided by Analytica. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.
Base pay range  $160,000.00/yr - $180,000.00/yr
Direct message the job poster from Analytica
Analytica is seeking a Senior Data Architect to lead a high-profile data management program supporting mission critical health care analytics for the Defense Health Agency. The ideal candidate should have large scale data architecture, governance and management experience with architecting Azure and AWS cloud data services for Enterprise Analytics.
The candidate needs to be a US Citizen with a SECRET clearance or the ability to secure a SECRET clearance. The role may be Hybrid, either in San Antonio Tx or Falls Church VA, or potentially remote with periodic travel for meetings.
Analytica has been recognized by Inc. Magazine as 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:
Lead data architecture and design for implementing data architecture frameworks that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset.
Ensure data interoperability, governance, and quality to support enterprise-wide decision-making and healthcare optimization play a critical role in designing and implementing data architecture frameworks that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset.
Define and Implement data architecture standards, frameworks and guidelines to ensure data platform efficiency and to ensure high quality data for gaining insights / downstream consumptions
Lead the creation of data models to standardize data definitions, relationships and semantics across systems
Collaborate with extended teams and stakeholders to establish data standards, metadata management practices and data quality frameworks
Design scalable architectures that integrate various data sources, systems, and platforms while minimizing duplication
Data Integration: Facilitate the integration of diverse data sources into unified structures, ensuring seamless data flow across the organization.
Master Data Management: Collaborate with HIT divisions and PMOs to establish master data management frameworks and standards.
Governance Support: Assist in defining and implementing data governance policies, procedures, and guidelines aligned with organizational goals.
Interoperability: Enhance data interoperability by defining well-structured data and information exchanges.
Compliance: Ensure alignment with regulatory requirements, security standards, and mission-critical objectives.
Documentation: Maintain detailed documentation of data architecture, processes, and standards.
Required Qualifications:
Bachelor’s degree in Computer Science, Information Technology, or related field.
7+ years of experience in data architecture, data modeling, or related roles.
Proven experience in architecting, management and evolving a hybrid enterprise data environment for analytics using Azure Synapse, Amazon Redshift, Glue, EMR, and Athena for high volume data and analytics products
Proficiency in data modeling tools and techniques, including developing conceptual and logical data models.
Strong knowledge of SQL, metadata management, and data integration processes.
Ability to collaborate with cross-functional teams and stakeholder
Strong knowledge of SQL, metadata management, and data integration processes.
Ability to collaborate with cross-functional teams and stakeholder
Must possess or be eligible for a SECRET clearance
About Analytica:   Analytica  is 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 certified 8(a) small business  that has been recognized by  Inc. Magazine  each of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI Maturity Level 3 and is an ISO 9001:2008 certified provider.
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 analytica.net to verify its authenticity.
Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Full-time
Job function    Job function Information Technology
Industries IT Services and IT Consulting
Referrals increase your chances of interviewing at Analytica by 2x
Inferred from the description for this job  Medical insurance
401(k)
Disability insurance
Paid maternity leave
Get notified when a new job is posted.
Sign in to set job alerts for “Data Architect” roles.  Continue with Google Continue with Google
Continue with Google Continue with Google
Presales Data Science Architect – AWS Cloud  San Antonio, TX $187,200 - $383,900 2 weeks ago
San Antonio, TX $111,690 - $136,510 1 day ago
San Antonio, TX $158,000 - $197,000 14 hours ago
Integrated Justice Architect - Government Sector - Manager - Consulting - Location Open  *Internal Only* Data Management Analyst II (DCOPS-Operations Support)  ServiceNow CMDB ITOM Engineer – Data Manager - Hybrid  San Antonio, TX
$115,760.00
-
$173,640.00
2 weeks ago
LHIP Internship: Cultural Landscape Management Intern (DHA) - ONSITE - San Antonio Missions National Historical Park  Data Management Analyst - Entry Level (Must HaveWorkday Exp)  Kinaxis Integration Lead Specialist Master  San Antonio, TX
$130,800.00
-
$241,000.00
13 hours ago
San Antonio, Texas Metropolitan Area 23 hours ago
Python and Kubernetes Software Engineer - Data, AI/ML & Analytics  Architecture Opportunities (Data Center/Mission Critical Facilities)  We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

Analytica is seeking a  Data Analyst  to support one or more dynamic, long-term federal government enterprise data programs for the Defense Health Agency.

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:
Support the Military Health System (MHS) by analyzing complex datasets, developing reports, and enabling data-driven decision-making to improve healthcare quality, readiness, and operational efficiency
Analyze healthcare and business data to identify trends, insights, and areas for improvement.
Develop dashboards, reports, and visualizations using tools like Tableau, Power BI, or SAS.
Collaborate with stakeholders to define data requirements and ensure data quality.
Perform ad hoc data queries and generate reports to support leadership decisions.
Link program data with other health and personnel datasets to support longitudinal analysis.
Monitor and troubleshoot data import, analysis, and display errors.
Required Qualifications:               Bachelor’s degree in Data Science, Statistics, Computer Science, or related field.
Proven ability to analyze large datasets, synthesize insights, and create actionable reports.
Proficiency in SQL, Python, R, or SAS; advanced knowledge of data visualization tools (e.g., Tableau, Power BI); strong analytical and problem-solving skills.
Familiarity with Defense Department Data Sources; experience in healthcare analytics.
Proven ability to synthesize disparate data from multiple sources into accurate and useful analytic products
Demonstrated ability to provide timely analytical products with substantiated options or courses of action.
Must possess or be eligible for a SECRET clearance

AboutAnalytica:  Analytica is 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 business that hasbeen recognized by Inc. Magazine each 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 Employment Opportunity and Affirmative Action employer. We value diversity at all levels. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, religion or religious creed, color, gender, gender identity, gender expression, national origin, ancestry, physical or mental disability, medical condition, genetic information, marital status, registered domestic partner status, age, sexual orientation, military or veteran status, protected veteran status, or any other basis protected by federal, state, local law, ordinance, or regulation and will not be discriminated against on these bases
When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.

#J-18808-Ljbffr

Analytica is seeking a  Data Engineer  to support a complex data program for the Defense Health Agency. This role will work closely with reporting and analytics developers, data governance and data architects to build robust, high quality data pipelines that enhance productivity and operational efficiency. This position is for US Citizens only and candidate will hold (or be able to hold) a US Secret Clearance. The position is a remote position with occasional onsite meetings in at San Antonio, TX as required.

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:             Support the Military Health System (MHS) by supporting data engineering that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset
Ensure data interoperability, governance, and quality to support enterprise-wide decision-making and healthcare optimization play a critical role in designing and implementing data architecture frameworks that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset.
Design and build robust and scalable data pipelines for managing structured and unstructured data using traditional databases (Oracle, PostgreSQL, etc.) or cloud Databases such as Amazon Redshift or AWS Vertica
Translate business needs into:          data architecture solutions development within supported data systems.
data orchestration pipelines (source to target analysis & recommendations), data sourcing, cleansing, augmentation and quality control processes within supported data systems.
Prototype, test and integrate new data tools (i.e. data features and functionality) as defined by the product owners and business teams

Monitor and troubleshoot data import, analysis, and display errors.

Required Qualifications:               Bachelor’s degree in information technology, Computer Science, Engineering or equivalent technical field
3+ years creating data pipelines using cloud based ETL tools, like AWS Glue (AWS preferred)
2+ years experience with Python and SQL (Java and Python preferred)
Experience working on relational NoSQL and SQL databases
Experience designing and implementing various data pipeline patterns and strategies
Strong knowledge of data security principles
Prior experience with DHA M2 or MDR databases, CERNER EHR a strong plus
Must be a US Citizen and must possess or be eligible for a SECRET clearance

About ANALYTICA : Analytica is a leading consulting and information technology solutions provider to public sector organizations supporting health, civilian, and national security missions. Founded in 2009 and headquartered in Bethesda, MD., the company is an established 8(a) small business that has been recognized byInc. Magazineeach of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI Maturity Level 3 and is an ISO 9001:2008 certified provider.

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 analytica.net to verify its authenticity.

#J-18808-Ljbffr

Analytica is seeking a  Data Analyst  to support one or more dynamic, long-term federal government enterprise data programs for the Defense Health Agency.

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:
Support the Military Health System (MHS) by analyzing complex datasets, developing reports, and enabling data-driven decision-making to improve healthcare quality, readiness, and operational efficiency
Analyze healthcare and business data to identify trends, insights, and areas for improvement.
Develop dashboards, reports, and visualizations using tools like Tableau, Power BI, or SAS.
Collaborate with stakeholders to define data requirements and ensure data quality.
Perform ad hoc data queries and generate reports to support leadership decisions.
Link program data with other health and personnel datasets to support longitudinal analysis.
Monitor and troubleshoot data import, analysis, and display errors.
Analytica is seeking a  Data Analyst  to support one or more dynamic, long-term federal government enterprise data programs for the Defense Health Agency.

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:
Support the Military Health System (MHS) by analyzing complex datasets, developing reports, and enabling data-driven decision-making to improve healthcare quality, readiness, and operational efficiency
Analyze healthcare and business data to identify trends, insights, and areas for improvement.
Develop dashboards, reports, and visualizations using tools like Tableau, Power BI, or SAS.
Collaborate with stakeholders to define data requirements and ensure data quality.
Perform ad hoc data queries and generate reports to support leadership decisions.
Link program data with other health and personnel datasets to support longitudinal analysis.
Monitor and troubleshoot data import, analysis, and display errors.
Required Qualifications:   Bachelor’s degree in Data Science, Statistics, Computer Science, or related field.
Proven ability to analyze large datasets, synthesize insights, and create actionable reports.
Proficiency in SQL, Python, R, or SAS; advanced knowledge of data visualization tools (e.g., Tableau, Power BI); strong analytical and problem-solving skills.
Familiarity with Defense Department Data Sources; experience in healthcare analytics.
Proven ability to synthesize disparate data from multiple sources into accurate and useful analytic products
Demonstrated ability to provide timely analytical products with substantiated options or courses of action.
Must possess or be eligible for a SECRET clearance

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-winningSBA certified8(a) small businessthat hasbeen recognized by Inc. Magazine each 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.

Seniority level    Seniority level Entry level
Employment type    Employment type Full-time
Job function    Job function Sales, General Business, and Education
Industries Wireless Services, Telecommunications, and Communications Equipment Manufacturing
Referrals increase your chances of interviewing at Analytica by 2x
Washington, DC $60,000 - $75,000 4 days ago
District of Columbia, United States 3 months ago
Washington, DC $62,000 - $141,000 3 days ago
We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr

<h3>Job Description</h3><div>Job Description<div><p>Analytica is seeking a <strong>Data Analyst</strong> to support one or more dynamic, long-term federal government enterprise data programs for the Defense Health Agency.  <br><br>Analytica has been recognized by Inc. Magazine as 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.   <br><br><b>Responsibilities:</b> ​</p><ul><li>Support the Military Health System (MHS) by analyzing complex datasets, developing reports, and enabling data-driven decision-making to improve healthcare quality, readiness, and operational efficiency</li><li>Analyze healthcare and business data to identify trends, insights, and areas for improvement. </li><li>Develop dashboards, reports, and visualizations using tools like Tableau, Power BI, or SAS. </li><li>Collaborate with stakeholders to define data requirements and ensure data quality. </li><li>Perform ad hoc data queries and generate reports to support leadership decisions. </li><li>Link program data with other health and personnel datasets to support longitudinal analysis. </li><li>Monitor and troubleshoot data import, analysis, and display errors. </li></ul><b>Required Qualifications: </b><b>​</b><ul><li>Bachelor’s degree in Data Science, Statistics, Computer Science, or related field.</li><li>Proven ability to analyze large datasets, synthesize insights, and create actionable reports. ​</li><li>Proficiency in SQL, Python, R, or SAS; advanced knowledge of data visualization tools (e.g., Tableau, Power BI); strong analytical and problem-solving skills. ​</li><li>Familiarity with Defense Department Data Sources; experience in healthcare analytics.</li><li>Proven ability to synthesize disparate data from multiple sources into accurate and useful analytic products</li><li>Demonstrated ability to provide timely analytical products with substantiated options or courses of action. ​</li><li><b>Must possess or be eligible for a SECRET clearance</b></li></ul><p><br /><b>About Analytica: </b>Analytica is 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 certified 8(a) small business that has been recognized by <i>Inc. Magazine </i>each of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI® Maturity Level 3 and is an ISO 9001:2008 certified provider.<br><br> </p><p>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. </p><p>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</p><p>When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.</p><p>Powered by JazzHR</p><p>1adPPfoABz</p></div></div>

<h3>Job Description</h3><div>Job Description<div><p>Analytica is seeking a Senior Data Architect to lead a high-profile data management program supporting mission critical health care analytics for the Defense Health Agency. The ideal candidate should have large scale data architecture, governance and management experience with architecting Azure and AWS cloud data services for Enterprise Analytics.<br><br>The candidate needs to be a US Citizen with a SECRET clearance or the ability to secure a SECRET clearance. The role may be Hybrid, either in San Antonio Tx or Falls Church VA, or potentially remote with periodic travel for meetings.<br><br>Analytica has been recognized by Inc. Magazine as 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.   <br /><b>Responsibilities:</b> ​</p><ul><li>Lead data architecture and design for implementing data architecture frameworks that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset.  </li><li>Ensure data interoperability, governance, and quality to support enterprise-wide decision-making and healthcare optimization play a critical role in designing and implementing data architecture frameworks that enhance the Military Health System's (MHS) ability to leverage data as a strategic asset.</li><li>Define and Implement data architecture standards, frameworks and guidelines to ensure data platform efficiency and to ensure high quality data for gaining insights / downstream consumptions</li><li>Lead the creation of data models to standardize data definitions, relationships and semantics across systems</li><li>Collaborate with extended teams and stakeholders to establish data standards, metadata management practices and data quality frameworks</li><li>Design scalable architectures that integrate various data sources, systems, and platforms while minimizing duplication</li><li>Data Integration: Facilitate the integration of diverse data sources into unified structures, ensuring seamless data flow across the organization. ​</li><li>Master Data Management: Collaborate with HIT divisions and PMOs to establish master data management frameworks and standards. ​</li><li>Governance Support: Assist in defining and implementing data governance policies, procedures, and guidelines aligned with organizational goals. ​</li><li>Interoperability: Enhance data interoperability by defining well-structured data and information exchanges. ​</li><li>Compliance: Ensure alignment with regulatory requirements, security standards, and mission-critical objectives. ​</li><li>Documentation: Maintain detailed documentation of data architecture, processes, and standards.</li></ul><b>Required Qualifications: </b><b>​</b><ul><li>Bachelor’s degree in Computer Science, Information Technology, or related field. ​</li><li>7+ years of experience in data architecture, data modeling, or related roles.</li><li>Proven experience in architecting, management and evolving a hybrid enterprise data environment for analytics using Azure Synapse, Amazon Redshift, Glue, EMR, and Athena for high volume data and analytics products   </li><li>Proficiency in data modeling tools and techniques, including developing conceptual and logical data models.</li><li>Strong knowledge of SQL, metadata management, and data integration processes.</li><li>Ability to collaborate with cross-functional teams and stakeholder</li><li>Strong knowledge of SQL, metadata management, and data integration processes.</li><li>Ability to collaborate with cross-functional teams and stakeholder</li><li><b>Must possess or be eligible for a SECRET clearance</b></li></ul><p><br /><b>About Analytica: </b>Analytica is 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 certified 8(a) small business that has been recognized by <i>Inc. Magazine </i>each of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI® Maturity Level 3 and is an ISO 9001:2008 certified provider.<br><br> </p><p>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. </p><p>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</p><p>When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.</p><p>Powered by JazzHR</p><p>czOkR5LwtQ</p></div></div>

<h3>Job Description</h3><div>Job Description<div>Analytica is seeking a <b>Data Scientist</b> to support a defense health mission critical program. The ideal candidate will be comfortable working directly with clients in consulting and delivery capacity to provide solutions that tackle complex problems. The person needs to be a US Citizen with a SECRET clearance or the ability to secure a SECRET clearance.  The role may be Hybrid, either in San Antonio Tx or Falls Church VA or potentially remote with periodic travel for meetings.<br><br>Analytica is looking for bright, motivated professionals who want to continue their careers in the data analytics field. The data scientist will support the agency’s mission to provide high-quality healthcare for beneficiaries and their families. The ideal candidate will work across different project workstreams to help analyze and improve quality of care on a range of special topics.<br /> <br />Analytica has been recognized by Inc. Magazine as a fastest-growing private US small business.  We work with U.S. government customers in health, civilian, and national security missions.  Analytica offers competitive compensation with opportunities for bonuses, employer paid health care, training and development funds, and 401k match. <br><br><b>Responsibilities include (but are not limited to):</b><ul><li>Demonstrate experience working with military or veteran healthcare systems (e.g., DHA, VA), with a deep understanding of healthcare data, regulatory compliance, and mission-driven care delivery.</li><li>Conduct ETL, exploratory data analysis (EDA), data wrangling to develop and present innovative ML algorithms to enhance healthcare system and collaboration.</li><li>Apply ML techniques and time series for predictive analytics to support faster and more accurate healthcare outcomes.</li><li>Design, develop, deploy NLP and AI/ML models incorporating unit testing, performance validation, and post-deployment monitoring to ensure reliability and scalability.</li><li>Develop interactive, user-friendly dashboards and visualizations in Python, Power BI, and/or Tableau to support real-time healthcare analytics and decision-making.</li><li>Work with clinical and operational stakeholders to gather requirements and translate them into meaningful, data-driven visual solutions.</li><li>Enhance user engagement with dynamic, drill-through capabilities and actionable insights embedded within dashboards.</li><li>Execute thorough quality control procedures to ensure high reliability, data integrity, and optimized performance of ML algorithms and dashboard solutions</li><li>Produce clear and comprehensive documentation, including business requirements, technical specifications, and user training materials tailored to AI/ML and dashboard solutions.</li><li>Develop presentation materials (e.g., PowerPoint summaries, technical briefs) to support algorithm approval processes and facilitate stakeholder communication.</li><li>Maintain versioned documentation to support compliance, reproducibility, and knowledge transfer across teams.</li></ul><b>Basic Qualifications:</b><ul><li>Bachelor’s or master’s degree in data science, data analytics, statistics, computer science, health policy, or public health.</li><li>Must be able to maintain a Secret security clearance.</li><li>3+ years of experience in Python, R, and/or SQL for programming, ETL, and data analysis.</li><li>Strong knowledge of statistical programming concepts and best practices.</li><li>Experience with machine learning development, including creating training/testing sets, validation sets, target definition, and algorithm evaluation criteria.</li><li>Hands-on experience building ML algorithms such as regularized regression, random forest, XGBoost, and neural networks.</li><li>Experience delivering analytic dashboard products (Tableau and/or Power BI) is required.</li><li>Demonstrated experience with SQL development, including writing queries, procedures, and performing query optimization.</li><li>Proven ability to investigate, report, and justify algorithm results, and present insights in the context of organizational business challenges.</li><li>Excellent written and verbal communication skills; able to convey technical concepts to a wide range of audiences and maintain effective interpersonal relationships.</li><li>Ability to manage multiple tasks within time constraints and meet critical deadlines.</li></ul><b>Key Technical Skills</b><ul><li>Proficient in Python, R, SQL for ETL, data analysis and ML development.</li><li>Skilled in data visualization and business intelligence tools (e.g., Power BI, Tableau).</li><li>Experienced with git version control systems (e.g., Github and Gitlab).</li><li>Experience with cloud platforms such as AWS and a variety of DBMS that are primarily analytic databases, like Amazon Redshift and Vertica for scalable ML solutions</li></ul><b>Preferred Qualifications:</b><ul><li>Familiar with large language models (LLMs), chatbots, and recommendation systems to improve decision-making.</li></ul><ul><li>Provide mentorship and technical support to junior data scientists and analysts, fostering a collaborative and innovative team culture.</li><li>Share best practices and promote continuous learning in AI/ML methodologies and tools aligned with business goals.</li><li>Implement automated testing frameworks and monitoring tools to maintain consistent deployment quality across data applications.</li><li>Experience with the Department of Defense or a Federal health care entity.</li><li>Experience in a private sector of health care.</li><li>Experience with building and maintaining client relationships.</li></ul><br /><b>About Analytica: </b>Analytica is 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 certified 8(a) small business that has been recognized by <i>Inc. Magazine </i>each of the past three years as one of the 250 fastest-growing companies in the U.S. Analytica specializes in providing software and systems engineering, information management, analytics & visualization, agile project management, and management consulting services. The company is appraised by the Software Engineering Institute (SEI) at CMMI® Maturity Level 3 and is an ISO 9001:2008 certified provider.<br><br> <p>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. </p><p>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</p><p>When receiving email communication from Analytica, please ensure that the email domain is analytica.net to verify its authenticity.</p><p>Powered by JazzHR</p><p>HnKJk6xfac</p></div></div>

Question	Topic	Difficulty	Ask Chance
Slacking Employees Salaries	SQL	Medium	Very High
Player Analysis	SQL	Easy	Very High
Sequentially Fill in Integers	SQL	Hard	Very High

Analytica Business Intelligence Interview Guide

Overview

Analytica Business Intelligence Interview Process

Analytica Business Intelligence Interview Questions

Analytica Business Intelligence Jobs