The Columbia Business School Data Analyst interview guide, interview questions, salary data, and interview experiences.

Columbia Business School Data Analyst Interview Guide

Getting ready for an Data Analyst interview at Columbia Business School? The Columbia Business School Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:
<ul>
<li>Know what skills are necessary for Columbia Business School Data Analyst roles.</li>
<li>Gain insights into the Data Analyst interview process at Columbia Business School.</li>
<li>Practice real Columbia Business School Data Analyst interview questions.</li>
</ul>
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 Columbia Business School Data Analyst interview.


Getting ready for an Data Analyst interview at Columbia Business School? The Columbia Business School Data Analyst interview span across 10 to 12 different question topics. In preparing for the interview:

- Know what skills are necessary for Columbia Business School Data Analyst roles.
- Gain insights into the Data Analyst interview process at Columbia Business School.
- Practice real Columbia Business School Data Analyst 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 Columbia Business School Data Analyst interview.
        

Overview

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

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

Columbia Business School Data Analyst Interview Process

Let’s say your team at Spotify wants to determine if a recently launched feature, curated playlists, has increased user engagement. However Spotify launched the feature without an A/B test.

How would you measure the effect of curated playlists on user engagement?

How would you establish causal inference to measure the effect of curated playlists on engagement without A/B?

Causal Inference Without A/B

As part of the financial management in a large corporation, the CFO wants to review the expenses in all departments for the previous financial year (2022).

Write a SQL query to calculate the total expenditure for each department in 2022. Additionally, for comparison purposes, return the average expense across all departments in 2022.

Note: The output should include the department name, the total expense, and the average expense (rounded to 2 decimal places). The data should be sorted in descending order by total expenditure.

<h3>Example:</h3>

Input:

<code>departments</code> table

<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>
</tbody>
</table>
<code>expenses</code> table

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

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

<tr>
<td>department_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>amount</td>
<td>FLOAT</td>
</tr>

<tr>
<td>date</td>
<td>DATE</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td>department_name</td>
<td>VARCHAR</td>
</tr>

<tr>
<td>total_expense</td>
<td>FLOAT</td>
</tr>

<tr>
<td>average_expense</td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Calculate total and average expenses for each department.

Department Expenses

The probability that it will rain tomorrow is dependent on whether or not it is raining today and whether or not it rained yesterday.

If it rained yesterday and today, there is a 20% chance it will rain tomorrow. If it rained one of the days, there is a 60% chance it will rain tomorrow. If it rained neither today nor yesterday, there is a 20% chance it will rain tomorrow.

Given that it is raining today and that it rained yesterday, write a function <code>rain_days</code> to calculate the probability that it will rain on the nth day after today.

Example:

Input:

<pre tabindex="0" class="chroma"><code>n=5
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def rain_days(n) -&gt; 0.39968
</code></pre>

Given that it is raining today and that it rained yesterday, write a function to calculate the probability that it will rain on the nth day after today.

Rain in N Days

Columbia Business School Data Analyst Interview Questions

Description
JOB TITLE:  Social Care Network Data Analyst
Department : Community Services
Location:  Main office, Brooklyn, NY
Exemption:  Non-Exempt
Schedule : Full-time at 35 hours per week
Salary : $50,000
Reports To:  Director of Community Services and Director of Data Systems & Analytics
Center for Family Life in Sunset Park (CFL) is a neighborhood-based 501(c)3 non-profit organization that aims to promote positive outcomes for children and adults through a comprehensive range of youth, family, and social services programs. Since 1978, CFL has grown with the dynamic, immigrant community of Sunset Park, offering access to resources that families need to thrive and responding to emerging needs with innovative programs including family counseling, cultural, educational, and recreational programs at neighborhood public schools, adult and youth employment programs, and an emergency storefront for food, legal and immigration services, and advocacy. In partnership with our community, we provide opportunities for personal development, enrich neighborhood residents’ quality of life, and nurture relationships that sustain families and support youth in becoming confident, capable adults.
The Social Care Network Data Analyst will support our new Social Care Network (SCN), which aims to identify, screen, and monitor eligible Medicaid Members with Health-Related Social Needs. This position will include detailed data entry into a Medicaid-specific monitoring platform and ensuring compliance with our partner agency, Public Health Solutions, on any requests, including submission of all necessary documentation to support Medicaid billing, reimbursement, and capacity-building expenditure audits to complete all reporting requirements. Additional responsibilities include liaising with partners in our SCN, assisting in the operational set-up of our new program, and other administrative tasks related to our SCN. Detail-oriented, strong organizational skills and a focus on process improvement are key.
I.   SPECIFIC   RESPONSIBILITIES include but are not limited to
Data Analysis
Entry : Prepare and record outcomes for client data of Medicare-eligible members.
Compliance:  Ensure that client data, data sharing and outcome reporting is in compliance with legal standards and into Public Health Solutions’ Unite Us Platform.
Monitoring : Monitor client outcomes including referral statuses and service provisions.
Reporting : Collaborate with our Development and Finance teams on reporting accurate outcome data on our Social Network.
Effectively utilize external and internal databases (e.g. ClientTrack, Client Navigator)
Abide by privacy laws and understand the need to maintain client confidentiality
Social Care Network Program Onboarding
Assist in onboarding SCN program staff and tasks with a supervisor
Participate in Public Health Solutions-led training, liaison with SCN stakeholders
Collaborate with supervisor for timely implementation of SCN into current intake procedure
Social Care Network Governance
Ensure program staff are compliant in the administration of Health-Related Social Needs screenings through full integration of the Accountable Health Communities (AHC) HRSN Screening Tool into our SCN.
Assist with weekly check-ins to coordinate programmatic changes or updates with SCN staff.
Liaison with, and if necessary, train program staff to ensure compliance with SCN Care Management.
Medicaid Reimbursement Quality Review
Develop improved organization capacity for Medicaid reimbursement procedure with the Development and Finance teams.
Perform quality assurance review of all deliverables to ensure that only screens of eligible Medicaid Members (both FFS and Managed Care Members) would occur
Assist our Finance teaminmonitoring SCN spending as aligned with the budget
Recommend possible actions to improve existing processes
Administrative Tasks
Respond to general tasks around SCN staff training and program implementation
Assist with preparing SCN-related paperwork and meetings
Assist with preparing contractual materials
Outreach
Assist with Supervisor to devise outreach towards Medicaid-eligible clients in Sunset Park
Coordinaterecord-keeping of outreach management
Assist in the coordination of Health-Related public events to promote our Social Care Network
II.   QUALIFICATIONS
Education/Degree minimum requirement: Associate’s Degree in Computer Science preferred, or professional and community experience that may be the equivalent of or a substitute for a formal Associate's Degree
Bachelor's in Computer Science or relevant fields preferred
2 years of Database Management and Healthcare Systems experience preferred
Possess an understanding or interest in Medicaid billing operations in New York State including, but not limited to, the New York Health Equity Reform (NYHER) 1115 Waiver Demonstration Amendment
Detail-oriented, highly organized, and able to manage time efficiently
Committed to maintaining and safeguarding confidential information
Able to work in a fast-paced environment
Proficient with word processing tools and spreadsheets (MS Office Word, Excel, etc.)
Excellent written and verbal communication skills
Ability to take initiative with projects and work independently
Bilingual in English-Spanish, English-Mandarin, English-French Creole a plus
III. RELATIONSHIP WITH OTHERS
Build and maintain close, daily interactions with co-workers and supervisors
Effectively communicate with outside agency staff
Have a strong sensitivity to cultural differences present among staff and clients within our organization
Possess a strong belief in people’s ability to grow and change
VI. WORKING CONDITIONS
Work primarily in an office setting
Considerable time is spent at a desk using a computer
May attend various meetings with different personnel and supervisors
Fast-paced, high-energy, and highly-collaborative environment
Schedule:
Full-Time (35 hours per week)
Monday to Friday
Benefits
Full-time non-exempt position at 35 hours per week
On-site training provided
Medical, dental, vision, and life insurance benefits along with the opportunity to participate in additional voluntary life, disability, and 403B retirement plan
Up to four weeks of paid vacation
Individual supervision and ongoing professional development opportunities
Please upload your resume and cover letter when applying.
EEO Statement
Center for Family Life in Sunset Park is an equal-opportunity employer.

#J-18808-Ljbffr

Overview

Please note that this position is contingent upon the successful award of a contract currently under bid.
Goldbelt Apex, a part of the Healthcare Technology Transformation Group, is a data-focused company dedicated to process and quality in every aspect. As experts in healthcare IT experts, Apex is committed to building systems for healthcare organizations to seamlessly communicate and exchange data across different systems and devices.
Summary:
We are looking for a Data Analyst.
Immediate hire upon Contract Award and completion of all background and security investigations. Candidates must be willing to sign a Letter of Intent for submission with their resume.

Responsibilities

Essential Job Functions:
Provide expert knowledge in data analytics, related explicitly to HP data, to support the AFGSC Striker STEEL project.
Involves interpreting data sets, designing effective data collection methods, developing and maintaining databases and software tools, and collaborating with stakeholders to provide actionable insights that inform program development and decision-making.
Shape long-term understanding and impact of training, understanding the context, and operationalizing research constructs into field studies as indicated by the Government.
Interpret key program data sets to identify trends, patterns, and areas for improvement.
Serve as a subject matter expert in designing effective data collection measures to deliver objective program return on investment data, advising the AFGSC Striker STEEL Program Director on relevant metrics and trending data.
Develop and maintain databases and software tools to provide capabilities for data analysis and reporting, integrating them into the existing AFGSC Striker STEEL web application software and applicable platforms. This includes analysis, architecture, design, development, and maintenance.
Develop and deploy dashboards to collect data-backed programmatic insights as requested.
Deliver insights to the Striker STEEL Program Director on potential areas of growth, optimization, and improvements based on data analysis efforts and findings.
Collaborate with Striker STEEL personnel, other MAJCOMs, Air Staff, academia, partners, and stakeholders to ensure effective data collection, analysis, and reporting.
Prepare and maintain test and measurement results, technical information, reports, and briefings on progress, providing evaluation, analysis, and recommendations for ongoing and proposed data collection efforts.
Prepare data collection proposals and protocols for improved standardization across the Striker STEEL enterprise.
Track and present actionable metrics for qualitative assessments, scaling data management, and outputs.
Implement modeling features and methods to develop custom architectures and application integration for program execution.
Ensure data security measures and methods are current and implemented throughout the data lifecycle.
Collaborate with customers to develop comprehensive operational and strategic data analytics plans and solutions.
Conduct a thorough review of data sets to provide customers with actionable metrics.
Create visualizations of key performance indicators (KPIs) for customers, including both physiological and psychological metrics.
Develop presentations and papers for client digestion of varying data sets.
Assist developers in structuring input and analytical tools and processes within the data management system.
Collaborate with client staff, including coaches and managers, to extract actionable insights from data sets.

Qualifications

Necessary Skills and Knowledge:
Proficient understanding and working knowledge of computers, e-mail, voice mail, and telephone texts to perform duties.
Additionally, be proficient with Microsoft Word, Excel, and PowerPoint.
Excellent communication and interpersonal skills.
Ability to work collaboratively with a multidisciplinary team.
Strong organizational and time management skills.
Minimum Qualifications:
Bachelor’s degree in business, Project Management, Human Performance, Exercise Science, Kinesiology, or a related field.
Project Management Professional (PMP) or Certified associate in project management (CAPM) or Program Management Professional (PgMP) or PRINCE2 Practitioner.
Minimum 2+ years’ data mining and/or 4+ years in a data analyst, engineer, or scientist role.
US Citizenship (Birth or Naturalized).
Pass a background check (Tier 1 investigation).
Preferred Qualifications:
Preferred knowledge and background in human performance data. Familiarity with fighter wing culture is also highly desired.
Preferred experience or background in human performance or behavioral health.
Pay and Benefits
At Goldbelt, we value and reward our team's dedication and hard work. We provide a competitive base salary commensurate with your qualifications and experience. As an employee, you'll enjoy a comprehensive benefits package, including medical, dental, and vision insurance, a 401(k) plan with company matching, tax-deferred savings options, supplementary benefits, paid time off, and professional development opportunities.

#J-18808-Ljbffr

Direct message the job poster from Mavis Tire
Vice President of Talent Acquisition at Mavis Tire Supply, LLC    Mavis Discount Tire – Sr. Financial Data Analyst / Developer
Put your career into high gear with Mavis Discount Tire! We're looking for a full-time Senior Financial Data Analyst / Developer to join Team Mavis at our Operations Support Center in White Plains, New York. With over 2,300 retail locations, Mavis is the largest independently held tire sales and automotive repair chains in the United States.
About the Position of Sr. Developer
As a member of the Analytics Department, the Sr. Developer will develop reporting and
analyses for the purpose of presenting actionable insights through the rigorous analysis of
Requirements & Qualifications
• 3-5 years of SQL experience
• SSRS experience a strong experience building views for PowerBI developers a +
• Excellent analytic skills
• Strong Excel skills
• Self-starter who knows how to use data and reporting to drive profits
Duties & Responsibilities
The Senior Developer will assist the Development Manager, the VP and SVP of Analytics, in the
development of reports and analyses. Reporting and analysis will support various
customers within and outside the organization, including Store Operations, Finance,
Payroll, and Supply Chain. The developer will be responsible for compiling data from
disparate data repositories, organizing and presenting the data. The Sr. Developer will
also be expected to be able to evaluate and present the data for the purpose of
providing actionable insights with a quantifiable impact on profitability.
Employee Benefits:
At Ma vis, we understand that our people drive our success. We provide our team members with competitive weekly pay, a good working environment and an excellent combination of additional benefits like health, vision and dental insurance, a 401(k) retirement savings plan with employer match, paid vacations, life insurance, paid personal and sick time, paid holidays, on-the-job training, and opportunities for career growth and advancement.
Mavis is an Equal Opportunity Employer
Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Full-time
Job function    Job function Analyst and Finance
Industries Retail
Referrals increase your chances of interviewing at Mavis Tire by 2x
Inferred from the description for this job  Medical insurance
Vision insurance
401(k)
Paid maternity leave
Get notified when a new job is posted.
Sign in to set job alerts for “Data Analyst” roles.  New York City Metropolitan Area 3 weeks ago
Data Manager and Analyst, Bureau of the Public Health Laboratory  Fund Data Analytics & Operations Specialist- $200,000-250,000 + bonus!  New York City Metropolitan Area $200,000.00-$250,000.00 21 hours ago
New York City Metropolitan Area $25.00-$35.00 4 days ago
New York City Metropolitan Area 2 weeks ago
New York City Metropolitan Area 1 week ago
New York City Metropolitan Area $25.00-$35.00 1 day ago
Westbury, NY $70,000.00-$90,000.00 4 months ago
New York, NY $56,500.00-$103,100.00 1 week ago
New York City Metropolitan Area $200,000.00-$350,000.00 1 week ago
New York City Metropolitan Area 3 weeks ago
Assistant Director, Systems and Data Analysis, SIPR (OM/WBE)  Manhattan, NY $80,000.00-$90,000.00 6 months ago
New York, NY $140,000.00-$150,000.00 1 week ago
Quantitative Researcher – Digital Assets  New York City Metropolitan Area $125,000.00-$250,000.00 1 week ago
Yonkers, NY $67,500.00-$90,000.00 1 day ago
New York, NY $65,000.00-$75,000.00 1 week ago
Data Analyst, Bureau of Hepatitis, HIV, and STI  Queens, NY $10,000.00-$72,190.00 10 hours ago
Senior Data Science Analyst (Health Plans)  New York City Metropolitan Area $130,000.00-$155,000.00 3 weeks ago
New York City Metropolitan Area 6 days ago
Teaneck, NJ $80,000.00-$120,000.00 2 days ago
New York City Metropolitan Area 3 hours 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

No Corp-to-Corp, No 3rd party firms.Job Title: Data Analyst (logistics, supply chain, inventory management) Location: 100% onsite nearby Westminster, CA Employment Type: 6+ months contract Compensation: $38.00 to 44.00 per hour (based on experience).Partnered with a client who's an automotive leader. They are seeking a Data Analyst who has experience handling data for inventory management, supply chain and/or logistics. Responsibilities<ul><li>Reporting, communications, data collection for Inbound, Outbound, Inventory, and coordination of key initiatives between departments.</li><li>Update Monthly results for all trackers for all locations; Update KPl's, action plans, results and reward programs; Update monthly requirements such as training, safety and maintenance programs</li><li>Maintain All other KPI's and assist in analysis of Planning of future KPI's targets, revisions, and calculations </li></ul>. Requirements<ul><li>5 years of database analysis experience is required</li><li>Exposure to inventory management or supply chain</li><li>Strong experience in SQL and PowerBI</li><li>Advanced skills in Excel</li><li>4+ years experience in a corporate/enterprise setting working with large data sets</li><li>Must be detailed-oriented and attention to detail</li></ul>. . All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.

Software Guidance & Assistance, Inc., (SGA), is searching for a Data Analyst - Capital Markets Technology for a contract assignment with one of our premier Financial Services clients in New York, NY. Responsibilities : <ul><li> Responsibility of the role is to identify and deliver strategic data solutions which will provide long term benefits to the firm. </li><li> The role requires direct engagement with senior leadership across Markets business, Risk, Finance and technology in Capital Markets space to advise on data strategy, design and delivery plans. </li><li> The role is responsible for management of multiple Olympus Consent Order Data programs (for onboarding, controls and consumption), Markets business MRIAs, Finance and SM&C data synergies (Genesis and Olympus), Finance Strategic Ledger delivery, Strategic Finance reporting and the firm's heightened focus to reduce data concerns - all for the Markets Business. </li><li> These responsibilities include delivery of the following critical programs in the Markets and Finance space for the Institutional Data Platform – Olympus:</li><ul><li> Markets data onboardings, Unity Data Controls, Multi-Way reconciliations for Consent Order RBCMs. </li><li> Consolidate Genesis into Olympus, resulting in a unified data fabric to source and distribute data for Finance reporting </li><li> Strategic alignment of critical data elements used by Finance BCBS reports with data used for SA-CCR and CCR reporting, leveraging Olympus as the single data source for both sets of reporting </li><li> Devise and deliver solutions for Data Concerns (DCs) for the Burn-to-Zero program </li><li> Markets business critical discretionary requests associated with onboarding, distribution and analysis of Olympus data across trades, positions, payments and settlements. </li></ul></ul> Required Skills: <ul><li> 15+ years or more years of experience in Capital Markets Technology </li><li> Deep functional and technical experience in Capital Markets across Front Office, Middle Office, Operations and Finance </li><li> Strong technical solution and delivery skills identifying opportunities & championing ongoing best-in-class business transformation/ innovation for global enterprise projects </li><li> Extensive Business Analysis experience in one or more Markets Business: Equities, FX, Rates, Credit, Commodities </li><li> Understanding of Trade lifecycles, Business Events, Accounting Events, and related data. </li><li> Expertise presenting & socializing technical solutions and program status with Senior Management across Business & Technology </li><li> Demonstrated strong leadership taking control of complex Issue for the business, facilitating technical workings session, providing technology solutions through resolution. </li><li> Effective communication and influential skills using logical thought process, with ability to arrive at consensus across varied user groups </li><li> Positive and motivated individual with an ability to take initiative; demonstrate resiliency and calm under pressure. </li><li> Drive and deliver the large-scale projects in a diverse technical environment </li><li> Ability to drive architecture decisions </li><li> Strong working knowledge of data management and big data platforms, which includes </li><li> Hadoop </li><li> Expertise in Big Data querying tools e.g. Hive and Impala </li><li> Relational SQL and NoSQL databases </li><li> Business Intelligence Tools </li><li> Financial message formats (e.g. Fix, FPML, Swift ISO, etc.) </li><li> Experience with complex data analysis </li><li> Comprehensive knowledge of all phases of Software Development Life Cycle </li><li> Proficiency in MS Office (Word, Excel, Visio, PowerPoint) with extensive experience using Excel for data analysis </li><li> Use of Confluence, JIRA, and other agile team process tools to accelerate team outcomes. </li></ul>SGA is a technology and resource solutions provider driven to stand out. We are a women-owned business. Our mission: to solve big IT problems with a more personal, boutique approach. Each year, we match consultants like you to more than 1,000 engagements. When we say let's work better together, we mean it. You'll join a diverse team built on these core values: customer service, employee development, and quality and integrity in everything we do. Be yourself, love what you do and find your passion at work. Please find us at <a> https://sgainc.com/</a> . SGA is an Equal Opportunity Employer and does not discriminate on the basis of Race, Color, Sex, Sexual Orientation, Gender Identity, Religion, National Origin, Disability, Veteran Status, Age, Marital Status, Pregnancy, Genetic Information, or Other Legally Protected Status. We are committed to providing access, equal opportunity, and reasonable accommodation for individuals with disabilities in employment, and our services, programs, and activities. Please visit our company <a> EEO page</a> to request an accommodation or assistance regarding our policy.

We are seeking a highly skilled GIS Technologist with at least five years of experience working within Esri platforms and geodatabases. The ideal candidate will possess strong software development skills in C# and/or Python, Angular and/or other Javascript based web frameworks. They will have expertise in applying GIS technology to statistical and financial analysis with a basic understanding of data science and regression analysis. Responsibilities<ul><li>Conduct comprehensive demographic, transportation network analysis, and other geospatial analysis, and using Esri data for CRE investment team</li><li>Utilize Esri software to analyze population trends, economic data, and geographic patterns relevant to CRE investments</li><li>Develop high-quality spatial visualizations and reports to communicate findings effectively to stakeholders</li><li>Create tools (code libraries, APIs, and Web Apps) that provide simplified workflows for software engineering, quantitative research, and investment teams</li><li>Maintain and optimize geodatabases to ensure data integrity and accessibility for ongoing analyses</li><li>Work in a dynamic and collaborative environment located in the heart of Midtown Manhattan</li></ul> Qualifications<ul><li>5+ years of experience and at least 3 years working with Esri GIS software and geodatabases</li><li>Proficiency in programming languages, including C#, Python, and/or Angular</li><li>Strong analytical skills with a focus on statistics and financial data integration</li><li>Experience working with spatial data processing, visualization, and geospatial analysis</li><li>Knowledge of data science methodologies and their application to GIS</li><li>Ability to communicate technical concepts effectively to non-technical stakeholders</li><li>Bachelor's degree in GIS, Computer Science, Statistics, Finance, or a related field (or equivalent experience)</li><li>Experience with cloud-based GIS platforms and APIs</li><li>Familiarity with machine learning applications in GIS analysis</li><li>Familiarity with distributed compute frameworks like Spark</li><li>Experience with big data set efficient storage, management, and processing</li></ul>

Immediate need for a talented Data Analyst. This is a 12+ months contract opportunity with long-term potential and is located in Wall Township, NJ(Onsite). Please review the job description below and contact me ASAP if you are interested. Job ID: 25-74342 Pay Range: $50 - $55/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location). Key Responsibilities: <ul><li>Reporting and analysis for F1U, PBit0, PBit5 and Loss of Diversity</li><li>Tracking and reporting on various metrics, directives and PM tasks.</li><li>Troubleshooting hardware and performance problems independently or by coordinating with other teams.</li><li>PO creation, support and management</li><li>Reporting issues to appropriate engineers.</li><li>Kirke MOP review and support</li><li>GRE ticket creation and support</li><li>RMA and Inventory support</li><li>Break/fix tracking and analysis</li><li>Working with Engineering and Field teams to resolve customer impacting issues</li></ul> Key Requirements and Technology Experience: <ul><li>Key skills: MS Office, Google sheets, Troubleshooting hardware</li><li>Ability to dig into details to troubleshoot complex problems</li><li>Ability to multitask and avoid things falling through the cracks</li><li>Ability to work with others/teams as well as independently</li><li>Proficient in Microsoft Word/Excel, Google Docs/Sheets.</li></ul> Our client is a leading Telecommunications Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration. Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy <a>here</a>.

Responsibilities
Defines, designs, and creates advanced analytical reports and dashboards to meet business needs
Collaborates with both internal and external stakeholders to clearly define and document information/data requirements
Develop and implement strategies to translate business requirements and models into feasible and acceptable data warehouse designs to ensure that business needs are met
Utilize data mining languages, such as SQL, to collect and aggregate information
Presents data back to stakeholders in digestible format as table or using data visualization tools such as PowerBI
Builds application workflows to collect and visualize data for non-technical users using Microsoft Power Platform
Ensures data and findings are accurate and meet highest quality standards
Develops and implements data mining techniques that are efficient, repeatable, and production-ready
Works with structured and unstructured data to prepare in-depth analysis. This may include cleansing and normalizing data or development of internal control reporting to ensure data validity going forward.
Quickly identifies, troubleshoots, and remediates issues that are produced from anomalies in the database environment
Supports analytics strategic initiatives by providing feedback and completing testing, as needed
Works closely with management and other department heads to prioritize business and information needs
Assists in the application and implementation procedures of data standards and guidelines on data ownership, coding structures, and data replication to ensure access to and integrity of data sets.
Demonstrate commitment to Company's Code of Business Conduct and Ethics, and apply knowledge of compliance policies and procedures, standards and laws applicable to job responsibilities in the performance of work
#LI-Remote

Qualifications     2+ years' experience as a data analyst in the Insurance industry, with emphasis in Workers Compensation preferred
Proficiency with relational databases and SQL
Proficiency with data visualization and analysis using tools such as PowerBI, Tableau, Qlik etc.
Proficiency with Microsoft Excel/Access
Proficiency with Microsoft Power Platform including Sharepoint, Microsoft PowerApps and PowerAutomate preferred
Proficiency in data storytelling, including ability to communicate technical concepts with non-technically oriented people
Advanced technical expertise regarding data modelling and design
Strong analytical skills with the ability to collect, organize, analyze, and communicate significant amounts of information with attention to detail and accuracy
Familiarity with project management tools such as Jira and Confluence preferred
BS in Mathematics, Economics, Business, Computer Science, Information Management, Statistics or other quantitative discipline
High level written and verbal communication skills
Ability to work with little or no supervision
Ability to organize and balance multiple concurrent timelines and tasks to meet deadlines
Strong analytical and problem-solving skills

1 week ago Be among the first 25 applicants
Get AI-powered advice on this job and more exclusive features.
The Opportunity:

The Data Analyst will support the Director of the Aircraft Carrier Industrial Base in developing data-driven solutions to understand and enhance the health and resilience of the industrial base. This involves collecting, cleaning, analyzing, and visualizing large datasets related to manufacturing, supply chains, and economic indicators. The Data Analyst possesses a strong analytical mindset, advanced statistical modeling skills, and a passion for uncovering actionable insights from complex data.
Job Profile

Data Analytics T2

JR Type

Funded

Job Category

Information Technology

Minimum Clearance Required To Start

Secret

Percentage Of Travel Required

Up to 10%

Type Of Travel

Continental US

Program/Opportunity Name

Program | PEO Carriers

Referral Bonus Plan

PTOC Conversion - $1,000

* * *

Job Description

The Opportunity:

The Data Analyst will support the Director of the Aircraft Carrier Industrial Base in developing data-driven solutions to understand and enhance the health and resilience of the industrial base. This involves collecting, cleaning, analyzing, and visualizing large datasets related to manufacturing, supply chains, and economic indicators. The Data Analyst possesses a strong analytical mindset, advanced statistical modeling skills, and a passion for uncovering actionable insights from complex data.

Responsibilities

Collect, clean, and preprocess large datasets from various sources related to the industrial base, including government databases, industry reports, and open-source intelligence.
Develop and implement statistical models and machine learning algorithms to identify trends, patterns, and anomalies within the industrial base data.
Conduct exploratory data analysis (EDA) to uncover insights and hypotheses regarding industrial base health, vulnerabilities, and opportunities.
Build interactive dashboards and visualizations to communicate complex data insights to both technical and non-technical audiences.
Collaborate with subject matter experts and stakeholders to define data requirements and translate business needs into analytical solutions.
Develop and maintain data pipelines and ETL processes to ensure data quality and accessibility.
Stay current with the latest advancements in data science and machine learning techniques and apply them to improve analytical capabilities.
Contribute to the development of innovative data-driven solutions to address critical industrial base challenges.
Document and present findings, methodologies, and recommendations to stakeholders.

Qualifications

Required:

Proven experience (5+ years preferred) working with large datasets and applying statistical modeling and machine learning techniques in a professional setting.
Strong proficiency in programming languages such as Python or R, and experience with relevant data science libraries (e.g., pandas, scikit-learn, TensorFlow/PyTorch).
Experience with data visualization tools such as Tableau, Power BI, or similar.
Familiarity with database technologies (SQL, NoSQL) and data warehousing concepts.
Security Clearance: [Secret; Ability to obtain/maintain a Secret clearance]

Desired

Knowledge of industrial base concepts, including manufacturing processes, supply chains, and economic indicators, is a plus.
Excellent communication, presentation, and interpersonal skills.
Ability to work both independently and collaboratively within a team environment.
Strong analytical and problem-solving skills.

Pay Range:  There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn more here.

The Proposed Salary Range For This Position Is

$72,700 - $149,200

CACI is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, age, national origin, disability, status as a protected veteran, or any other protected characteristic.
Seniority level    Seniority level Mid-Senior level
Employment type    Employment type Full-time
Job function    Job function Information Technology
Industries Defense and Space Manufacturing
Referrals increase your chances of interviewing at SA Photonics, a CACI Company by 2x
Get notified about new Data Analyst jobs in  Washington, DC .
Washington DC-Baltimore Area $70,000.00-$85,000.00 1 week ago
Herndon, VA $65,000.00-$80,000.00 2 weeks ago
Washington, DC $152,000.00-$221,000.00 2 weeks ago
Data Analyst - People Analytics (Short-Term Employment)  Washington, DC $124,000.00-$176,000.00 2 weeks ago
Washington, DC $80,000.00-$110,000.00 22 hours ago
North Bethesda, MD $55,000.00-$125,000.00 1 day ago
Bethesda, MD $64,200.00-$101,000.00 1 week ago
Washington DC-Baltimore Area 2 months ago
Data Analyst / Report Writer, Associate - Power BI  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

Location: Stamford, CT (4 days onsite, 1 day remote)Duration: Contract budget until end of 2025Compensation: $40-45/hr Day-to-Day:Insight Global is hiring for a Jr. Business/Data Analyst to sit onsite in Stamford, CT for a large, telecommunication company. This analyst is joining the Location Lifecycle Management team within Customer Operations that’s comprised of 12 people. This team is responsible for managing part of the RDOF or Rural Digital Opportunity Fund initiative. This is an estimated 6-year initiative to expand their footprint or services in rural areas. This initiative is estimated to activate or add 1.1 million customers to the company. This data analyst will be responsible for working with various groups and stakeholders, extracting their data from multiple sources, identifying any gaps or discrepancies, then being able to report their findings. This data will be pertaining to all things regarding customer addresses: location attributes, duplicates, fall outs, etc. Furthermore, the ideal candidate will be able to understand & write business requirements that are gathered from the various teams they are working with. On a day-to-day, this analyst will be partaking in project related discussions: team meetings, stakeholder meetings, working with technical and non-technical teams, providing reporting on the data they formatting, and be able to provide explanation analysis to the team on the data so they better understand. Must Haves:<ul><li>3+ years of data/ business analysis experience</li><li>Ability to extract and compare data from various sources and input into Excel</li><li>Applying formulas: vlookups, pivot tables, etc.</li><li>Understand & write business requirements/ gather from stakeholders</li><li>Root Cause Analysis</li><li>Strong experience with reporting using Excel, Tableau, or Macros</li><li>Strong experience with MS Office Suites: PowerPoint, Word, Excel</li><li>Prior experience working with various stakeholders and groups across the organization</li><li>Good communication & personality</li><li>Bachelor's Degree</li></ul> Plusses:<ul><li>Telecom experience</li><li>SQL, Tableau, ETL processes</li></ul>

Columbia Business School Data Analyst Interview Guide

Overview

Columbia Business School Data Analyst Interview Process

Columbia Business School Data Analyst Interview Questions

Columbia Business School Data Analyst Jobs