The MSCI Data Engineer interview guide, interview questions, salary data, and interview experiences.

MSCI Data Engineer Interview Guide

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


Getting ready for an Data Engineer interview at MSCI? The MSCI Data Engineer interview span across 10 to 12 different question topics. In preparing for the interview:

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

Overview

MSCI Data Engineer Salary

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.

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

MSCI Data Engineer Interview Process

Given a table called <code>employees</code>, get the largest salary of any employee by department

Example:

Input:

<code>employees</code> table

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

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

<tr>
<td><code>department</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

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

<tbody>
<tr>
<td><code>department</code></td>
<td>VARCHAR</td>
</tr>

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

Write a query to get the largest salary of any employee by department

Largest Salary by Department

You’re tasked with designing a database system for Swipe Inc., a company that manages payments for software developers. Swipe manages a set of APIs so developers can abstract payment processes for their web service and transfer control over to Swipe’s APIs to manage payment security and finance handling (contacting credit card providers, etc.)

Your database system should store a collection of API keys with their attributes, as shown in the example below:

<pre tabindex="0" class="chroma"><code>{
 &#34;API_key&#34;:{
 &#34;Transaction_list&#34;:{
 &#34;User_ID&#34;:{
 &#34;Name&#34;:{
 &#34;f_name&#34;: 
 &#34;l_name&#34;: 
 }
 &#34;Card_Details&#34;:{
 &#34;Bank&#34;:
 &#34;Card_No&#34;:
 &#34;Expiry&#34;:
 &#34;CV&#34;:
 } 
 }
 }
 &#34;Curr_balance&#34;:
 }
}
</code></pre>

What are the functional and non-functional requirements for this database?

Determine the requirements for designing a database system to store payment APIs

Swipe Payment API

You’re given a dataframe of students named <code>students_df</code>:

<code>students_df</code> table

<table>
<thead>
<tr>
<th>name</th>
<th>age</th>
<th>favorite_color</th>
<th>grade</th>
</tr>
</thead>

<tbody>
<tr>
<td>Tim Voss</td>
<td>19</td>
<td>red</td>
<td>91</td>
</tr>

<tr>
<td>Nicole Johnson</td>
<td>20</td>
<td>yellow</td>
<td>95</td>
</tr>

<tr>
<td>Elsa Williams</td>
<td>21</td>
<td>green</td>
<td>82</td>
</tr>

<tr>
<td>John James</td>
<td>20</td>
<td>blue</td>
<td>75</td>
</tr>

<tr>
<td>Catherine Jones</td>
<td>23</td>
<td>green</td>
<td>93</td>
</tr>
</tbody>
</table>
Write a function named <code>grades_colors</code> to select only the rows where the student’s favorite color is green or red and their grade is above 90.

Example:

Input:

<pre tabindex="0" class="chroma"><code>import pandas as pd

students = {&#34;name&#34; : [&#34;Tim Voss&#34;, &#34;Nicole Johnson&#34;, &#34;Elsa Williams&#34;, &#34;John James&#34;, &#34;Catherine Jones&#34;], &#34;age&#34; : [19, 20, 21, 20, 23], &#34;favorite_color&#34; : [&#34;red&#34;, &#34;yellow&#34;, &#34;green&#34;, &#34;blue&#34;, &#34;green&#34;], &#34;grade&#34; : [91, 95, 82, 75, 93]}

students_df = pd.DataFrame(students)
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def grades_colors(students_df) -&gt;
</code></pre>

<table>
<thead>
<tr>
<th>name</th>
<th>age</th>
<th>favorite_color</th>
<th>grade</th>
</tr>
</thead>

<tbody>
<tr>
<td>Tim Voss</td>
<td>19</td>
<td>red</td>
<td>91</td>
</tr>

<tr>
<td>Catherine Jones</td>
<td>23</td>
<td>green</td>
<td>93</td>
</tr>
</tbody>
</table>

Write a function to select only the rows where the student's favorite color is green or red and their grade is above 90.

Good Grades and Favorite Colors

MSCI Data Engineer Interview Questions

Your Team Responsibilities MSCI is transforming its critical analytical applications into a modern ecosystem of high-performance and scalable services. We are seeking highly skilled and motivated engineers who are eager to help us create, select and utilize the best technology to accelerate improvements to our platforms. This senior position is in the Analytics systems development group and will focus on delivering new capabilities to our clients, overhauling architecture, improving our code base, investigating issues, and fixing bugs. You will join a multi-year effort to modularize our code, factor out critical services into separate components, work towards a high-performance data architecture, migrate to modern elastic execution environment (on-prem and in the cloud), address security issues, and adopt current standards and best-practice approaches. Your Key Responsibilities We require a lead software engineer who is happy to work across a large code base and keen to make a difference. They should recognize when they can reuse, refactor, or start afresh - and make recommendations accordingly. Performance and scale must be central to their approach. In this role you will be an active member of a globally distributed technical leadership team. It will be hands-on - using your expertise in software development to contribute and improve our code base as well leading, mentoring and coaching other team members. You will work on a mixture of short-term items (bugs, features) as well as longer term initiatives and strategic projects. You will be expected to lead design discussions, manage code reviews and create a culture of quality leading to performant and tested solutions. Your skills and experience that will help you excel Proven expertise with Java and Python - demonstrating an ability to write robust, efficient code as well as test, debug and optimize. Expertise of the JVM - configuring parameters, have a strong understanding of garbage collection, ability to profile hotspots and tune for performance. Strong analytical skills (algorithms, data structures, and statistics) and system proficiency (concurrency, memory) essential. Experience delivering global Risk Management, Performance Attribution or financial trading systems. Seasoned team lead able to coach, mentor and develop junior skillsets. Great communication skills with a positive and constructive outlook, with the team and stakeholders. Attention to detail with the ability to balance quality and timeliness. Experience with Spark (or similar) to deliver high-performance and scalable analytical reporting a bonus. Experience with Linux, K8s, Azure, Helm, Terraform, Docker a bonus. BSc in Computer Science or equivalent degree in an engineering or mathematical field. About MSCI What we offer you Salary range: $171,000 - $222,000 / year plus eligible for annual bonus Transparent compensation schemes and comprehensive employee benefits, tailored to your location, ensuring your financial security, health, and overall wellbeing. Flexible working arrangements, advanced technology, and collaborative workspaces. A culture of high performance and innovation where we experiment with new ideas and take responsibility for achieving results. A global network of talented colleagues, who inspire, support, and share their expertise to innovate and deliver for our clients. Global Orientation program to kickstart your journey, followed by access to our LearningMSCI platform, LinkedIn Learning Pro and tailored learning opportunities for ongoing skills development. Multi-directional career paths that offer professional growth and development through new challenges, internal mobility and expanded roles. We actively nurture an environment that builds a sense of inclusion belonging and connection, including eight Employee Resource Groups. All Abilities, Asian Support Network, Black Leadership Network, Climate Action Network, Hola MSCI, Pride & Allies, Women in Tech, and Women's Leadership Forum. At MSCI we are passionate about what we do, and we are inspired by our purpose - to power better investment decisions. You'll be part of an industry-leading network of creative, curious, and entrepreneurial pioneers. This is a space where you can challenge yourself, set new standards and perform beyond expectations for yourself, our clients, and our industry. MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research, data, and technology, we power better investment decisions by enabling clients to understand and analyze key drivers of risk and return and confidently build more effective portfolios. We create industry-leading research-enhanced solutions that clients use to gain insight into and improve transparency across the investment process. MSCI Inc. is an equal opportunity employer committed to diversifying its workforce. It is the policy of the firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, gender, gender identity, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy (including unlawful discrimination on the basis of a legally protected parental leave), veteran status, or any other characteristic protected by law. MSCI is also committed to working with and providing reasonable accommodations to individuals with disabilities. If you are an individual with a disability and would like to request a reasonable accommodation for any part of the application process, please email Disability.Assistancemsci.com and indicate the specifics of the assistance needed. Please note, this e-mail is intended only for individuals who are requesting a reasonable workplace accommodation; it is not intended for other inquiries. To all recruitment agencies MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee, location, or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes. Note on recruitment scams We are aware of recruitment scams where fraudsters impersonating MSCI personnel may try and elicit personal information from job seekers. Read our full note on careers.msci.com

Your Team Responsibilities MSCI is transforming its critical analytical applications into a modern ecosystem of high-performance and scalable services. We are seeking highly skilled and motivated engineers who are eager to help us create, select and utilize the best technology to accelerate improvements to our platforms. This senior position is in the Analytics systems development group and will focus on delivering new capabilities to our clients, overhauling architecture, improving our code base, investigating issues, and fixing bugs. You will join a multi-year effort to modularize our code, factor out critical services into separate components, work towards a high-performance data architecture, migrate to modern elastic execution environment (on-prem and in the cloud), address security issues, and adopt current standards and best-practice approaches. Your Key Responsibilities We require a lead software engineer who is happy to work across a large code base and keen to make a difference. They should recognize when they can reuse, refactor, or start afresh - and make recommendations accordingly. Performance and scale must be central to their approach. In this role you will be an active member of a globally distributed technical leadership team. It will be hands-on - using your expertise in software development to contribute and improve our code base as well leading, mentoring and coaching other team members. You will work on a mixture of short-term items (bugs, features) as well as longer term initiatives and strategic projects. You will be expected to lead design discussions, manage code reviews and create a culture of quality leading to performant and tested solutions. Your skills and experience that will help you excel Proven expertise with Java and Python - demonstrating an ability to write robust, efficient code as well as test, debug and optimize. Expertise of the JVM - configuring parameters, have a strong understanding of garbage collection, ability to profile hotspots and tune for performance. Strong analytical skills (algorithms, data structures, and statistics) and system proficiency (concurrency, memory) essential. Experience delivering global Risk Management, Performance Attribution or financial trading systems. Seasoned team lead able to coach, mentor and develop junior skillsets. Great communication skills with a positive and constructive outlook, with the team and stakeholders. Attention to detail with the ability to balance quality and timeliness. Experience with Spark (or similar) to deliver high-performance and scalable analytical reporting a bonus. Experience with Linux, K8s, Azure, Helm, Terraform, Docker a bonus. BSc in Computer Science or equivalent degree in an engineering or mathematical field. About MSCI What we offer you Salary range: $171,000 - $222,000 / year plus eligible for annual bonus Transparent compensation schemes and comprehensive employee benefits, tailored to your location, ensuring your financial security, health, and overall wellbeing. Flexible working arrangements, advanced technology, and collaborative workspaces. A culture of high performance and innovation where we experiment with new ideas and take responsibility for achieving results. A global network of talented colleagues, who inspire, support, and share their expertise to innovate and deliver for our clients. Global Orientation program to kickstart your journey, followed by access to our LearningMSCI platform, LinkedIn Learning Pro and tailored learning opportunities for ongoing skills development. Multi-directional career paths that offer professional growth and development through new challenges, internal mobility and expanded roles. We actively nurture an environment that builds a sense of inclusion belonging and connection, including eight Employee Resource Groups. All Abilities, Asian Support Network, Black Leadership Network, Climate Action Network, Hola MSCI, Pride & Allies, Women in Tech, and Women's Leadership Forum. At MSCI we are passionate about what we do, and we are inspired by our purpose - to power better investment decisions. You'll be part of an industry-leading network of creative, curious, and entrepreneurial pioneers. This is a space where you can challenge yourself, set new standards and perform beyond expectations for yourself, our clients, and our industry. MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research, data, and technology, we power better investment decisions by enabling clients to understand and analyze key drivers of risk and return and confidently build more effective portfolios. We create industry-leading research-enhanced solutions that clients use to gain insight into and improve transparency across the investment process. MSCI Inc. is an equal opportunity employer committed to diversifying its workforce. It is the policy of the firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, gender, gender identity, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy (including unlawful discrimination on the basis of a legally protected parental leave), veteran status, or any other characteristic protected by law. MSCI is also committed to working with and providing reasonable accommodations to individuals with disabilities. If you are an individual with a disability and would like to request a reasonable accommodation for any part of the application process, please email Disability.Assistancemsci.com and indicate the specifics of the assistance needed. Please note, this e-mail is intended only for individuals who are requesting a reasonable workplace accommodation; it is not intended for other inquiries. To all recruitment agencies MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee, location, or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes. Note on recruitment scams We are aware of recruitment scams where fraudsters impersonating MSCI personnel may try and elicit personal information from job seekers. Read our full note on careers.msci.com

Your Team Responsibilities MSCI is transforming its critical analytical applications into a modern ecosystem of high-performance and scalable services. We are seeking highly skilled and motivated engineers who are eager to help us create, select and utilize the best technology to accelerate improvements to our platforms. This senior position is in the Analytics systems development group and will focus on delivering new capabilities to our clients, overhauling architecture, improving our code base, investigating issues, and fixing bugs. You will join a multi-year effort to modularize our code, factor out critical services into separate components, work towards a high-performance data architecture, migrate to modern elastic execution environment (on-prem and in the cloud), address security issues, and adopt current standards and best-practice approaches. Your Key Responsibilities We require a lead software engineer who is happy to work across a large code base and keen to make a difference. They should recognize when they can reuse, refactor, or start afresh - and make recommendations accordingly. Performance and scale must be central to their approach. In this role you will be an active member of a globally distributed technical leadership team. It will be hands-on - using your expertise in software development to contribute and improve our code base as well leading, mentoring and coaching other team members. You will work on a mixture of short-term items (bugs, features) as well as longer term initiatives and strategic projects. You will be expected to lead design discussions, manage code reviews and create a culture of quality leading to performant and tested solutions. Your skills and experience that will help you excel Proven expertise with Java and Python - demonstrating an ability to write robust, efficient code as well as test, debug and optimize. Expertise of the JVM - configuring parameters, have a strong understanding of garbage collection, ability to profile hotspots and tune for performance. Strong analytical skills (algorithms, data structures, and statistics) and system proficiency (concurrency, memory) essential. Experience delivering global Risk Management, Performance Attribution or financial trading systems. Seasoned team lead able to coach, mentor and develop junior skillsets. Great communication skills with a positive and constructive outlook, with the team and stakeholders. Attention to detail with the ability to balance quality and timeliness. Experience with Spark (or similar) to deliver high-performance and scalable analytical reporting a bonus. Experience with Linux, K8s, Azure, Helm, Terraform, Docker a bonus. BSc in Computer Science or equivalent degree in an engineering or mathematical field. About MSCI What we offer you Salary range: $171,000 - $222,000 / year plus eligible for annual bonus Transparent compensation schemes and comprehensive employee benefits, tailored to your location, ensuring your financial security, health, and overall wellbeing. Flexible working arrangements, advanced technology, and collaborative workspaces. A culture of high performance and innovation where we experiment with new ideas and take responsibility for achieving results. A global network of talented colleagues, who inspire, support, and share their expertise to innovate and deliver for our clients. Global Orientation program to kickstart your journey, followed by access to our LearningMSCI platform, LinkedIn Learning Pro and tailored learning opportunities for ongoing skills development. Multi-directional career paths that offer professional growth and development through new challenges, internal mobility and expanded roles. We actively nurture an environment that builds a sense of inclusion belonging and connection, including eight Employee Resource Groups. All Abilities, Asian Support Network, Black Leadership Network, Climate Action Network, Hola MSCI, Pride & Allies, Women in Tech, and Women's Leadership Forum. At MSCI we are passionate about what we do, and we are inspired by our purpose - to power better investment decisions. You'll be part of an industry-leading network of creative, curious, and entrepreneurial pioneers. This is a space where you can challenge yourself, set new standards and perform beyond expectations for yourself, our clients, and our industry. MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research, data, and technology, we power better investment decisions by enabling clients to understand and analyze key drivers of risk and return and confidently build more effective portfolios. We create industry-leading research-enhanced solutions that clients use to gain insight into and improve transparency across the investment process. MSCI Inc. is an equal opportunity employer committed to diversifying its workforce. It is the policy of the firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, gender, gender identity, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy (including unlawful discrimination on the basis of a legally protected parental leave), veteran status, or any other characteristic protected by law. MSCI is also committed to working with and providing reasonable accommodations to individuals with disabilities. If you are an individual with a disability and would like to request a reasonable accommodation for any part of the application process, please email Disability.Assistancemsci.com and indicate the specifics of the assistance needed. Please note, this e-mail is intended only for individuals who are requesting a reasonable workplace accommodation; it is not intended for other inquiries. To all recruitment agencies MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee, location, or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes. Note on recruitment scams We are aware of recruitment scams where fraudsters impersonating MSCI personnel may try and elicit personal information from job seekers. Read our full note on careers.msci.com

Your Team Responsibilities You will join an MSCI team that works on Private Asset investment solutions for global clients who are Asset Owners or Private Asset Managers. Your role is to develop and execute a strategy for Private Credit. You will collaborate with the business stakeholders to understand client needs and deliver profitable solutions. You will work with the Technology and Data team to build solutions from your requirements. Your Key Ressponsibilities Set and share the vision, strategy, competitive positioning and roadmap for providing essential private credit data and solutions to private asset managers (GPs), leveraging existing assets of MSCI. Analyze the private credit eco-system, including data and analytics solutions providers and opportunities, and determine where MSCI could offer unique and mission-critical solutions. With Client Coverage and Marketing, identify and evaluate client needs and develop value propositions and business plans/cases for MSCI solutions. Review and improve service delivery and cost, to ensure we deliver solutions in an efficient, scalable and profitable manner. Provide product expertise in key client meetings, lead client consultations to gather critical feedback from MSCI clients and stakeholders and present the product roadmap in client calls and meetings. Support our client facing organization by responding to questions from MSCI client coverage related to existing product features, functionality, pricing and licensing; assisting with RFPs; assisting with client communications; and helping to organize periodic training sessions for coverage. Your skills and experience that will help you excel Education: An ideal candidate will hold a degree in a technical field; for example, Finance, Economics, or Business Administration or the equivalent in experience. Minimum 15 years of experience in product management, preferably in the financial services industry focused on private assets. Deep knowledge and understanding of the private credit investment process and market participants, including general partners. Strong analytical, problem-solving, and decision-making skills and ability to translate business needs into data solutions. Excellent communication, presentation, and stakeholder management skills and ability to communicate complex data concepts and solutions to both technical and non-technical audiences. Proven track record of delivering private asset solutions products and projects that meet or exceed the business expectations and objectives. About MSCI What we offer you Salary range: $190,000 - $300,000 / year plus eligible for annual bonus Transparent compensation schemes and comprehensive employee benefits, tailored to your location, ensuring your financial security, health, and overall wellbeing. Flexible working arrangements, advanced technology, and collaborative workspaces. A culture of high performance and innovation where we experiment with new ideas and take responsibility for achieving results. A global network of talented colleagues, who inspire, support, and share their expertise to innovate and deliver for our clients. Global Orientation program to kickstart your journey, followed by access to our LearningMSCI platform, LinkedIn Learning Pro and tailored learning opportunities for ongoing skills development. Multi-directional career paths that offer professional growth and development through new challenges, internal mobility and expanded roles. We actively nurture an environment that builds a sense of inclusion belonging and connection, including eight Employee Resource Groups. All Abilities, Asian Support Network, Black Leadership Network, Climate Action Network, Hola MSCI, Pride & Allies, Women in Tech, and Women's Leadership Forum. At MSCI we are passionate about what we do, and we are inspired by our purpose - to power better investment decisions. You'll be part of an industry-leading network of creative, curious, and entrepreneurial pioneers. This is a space where you can challenge yourself, set new standards and perform beyond expectations for yourself, our clients, and our industry. MSCI is a leading provider of critical decision support tools and services for the global investment community. With over 50 years of expertise in research, data, and technology, we power better investment decisions by enabling clients to understand and analyze key drivers of risk and return and confidently build more effective portfolios. We create industry-leading research-enhanced solutions that clients use to gain insight into and improve transparency across the investment process. MSCI Inc. is an equal opportunity employer committed to diversifying its workforce. It is the policy of the firm to ensure equal employment opportunity without discrimination or harassment on the basis of race, color, religion, creed, age, sex, gender, gender identity, sexual orientation, national origin, citizenship, disability, marital and civil partnership/union status, pregnancy (including unlawful discrimination on the basis of a legally protected parental leave), veteran status, or any other characteristic protected by law. MSCI is also committed to working with and providing reasonable accommodations to individuals with disabilities. If you are an individual with a disability and would like to request a reasonable accommodation for any part of the application process, please email Disability.Assistancemsci.com and indicate the specifics of the assistance needed. Please note, this e-mail is intended only for individuals who are requesting a reasonable workplace accommodation; it is not intended for other inquiries. To all recruitment agencies MSCI does not accept unsolicited CVs/Resumes. Please do not forward CVs/Resumes to any MSCI employee, location, or website. MSCI is not responsible for any fees related to unsolicited CVs/Resumes. Note on recruitment scams We are aware of recruitment scams where fraudsters impersonating MSCI personnel may try and elicit personal information from job seekers. Read our full note on careers.msci.com

Plano 7 (31067), United States of America, Plano, Texas Senior Data Engineer Do you love building and pioneering in the technology space? Do you enjoy solving complex business problems in a fast-paced, inclusive, and iterative delivery environment? At Capital One, you'll be part of a big group of makers, breakers, doers and disruptors, who solve real problems and meet real customer needs. We are seeking Data Engineers who are passionate about marrying data with emerging technologies. As a Capital One Data Engineer, you’ll have the opportunity to be on the forefront of driving a major transformation within Capital One. As a Data Engineer for the Originations Data Engineering and Analytics team, you will get to work on the most cutting-edge Fintech products that Capital One is building for its customers. You will be working on creating One Stream data pipelines for real time consumptions as well as building reports in Tableau, ThoughtSpot and other tools to provide insights to stakeholders which includes multiple VPs and Directors. You will have a lot of exposure to AWS services on your day to day job. If you are passionate about innovation in both engineering and analytics, come join our team What You’ll Do: Be a part of team designing and building Enterprise Level scalable, low-latency, fault-tolerant streaming data platform that provides meaningful and timely insights Build the next generation Distributed Streaming Data Pipelines and Analytics Data Stores using streaming frameworks (Flink, Spark Streaming) using programming languages like Java, Scala, Python Be part of a group of engineers building data pipelines using big data technologies (Spark, Flink, Kafka, Snowflake, AWS Big Data Services, Snowflake, Redshift) on medium to large scale datasets Work in a creative & collaborative environment driven by agile methodologies with focus on CI/CD, Application Resiliency Standards, and partnership with Cyber & Security teams Share your passion for staying on top of tech trends, experimenting with and learning new technologies, participating in internal & external technology communities, and mentoring other members of the engineering community Collaborate with and across Agile teams to design, develop, test, implement, and support technical solutions in full-stack development tools and technologies Work with a team of developers with deep experience in machine learning, distributed microservices, and full stack systems Collaborate with digital product managers, and deliver robust cloud-based solutions that drive powerful experiences to help millions of Americans achieve financial empowerment Perform unit tests and conduct reviews with other team members to make sure your code is rigorously designed, elegantly coded, and effectively tuned for performance Basic Qualifications: Bachelor’s Degree At least 3 years of experience in application development (Internship experience does not apply) At least 1 year of experience in big data technologies Preferred Qualifications: 5 years of experience in application development including Python, SQL, Scala, or Java 2 years of experience with a public cloud (AWS, Microsoft Azure, Google Cloud) 3 years experience with Distributed data computing tools (Kafka, Spark, Flink) 2 year experience working on real-time data and streaming applications 2 years of experience with NoSQL implementation (DynamoDB, OpenSearch) 2 years of data warehousing experience (Redshift or Snowflake) At this time, Capital One will not sponsor a new applicant for employment authorization, or offer any immigration related support for this position (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, or another type of work authorization). Capital One offers a comprehensive, competitive, and inclusive set of health, financial and other benefits that support your total well-being. Learn more at the Capital One Careers website . Eligibility varies based on full or part-time status, exempt or non-exempt status, and management level. This role is expected to accept applications for a minimum of 5 business days. No agencies please. Capital One is an equal opportunity employer committed to diversity and inclusion in the workplace. All qualified applicants will receive consideration for employment without regard to sex (including pregnancy, childbirth or related medical conditions), race, color, age, national origin, religion, disability, genetic information, marital status, sexual orientation, gender identity, gender reassignment, citizenship, immigration status, protected veteran status, or any other basis prohibited under applicable federal, state or local law. Capital One promotes a drug-free workplace. Capital One will consider for employment qualified applicants with a criminal history in a manner consistent with the requirements of applicable laws regarding criminal background inquiries, including, to the extent applicable, Article 23-A of the New York Correction Law; San Francisco, California Police Code Article 49, Sections 4901-4920; New York City’s Fair Chance Act; Philadelphia’s Fair Criminal Records Screening Act; and other applicable federal, state, and local laws and regulations regarding criminal background inquiries. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation, please contact Capital One Recruiting at 1-800-304-9102 or via email at RecruitingAccommodationcapitalone.com . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. For technical support or questions about Capital One's recruiting process, please send an email to Careerscapitalone.com Capital One does not provide, endorse nor guarantee and is not liable for third-party products, services, educational tools or other information available through this site. Capital One Financial is made up of several different entities. Please note that any position posted in Canada is for Capital One Canada, any position posted in the United Kingdom is for Capital One Europe and any position posted in the Philippines is for Capital One Philippines Service Corp. (COPSSC).

NO THIRD PARTIES, NO LLC/INC/CTC, MUST BE ABLE TO CONVERT WITHOUT SPONSORSHIP. MUST ALREADY BE LOCATED IN DALLAS, TX OR SAN FRANCISCO, CA. THIS IS A 100% ONSITE POSITION. Sr. Business Intelligence Developer / Data EngineerLocation: North Dallas, 75251, or San Francisco, CA, 94103 JOB SUMMARYWe are an innovative FinTech/InsurTech that is changing the global insurance industry ingest, transform, validate and analyze its big data. We are seeking a skilled Sr. Business Intelligence & Data Engineer (MS Fabric) who can enhance our platform using modern technologies while ensuring reliable and high-performance operations.This position be in the Data Insights & Analytics team to help drive analytics in the world of complex and big data Our portfolio of products are part of the Microsoft business intelligence stack, including Microsoft Fabric, Azure SQL, PostgreSQL, Azure Data Factory, Azure Synapse Analytics, and Power BI. Our platform delivers valuable insights to executives, claims operations, and finance teams at our insurance carrier clients.Our mission is to build the leading insurance data platform, powering a new class of data-first applications and driving a data culture. Leveraging Azure data, our Insights and Analytics team is dedicated to building and maintaining analytics and reporting platform hosted in Azure, including on Microsoft Fabric.Our Azure Insights and Analytics team is tasked with maintaining and advancing our comprehensive data platform. This platform encompasses traditional DAX/MQuery design and more recently Spark development, with an emphasis on PySpark and Spark SQL within Microsoft Fabric notebooks. Our team places high importance on code optimization, metadata-driven orchestration, and implementing best practices in DevOps.You will be in charge of maintaining, designing and developing our Fabric platform, including Power BI dashboards, further implementing complex data models, data flows, and data transformations to support company and client requirements. You will be developing and maintaining complex data pipelines and notebooks for information processing and analysis.You will have the autonomy to define your area of expertise and cultivate skills that will propel your career forward. Your daily routine will include participating in standup meetings, managing work items based on your capacity, collaborating with the team’s growing technology department to define new projects or initiatives, and engage in development activities. In addition to traditional data engineering tasks, you will directly interact with the teams developing the tools we utilize, enabling you to provide direct product feedback and witness your input driving changes in the products over time.Our mission is to empower our team to achieve their potential. We come together with a growth mindset, innovate to empower others, and collaborate to realize our shared goals. Each day we build on our values of respect, integrity, and accountability to create a culture of inclusion where everyone can thrive at work and beyond. In alignment with our founder’s values, we are committed to cultivating an inclusive work environment for all employees to positively impact our culture every day.The position is office-based in either in the Dallas, TX Headquarters or its San Francisco Office.Key Expertise • Microsoft Fabric: Demonstrated experience in developing and maintaining complex data pipelines with Microsoft Fabric• PowerBI / Synapse: Senior level expertise in dashboard design and development• Data Engineering / Azure Data Factory: Solid experience in data warehousing, ETL/ELT processes, and data modeling (dimensional, normalized)• Azure Full Stack Knowledge: Strong working knowledge of Azure services, especially Data Factory, Synapse Analytics, and Azure SQL Database• Coding fluency: Expert proficiency in DAX, MQuery, SQL, Python, PySpark and Spark SQL or similar languages for data scripting, transformation, and automation related to data transformation and analysis Requirements • Apply industry best practice transformation and modeling techniques – validating the output to ensure reliable and accurate results for consumption by downstream data teams, and end users.• Extract and transform disparate data into actionable insights that drive our client’s business decisions.• Drive development projects to evolve our platform and operations, leveraging the newest Azure and Fabric technologies available to us.• Contribute to the success of our data in Azure by introducing new Azure products and features to our company and clients• Work directly with business stakeholders to refine requirements, iterate and finalize design, deliver working proofs of concept, and develop final data solution.• Live site and on call duty for maintaining high availability of our analytics solutions.• Collaborate with your peers and maintain flexibility on domain ownership as business priorities evolve.• Work with other teams and understanding their data products and onboarding them. QUALIFICATIONS: • Bachelor’s degree in engineering, computer science, or similar technical area• Master’s degree in data engineering or business intelligence a plus• 7+ years’ experience with Data Science and analytics using Power BI for data modeling, data visualization, and data management using Power BI and MS SQL. Recent exposure to MS Fabric a plus.• 5+ plus years of Business Intelligence Engineering, specifically with PowerBI• 5+ years' experience with DAX, Power Query, and MD• 3+ years’ experience with Azure cloud services, including Azure SQL, Full Azure Stack, DevOps

Centurion is looking for a Secret cleared Data Engineer for a hybrid opportunity out of the DC area. (3 days a month onsite) Required Skills: <ul><li>Tech Stack (must haves): Python, SQL, SQL Server, Azure (Data Factory), Databricks, PowerBI (especially back-end programming for PowerBI)</li><li>Working Style: GitHub collaboration, SharePoint experience (moderate user), ability to work onsite at Foggy Bottom and/or collaborate at Rosslyn, 5 – 8 days a month</li><li>Above average experience with Power Point (deck creation and presentation)</li><li>8 Years of Experience (total)</li><li>8+ years hands-on-keyboard experience</li><li>5+ years data analysis experience</li><li>Cloud certification (i.e. AWS, Databricks)</li><li>Basic understanding of LLM-based tools such as model inference API and RAG methods.</li><li>Bachelor’s Degree</li><li>Secret clearance</li></ul>Experience Breakdowns <ul><li>3+ years of experience in the private sector with a cloud migration</li><li>2+ years defining cloud architecture requirements and gathering user stories for analytic product outputs</li><li>2+ years managing cloud migrations and setting milestones and timelines.</li><li>2+ years in end-to-end design, develop and implement of cloud data architecture.</li><li>2+ years of stakeholder management in a low-data maturity environment.</li><li>2+ years of experience with data governance, data security and compliance.</li><li>3+ years providing technical mentorship to junior team members.</li><li>2+ years developing and managing data stacks and dataflow layer using metadata</li><li>2+ years creating SOPs and process documentation"</li></ul>Preferred Skills: <ul><li>Experience in the State Department with DT (aka IRM)</li><li>Experience in DoD or State Department with security assistance data</li><li>Experience with political-military lingo/jargon, OR, experience in the armed forces or reserves</li><li>Experience with government financial data (e.g. appropriations, obligations, etc.)</li><li>Experience supporting a Chief Data Officer or a Chief Analytics Officer</li><li>Experience using/developing data inventories and data catalogs</li><li>Working knowledge of AWS</li></ul>Expected Deliverables: <ul><li>Migration from SQL Server and Python-based workflows to Azure and Databricks</li></ul>Education: <ul><li>Bachelors</li></ul>Position Details: Clearance: Current Active Secret ClearanceUS Citizenship is requiredTravel: < 10% (CONUS)Centurion Consulting Group, LLC is an Equal Opportunity Employer EOE M/F/D/V<ul><li>No third parties or subcontractors</li></ul>

Data Engineer <ul><li>Direct Hire</li><li>1 day onsite in Durant OK</li></ul> Our Durant, Oklahoma based client is looking for a Data Engineer II. In this role, the candidate will establish data management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy. They will participate in development of interfaces and design of user interface and business application prototypes. Job Responsibilities<ul><li>Work on problems of moderate scope where analysis of situations or data requires a review of a variety of factors.</li><li>Exercise judgment within defined procedures and practices to determine appropriate action and escalates to manager as needed.</li><li>Build productive internal/external working relationships.</li><li>Participate, and in some cases take the lead on, formulating and monitoring data architecture policies, procedures and standards.</li><li>Build moderate level complexity data interfaces, both internal and external sources</li><li>Participate in design of data architecture standards.</li><li>Design and implement database logical and physical models</li><li>Provide development and production support to troubleshoot all data interfaces and data model related issues.</li><li>Perform other duties as may be assigned.</li></ul> Job Requirements<ul><li> Bachelor’s degree in computer science, electronic engineering, computer information systems or related field, and minimum of 3 years of equivalent experience, 5 years preferred.</li><li>Professional ETL or data modeling focused Certifications preferred.</li><li>3 years exposure to database conceptual design and logical data modeling. 2 years of experience with conceptual design using data modeling tools preferred.</li><li>2 years of hands-on experience developing internal and external data interfaces and data loading plans.</li><li>Some experience with implementing and managing data security policies. Working knowledge of Data Governance concepts preferred.</li><li>3 years of converting business requirements into data, data warehouse specifications and loading plans.</li><li>3 years of hands-on experience with data Integration tools (SSIS, Informatica, SQL Stored Procedures etc.)</li><li>Some experience working with development teams on data used in user interfaces and backend data requirements, and on data used in user-based interfaces and backend data requirements preferred.</li><li>4 years of converting business requirements into data, database specifications and loading plans preferred.</li><li>4 years of data migration experience preferred.</li><li>Experience with managing multiple Service Requests and competing priorities preferred.</li><li>Minimum of 1 years of experience with programming languages (SQL, Python etc.) 2 years preferred.</li><li>3 years of experience supporting a data warehouse preferred.</li><li>Informatica experience desired.</li></ul>

REQ ID – 33915592ROLE – Data Engineer, Battery TechnologyLOCATION – Cupertino - Hybrid MAIN SKILLS – We need someone with Snowflake, Python, SQL, Tableau, Airflow, DBT, Conductor, developing machine learning solutions using Python and its associated ecosystem — numpy, pandas, TensorFlow, PyTorch Key Qualifications: <ul><li>6+ years as data scientist, data engineer or analyst. Battery Engineering experience desired. Working knowledge and experience with big data.</li><li>Strong working knowledge of Snowflake, Python, SQL, Airflow and Tableau.</li><li>Solid competency in statistics and the ability to provide value-added analysis.</li><li>Familiar with machine learning algorithm and capable to use proper metrics to evaluate model results.</li><li>Proficiency developing machine learning solutions using Python and its associated ecosystem — numpy, pandas, TensorFlow, PyTorch, etc.</li><li>Experience working with large-scale data processing pipelines is a must.</li></ul> Job Description: <ul><li>Deliver high quality analytic insights from a large data warehouse, especially time series data</li><li>Experience working in a cloud-native environment such as Snowflake</li><li>Demonstrated abilities in problem formulation, algorithm design, and model building, including statistical analysis and evaluation.</li><li>Compare the results of predicted values and actual values, based on historical data availability</li><li>Write Python programs to implement Machine Learning functions and maintain revision in Github. Utilize advanced technologies, for modeling enhancements</li><li>Understand end to end nature of Apple DB to organize proper sample size, proper key pull and minimize SQA issues with maximum efficiency</li><li>Drive development of data products in collaboration with data scientists and analysts. Automate reporting where possible to make team more efficient</li><li>Be able to analyze factory, user, and failure data and use engineering understanding mechanisms to resolve battery problems</li><li>Work with diverse teams including data scientists, engineers, product managers and executives</li><li>Write programs for data filtering, organization, reporting. Write programs for uploading to and maintaining data in SQL database. Develop basic data management and selection programs on SQL.</li><li>Maintain software traceability through GitHub</li></ul> Education: MS or Ph.D. in Computer Science, Software Engineer, Data Science, Machine Learning, Statistics, Operations Research or related field.

MSCI Data Engineer Interview Guide

Overview

MSCI Data Engineer Salary

MSCI Data Engineer Interview Process

MSCI Data Engineer Interview Questions

MSCI Data Engineer Jobs