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

Baird Data Engineer Interview Guide

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


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

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

Overview

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

Baird 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

Baird Data Engineer Interview Questions

As we continue to grow and add top talent to the Baird family of technical associates, we are currently seeking an IT Portfolio Business Analyst for our Milwaukee Office. The IT Portfolio Business Analyst is responsible for supporting the IT PWM (Private Wealth Management) Leadership Team and working closely with the Lead Portfolio Business Analysts to support the business and IT needs within the PWM IT portfolio to ensure critical business outcomes.The IT Portfolio Business Analyst will use relationship building and influence to work with key business leaders, stakeholders, and team members to help identify business objectives and deliver technical solutions for Baird. In doing so, our Portfolio Business Analysts leverage diverse project methodologies (lean, agile, waterfall, iterative) and embody a strong culture of continuous improvement and learning. Portfolio Business Analysts support the Portfolio IT Leadership Team and are relied upon to build trusting, strategic partnerships with key stakeholders as well as effectively navigate organizational complexity to deliver results. As an IT Portfolio Business Analyst, you will:Portfolio DeliveryAs a member of the portfolio IT team,Support the ideation and definition of new project initiatives including problem statements, benefits, success criteria, business case, and solution optionsHelp ensure appropriate level of consistency of approach across teamsProvide transparency in order to manage team members expectationsContribute to a positive culture where our team members are engaged and motivatedSupport cross team / portfolio project planning activities (Increment Planning; Dependency Tracking, etc.)Capture portfolio level metrics for Portfolio Project Communications to business leadersIdentify gaps and opportunities for improvement within Portfolio Delivery approaches and processesWith support from the Lead Portfolio Business Analyst, manage stakeholder expectations regardless of initiative complexity or sizeWith support from the Lead Portfolio Business Analyst, identify and manages project risks, issues, dependencies, and milestones in accordance with project needUnderstands the strategic business needs and works with the team, IT- and business- leadership to deliver business-impactful resultsProvide business / field / client perspective in technical discussionsDocument / illustrate / Diagram complex technical ideas for consumption by non-technical team membersMerger & AcquisitionsDuring Firm-wide Merger and Acquisition endeavorsSupport the Lead Portfolio Business Analyst and IT Leadership Team on all Merger & Acquisition projectsCreate and maintain necessary communication materials (status reports; execution playbooks; etc.)Work with IT Ops & Client Services Teams to manage scope of work & timing of activitiesWork with IT Delivery Teams to manage scope of work and timing of activitiesSupport the creation of materials necessary for Exec / SCO level meetings / report outsSupport the Operational Data Conversion needs and & help execute solution plansRelationship ManagementCan build and maintain strong relationships across Baird with Senior Business and IT leadersWith support from the Lead Portfolio Business Analyst, evaluates the situation to effectively communicate to the right audience and at the right timeTailors message and communication style and can pivot as needed.Confidently participates in interactions with associates at all levels of the organization, including COOs and senior business leadersSupports the efforts around team and portfolio strategyHas highly advanced awareness of organizational dynamics and independently navigates to drive decisions and achieve outcomesCan utilize an established network throughout IT and leverage it to navigate complexityAnalysis and Solution DevelopmentElicits functional & nonfunctional requirements through the use of interviews, workflow analysis, requirements workshops, and surveys to provide business process descriptions, business requirements, use cases, and user stories, with minimal supportApplies a number of BA approaches and techniques with limited guidance from othersDevelops analysis approach for medium and/or moderately complex efforts while keeping senior leaders informedTakes a systems thinking approach to quickly develop an understanding of value streams and end-to-end processes, while looking for opportunities for improvementAble to work in ambiguous situations and derive actionable outcomes with support and guidanceCollaborates with delivery teams (business analysts, developers, architects, product owners) to establish the technical vision and analyze tradeoffs for complex / cross team initiativesContributes and supports the execution of Portfolio Level initiativesDevelops an end-to-end knowledge of technology ecosystem and its impacts on the businessWhat makes this opportunity great:Information technology is a core part of Baird's business strategy and plays a critical role in the growth and transformation of the firmAbility to work with a variety of teams and leaders, proving your ability to be flexible and high adaptableFast paced environment that will enable you to grow as a professional Team of associates passionate about achieving great results for clients and give back to the communities where we live and workWhat we look for:At least 5 years IT related experience including a minimum of 2 years Business Analysis experience is preferredB.S. in Computer Science, MIS, Business Administration, or Finance is preferred and we will consider combination of education and experience.Two years serving as a Business Analyst in the financial industry is preferredExperience in an agile/lean delivery environment is preferredExperience with a variety of tools for prototyping, modeling, data analysis, reporting, backlog and value stream management is preferred (Visio, Miro, PowerBI, Balsamiq, and Azure DevOps).Exposure to data visualization techniques (SQL, Power BI) is strongly preferredGood communication and collaboration skills, ability to influence without authority including with senior business leadersDetail-oriented and possesses exceptional organizational, critical thinking, and problem-solving skills#DI#LI-SB1#LI-HybridBaird is committed to diversity and provides employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, pregnancy, citizenship, national origin, age, disability, military service, veteran status, sexual orientation, gender identity or expression, genetic information, or any other status protected by law.

As we continue to grow and add top talent to the Baird family of technical associates, we are currently seeking an IT Portfolio Business Analyst for our Milwaukee Office. The IT Portfolio Business Analyst is responsible for supporting the IT PWM (Private Wealth Management) Leadership Team and working closely with the Lead Portfolio Business Analysts to support the business and IT needs within the PWM IT portfolio to ensure critical business outcomes.The IT Portfolio Business Analyst will use relationship building and influence to work with key business leaders, stakeholders, and team members to help identify business objectives and deliver technical solutions for Baird. In doing so, our Portfolio Business Analysts leverage diverse project methodologies (lean, agile, waterfall, iterative) and embody a strong culture of continuous improvement and learning. Portfolio Business Analysts support the Portfolio IT Leadership Team and are relied upon to build trusting, strategic partnerships with key stakeholders as well as effectively navigate organizational complexity to deliver results. As an IT Portfolio Business Analyst, you will: Portfolio Delivery As a member of the portfolio IT team,Support the ideation and definition of new project initiatives including problem statements, benefits, success criteria, business case, and solution optionsHelp ensure appropriate level of consistency of approach across teamsProvide transparency in order to manage team members expectationsContribute to a positive culture where our team members are engaged and motivatedSupport cross team / portfolio project planning activities (Increment Planning; Dependency Tracking, etc.)Capture portfolio level metrics for Portfolio Project Communications to business leadersIdentify gaps and opportunities for improvement within Portfolio Delivery approaches and processesWith support from the Lead Portfolio Business Analyst, manage stakeholder expectations regardless of initiative complexity or sizeWith support from the Lead Portfolio Business Analyst, identify and manages project risks, issues, dependencies, and milestones in accordance with project needUnderstands the strategic business needs and works with the team, IT- and business- leadership to deliver business-impactful resultsProvide business / field / client perspective in technical discussionsDocument / illustrate / Diagram complex technical ideas for consumption by non-technical team membersMerger & Acquisitions During Firm-wide Merger and Acquisition endeavorsSupport the Lead Portfolio Business Analyst and IT Leadership Team on all Merger & Acquisition projectsCreate and maintain necessary communication materials (status reports; execution playbooks; etc.)Work with IT Ops & Client Services Teams to manage scope of work & timing of activitiesWork with IT Delivery Teams to manage scope of work and timing of activitiesSupport the creation of materials necessary for Exec / SCO level meetings / report outsSupport the Operational Data Conversion needs and & help execute solution plansRelationship Management Can build and maintain strong relationships across Baird with Senior Business and IT leadersWith support from the Lead Portfolio Business Analyst, evaluates the situation to effectively communicate to the right audience and at the right timeTailors message and communication style and can pivot as needed.Confidently participates in interactions with associates at all levels of the organization, including COOs and senior business leadersSupports the efforts around team and portfolio strategyHas highly advanced awareness of organizational dynamics and independently navigates to drive decisions and achieve outcomesCan utilize an established network throughout IT and leverage it to navigate complexityAnalysis and Solution Development Elicits functional & nonfunctional requirements through the use of interviews, workflow analysis, requirements workshops, and surveys to provide business process descriptions, business requirements, use cases, and user stories, with minimal supportApplies a number of BA approaches and techniques with limited guidance from othersDevelops analysis approach for medium and/or moderately complex efforts while keeping senior leaders informedTakes a systems thinking approach to quickly develop an understanding of value streams and end-to-end processes, while looking for opportunities for improvementAble to work in ambiguous situations and derive actionable outcomes with support and guidanceCollaborates with delivery teams (business analysts, developers, architects, product owners) to establish the technical vision and analyze tradeoffs for complex / cross team initiativesContributes and supports the execution of Portfolio Level initiativesDevelops an end-to-end knowledge of technology ecosystem and its impacts on the businessWhat makes this opportunity great:Information technology is a core part of Baird's business strategy and plays a critical role in the growth and transformation of the firmAbility to work with a variety of teams and leaders, proving your ability to be flexible and high adaptableFast paced environment that will enable you to grow as a professionalTeam of associates passionate about achieving great results for clients and give back to the communities where we live and workWhat we look for:At least 5 years IT related experience including a minimum of 2 years Business Analysis experience is preferredB.S. in Computer Science, MIS, Business Administration, or Finance is preferred and we will consider combination of education and experience.Two years serving as a Business Analyst in the financial industry is preferredExperience in an agile/lean delivery environment is preferredExperience with a variety of tools for prototyping, modeling, data analysis, reporting, backlog and value stream management is preferred (Visio, Miro, PowerBI, Balsamiq, and Azure DevOps).Exposure to data visualization techniques (SQL, Power BI) is strongly preferredGood communication and collaboration skills, ability to influence without authority including with senior business leadersDetail-oriented and possesses exceptional organizational, critical thinking, and problem-solving skills#LI-SB1Commitment to Inclusion & Diversity Baird is committed to inclusion & diversity for our clients, our associates and the communities where we live and work. This commitment stems from our culture of integrity, genuine concern for others and respect for the individual. We view inclusion & diversity as an ongoing journey - one of shared responsibility, continuous improvement and a focus on progress. We invite you to join us as we work together to foster an environment where diversity unites rather than divides us.

As we continue to grow and add top talent to the Baird technology team, we are currently seeking a Business Analyst II. The Business Analyst is responsible for eliciting requirements to facilitate a shared understanding across the team and enabling delivery of high-quality solutions for our stakeholders. As a Business Analyst, you will: Analysis and Solution Development Business Process Analysis <ul> <li>Elicits functional & nonfunctional requirements using interviews, workflow analysis, requirements workshops, and surveys to provide business process descriptions, business requirements, use cases, and user stories, with minimal support </li><li>Applies BA approaches and techniques with limited guidance from others </li><li>Develops analysis approach for medium or moderately complex efforts with minimal support and guidance </li><li>Develops an understanding of value streams and end-to-end processes </li><li>Connects day-to-day work, for self and assists for team, to strategic outcomes and goals of the firm </li><li>Able to work in ambiguous situations with support and guidance </li></ul>Systems Analysis <ul> <li>Collaborates with project team members (developers, architects, product owners) to establish the technical vision and analyze tradeoffs </li><li>Leads execution - with guidance from others - of analysis approach, engaging and coordinating others to conduct analysis and develop solutions </li><li>Develops an end-to-end knowledge of technology environment and partners to understand business impacts </li><li>Supports team needs for data analysis approaches and best practices </li><li>Generates data visualizations and diagrams in support of analysis approach </li></ul>Relationship Management <ul><li>With guidance from mentors and leadership, a BA <ul><li>builds trusting relationships and may represent IT in strategic conversations between business partners and PWM leaders </li><li>resolves previously identified conflicting objectives/expectations </li><li>tailors message and communication style </li><li>be aware of and navigates organizational dynamics to assist in decision making and achieving outcomes </li></ul> </li><li>Has begun to independently diagnose when to communicate information </li><li>Frequently leads the definition of an individual team, while supporting the team's strategy </li><li>Establishing a network throughout Baird and, with guidance, occasionally leverages it to navigate complexity </li></ul>Business Analysis Practice Leadership <ul><li>Serves as a business analyst role model within their delivery team with strong understanding of the Baird business they are aligned with and how it serves our internal/external clients </li><li>Building mentoring skills with the assistance of a more experienced BA or manager </li><li>Is building subject matter expertise within the BA Community of Practice and knows when to seek advice and guidance from more experienced BAs and others </li></ul>Delivery Leadership <ul><li>Articulates thoughts and recommendations effectively </li><li>Understands the strategic business needs and works with the team, IT- and business- leadership to deliver business-impactful results </li><li>Leads medium or moderately complex initiatives and supports organizational changes </li><li>Challenges and drives continuous improvement on immediate team and, with guidance, across the portfolio </li><li>Building skill in identifying the appropriate project methodology and coaching the applicable delivery principles and best practices within teams </li></ul>Solution Delivery <ul><li>Provides team facilitation for aligned project team </li><li>Effectively manages stakeholder expectations with guidance </li><li>Executes work using a variety of approaches (lean, agile, waterfall, iterative) based on situation with guidance </li><li>With guidance, identifies and manages project risks, issues, dependencies, and milestones in accordance with project need </li></ul>Quality Assurance <ul><li>Begins to design and participates in the execution of a quality approach with guidance </li><li>Begins to facilitate requirements validation and User Acceptance Testing with the client, third-party vendors and other team members </li></ul> What we look for: <ul> <li>At least 5 years IT related experience including a minimum of 3 years Business Analysis experience </li><li>B.S. in Computer Science, MIS, Business Administration, or Finance is preferred, or equivalent education and experience. </li><li>Two years serving as a Business Analyst in the financial industry is preferred </li><li>Experience in an agile/lean delivery environment is preferred </li><li>Thorough working knowledge of Microsoft Office is required. In addition, experience with a variety of tools for prototyping, modeling, data analysis, reporting, backlog and value stream management is preferred (MS Visio, PowerBI, Balsamiq, and Rally). </li><li>Exposure to data visualization techniques and SQL is preferred </li><li>Strong communication and collaboration skills </li><li>Detail-oriented and possesses exceptional organizational, critical thinking, and problem-solving skills </li><li>Able to work and grow in a fast-paced, team-oriented environment </li></ul> #LI-SB1 Commitment to Inclusion & Diversity Baird is committed to inclusion & diversity for our clients, our associates and the communities where we live and work. This commitment stems from our culture of integrity, genuine concern for others and respect for the individual. We view inclusion & diversity as an ongoing journey - one of shared responsibility, continuous improvement and a focus on progress. We invite you to join us as we work together to foster an environment where diversity unites rather than divides us.

As we continue to grow and add top talent to the Baird technology team, we are currently seeking a Business Analyst II. The Business Analyst is responsible for eliciting requirements to facilitate a shared understanding across the team and enabling delivery of high-quality solutions for our stakeholders. As a Business Analyst, you will: Analysis and Solution Development Business Process Analysis <ul> <li>Elicits functional & nonfunctional requirements using interviews, workflow analysis, requirements workshops, and surveys to provide business process descriptions, business requirements, use cases, and user stories, with minimal support </li><li>Applies BA approaches and techniques with limited guidance from others </li><li>Develops analysis approach for medium or moderately complex efforts with minimal support and guidance </li><li>Develops an understanding of value streams and end-to-end processes </li><li>Connects day-to-day work, for self and assists for team, to strategic outcomes and goals of the firm </li><li>Able to work in ambiguous situations with support and guidance </li></ul>Systems Analysis <ul> <li>Collaborates with project team members (developers, architects, product owners) to establish the technical vision and analyze tradeoffs </li><li>Leads execution - with guidance from others - of analysis approach, engaging and coordinating others to conduct analysis and develop solutions </li><li>Develops an end-to-end knowledge of technology environment and partners to understand business impacts </li><li>Supports team needs for data analysis approaches and best practices </li><li>Generates data visualizations and diagrams in support of analysis approach </li></ul>Relationship Management <ul> <li>With guidance from mentors and leadership, a BA II <ul><li>builds trusting relationships and may represent IT in strategic conversations between business partners and PWM leaders </li><li>resolves previously identified conflicting objectives/expectations </li><li>tailors message and communication style </li><li>be aware of and navigates organizational dynamics to assist in decision making and achieving outcomes </li></ul> </li><li>Has begun to independently diagnose when to communicate information </li><li>Frequently leads the definition of an individual team, while supporting the team's strategy </li><li>Establishing a network throughout Baird and, with guidance, occasionally leverages it to navigate complexity </li></ul>Business Analysis Practice Leadership <ul><li>Serves as a business analyst role model within their delivery team with strong understanding of the Baird business they are aligned with and how it serves our internal/external clients </li><li>Building mentoring skills with the assistance of a more experienced BA or manager </li><li>Is building subject matter expertise within the BA Community of Practice and knows when to seek advice and guidance from more experienced BAs and others </li></ul>Delivery Leadership <ul> <li>Articulates thoughts and recommendations effectively </li><li>Understands the strategic business needs and works with the team, IT- and business- leadership to deliver business-impactful results </li><li>Leads medium or moderately complex initiatives and supports organizational changes </li><li>Challenges and drives continuous improvement on immediate team and, with guidance, across the portfolio </li><li>Building skill in identifying the appropriate project methodology and coaching the applicable delivery principles and best practices within teams </li></ul>Solution Delivery <ul> <li>Provides team facilitation for aligned project team </li><li>Effectively manages stakeholder expectations with guidance </li><li>Executes work using a variety of approaches (lean, agile, waterfall, iterative) based on situation with guidance </li><li>With guidance, identifies and manages project risks, issues, dependencies, and milestones in accordance with project need </li></ul>Quality Assurance <ul> <li>Begins to design and participates in the execution of a quality approach with guidance </li><li>Begins to facilitate requirements validation and User Acceptance Testing with the client, third-party vendors and other team members </li></ul>What we look for: <ul> <li>At least 5 years IT related experience including a minimum of 3 years Business Analysis experience </li><li>B.S. in Computer Science, MIS, Business Administration, or Finance is preferred, or equivalent education and experience. </li><li>Two years serving as a Business Analyst in the financial industry is preferred </li><li>Experience in an agile/lean delivery environment is preferred </li><li>Thorough working knowledge of Microsoft Office is required. In addition, experience with a variety of tools for prototyping, modeling, data analysis, reporting, backlog and value stream management is preferred (MS Visio, PowerBI, Balsamiq, and Rally). </li><li>Exposure to data visualization techniques and SQL is preferred </li><li>Strong communication and collaboration skills </li><li>Detail-oriented and possesses exceptional organizational, critical thinking, and problem-solving skills </li><li>Able to work and grow in a fast-paced, team-oriented environment </li></ul> #DI #LI-SB1 #LI-Hybrid Baird is committed to diversity and provides employment opportunities to all employees and applicants for employment without regard to race, color, religion, sex, pregnancy, citizenship, national origin, age, disability, military service, veteran status, sexual orientation, gender identity or expression, genetic information, or any other status protected by law.

In this role, you will maintain our data warehouse, develop ETL processes, create production-ready software from prototypes, and other technical tasks. This is an opportunity to use a variety of technical skills and create new infrastructure, systems and software. From day one, you will be working with 10s of millions of rows of data which we expect to grow very quickly. You will report to the Director of RV Pricing Strategy as part of a team of analysts and data scientists. **Responsibilities:** + Processing data from outside our organization and from third party data providers, making it readily accessible to the team. + Creating data warehouse infrastructure and implementing ETL processes to gather data from other enterprise systems and external sources. + Evaluating technical needs of the pricing team and designing and implementing infrastructure and technology to support their work. + Identifying, designing and implementing internal process improvements including redesigning infrastructure for greater scalability, optimizing data delivery, and automating manual processes. + Implementing best practice data management, version control and other best practices within the team. + Working closely with the pricing team to support their current technical needs and identify new technologies which will be valuable for the team and its mission. + Perform daily tasks to monitor technical infrastructure and processes and take corrective action as necessary. + Take on special projects as needed including data science tasks such as creating analytics and even machine learning projects. **Technologies We Currently Use:** + Python and related software such as Jupyter, Anaconda, and VS Code + Docker + Kubernetes + Microsoft SQL Server + Snowflake + Microsoft Power BI + Microsoft Excel including Power Query and VBA **Must Have Qualifications:** + Bachelor's degree in computer science, software development, data engineering, or closely related field. + 1 3 years experience including + Implementing data solutions including designing new databases and implementing data pipelines. + Database technology experience including writing SQL queries and CRUD routines. + Software development experience including creating software for non-technical end-users. + Proficiency with Microsoft Office tools (Word, Excel, PowerPoint, Outlook). + Ability to maintain professional demeanor and strict confidentiality. + Ability to work independently to complete assigned tasks. + Must be diligent, organized, and extremely detail-oriented + Strong analytical and problem-solving skills **Preferred Qualifications:** + Experience developing ETL pipelines and machine learning pipelines using Python. + Experience creating front-ends for SQL Server and Snowflake based data. + Experience with Microsoft analytical tools, including Power BI, Excel, VBA, and Power Query. **This position is hybrid out of our Lincolnshire, IL offices.** **Pay Range:** $89,565.00-$134,295.00 Annual In addition to competitive pay, we offer Paid Time Off, 401(k), an Employee Assistance Program, Good Sam Roadside Assistance, discounts, paid parental leave (if eligibility is met), Tuition Reimbursement (if eligibility is met), and on the job training opportunities. Full-time associates are offered a comprehensive benefit package including medical, dental, vision and more! Part-time associates are offered access to dental & vision coverage! For more information please visit: www.mycampingworldbenefits.com We are an equal employment opportunity employer. The Company's policy is not to discriminate against any applicant or employee based on race, color, sex, sexual orientation, gender identity, religion, national origin, age (40 and over), disability, veteran or uniformed service-member status, genetic information, or any other basis protected by applicable federal, state, or local laws.

Responsibilities: Peraton is seeking an experienced Principal Cyber Data Engineer with Splunk, UNIX, Network experience to become part of Peratons Department of State (DoS) Diplomatic Security Cyber Mission (DSCM) program providing leading cyber and technology security experience to enable innovative, effective and secure business processes. Location: Beltsville, MD. First 90-days, on-site; Hybrid upon approval by the customer & the program. <ul><li>Work hours - work needs to be performed between 7:00 AM and 5:00 PM, EST; when on-site, requirement to be on-site by 9:00 AM, EST. </li></ul> In this role, you will:<ul><li>Support the Cyber Analytics team by being a SME on Splunk's Enterprise Security.</li><li>Provide SME input for future-state solutions pertaining to cyber analytics, XDR, and cloud data management.</li><li>Manage the administration of a growing 15 TB/day on-premises Splunk deployment, including both operating system and application aspects.</li><li>Integrate new data sources and technologies into Splunk Enterprise using the Common Information Model (CIM).</li><li>Onboard data by directly editing Splunk configuration files, utilizing RegEx skills as needed.</li><li>Troubleshoot log feeds by effectively communicating with external departments in an enterprise environment.</li><li>Apply upgrades and patches as necessary to maintain system security and compliance.</li><li>Assist cyber analysts in solving complex big data search processing challenges using expert SPL knowledge.</li><li>Support Splunk Enterprise Security and Ansible.</li></ul> Qualifications: Required: <ul><li>Bachelors degree and a minimum of 5 years of relevant experience in IT. An additional 4 years of experience will be considered in lieu of degree/education.</li><li>Must have ONE of the following certifications or be able to obtain before start date: <ul><li>CAP; CASP+ CE; CCISO; CCNA-Security; CISM; CISSP (or Associate); CISSP (or Associate); CND CSSLP; CySA+; GICSP; GSEC; GSLC; Security+ CE; SSCP</li></ul></li><li>Must have at a minimum, 1-2 years experience in / with Splunk Administration, UNIX, and Network experience: <ul><li>Hands-on experience with Unix in a STIG environment; at least 1-2 years.</li><li>Proficiency in working with bash prompts, including editing configuration files and performing troubleshooting analysis with TCPDump.</li><li>Prior Tier-1 Administrator experience, including familiarity with network protocols such as DNS, DHCP, LDAP, SSH, SMTP, etc.</li><li>At least 3 years of hands-on Splunk Administration experience in a multi-indexer search head cluster environment.</li><li>Understanding of security-centric data sets.</li><li>Familiarity with cloud computing and experience working in a cloud environment.</li><li>Proficiency in Python, SQL, Bash, and PowerShell.</li></ul></li><li>U.S. citizenship an an active Secret security clearance. <ul><li>The ability to obtain a final Top Secret security clearance.</li></ul></li></ul>Preferred:<ul><li>Masters in Data Analytics preferred</li><li>CRIBL experience.</li><li>Splunk Enterprise Certified Admin, Splunk Enterprise Certified Architect, or Splunk Enterprise Security Certified Admin certifications.</li></ul> Peraton Overview: Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the worlds leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the cant be done by solving the most daunting challenges facing our customers. Visit <a href="http://peraton.com/" target="_blank" rel="noopener">peraton.com</a> to learn how were keeping people around the world safe and secure. Target Salary Range: $86,000 - $138,000. This represents the typical salary range for this position based on experience and other factors.

Baird Data Engineer Interview Guide

Overview

Baird Data Engineer Salary

Baird Data Engineer Interview Process

Baird Data Engineer Interview Questions

Baird Data Engineer Jobs