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

605 Data Engineer Interview Guide

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


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

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

Overview

605 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.

605 Data Engineer Interview Process

You are given a dictionary with a key-value of <code>{string: number}</code> where values in the dictionary could be duplicates. You are required to extract the unique values from the dictionary where the value occurred only once.

Return a list of values where they occur only once.

Note: You can return the values in any order.

Input:

<pre tabindex="0" class="chroma"><code>dictionary = {&#34;key1&#34;: 1, &#34;key2&#34;: 1, &#34;key3&#34;: 7, &#34;key4&#34;: 3, &#34;key5&#34;: 4, &#34;key6&#34;: 7}
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>find_unique_values(dictionary) -&gt; [3,4]

#Only 3 and 4 occurred once.
</code></pre>

Dictionary Unique Values

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

605 Data Engineer Interview Questions

CDTI Data Engineer – Pre-DigitalEligible for SC - 5 years residency, with no more than 6 months outside UKHybrid Working – Remote / Telford£450 – £470 per day – Umbrella Would you like to join a global leader in consulting, technology services and digital transformation?Our client is at the forefront of innovation to address the entire breadth of opportunities in the evolving world of cloud, digital and platforms. Role purpose / skills <ul><li>In this crucial role, you’ll be focused on the complexities of Corporate Data Transformation and Integration(CDTI) across the client’s estate and investigating and fixing Live issues, a solid background in Linux/UNIX shell scripting and PL/SQL scripting, and SQL database knowledge would be ideal, with knowledge of Cloud technologies also.</li><li>Motivated, collaborative and determined, you’ll need to validate new versions of our scripts, also making use of SQL Loader, Maestro/IBM Workload Scheduler batch jobs, and ensuring all changes are fully controlled in GitLab.</li><li>With a collaborative ethos, you’ll work with Architects looking at the wider picture to consider the risks and consequences of changes.</li></ul> The CDTI Team is looking for a Data Engineer to work with a team of 4 other engineers to support and maintain the complexities of Corporate Data Transformation and Integration across the estate and investigate and fix live issues.As technology advances, we need to validate new versions of our scripts, making use of SQL Loader, Maestro/IBM Workload Scheduler batch jobs, and ensuring all changes are fully controlled in GitLab so that we can quickly respond to Service requests to provide more efficient solutions. We often work with Architects looking at the wider picture to consider the risks and consequences of changes. Collaboration / Innovation <ul><li>As a vital part of our business unit, you’ll contribute to first-class end-to-end solutions in your assignments. You will play an active role in defining our practices, standards and ways of working, and apply them to your role. Be open to working across organisation and team boundaries to ensure we bring the best to our customers.</li><li>The Corporate Data Transformation and Integration handles data from critical head of duty systems across the client’s estate.</li><li>The service is currently subject modernisation being moved to cloud infrastructure, so this is an exciting time to join the team.</li><li>Work is varied between Project work such as moving services to new infrastructure along with the accompanying scripts or maintaining/troubleshooting existing scripts for services when issues/changes arise.</li><li>Due to the criticality of corporate data transformation and integration across the estate this is fast paced area of expertise, collaborating across technology landscapes, management levels and organisational boundaries.</li><li>On the job / external training will be available for the right candidate as well as the opportunity for overtime and on-call.</li><li>The team are predominantly Telford based and we have team days each week in the office to meet the Capgemini Hybrid Working standards.</li></ul> Essentials: <ul><li>A solid background in Linux/Unix</li><li>PL/SQL Scripting experience</li><li>SQL Database knowledge</li></ul> Nice to have: <ul><li>Knowledge of Amazon Web Services (AWS)</li><li>Knowledge of IBM Workload Scheduler</li><li>Knowledge of GitLab</li><li>Development Experience</li><li>Knowledge of Atlassian tooling (for example Jira, confluence, Bitbucket/Bamboo)</li></ul> All profiles will be reviewed against the required skills and experience. Due to the high number of applications we will only be able to respond to successful applicants in the first instance. We thank you for your interest and the time taken to apply!

Data EngineerEmployment Type: Full-Time / Direct-HireWorkplace Type: HybridLocation: Santa Monica (CA)Industry: Advertising Services/Ad TechCompensation: $90,000 - $120,000 SUMMARY: We are seeking a highly skilled and motivated Data Engineer to join our dynamic data team. The ideal candidate will have deep expertise in SQL, cloud platforms, data modeling, and building production-ready ETL pipelines. This role will be essential in designing and maintaining scalable data infrastructure, ensuring seamless data integration, and optimizing end-to-end data workflows. As a key player in shaping our data architecture, you will contribute to building robust, cloud-based solutions that support data analytics and business intelligence initiatives across the organization. RESPONSIBILITIES: <ul><li>Develop, test, and deploy ETL pipelines to move and transform data across multiple data sources.</li><li>Build integrations with third-party tools, APIs, and services, ensuring data is synchronized and accessible.</li><li>Manage and optimize data storage, particularly in cloud-based OLAP databases (e.g., Snowflake, Redshift).</li><li>Work with cross-functional teams including data scientists, business analysts, and product teams to understand data needs and ensure effective solutions.</li><li>Monitor and tune data processes and queries for optimal performance and efficiency.</li><li>Help design, deploy, and maintain cloud infrastructure and storage</li><li>Maintain clear and comprehensive technical documentation of data pipelines, workflows, and infrastructure.</li><li>Knowledge of containerization technologies like Docker and Kubernetes and experience with deploying data pipelines in containerized environments</li></ul> REQUIREMENTS: <ul><li>Bachelor's degree in Mathematics, Statistics, Economics, Computer Science, Engineering, or a related quantitative discipline</li><li>Strong skills with data manipulation/modeling and creating complex SQL query scripts.</li><li>Hands-on experience with cloud-based data warehouses such as Snowflake or Redshift.</li><li>Familiarity with ETL tools such as Fivetran, Stitch, Rivery, or Airbyte.</li><li>Experience working with AWS cloud services including S3, AWS Batch, ECR, Lambda, SNS, SQS, and other managed cloud platforms.</li><li>Experience writing production-ready, testable code in languages like Python, Scala, or Java.</li><li>Familiarity with project management and documentation tools like JIRA Software, JIRA Service Management and Confluence.</li><li>Experience with data transformation tools such as DBT (Data Build Tool).</li><li>Advanced experience with API integrations and automating data ingestion.</li><li>Experience with data orchestration tools like Apache Airflow or Luigi for scheduling and managing workflows.</li><li>Experience with data modeling techniques such as Kimball, Inmon, or Data Vault.</li><li>Experience with CI/CD pipelines, deployment, and automation using Git and other DevOps tools.</li><li>Strong problem-solving skills and the ability to work independently and as part of a team.</li><li>Excellent communication skills with the ability to explain complex technical concepts to non-technical stakeholders.</li></ul> DESRIED SKILLS: <ul><li>Understanding of data governance practices and tools for managing data quality, lineage, and security.</li><li>Experience with large-scale data processing frameworks such as Spark or Hadoop.</li><li>Knowledge of data streaming tools and best practices using Kafka, Kinesis, or similar technologies.</li><li>Experience with NoSQL technologies like MongoDB, Cassandra, or Elasticsearch.</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.

Description  Lifespark is a complete senior health company headquartered in St. Louis Park, Minnesota. Since 2004, we've been helping seniors stay healthy, navigate their health care options with confidence, and live fuller, more independent lives as they age. That's where our people come in - from accounting and health technology to front-line nurses, advanced practice professionals, caregivers and everything in between, we are all invested entrepreneurs focused on helping people age magnificently.

Our Lifespark culture has created not only an award-winning workplace - earning Star Tribune Top Workplace 11 times, Minneapolis Business Journal Best Places to Work three times, and Top USA #1 in Healthcare - but a place where you have the room to be creative, make a difference, and have a purposeful, direct impact on how people age. Lifespark's full continuum of services offers a breadth of roles with the support to grow your career. To see the experience we are creating, watch our award-winning video Going South - this is the experience you will help create at Lifespark! Changing the age-old story starts with you - let's get you hired.
Salary:  $140,000-$150,000 annually, depending on experience
Schedule:  Monday - Friday 8:00am-5:00pm
Lifespark Benefits include:
Annual Reviews/Raises{Shift differentials if applicable}
Paid Time Off - Vacation Time
Mileage reimbursement
Medical, Dental, Vision benefits for Full Time Hires
Short-Term Disability & Long-Term Disability Insurance
Life Insurances
401k + Company Match for full-time and part-time employees
Referral bonuses
Career path to other positions within our growing company!

As a Senior Data Engineer at Lifespark, you will provide leadership across our data engineering team and drive solutions that support our overall analytics efforts. With your expertise, we will use data insights to support Lifespark Complete, our unique approach to holistic senior health. In partnership with Director of Data and Analytics, you will help define our strategies around data governance, security, and analytics. You will bring your passion for how data can transform lives. This hands-on role will require the development of solid processes around ETL, data cleanliness, data wrangling as well as thorough knowledge around SQL, Python and other data-oriented languages. We are users of dbt, Dagster, and Snowflake, and are biased towards building data products using software engineering best practices. We hope you're eager to dive in!
Position Functions and Responsibilities
Lead the design, development, and maintenance of scalable data pipelines and ETL processes to support data integration, interoperability and analytics.
Collaborate with data engineers, data scientists, analysts, vendors and other stakeholders to understand data requirements and deliver high-quality data solutions.
Optimize and improve existing data infrastructure for performance, reliability, and scalability.
Implement data quality and validation processes to ensure data accuracy and consistency.
Develop and maintain documentation for data engineering processes and systems.
Stay up-to-date with the latest industry trends and technologies in data engineering and analytics.
Build and manage APIs to ensure that data exchanged is available and reliable between disparate systems and is reflected accurately in our foundational data repositories.
Work as part of our agile engineering team, cranking through stories and providing value.
Maintain and build infrastructure in our cloud environment to support ongoing technological changes and development requirements.

Qualifications
Over 5 years of professional experience as a software developer, preferably in a data engineering role
At least 3 years of experience with SQL, Python and data orchestration
Proficiency in working with ETL data pipeline and workflow management tools such as Dagster and Snowpipes
Experience with cloud platforms like AWS, Google Cloud, or Azure and big data technologies.
Strong understanding of API integrations with more that 2 years of experience building backend APIs.
Experience working in Agile teams with a commitment to continuous improvement.
A focus on maintainability, including willingness to engage in refactors, clean-ups, testing and documentation
A proactive approach with a bias toward action and openness to using various tools and languages used to solve the problems.
A team player with a positive and energetic attitude, thriving when solving unique and difficult problems.
Experience with open-source data orchestration frameworks like Airflow or Dagster
Strong communication and collaboration skills.

It has been and will continue to be our policy to provide equal employment opportunities to all employees and applicants without regard to age, race, creed, color, disability, marital status, sex, gender identity, national origin, ancestry, sexual orientation, arrest record, conviction record, military service, use or nonuse of lawful products off the Employer's premises during nonworking hours, or declining to attend a meeting or to participate in any communication about religious matters or political matters, or any other status protected by federal, state, or local law.
#LSCorp

Requisition Number: 21553

Required Travel: 0 - 10%

Employment Type: Full Time/Salaried/Exempt

Anticipated Salary Range: $70,561.00 - $100,000.00

Security Clearance: Secret

Level of Experience: Mid

This opportunity resides with Global Security (GS), a business group within HII’s Mission Technologies division. Global Security comprises live, virtual, constructive training and range systems, services and operations; fleet maintenance, repair, operations and sustainment; nuclear; and international. As a trusted partner to our military customers, HII designs, develops and operates the largest LVC enterprise that prepares warfighters for cross-domain battle. With advanced technologies to enable mission readiness, HII understands that preparation requires full coordination—not readiness in piece-parts.

For more than 40 years, the U.S. Navy has entrusted HII to maintain and modernize the vast majority of its fleet. With a holistic approach to life-cycle maritime defense systems—from small watercraft to submarines, surface combatants and aircraft carriers—HII ensures a high state of readiness. HII supports the Department of Energy’s national security mission through the management and operation of its sites, as well as the safe cleanup of legacy waste across the country. HII meets clients’ toughest nuclear and environmental challenges.

Meet HII’s Mission Technologies Division

Our team of more than 7,000 professionals worldwide delivers all-domain expertise and advanced technologies in service of mission partners across the globe. Mission Technologies is leading the next evolution of national defense – the data evolution - by accelerating a breadth of national security solutions for government and commercial customers. Our capabilities range from C5ISR, AI and Big Data, cyber operations and synthetic training environments to fleet sustainment, environmental remediation and the largest family of unmanned underwater vehicles in every class. Find the role that’s right for you. Apply today. We look forward to meeting you.

To learn more about Mission Technologies, click here for a short video: https://vimeo.com/732533072

Job Description

HII Mission Technologies is seeking a Data Engineer with skilled talent to join a team that identifies, develops, manages, and analyzes data (geospatial, force structure, and system characteristic), digital applications, and policy to support virtual, constructive, and gaming simulation-enabled Joint and Combatant Command training. This Data Engineer position will assist in improving the processes in which data is collected, managed, and converted for the purposes of the Joint Staff (JS) J7, Deputy Director of Joint Training (DDJT) data initiatives.

This position is onsite in Suffolk, VA. An active Secret security clearance is required in order to qualify for this role.

Essential Job Responsibilities

Curation of data from various authoritative sources into schemas and formats that can be consumed by applications of the DDJT’s Joint Training Synthetic Environment (JTSE).

Assist in the development of Data Pipelines for data cleaning, transformation, and aggregation.

Reduce amount of manual touch labor required to transform data into useable formats by enhancing data quality and efficiency.

Assist in management of DDJT’s data and analytics operations including architecture, user requirements, software development, report development, and Artificial Intelligence (AI)/Machine Learning (ML) integration.

Minimum Qualifications

2 years relevant experience with Bachelors in related field; 0 years experience with Masters in related field; or High School Diploma or equivalent and 6 years relevant experience.

Client requirements: Bachelor’s degree and 2-4 years of experience OR a Master’s degree with 0-2 years of experience. In some cases, educational requirements may be adjusted or waived for more than 8 years of applicable work experience. Work experience may be adjusted for highly specialized knowledge or uniquely applicable experience.

An active Secret security clearance is required.

Knowledge, Skills, Abilities:

• Interest in data and data analytics.

• Experience with MS Excel functions for data analysis.

• Experience with SQL for data queries.

• Knowledge or interest in Data Dashboards (Tableau, PowerBI, Looker, etc.).

• Knowledge of scripting (Python).

• Knowledge of database/technology/processes (PostgreSQL, Apache Kafka, ETL, noSQL databases, etc.).

• Ability to communicate in person, over virtual platforms, and in writing with teammates, technical Subject Matter Experts (SME), and senior leaders.

• Ability to work in a team environment.

• On-site support required (Must Interface with customers on a daily basis).

Preferred Requirements

Experience with curation of force structure, terrain, and system characteristic data for use in DoD Modeling & Simulation (M&S) training applications is a plus.

Knowledge of JS J7’s Joint Live Virtual Constructive (JLVC) federation is a plus.

Knowledge of the Joint training exercise planning, design, execution, and assessment process (JELC – Joint Exercise Life Cycle) is a plus.

Experience with Jira and Confluence is a plus.

HII is more than a job - it’s an opportunity to build a new future. We offer competitive benefits such as best-in-class medical, dental and vision plan choices; wellness resources; employee assistance programs; Savings Plan Options (401(k)); financial planning tools, life insurance; employee discounts; paid holidays and paid time off; tuition reimbursement; as well as early childhood and post-secondary education scholarships. Bonus/other non-recurrent compensation is occasionally offered for qualified positions, and if applicable to this role will be addressed by the recruiter at the screening phase of application.

The listed salary range for this role is intended as a good faith estimate based on the role's location, expectations, and responsibilities. When extending an offer, HII's Mission Technologies division takes a variety of factors into consideration which include, but are not limited to, the role's function and a candidate's education or training, work experience, and key skills.

Why HII

We build the world’s most powerful, survivable naval ships and defense technology solutions that safeguard our seas, sky, land, space and cyber. Our diverse workforce includes skilled tradespeople; artificial intelligence, machine learning (AI/ML) experts; engineers; technologists; scientists; logistics experts; and business administration professionals.

Recognized as one of America’s top large company employers, we are a values and ethics driven organization that puts people’s safety and well-being first. Regardless of your role or where you serve, at HII, you’ll find a supportive and welcoming environment, competitive benefits, and valuable educational and training programs for continual career growth at every stage of your career.

Together we are working to ensure a future where everyone can be free and thrive.

Today’s challenges are bigger than ever, and the nation needs the best of us. It’s why we’re focused on hiring, developing and nurturing our diversity. We believe that diversity among our workforce strengthens the organization, stimulates creativity, promotes the exchange of ideas and enriches the work lives of all our employees.

All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, physical or mental disability, age, or veteran status or any other basis protected by federal, state, or local law.

Do You Need Assistance?

If you need a reasonable accommodation for any part of the employment process, please send an e-mail to buildyourcareer@hii-co.com and let us know the nature of your request and your contact information. Reasonable accommodations are considered on a case-by-case basis. Please note that only those inquiries concerning a request for reasonable accommodation will be responded to from this email address. Additionally, you may also call 1-844-849-8463 for assistance. Press #3 for HII Mission Technologies.

Are you a data enthusiast who thrives on building seamless, efficient, and reliable data systems? Do you enjoy transforming raw data into actionable insights that make a difference? As a Data Engineer, you'll play a critical role in creating and maintaining cutting-edge data pipelines and systems that drive our business decisions. You'll collaborate across teams, automate processes, and turn complex data into solutions that empower stakeholders and analysts company-wide. The position will be headquartered in Charlottesville, VA and will be supported by the Director, Technical Services and Architecture. Candidates based on the east coat would be ideal to accommodate same time zone collaboration. What You'll Do: <ul> <li>Design, maintain, and optimize data pipelines that keep our data moving smoothly. </li><li>Automate processes to ensure efficiency, reliability, and scalability. </li><li>Partner with teams across the company to uncover opportunities for using data to solve business challenges. </li><li>Build and support data integrations for in-house and third-party systems. </li><li>Create data visualizations that make information clear and actionable. </li><li>Rapidly prototype datasets to support Data Science and Analytics teams. </li><li>Ensure the security, integrity, and quality of all data structures and systems. </li></ul>What We're Looking For: <ul> <li>3+ years of experience in a data engineering role. </li><li>Expertise in Snowflake, Python, DBT. AWS Glue, and SQL are advantageous. </li><li>Experience with ETL/ELT pipelines and designing star-schema or flattened data models. </li><li>A Bachelor's degree in Data Science/ Information Technology or a related field is advantageous. </li><li>Excellent communication and collaboration skills-you love solving problems and sharing ideas. </li><li>A proactive mindset with the ability to ask questions, innovate, and challenge the status quo. </li><li>Strong organizational skills with the ability to juggle priorities and adapt to changing expectations. </li></ul>Why You'll Love Working With Us: <ul> <li>Join a collaborative team that values creativity, innovation, and growth. </li><li>Flexibility to work fully remote or come into the office, depending on your location. </li><li>A chance to directly impact the business by building efficient and scalable data systems. </li><li>A supportive environment where asking questions, learning, and growing are encouraged. </li></ul>About CFA Institute CFA Institute are the global leader in investment excellence and ethics. With nearly 200,000 charterholders across 160 markets, we drive professional growth, ethical behavior, and better markets. We care about our employees' well-being, offering industry-leading benefits like: <ul> <li>Comprehensive health coverage for you and your family </li><li>Generous leave and time off </li><li>Competitive retirement plans </li><li>Flexible work options </li><li>Wellness, education, and support programs </li></ul> If you feel this opportunity could be the next step in your career, we encourage you to click "Apply" and complete our three-minute application. Be part of a team committed to putting investors first and growing economies. Follow us @CFAInstitute on LinkedIn and X. We are an Equal Opportunity Employer. CFA Institute prohibits both discrimination and harassment with regard to all identifying characteristics: any individual employee, group of employees, or prospective employee on the basis of race, color, national origin, citizenship or immigration status, religion, creed or belief, age, marital or partnership status, marital or family status, care giver status, pregnancy and maternity, sexual and other reproductive health decisions, physical abilities/qualities, disability, sexual orientation, gender, gender identity or expression, predisposing genetic characteristic, military or veteran status, status as a victim or witness of domestic violence or sex offense or stalking, unemployment status, infectious disease carrier status, migrant worker status, educational background, socio-economic status, geographic location and culture or any other basis protected by applicable law. This policy impacts all aspects of employment, including but not limited to, recruitment, hiring, compensation, training, development, promotion, demotion, layoff, recall, furlough, transfer, leave of absence, and dismissal. This is a global policy that applies to all CFA Institute employees, regardless of location. If, due to a disability or current medical condition, you need an accommodation or assistance to complete a job application, you can request one at any stage of the recruitment process. Please send an email to humanresources@cfainstitute.org noting the accommodations or assistance you are requesting. Please do not include any medical or health information in this email. We will review your request and contact you to discuss the possible options and arrangements. We will try our best to provide you with an accommodation or assistance that meets your needs and respects your preferences. Our application is not compatible with Internet Explorer (IE). We recommend using Chrome.

(*) This is a remote position; however, the candidate must reside within 30 miles of one of the following locations:     Boston, MA; Chicago, IL; San Francisco Bay Area, CA; and Portland, ME.
About the Team/Role
We are the cloud data platform team at WEX. We empower businesses by providing cutting-edge data platforms and solutions that drive innovation and enhance decision-making. Our platform is built on a foundation of innovation, security, and scalability, and we are looking for a highly skilled and experienced Senior Data Engineer to join our dynamic team and help us continue to push the boundaries of what is possible.
As a Senior Data Engineer at WEX, you will drive the implementation and optimization of our cloud data platform. As a key member of our organization, you will play a critical role in designing and implementing industry-leading data solutions that meet the needs of our business. You will also play a pivotal role in architecting and implementing data solutions that underpin our data platform.
As a Senior data engineer, you will be at the forefront of driving transformative change in our data engineering capabilities. You will leverage your product expertise, along with your extensive experience in AWS, Snowflake, Big Data technologies, and DataOps, to design and implement cutting-edge data solutions. Your role will involve making design decisions that optimize performance, scalability, and data governance while meeting the unique requirements of WEX.
How you'll make an impact
Lead the design and implementation of scalable, robust, and high-performance data pipelines, ETL processes, and analytics solutions using AWS services, Snowflake, and other Big Data technologies.

Understanding of Data Warehousing/Data Lake/Data Lake House architecture.

Collaborate closely with business stakeholders, data scientists, and other cross-functional teams to understand their requirements and translate them into innovative data solutions.

Optimizing with the capability to do performance-tune complex SQL queries on Snowflake along with a deep understanding of cost optimization strategies in Snowflake.

Working with Data Analysts to ensure that all data feeds are optimized and available at the required times. This can include Change Capture, Change Data Control, and other 'delta loading' approaches.

Implement solutions for data integration, data management, metadata management, data processing, data security, and data quality, including technical delivery review, resolution of design issues, and the migration of the existing on-premises applications to the data platform.

Improve data discovery and usability with data tagging, cataloging, and ensuring accuracy, consistency, and reliability of data.

Experience you'll bring
Proficiency in data engineering.

Strong expertise in designing and building scalable data pipelines, ETL processes, and analytics solutions using AWS services (e.g., S3, Glue, Lambda), ETL tools (e.g., Informatica IDMC), and Snowflake.

Experience with increasing responsibilities implementing data solutions with a focus on Snowflake or similar warehouse.

Good understanding of Cloud-based data solution components and architecture covering data ingestion, data processing, data cataloging, data optimization, security, DevOps, consumption, etc.

Experience implementing core Snowflake concepts such as UDFs, zero-copy clones, time travel, micro partition, stored procedures, data import/export, and external tables focus on snowflake.

Experience with scripting language and governance tools (e.g., Alation, Collibra) will be an added advantage.

Exceptional communication and collaboration skills, with the ability to work effectively with senior stakeholders and cross-functional teams.

Extensive experience working with data related to the fintech industry, including knowledge of Rebates, commissions, and pricing and familiarity with how these processes integrate with other business operations such as sales and finance.

Knowledge of financial accounting principles relevant to rebates and commissions will be an added advantage.

Experience in software engineering with a strong background in software development, design patterns, and best practices.

Development experience with programming languages such as Java, Python, or Scala.

Strong understanding of code quality, version control, testing frameworks, and CI/CD pipelines.

Required Qualifications:
Bachelor in Computer Science or Equivalent with 10 years of experience in Data Engineering and data warehousing or Master with 7 years worth of experience in Data Engineering and data warehousing.

7+ Years of experience in PowerCenter/Informatica cloud (IICS) - Expert level knowledge & Experience in CDI and CAI.

Experience in API-based integration and real-time integration.

Knowledge of other Informatica products is always a plus.

#J-18808-Ljbffr

About usEndowus is Asia’s leading fee-only wealth platform. Headquartered in Singapore, we are the first digital advisor to span both private wealth and public pension savings (CPF & SRS), helping everyone grow all their money with expert advice, institutional access to financial solutions, low & fair fees, and a delightful personalised digital wealth experience. Our clients entrust us with a responsibility that goes far beyond technology or financial markets - they entrust us with their wealth - their livelihoods and ambitions of a better future for themselves and their loved ones. Our mission is clear: help people invest better so they can live easier today, and better tomorrow. The team has deep domain knowledge in finance and technology, bringing together decades of experience from various banks and tech companies. We treasure our diversity in background and experience, and we look for people who share our beliefs in our mission. About the TeamThe Client Interactions & Insights Platform team builds and operates the scalable data platform that powers data analytics and business intelligence for better decision making at Endowus. Working with colleagues in Data Analytics, Growth, Marketing, and Operations teams, the data engineering team creates data solutions that provide them with performant, near real time access to internal & third party data and insights.We are a full stack team that builds our systems using cloud native patterns and operates them with high standards of engineering & operational excellence. About this role, responsibilities & ownership<ul><li>Lead technical design, delivery, reliability & security of our core data platform.</li><li>Work closely with the Product team, other Engineering teams, and stakeholders in Data Analytics, Growth, Marketing, Operations, Compliance & IT Risk to achieve our business goals.</li><li>Strive for high levels of technical quality, reliability, and delivery efficiency.</li><li>Mentor and grow a small talented team of junior data engineers.</li></ul> Requirements<ul><li>Bachelors' or above in Computer Science, a related field, or equivalent professional experience.</li><li>At least 6 years experience in designing and implementing highly scalable, distributed data collection, aggregation, and analysis systems built for handling large volumes of data in the cloud.</li><li>Significant hands-on experience developing data pipelines with Apache Spark with Scala</li><li>At least 2 years experience as a tech lead facing business users directly and leading technical initiatives</li><li>Significant hands-on experience building and optimising data pipelines for data collection, transformation, aggregation in Apache Flink or Apache Spark, using dependency and workflow management tools such as Airflow, operating in a public cloud environment like AWS, GCP or Azure.</li><li>Advanced SQL knowledge and strong experience working with relational and non-relational databases.</li><li>Experience integrating BI tools such as Tableau, Mode, Looker, etc.</li><li>Experience integrating data sources using REST and streaming protocols, especially using Kafka.</li><li>Experience with building systems & processes to handle data quality, data privacy, and data sovereignty requirements.</li><li>Experience with agile processes, testing, CI/CD, and production error/metrics monitoring.</li><li>Self-driven with a strong sense of ownership.</li><li>Comfortable with numbers and motivated by steep learning curves.</li><li>Has a strong product sense and is empathetic to customers' experiences of using the product.</li></ul> Preferred Skills & Experience<ul><li>Domain experience in a B2C context is a strong plus.</li><li>Knowledge of finance, wealth, and trading domain.</li><li>Some exposure to CQRS / Event Sourcing patterns.</li><li>Experience with AWS or GCP, Cassandra, Kafka, Kubernetes, Terraform.</li></ul> Our Investors, recognition, licensingFounded in 2017, Endowus has raised a total of US$50 million in funding from investors such as UBS, EDBI, Prosus Ventures, Z Venture Capital, Samsung Ventures, Singtel Innov8, and global leading venture capital firms Lightspeed Venture Partners and SoftBank Ventures Asia. Endowus’ leadership and growth have been recognised by the industry and it has attained numerous awards including, Singapore’s Best Digital Wealth Management (Asia Asset Management’s Best of the Best Awards 2024), Singapore’s Best Digital Upgrade for enhancements made on the Endowus app (The Asset Triple A Digital Awards 2024), Singapore’s Best Digital Wealth Management Experience (The Asset Triple A Digital Awards 2023), and Best WealthTech Solution 2023 (Asian Private Banker 9th Technology Awards). Endowus is also among the firms named in the World Economic Forum’s Technology Pioneers 2023, LinkedIn Top Start-ups 2023 and Forbes’ “100 to Watch” list for 2022. The Endowus Group comprises Endowus' licensed companies in Hong Kong and Singapore, as well as Hong Kong-based multi family office Carret Private. Endowus Group serves over a hundred thousand clients with content, advice and access. With group assets of over US$6 billion, it is one of the largest independent wealth managers in Asia. From a combination of 100% trailer fees rebates as direct cashback to clients, savings from the access to institutional share class and exclusive funds, Endowus has created more than US$40 million in savings per year for its clients.

Xbox Game Studios makes some of the best AAA games on the planet and the opportunities for a motivated Senior Data Engineer are endless. We are an agile team within Xbox Games Studios Quality tackling a wide range of problems throughout the game development process. As a Senior Data Engineer in Xbox Games Studios Quality, you will be working with major franchises that include Halo, Forza, Gears of War and Microsoft Casual Suite. You will be working alongside Data Scientist, Applied Scientist, Software and Quality Engineers to find innovative ways to incorporate data solutions into the game development pipeline for major game studios. This position includes flexible work from home options.

Microsoft’s mission is to empower every person and every organization on the planet to achieve more. As employees 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.

Responsibilities

You will develop and maintain data pipelines, including solutions for data collection, management, transformation, and usage, ensuring accurate data ingestion and readiness for downstream analysis, visualization, and AI model training.

You will design and implement end-to-end software life cycles, encompassing design, development, CI/CD, service reliability, recoverability, and participation in agile development practices, including on-call rotation.

You will write code to implement performance monitoring protocols across data pipelines, building visualizations and aggregations to monitor pipeline health. You’ll also implement solutions and self-healing processes that minimize points of failure across multiple product features.

You will anticipate data governance needs, designing data modeling and handling procedures to ensure compliance with all applicable laws and policies.

You will implemnent and enforce security and access control measures to protect sensitive resources and data.

You will Perform database administration tasks, including maintenance, and performance monitoring.

You will collaborate with Product Managers, Data and Applied Scientists, Software and Quality Engineers, and other stakeholders to understand data requirements and deliver phased solutions that meet test and quality programs data needs, and support AI model training and inference.

Qualifications

Required/Minimum Qualifications:

Bachelor's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field AND 4+ years experience in business analytics, data science, software development, data modeling or data engineering work

OR Master's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field AND 3+ years experience in business analytics, data science, software development, data modeling or data engineering work

OR equivalent experience.

4+ years of experience in software or data engineering, with proven proficiency in at least one coding language (e.g., C#) and one scripting language for data retrieval and manipulation (e.g., SQL or KQL).

4+ years of experience with ETL and data cloud computing technologies, including Azure Data Lake, Azure Data Factory, Azure Synapse, Azure Logic Apps, Azure Functions, Azure Data Explorer, and Power BI or equivalent platforms.

2+ years of demonstrated experience implementing data governance practices, including data access, security and privacy controls and monitoring to comply with regulatory standards.

Additional or Preferred Qualifications:

8+ years of professional software development experience.

Experience building APIs and services using REST

Experience working with Python, AI and machine learning technologies.

Data Engineering IC4 - The typical base pay range for this role across the U.S. is USD $117,200 - $229,200 per year. There is a different range applicable to specific work locations, within the San Francisco Bay area and New York City metropolitan area, and the base pay range for this role in those locations is USD $153,600 - $250,200 per year.

Certain roles may be eligible for benefits and other compensation. Find additional benefits and pay information here: https://careers.microsoft.com/us/en/us-corporate-pay

Microsoft will accept applications for the role until January 9, 2025.

#gamingjobs

#Xbox

Microsoft is an equal opportunity employer. Consistent with applicable law, all qualified applicants will receive consideration for employment without regard to age, ancestry, citizenship, color, family or medical care leave, gender identity or expression, genetic information, immigration status, marital status, medical condition, national origin, physical or mental disability, political affiliation, protected veteran or military status, race, ethnicity, religion, sex (including pregnancy), sexual orientation, or any other characteristic protected by applicable local laws, regulations and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application process, read more about requesting accommodations (https://careers.microsoft.com/v2/global/en/accessibility.html) .

Do you dream of transforming raw, unstructured data into valuable insights that drive growth and profitability? Are you seeking a role where your skills can make a lasting impact on both the company you work for and its clients?
I have a Hybrid opportunity in Dallas, TX, for a Data Engineer to join an organization that's redefining SaaS business management software for small businesses. With a platform that's so effective, it helps mom-and-pop businesses turn a profit within days of implementation. Now, they're ready to turn their untapped data potential into a goldmine of insights and they need a data expert like you to lead the charge.

Your Role:

• Serve as the company's go-to Data Engineer, the first in this newly created role.

• Analyze, structure, and manipulate unstructured data within a Postgres database on AWS.

• Create ERP-style reports and deliver data-driven insights for Sera's internal operations and its platform clients.

• Write SQL queries and build detailed reports that unlock key business metrics.

• Provide valuable, actionable insights for leadership, customers, and end-users, driving better decision-making.

What You'll Need:

• 7+ years of experience as a Data Engineer, Data Analyst, or similar role (3-5 years of experience may be considered for exceptional candidates).

• Strong proficiency in SQL, including advanced query writing.

• Ability to analyze and manipulate unstructured data into structured, actionable insights.

• Prior experience creating ERP-style reports that influence business decisions.

• Familiarity with Postgres and AWS is highly valued.

Bonus Skills (Nice-to-Have):

• Experience with Ruby on Rails or JavaScript.

• Knowledge of AWS environments.

• Familiarity with Postgres.

The Perks:

• $100,000 to $125,000 annual salary.

• Generous PTO to recharge and relax.

• Flex time - because work-life balance matters.

• 401k with a 100% match up to 4%.

• Comprehensive medical, dental, and vision insurance.

• Additional benefits to support your well-being and career growth.

Work Environment:

Partial Remote - The first 90 days will be on-site to establish a strong foundation with the team and leadership. After that, enjoy a hybrid schedule with remote work on Mondays and Fridays and in-office collaboration Tuesday through Thursday.

Apply today and be part of something big. Your work will fuel growth, innovation, and profitability for businesses nationwide.

About Camden Kelly

At Camden Kelly, we've built a reputation for connecting top tech talent with great companies across the United States. Whether you're scaling your team or hunting for a new opportunity, we're your partner every step of the way.

We're not just another recruiting firm. We live by our values-honesty, accountability, ethics, and reliability. We push ourselves daily to raise the bar and deliver better results, faster. Our competition? It's not other firms-it's ourselves, striving to improve for you.

Explore your next opportunity at camdenkelly.com/jobs and stay in the loop by following us on Twitter , LinkedIn , and Facebook . Let's connect and get started on building your dream team or finding your dream job.

Job Posting Description  At Boston Children's Hospital, the quality of our care - and our inclusive hospital working environment - lies in the diversity of our people. With patients from local communities and 160 countries around the world, we're committed to reflecting the spectrum of their cultures, while opening doors of opportunity for our team. Here, different talents pursue common goals. Voices are heard and ideas are shared. Join us, and discover how your unique contributions can change lives. Yours included.
The Musculoskeletal Digital Innovation and Informatics Program (https://www.musculoskeletal.ai/) at the Department of Orthopedic Surgery and Sports Medicine at Boston Children's Hospital and Harvard Medical School has an immediate opening for a motivated Data Engineer to work with a multidisciplinary team of biomedical engineers, orthopedic surgeons, and computer and data scientists to contribute to development of data pipelines to process electronic medical records to assist with clinical care, research and operation. This opportunity is primarily focused on translational research with immediate impact on clinical care of patients with a range of musculoskeletal conditions, through publication of novel findings and development of computational tools used by clinicians.   This Data Engineer will be responsible for:
Working closely with the team to create data processing pipelines and fulfilling requests using a variety of database and analytic technologies
Supporting the design, implementation, and maintenance of Extract, Transform, Load (ETL) processes to gather and process data from electronic medical records
Troubleshooting issues with data processing pipelines and escalating problems requiring in-depth knowledge to the team lead
Participating in discussions with clinicians, researchers, and administrators to identify and refine project requirements
Collaborating with other data engineers on tools, languages, and code/process improvements, including code reviews
Producing and maintaining documentation on processes, database models, and project workflows
To qualify, you must have:
1+ years of experience
A Bachelor's degree in Computer Science, Software Engineering, or a related scientific discipline is required. Masters degree is a plus
Demonstrated experience with Python programming and data processing libraries (e.g., pandas, NumPy, etc.)
Experience with SQL and familiarity with database models
Familiarity with building dynamic visualizations and ETL process design/implementation
Interest in and demonstrated ability to learn new concepts and grow as a data engineer
Strong analytical skills, with attention to detail and accuracy
The ability to maintain positive and productive relationships and communicate effectively with both technical and non-technical users
Boston Children's Hospital offers competitive compensation and unmatched benefits including flexible schedules, affordable health, vision and dental insurance, child care and student loan subsidies, generous levels of time off, 403(b) Retirement Savings plan, Pension, Tuition and certain License and Certification Reimbursement, cell phone plan discounts and discounted rates on T-passes. Experience the benefits of passion and teamwork.
Boston Children's Hospital requires all employees to be vaccinated against COVID-19 and Flu, (unless you are eligible for a medical or religious exemption).
Boston Children's Hospital is an Equal Opportunity / Affirmative Action Employer. Qualified applicants will receive consideration for employment without regard to their race, color, religion, national origin, sex, sexual orientation, gender identity, protected veteran status or disability.

605 Data Engineer Interview Guide

Overview

605 Data Engineer Salary

605 Data Engineer Interview Process

605 Data Engineer Interview Questions

605 Data Engineer Jobs