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

Westat Data Engineer Interview Guide

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


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

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

Overview

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

Westat 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

Westat Data Engineer Interview Questions

Continental Properties is looking for a Data Engineer I to join our team at our home office in Menomonee Falls, Wisconsin. This newly created role is a part of a transformation we are undergoing to work towards a more data-driven organization that is better equipped to produce the high-quality data we need to make better decisions and provide more unique, more compelling products and services to our customers. As our Data Engineer you will develop data pipelines that support data warehousing, BI reporting, and analytics. You will use your technical abilities to provide value using data to our organization. As a Data Engineer, you will report to our Director of Data Management and Integration and meaningfully contribute to this department. We are embracing a hybrid working environment and you can work both in the office and remote. #LI-Hybrid Essential Responsibilities: <ul><li>Develop data pipelines for warehousing, BI reporting, and analytics using Snowflake, Matillion, DBT, and PowerBI from database, file, and API sources using DataOps methodologies</li><li>Implement data quality and integrity checks to identify and fix data issues.</li><li>Inform our processes that create data throughout the company; influence changes in processes to create data that is accurate and useful</li><li>Be a resource for data users in the organization. Create awareness of available data. Assist our users with technical tasks including data extracts, report creation, SQL, and general data system troubleshooting</li><li>Develop documentation on database and Power BI datasets</li><li>Participate in peer review of code and processes</li></ul> Skills for Success: <ul><li>Bachelor's or Master's Degree in Computer Science, Data Science, Finance, Statistics, Mathematics, or another quantitative field.</li><li>Ideally looking for 1 to 2 years in a SQL-based data engineering or analytics</li><li>Strong SQL skills</li><li>Working knowledge of Matillion</li><li>Experience working with APIs</li><li>An understanding of warehouse design and best practices</li><li>Experience loading and transforming structured and semi-structured data using</li><li>Data preparation and report creation using Power BI, Tableau, Qlik, or another BI tool</li></ul> Why You'll Love Life at Continental: Our award-winning culture fosters innovation and empowers our team members to lead. Here are some of the reasons that our team members continue to vote for us as a Top Workplace: <ul><li>Career Growth: You'll have the tools, training, and opportunities for a meaningful career with long-term growth potential. We invest in your learning & development with paid professional memberships, certifications, and tuition reimbursement.</li><li>Mental Health & Wellness: Your well-being matters. We provide comprehensive mental health support including but not limited to 8-free counseling sessions per year and access to additional wellness resources.</li><li>Balance: We recognize that balance varies for everyone, and we support our team members with that in mind. Recharge with generous vacation time, 9-paid holidays, and half-days on Fridays during designated months.</li><li>Community & Connection: Build relationships through informal gatherings, lunches, community and company events, volunteer opportunities, and a vibrant social culture. Learn more about recent Continental events here!</li><li>Culture of Belonging: The Continental IDEA (Inclusion, Diversity, Equity, & Allies) is our commitment to evolving our culture where team members feel a sense of belongingness each day. Our You Belong Here Initiative and Business Resource Groups focus on fostering an inclusive and equitable work environment for all.</li><li>Performance Incentives: Participate in our Building Above and Beyond (BAAB) incentive program that rewards team members annually based on company goals and achievements.</li><li>Industry-Leading Benefits: Enjoy a comprehensive benefits package, including Medical, Dental, and Vision Plans, flexible spending accounts, 401(k) with company match, and company-paid life and disability insurance.</li><li>Family Support: Support your growing family with 6-weeks paid parental leave and with family-forming & fertility resources (up to 12-weeks leave for birth mothers).</li></ul> We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender, gender identity or expression, or veteran status. We are proud to be an equal opportunity workplace. We comply with the Americans with Disabilities Act (ADA), and all applicable state and local fair employment practices laws, and are committed to providing equal employment opportunities to qualified individuals with disabilities. For the benefit of our residents, the communities we serve, and our co-workers, all applicants are required to pass a post-offer criminal background check prior to joining the Continental team

Company Description Visa is a world leader in payments and technology, with over 259 billion payments transactions flowing safely between consumers, merchants, financial institutions, and government entities in more than 200 countries and territories each year. Our mission is to connect the world through the most innovative, convenient, reliable, and secure payments network, enabling individuals, businesses, and economies to thrive while driven by a common purpose - to uplift everyone, everywhere by being the best way to pay and be paid. Make an impact with a purpose-driven industry leader. Join us today and experience Life at Visa. Job Description As an emerging professional Data Engineer, you will become a valuable contributor to one of Visa's dynamic technology teams. Visa is committed to fostering growth and development, and we encourage you to find a role that aligns with both your personal passions and professional aspirations. You will have the opportunity to take on new responsibilities, acquire new skills, and explore different parts of our business. As the new hire, you will be responsible for creating and optimizing data pipeline architecture, assembling large complex data sets that meet business requirements, and identifying, designing, and implementing process improvements such as automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability. In the context of Visa, you will be part of our team of software developers, data architects, data analysts, and data scientists. You will ensure optimal data flow and collection for these cross-functional teams and maintain data delivery architecture consistent throughout ongoing projects. As the Data Engineer, you are self-directed and comfortable supporting the needs of multiple teams, systems, and products through a wide variety of data sources using Big Data and Cloud technologies. You are excited by the prospect of optimizing or re-designing our company's data architecture to support our next generation of products and data initiatives. Responsibilities: <ul><li>Design and deploy new applications directly in the Big Data and Cloud platform. </li><li>Identify the best practices for Big Data and Cloud service management & promote these across teams. </li><li>Migrate on-premises corporate applications and related data to the Big Data and the Cloud. </li><li>Build analytics tools that utilize the data pipeline to provide actionable insights into clients' critical business performance metrics using Big Data and Cloud service technologies. </li><li>Research, implement and maintain Big Data and Cloud services to support applications. </li><li>Create data tools for business team members that assist them in building and optimizing Visa's products into innovative industry leaders. </li><li>Monitor data application performance for potential bottlenecks and resolve performance issues. </li><li>Identify and implement cost-saving strategies to reduce ongoing Big Data and Cloud costs/expenses. </li><li>Automate key services and tasks across Big Data and Cloud systems to increase efficiency </li><li>Formulating a recovery plan and executing the plan in the event of data pipeline downtime or failure </li></ul> Qualifications Basic Qualifications <ul><li>Less than 2 years relevant work experience with either Bachelor's or Master's degree in Computer Science, Computer Engineering, CIS/MIS, Cybersecurity, Business or a related field, graduating January 2024 - August 2025</li><li>Strong communications skills, specifically, the absence of repeated grammatical or typographical errors, clear and concise written and spoken communications, and communications that demonstrate professional judgment.</li></ul> Preferred Qualifications <ul><li>Experience with programming languages such as Python, Java, Scala, C++, Rust, Golang, </li><li>Basic knowledge of Distributed Systems, and Data Structures </li><li>Knowledge or experience with Big Data and the Cloud platform services: Apache Hadoop, Apache Spark. </li><li>Basic Knowledge in ETL, Data Pipelines using Python, Shell Scripts, Apache Airflow, and Apache Kafka; Building & Populating Data Warehouses, and Querying with BI tools. </li><li>Basic Knowledge in RDBMS fundamentals: Design & Creation of Databases, Schemas, Tables; DB Administration, Security & working with MySQL & IBM Db2. </li><li>Basic Knowledge in SQL query language, database functions, stored procs, working with multiple tables, joins, & transactions. </li><li>Basic Knowledge in NoSQL & Big Data concepts: MongoDB, Cassandra </li><li>Knowledge of best practices and IT operations in an always-up, always-available service </li><li>Experience with or knowledge of Agile Software Development methodologies </li><li>The ability to take on challenges and address problems head-on </li><li>Strong ability to collaborate </li><li>Highly driven, resourceful and results oriented </li><li>Good team player and excellent interpersonal skills </li><li>Good analytical and problem-solving skills </li><li>Demonstrated ability to lead and navigate through ambiguity.</li></ul> Additional Information U.S. APPLICANTS ONLY: The estimated salary for a new hire into this position is $105,000 USD which may include potential sales incentive payments (if applicable). Salary may vary depending on job-related factors which may include knowledge, skills, experience, and location. In addition, this position may be eligible for bonus and equity. Visa has a comprehensive benefits package for which this position may be eligible that includes Medical, Dental, Vision, 401 (k), FSA/HSA, Life Insurance, Paid Time Off, and Wellness Program. Work Authorization: Permanent Authorization to work in the U.S. is a precondition of employment for this position. Visa will not sponsor applicants for work visas in connection with this position. Future sponsorship will not be considered. Work Hours: Varies upon the needs of the department. This is a hybrid position: Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office 2-3 set days a week (determined by leadership/site), with a general guidepost of being in the office 50% or more of the time based on business needs. Travel Requirements: This position requires travel 5-10% of the time. Mental/Physical Requirements: This position will be performed in an office setting. The position will require the incumbent to sit and stand at a desk, communicate in person and by telephone, frequently operate standard office equipment, such as telephones and computers. Visa is an EEO Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status. Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law. Visa will consider for employment qualified applicants with criminal histories in a manner consistent with applicable local law, including the requirements of Article 49 of the San Francisco Police Code.

Join True Rx Health Strategists as a Trade Relations Senior Data Engineer! We are seeking a talented Trade Relations Senior Data Engineer to spearhead the development and support of our Trade Relations data mart. This crucial role reports directly to the Director of Trade Relations and is pivotal in delivering actionable insights for both internal and external stakeholders. If you're ready to make a significant impact and thrive in a collaborative environment, we want to hear from you! What You'll Do: <ul><li>Lead the Way: Drive full-stack solutions independently, owning data models and executing ETL functions.</li><li>Software Development: Participate in all aspects of software development, from research and design to the maintenance of our data marts.</li><li>Team Collaboration: Build and nurture positive relationships with multi-layered teams and staff, ensuring effective communication and collaboration.</li><li>Data Integrity: Monitor interfaces/jobs and support on-call activities to maintain operational efficiency.</li><li>Innovate and Integrate: Lead new integration initiatives, designing tables and models to support business growth and refining databases for optimal performance.</li><li>Insight Development: Create tools that facilitate actionable insights and work closely with the Trade Relations team to ensure data quality and organization.</li></ul> What We're Looking For: <ul><li>Experience: 5+ years in data management, including the creation, maintenance, and optimization of data models.</li><li>Technical Skills: 5+ years of ETL experience with PL/SQL and expertise in database querying, stored procedures, and schema definition.</li><li>ETL Tools: Proficiency with tools such as SnapLogic, Informatica, ADF, or MuleSoft.</li><li>Mentorship: Ability to share knowledge and mentor team members.</li><li>Adaptability: Fast learner with a strong appetite for continuous learning and new tools.</li><li>Industry Knowledge: 3-5 years of experience in pharmaceutical rebate management or PBM, with analytical skills using tools like Excel and BI.</li><li>Education: Bachelor's degree in a relevant field.</li></ul> True Rx Health Strategist Benefits: <ul><li>Path to Wellness: Health, Vision, & Dental Insurance, Health Savings Account, and Wellness Incentives for a balanced life.</li><li>Financial Fitness: 401k Matching and Employer-Provided Life Insurance to secure your future.</li><li>Work-Life Harmony: Flex Time, Hybrid/Fully Remote Work, Paid Time Off, and 8 Paid Holidays for a well-rounded lifestyle.</li></ul> Our Story:We've been pharmacy innovators since the Wright Brothers took flight. For more than 120 years, we have been innovating pharmacy solutions and taking care of patients. True Rx Health Strategists is led by a fourth generation of pharmacists. We are family-owned and continue to provide caring service for clients and patients. Our team of pharmacists and strategists delivers proven programs that find maximum savings and minimum disruption by creating a benefits plan that fits the unique needs of clients and patients. Learn more about us here. Our Mission: True Rx Health Strategists cultivates health, integrity, innovation, and care to transcend pharmacy benefit solutions for employers and patients. Learn more about our remarkable team members. Our Promise: As a pharmacist-led company, True Rx Health Strategists has an oath to treat members as patients. With our experience as health care providers, we protect companies against waste in health care spending and work hard to improve the health of employees every day. We get to improve lives by treating employees as our patients. Here are a few words from one of those lives. True Rx Health Strategists hires equally for culture fit and technical skills and experience. If you have the aptitude and attitude, we can help you grow your career through training, mentoring, increasing responsibility, and being around other rock star team members. True Rx Health Strategists is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, sex, age, status as a protected veteran, among other things, or status as a qualified individual with disability.

Current University of Arkansas System employees, including student employees and graduate assistants, need to log in to Workday via MyApps.Microsoft.com, then access Find Jobs from the Workday search bar to view and apply for open positions. Students at University of Arkansas System two-year institutions will also view open positions and apply within Workday by searching for "Find Jobs for Students". All Job Postings will close at 12:01 a.m. CT on the specified Closing Date (if designated).If you close the browser or exit your application prior to submitting, the application process will be saved as a draft. You will be able to access and complete the application through "My Draft Applications" located on your Candidate Home page. Closing Date: Type of Position:Professional Staff (Non-Classified), Professional Staff - Project/Program Administration Workstudy Position: NoJob Type:Regular Work Shift: Sponsorship Available: NoInstitution Name: University of Arkansas at Little Rock The University of Arkansas at Little Rock is a metropolitan research university that provides an accessible, quality education through flexible learning and unparalleled internship opportunities. At UA Little Rock, we prepare our more than 8,900 students to be innovators and responsible leaders in their fields. Committed to its metropolitan research university mission, UA Little Rock is a driving force in Little Rock's thriving cultural community and a major component of the city and state's growing profile as a regional leader in research, technology transfer, economic development, and job creation. Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening. To apply for the position, please click the Apply link/button. If you have a disability and need assistance with the hiring process please contact Human Resources at 501-916-3180. For general application assistance or if you have questions about a job posting, please contact Human Resources at 501-916-3180. Department:COSMOS Department's Website: https://cosmos.ualr.edu/Summary of Job Duties:The Data Engineer position is a full-time position at the COSMOS Research Center (cosmos.ualr.edu). The Data Engineer will be responsible for collecting, managing, and converting raw data into usable information for analytics and decision-making. This role requires comprehensive data analysis skills, developing and maintaining datasets, and improving data quality and efficiency through leveraging data systems and pipelines, interpreting trends and patterns of data, complex data reports, and building algorithms and prototypes. In addition, the other responsibilities include leading the development of social media data collection pipelines, inference methods and infrastructure, classification methods and infrastructure, and visualization dashboards. The Data Engineer will collaborate with researchers, participate in research projects, and interact with other developers at the COSMOS research center and partner organizations to achieve the best possible performance metrics across various projects. Excellent communication and problem-solving skills are essential for this on-campus position as the data engineer's role is to find opportunities to contribute to cutting-edge research in the exciting field of social computing. Position reports to Dr. Nitin Agarwal (nxagarwalualr.edu), Maulden-Entergy Endowed Chair and Distinguished Professor and Director, COSMOS Research Center, UA-Little Rock. This position is governed by state and federal laws, and agency/institution policy.Qualifications: Required Education and/or Experience: The candidate must have a bachelor's degree in Computer Science, Information Science, or a related discipline. Preferred Education and/or Experience: Having a Master's or a Ph.D. degree in Computer Science, Information Science, or a related discipline is a plus; Having a data engineer certification (e.g., IBM Certified Data Engineer) is a plus; A candidate with prior experience in data engineering and data management roles in social media data will be given preference. Job Duties and Responsibilities : Collecting and analyzing raw data from various sources including social media platforms; Organize and maintaining datasets; Improving data quality and efficiency; Design and manage data pipelines that encompass the journey of data from source to destination systems; Setup and manage the infrastructure required for ingestion, processing, and storage of data; Evaluate the model needs and objectives; Interpret trends and patterns of data; Conduct complex data analysis and report on results; Prepare data for analysis and reporting by transforming and cleansing it; Combine raw information from different sources; Explore ways to enhance data quality and reliability; Identify opportunities for data acquisition; Develop analytical tools and programs; Collaborate with teams at COSMOS on several projects; Other tasks as asked. Knowledge, Skills, and Abilities: Technical expertise in data models, data pipelines, ETL processes, data stores, data mining, and segmentation techniques; Excellent knowledge of programming/scripting languages (e.g., Java and Python); Experience with data integration platforms and SQL database design; Great numerical, analytical, and data security skills; Degree in Computer Science, IT, or a similar field; a Master's is a plus; Data engineering certification (e.g., IBM Certified Data Engineer) is a plus; Prior experience as a data engineer or in a similar role is a plus. Additional Information: Salary Information: $35,568 - $96,120 Required Documents to Apply: Resume Optional Documents: Special Instructions to Applicants: Recruitment Contact Information: Dr. Nitin Agarwal (nxagarwalualr.edu) Maulden-Energy Chair and Distinguished Professor Director, COSMOS Research Center All application materials must be uploaded to the University of Arkansas System Career Sitehttps://uasys.wd5.myworkdayjobs.com/UASYS Please do not send to listed recruitment contact. Pre-employment Screening Requirements:Criminal Background Check, Sex Offender Registry The University of Arkansas at Little Rock is committed to providing a safe campus community. We conduct background checks for applicants being considered for employment. Background checks include a criminal background check and a sex offender registry check. For certain positions, there may also be a financial (credit) background check, a Motor Vehicle Registry (MVR) check, and/or drug screening. Required checks are identified in the position listing. A criminal conviction or arrest pending adjudication or adverse financial history information alone shall not disqualify an applicant in the absence of a relationship to the requirements of the position. Background check information will be used in a confidential, non-discriminatory manner consistent with state and federal law. The University of Arkansas is an equal opportunity, affirmative action institution. The University does not discriminate in its education programs or activities (including in admission and employment) on the basis of age, race, color, national origin, disability, religion, marital or parental status, protected veteran status, military service, genetic information, or sex (including pregnancy, sexual orientation, and gender identity). Federal law prohibits the University from discriminating on these bases. Questions or concerns about the application of Title IX, which prohibits discrimination on the basis of sex, may be sent to the University's Title IX Coordinator and to the U.S. Department of Education Office for Civil Rights. Persons must have proof of legal authority to work in the United States on the first day of employment. All application information is subject to public disclosure under the Arkansas Freedom of Information Act. Constant Physical Activity:Manipulate items with fingers, including keyboarding, Sitting, Standing, Talking, WalkingFrequent Physical Activity:Manipulate items with fingers, including keyboarding, Sitting, Standing, Talking, WalkingOccasional Physical Activity:Manipulate items with fingers, including keyboarding, Sitting, Standing, Talking, WalkingBenefits Eligible:Yes

Job Description: Constellation West is looking for an entry-level to senior-level Data Engineer to support the CDAO's Mission Analytics Directorate through the Advana program, which provides core and data analytics across various domains, including procurement and financial management (FM). By enhancing the integration of procurement and FM datasets, the program aims to improve data quality and completeness, focusing on detailed contract line item numbers (CLIN) and line of accounting (LOA) levels. This integration facilitates the measurement of end-to-end processes, identification of interface failures, and timely obligations and payments. It also supports accurate data conversions and contract closeouts, offering the DoD critical insights into mission-critical processes and helping prevent financial discrepancies and overpayments. Job Details & Tasks: Senior-Level with seven plus years of experience: Manage a team of specialized data scientists and data engineers focused on optimizing the creation, deployment, testing, and iterative development of all bronze, silver, and gold data tables deployed across unclassified and classified CDAO environments under the References. Advana uses Python, SQL, and PySpark languages and standard Python packages in Databricks. Bronze tables are query-able versions of data as they are received, including historical copies. Silver tables are refined source data with a schema standardized against guidance from the data source. Gold tables store fit-for-purpose analytic data transformed, cleansed, and aggregated for the use case or application. All levels of Data Engineer will be expected to perform the following: Create and maintain templates, guides, and playbooks to inform and enable the DoD to reuse and scale data, analytic, and AI work for decision advantage. Provide engineering support to all customers working to leverage the Advana platform and other CDAO platforms: <ul><li>Build data products and data mesh services. </li><li>Register, ingest, store, search, and retrieve data products. </li><li>Develop suites of data quality business logic. </li><li>Train, test, and deploy production AI/ML models. </li><li>Integrate and maintain metadata.</li></ul> Job Qualifications & Requirements:<ul><li>For the Senior-Level position, 7-10+ years of development experience in Python, Spark, SQL</li><li>Proven ability to independently establish and manage multiple data pipelines.</li><li>Experience with Big Data systems and ELT processes.</li><li>Experience with Amazon Web Services (AWS) certification is preferred. </li><li>Experience applying DoD Security Technical Implementation Guides (STIGs) and automating the process.</li><li>Experience in Advana Preferred.</li><li>Bachelors or Higher in related field</li><li>Must hold a Secret security clearance with TS/SCI clearance preferred.</li><li>Valid Passport</li><li>Ability to commute to Falls Church 2-3 days per week.</li></ul> Note: This opportunity is contingent upon the awarding of a bid. We are conducting screenings and interviews to ensure a suitable fit for both candidates and our organization. Successful candidates will receive contingent offers based on mutual agreement, demonstrating our commitment to collaboration upon securing the project. We look forward to the possibility of welcoming you to our team. The tentative start date for this project is December 1, 2024 Project Background: Advana is the Department of Defense (DoD) Chief Digital and Artificial Intelligence Office’s (CDAO) enterprise-wide, multi-domain data, analytics, and artificial intelligence (AI) platform that provides all DoD military and civilian decision makers, analysts, and builders with enterprise data, tools, and capabilities—all in a scalable, reliable, and secure environment. Jointly managed by the DoD CDAO Mission Analytics and Enterprise Platforms and Services Directorates, the mission of Advana is to accelerate decision advantage by making data, analytics, and AI widely accessible, understandable, and actionable across DoD. To do this, the Advana platform hosts curated analytics applications in a total of 13 DoD business domains, to include logistics, people and health, intelligence and security, readiness and global force management, etc.; it provides market-leading, self-service tools to perform data exploration, model development, data visualization, and other analysis activities; and it provides both users and builders on-demand data, analytics, and AI capabilities via a DoD-wide platform. We are an Equal Opportunity Employer All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. Constellation West will not discharge or, in any other manner, discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c) About The Organization Constellation West is an award winning company that delivers Information Technology (IT) engineering services and solutions and non-IT subject matter expertise worldwide. Established in 1997, Constellation West is an industry leader, partnering with key organizations. As a prime contractor or preferred subcontractor, we have a continual list of opportunities to fill nationwide with multiple agencies such as the Department of Veteran Affairs, the Department of Defense, civilian agencies, and the national intelligence community. Many positions supporting the U.S. federal government require our employees to be granted security clearances.Constellation West strives to provide fully integrated solutions that cover all aspects of system and network engineering, administration, and management. We believe in attracting the right people ready to take on exciting challenges and be part of a dynamic team. Are you one of them? Do you have the expertise and knowledge to solve complex problems? If yes, join us and be a part of an exhilarating work environment that rewards your hard work and dedication. Don't miss out on this fantastic opportunity to make a difference! Benefits include but are not limited to:<ul><li>Tuition reimbursement</li><li>Competitive 401(k) plan</li><li>Competitive Health Benefits</li><li>11 Paid Holidays!!</li><li>Start accruing PTO on Day 1!</li><li>Veteran Hiring Preference</li></ul>Constellation West is proud to be an EEO/AA employer M/F/D/V

TITLE Data Engineer WHAT YOU WILL ACHIEVE In this role, you will create and maintain Addgene's data and bioinformatics pipelines, data warehouse environment, machine learning models, and analytics and AI capabilities. You will work with our small and nimble data science team to enable broad data access across the organization, perform large, complex analysis, and innovate utilization of data. By identifying and pursuing new opportunities to solve business problems, you will accelerate decision making processes and advance Addgene's scientific mission. POSITION REPORTS TO Director of Data Science SALARY $100,000 - $110,000 annually + our amazing benefits (see below)! LOCATION & POLICY ON REMOTE WORK This role is completely flexible to be fully remote, hybrid, or onsite-although ability to come into the office on occasion is preferred. Our office is located at 490 Arsenal Way in Watertown, Massachusetts. Our beautiful office space has free, ample parking with a complimentary shuttle from Harvard Square and is on multiple bus lines, with the cost of public transit covered by Addgene (if onsite at least 4 days/week). You have flexibility when you work your hours, but need to be available generally for meetings that occur during 9am-4pm EST. You must be a resident in one of the following states: MA, VT, ME, RI, NC, FL, CO and OH. Addgene's Covid-19 Safety Measures: At this time, vaccinations are strongly encouraged for all employees of Addgene, but not required. The Role: The Data Engineer will develop and maintain the infrastructure and tools required for Addgene's data and bioinformatics environment. The ideal candidate will collaborate and effectively communicate within and across various teams on complex projects to investigate, plan and deliver data solutions.. To Succeed in this Role, You Will: <ul><li>Work collaboratively with team members using Kanban and Agile frameworks to respond to internal requests for datasets, analysis and visualization, and contribute to larger team projects.</li><li>Curate, wrangle, and prepare data reports, summaries and/or visualizations for other Addgene teams</li><li>Collaborate with team members to maintain and improve existing bioinformatics workflows written in Nextflow (a domain specific language implemented in Groovy) and develop new automation capabilities for Addgene's bioinformatics needs</li><li>Design, create, monitor, and improve data pipelines to enable an accurate, comprehensive, and reliable data analytics environment</li><li>Generate large and/or complex datasets, reports, visualizations, and dashboards using Google Cloud products (BigQuery, LookerStudio) and Jupyter notebooks</li><li>Build and strengthen our infrastructure to easily and efficiently complete tasks and projects</li><li>Produce well-engineered software using best practices, including automated tests (Python unit testing), documentation (Confluence) and continuous integration and continuous deployment (Teamcity/Jenkins)</li><li>Collaborate with stakeholders on other teams to clarify requirements, provide estimates, verify data output, acceptance test, and communicate limitations and/or caveats</li><li>Work independently on assigned tasks, and effectively manage multiple responsibilities. Take initiative to make decisions that will impact team processes and output</li><li>Review other team members' code, and have your code reviewed</li><li>Keep up to date with new technologies and best practices, and seek out opportunities to integrate them into our code base and processes</li></ul> Skills and Competencies Required: <ul><li>Master's degree in Computer Science, Data Engineering, or related technical field with 1-2 years professional, full-time experience (or Bachelor's degree with additional 3-4 years of experience)</li><li>Minimum 1-2 years professional software or data engineering experience using Python</li><li>At least 1 year experience with Python data science libraries, such as pandas and NumPy</li><li>In-depth experience with relational databases and constructing complex queries (ex. SQL) to retrieve data</li><li>Familiarity with data pipelines and ETL architectures</li><li>Proficiency with common software engineering practices, including source control, testing, code reviews, and deployment</li><li>Working knowledge of Linux/Unix operating systems and command-line tools</li><li>Proactive problem-solving skills and ability to implement process improvements</li><li>Strong communication skills and ability to translate and explain concepts and results to non-technical team members and stakeholders</li></ul> Preferred: <ul><li>Experience working with Django and writing queries to retrieve data</li><li>Hands-on experience building and optimizing data pipelines and ETL architectures using cloud platform technologies (ex. Google Cloud, AWS)</li><li>Familiarity with and developing ML or statistical models using Python libraries, such as PyTorch, Tensorflow, XGBoost</li></ul> Benefits At Addgene, we prioritize our people with comprehensive benefits that support both your work and your life. Full-time employees receive: <ul><li>100% company-paid benefit package that includes health & dental (extending to family members), life, short-term, and long-term disability insurance.</li><li>Twenty days of PTO on top of our winter break closure and company holidays. </li><li>A 403(b) retirement account with a company match of 4% after 2 years of employment. </li><li>Annual professional development stipend</li><li>Annual lifestyle stipend</li><li>Fully paid public transportation for employees who work onsite four or more days per week. </li><li>Onsite yoga classes & wellness reimbursement</li><li>Pet insurance</li><li>Annual financial planning one-on-ones with our plan administrator</li></ul> The Organization: Addgene is a self-sustaining, thriving nonprofit life sciences organization that was created to help scientists share DNA-based research materials called plasmids. Our mission is to accelerate research and discovery by improving access to useful research materials and information. Since its founding in 2004, Addgene has grown and innovated in order to assist the research community by archiving and sharing useful DNA-based research materials and resources (such as plasmids, viral vectors, and recombinant antibodies) with scientists worldwide. Broad availability of these unique research materials promotes the advancement of research in a wide variety of disciplines, including cancer, heart disease, and neurodegenerative disorders, while increasing collaboration within the scientific community. Learn more here from one of our founders, Melina Fan. As an "Addgenie", you will work collaboratively with internal teams to help fulfill this mission, including scientists, software engineers and product developers, renowned customer support teams, scientific content creators, and business development professionals. Together, Addgenies create and enhance opportunities for research scientists to deposit their materials, find products and resources easily on our website, and receive unparalleled support in receiving and expertly using our materials in their own experiments. Life at Addgene: Addgene is a truly special place to work. We are an inclusive and welcoming group of people from many backgrounds and perspectives. We believe in flexibility, actively supporting professional development, and a strong work/life balance. We value sharing ideas and feedback with each other and the company. We also believe it's important to make time for fun, whether it's eating popcorn at our outdoor movie night, sharing cute photos in the #pets slack channel, or sampling whiskeys at our end-of-year social hour. Bookworms, athletes, gamers, parents, foodies, and more will find community in Addgene's events and Slack channels. Diversity, Equity, Inclusion & Belonging at Addgene Addgene is committed to creating and fostering a diverse, supportive, and inclusive working environment. We work with a diverse and open global scientific community, and we know that the best innovations and discoveries come from diverse teams. Addgene strives for diversity, equity, and inclusion in all aspects of our work. We continuously learn from and celebrate a variety of perspectives and backgrounds as we grow, while working as a community to identify and unlearn all forms of bias. We seek to create an environment where all people can feel a sense of belonging. Addgene is an Equal Opportunity Employer and considers all applicants without regard to race, color, religion, national origin, sex, ancestry, sexual orientation, genetic information, gender identity, active military or veteran status, age, handicap, or any other characteristic protected by Federal, State or Local law.

Job Description We connect our employees with some of the best opportunities around. Time and again, our employees tell us that the most important thing we offer is respect. Federal Staffing Solutions puts people to work in all types of jobs. When you work with us, you build a relationship with a team of employment professionals in your community who have, in turn, built professional relationships with the businesses that are hiring. We are looking for a Elasticsearch Data Engineer to work in Fort Meade, MD supporting our client. Clearance: Secret Salary: $121,000 Qualifications: <ul><li>Education/Experience: 8+ years of experience and a B.S. in Engineering, Computer Science, Mathematics, Statistics, Physics, Electrical Engineering, Computer Engineering, Data Science, or Data Analytics. Additional experience may be accepted in lieu of degree.</li><li>Data Management & Collaboration: Proficiency with Data Management platforms and strong communication skills for effective collaboration with virtual teams of data engineers and DevOps engineers.</li><li>Software Development Lifecycle: Experience following a software development lifecycle, with the ability to develop and maintain production-quality code.</li><li>Security Clearance: Ability to obtain interim Secret DoD Security clearance before the start date.</li></ul> Preferred Qualifications: <ul><li>Data Automation: Experience automating data cleansing, formatting, staging, and transformation processes.</li><li>Text Mining & ELK Stack: Proficiency with text mining tools, summarization, search (ELK Stack), entity extraction, training set generation, and anomaly detection.</li><li>CI/CD & Containerization: Familiarity with CI/CD techniques for developing and releasing software through containerized pipelines.</li><li>BI Tools & Search Analytics: Knowledge of BI tools (e.g., Kibana, Splunk) and experience with developing search and analytics applications.</li><li>Big Data Technologies: Experience with Elasticsearch, Logstash, Kibana, Kafka, ksql, NiFi, Apache Spark, ServiceNow.</li><li>Elastic Engineer Certification: Certified Elastic Engineer with experience developing logstash and ingest pipelines.</li><li>Experience developing in Confluent ksql and kstreams for data ETL purposes.</li><li>Kubernetes Expertise: Familiarity with Kubernetes and deployment of containers.</li><li>Agile Processes: Experience with Agile methodologies and related tools.</li></ul> Essential Requirements: US Citizenship is required. Active Secret Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job with or without reasonable accommodation. While performing the duties of this job, the employee will regularly sit, walk, stand and climb stairs and steps. May require walking long distance from parking to work station. Occasionally, movement that requires twisting at the neck and/or trunk more than the average person, squatting/ stooping/kneeling, reaching above the head, and forward motion will be required. The employee will continuously be required to repeat the same hand, arm, or finger motion many times. Manual and finger dexterity are essential to this position. Specific vision abilities required by this job include close, distance, depth perception and telling differences among colors. The employee must be able to communicate through speech with clients and public. Hearing requirements include conversation in both quiet and noisy environments. Lifting may require floor to waist, waist to shoulder, or shoulder to overhead movement of up to 20 pounds. This position demands tolerance for various levels of mental stress. Job Duties: <ul><li>Data Analysis & Problem Solving: Analyze quantitative and qualitative data to solve stakeholder problems and improve business efficiency.</li><li>o Design, implement, and document solutions as repeatable processes. -</li><li>ETL Pipeline Development: Perform extraction, transformation, and load (ETL) tasks. Develop and integrate data sets from diverse environments to support use cases involving network, performance, application, and configuration data. -</li><li>Data Modeling & Management: Develop, test, and maintain both physical and logical data models. Ensure consistency, quality, accuracy, and security of data by managing relevant metadata in support of the project.</li><li>o Identify and resolve Elasticsearch issues, including slow queries and indexing problems. -</li><li>Adherence to Governance & SecDevOps: Follow GMS Data Governance and SecDevOps policies to develop, test, deploy, and maintain data engineering pipelines. -</li><li>Cross-Team Collaboration: Work within a matrixed organization to collaborate with primary project leadership while maintaining standard practices with GMS core teams.</li><li>o Combine software and data engineering practices to strengthen enterprise data governance. -</li><li>System Architecture & Data Transformation: Apply knowledge of system architecture, network, and Centralized Logging (ELK) to support data transformation efforts.</li><li>Data Analytics & Visualization: Secure, maintain, optimize, and document analytics and visualization solutions, including some design and build responsibilities.</li><li>Agile Practices: Follow Agile scrum practices in daily operations.</li><li>Elastic Cluster Management: Deploy and manage Elastic clusters on Kubernetes in both on-premise and cloud environments.</li><li>Platform Expansion: Expand data platforms and analytics solutions using Elastic and Confluent platforms, focusing on SATCOM metadata for dashboard and reporting visualizations.</li><li>Customer Visualization Support: Support customer-driven visualization requirements and collaborate on data integration and Kibana dashboard development.</li></ul> Equal Opportunity Employer

Westat Data Engineer Interview Guide

Overview

Westat Data Engineer Salary

Westat Data Engineer Interview Process

Westat Data Engineer Interview Questions

Westat Data Engineer Jobs