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

Orzota Data Engineer Interview Guide

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


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

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

Overview

Orzota Data Engineer Salary

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

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

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Orzota 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

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

Orzota Data Engineer Interview Questions

Description

The Enterprise Data Platforms, Risk and Finance Technology team is looking for a Senior Data Engineer with a winning track record in building high performing data and analytical solutions that transform, integrate, and make data available for business.

As a Senior Data Engineer, you will be responsible for the management of existing Data Frameworks and development of new frameworks that solve data problems across the enterprise. Along with delivering these enterprise capabilities, you will lead a team of engineers and get an opportunity to mentor them. You will also be responsible for building and deploying data products including driving architecture, design, build, test, and support applications in production.

Primary responsibilities include:

Drive technical requirements of Data Frameworks and build solutions to meet them.

Identify opportunities to expand the frameworks as well as create new frameworks that can be built once and re-used across multiple use cases.

Building robust data pipelines to collect process and compute different metrics from various financial sources, adhering to quality and development standards.

Designing application architecture / technical design and articulating the data frameworks to team members and data engineers.

Collaborating with cross functional team members as necessary and coming up with optimal solutions that meet data demands.

Deploy high performing, quality/bug-free code in production.

Executing unit test of data populated in target data container, validating expected result and ensuring quality and accuracy. Coordinating with business users for User Acceptance Testing and with Operations team for code deployment to upper environments.

Following change management team stipulations on path to production requirements and strictly adhering to the compliance and regulatory needs.

Required Skills/Experience:

At-least of 5 years of experience in the technologies listed below.

Working experience with streaming capabilities such as Apache Spark, Beam, Flink

Working experience with message brokers/messaging platforms such as Apache Kafka

Proven track record of working with microservices and batch sources

Hands-on in a programming language such as Java, Scala

Excellent skills in SQL Development

Working experience with ETL Development tools like Talend, Data Stage would be a plus

Working experience with Java Spring boot, React, Typescript, Angular for UI would be a plus

Deep understanding of Cloud offerings for Data processing (AWS would be a plus)

Ability to work on AWS S3, Redshift and other databases such as Postgres, Oracle, MongoDB.

Education, Certifications, and/or Other Professional Credentials:

BS/Engineering in Computer Science or any technology related degree

Hours and Work Schedule

Hours per Week: 40

Work Schedule: Monday through Friday

Some job boards have started using jobseeker-reported data to estimate salary ranges for roles. If you apply and qualify for this role, a recruiter will discuss accurate pay guidance.

Equal Employment Opportunity

At Citizens, we are committed to fostering an inclusive culture that enables colleagues to bring their best selves to work every day. Employment decisions are based solely on experience, performance, and ability. Citizens, its parent, subsidiaries, and related companies (Citizens) provide equal employment and advancement opportunities to all colleagues and applicants for employment without regard to age, ancestry, color, citizenship, physical or mental disability, perceived disability or history or record of a disability, ethnicity, gender, gender identity or expression (including transgender individuals who are transitioning, have transitioned, or are perceived to be transitioning to the gender with which they identify), genetic information, genetic characteristic, marital or domestic partner status, victim of domestic violence, family status/parenthood, medical condition, military or veteran status, national origin, pregnancy/childbirth/lactation, colleague’s or a dependent’s reproductive health decision making, race, religion, sex, sexual orientation, or any other category protected by federal, state and/or local laws.

Equal Employment and Opportunity Employer

Citizens is a brand name of Citizens Bank, N.A. and each of its respective affiliates.

Why Work for Us

At Citizens, you'll find a customer-centric culture built around helping our customers and giving back to our local communities. When you join our team, you are part of a supportive and collaborative workforce, with access to training and tools to accelerate your potential and maximize your career growth

Background Check

Any offer of employment is conditioned upon the candidate successfully passing a background check, which may include initial credit, motor vehicle record, public record, prior employment verification, and criminal background checks. Results of the background check are individually reviewed based upon legal requirements imposed by our regulators and with consideration of the nature and gravity of the background history and the job offered. Any offer of employment will include further information.

12/27/2024

Our client, the commercial real estate industry, is seeking a data engineer to join their team. Ideal candidates should have strong technical skills in SnapLogic, snowflake, MuleSoft, and Azure Share resume gayatri.samantaraexperis.com / 4147862324 Job Title: Data engineer Location: Local to Richardson, but possible to be local to Houston (Hybrid) Pay Range: $60/hr on w2 Hours: Monday-Friday, 8:00 am-5:00 pm Assignment Duration: hybrid: 3 days in office minimum with potential change to full time in office This role is for a data engineer with a hybrid work model requiring 3 days in-office in Richardson, TX, with potential for a shift to full-time in-office or local placement in Houston. The assignment duration is 1 year, with the possibility of converting to a full-time position. The candidate will be responsible for creating pipelines, aggregating data, resolving data issues, attending team meetings, quantifying tasks, and validating data. Key Requirements: Experience: 5-10 years in data engineering Education: Bachelor's Degree in Computer Science or related field preferred Technical Skills: Proficiency in SnapLogic, Snowflake, MuleSoft, and Azure Essential Traits: Exceptional attention to detail ("eagle eye"), proactive mindset, and clear communication skills Additional Skills: Strong interpersonal abilities, open communication, and a "go-getter" attitude Interview Process: Four rounds (1 team interview, 2 technical interviews, and a final interview), all conducted virtually. Candidates must have top-tier communication skills, availability, and clarity about their data engineering expertise. If this is a role that interests you and you’d like to learn more, click apply now and a recruiter will be in touch with you to discuss this great opportunity. We look forward to speaking with you About ManpowerGroup, Parent Company of: Manpower, Experis, Talent Solutions, and Jefferson Wells ManpowerGroup® (NYSE: MAN), the leading global workforce solutions company, helps organizations transform in a fast-changing world of work by sourcing, assessing, developing, and managing the talent that enables them to win. We develop innovative solutions for hundreds of thousands of organizations every year, providing them with skilled talent while finding meaningful, sustainable employment for millions of people across a wide range of industries and skills. Our expert family of brands – Manpower, Experis, Talent Solutions, and Jefferson Wells – creates substantial value for candidates and clients across more than 75 countries and territories and has done so for over 70 years. We are recognized consistently for our diversity - as a best place to work for Women, Inclusion, Equality and Disability and in 2022 ManpowerGroup was named one of the World's Most Ethical Companies for the 13th year - all confirming our position as the brand of choice for in-demand talent. ManpowerGroup is committed to providing equal employment opportunities in a professional, high quality work environment. It is the policy of ManpowerGroup and all of its subsidiaries to recruit, train, promote, transfer, pay and take all employment actions without regard to an employee's race, color, national origin, ancestry, sex, sexual orientation, gender identity, genetic information, religion, age, disability, protected veteran status, or any other basis protected by applicable law.

Sr. Data Engineer Remote - Onsite 3 days per month in Greater Chicago Position Summary: This role is responsible for providing technical expertise and leadership to design and deliver end-to-end data engineering solutions to support advanced analytics capabilities and drive innovation and decision-making across our enterprise. Responsibilities: Build and maintain real-time and batch data pipelines across the advanced analytics platform. Design, develop and orchestrate highly robust and scalable ETL pipelines. Design and implement Dimensional and NoSQL data modeling as per the business requirements. Develop highly optimal codebase and perform Spark optimizations for Big Data use cases. Design, develop and deploy optimal monitoring and testing strategy for the data products. Collaborate with stakeholders and advanced analytics business partners to understand business needs and translate requirements into scalable data engineering solutions. Collaborate with data scientists to prepare data for model development and production. Collaborate with data visualization and reporting application developers to ensure the sustainability of production applications and reports. Collaborate with data architects on the enhancement of our enterprise data architecture and platforms. Provide leadership to third-party contractors. Comply with health and safety guidelines and rules. Maintain professional and technical knowledge by attending educational workshops, professional publications, establishing personal networks, and participating in professional societies. Requirements: 4 years of experience in Data Engineering 2 years of experience with Advanced Analytics or Data Science Proficient in Spark Experience with Azure Nice to have: Experience with IoT Data Architecture. Machine Learning Operationalization (MLOps) proficiency. Proficiency with streaming design patterns

Description

JOB SUMMARY:

The Healthcare Data Engineer is responsible for collecting, processing, and performing statistical analyses on large datasets to help the organization make data-driven decisions. Their work is essential for identifying trends, solving problems, and improving efficiency. The HealthCare Data Engineer plays a vital role in turning raw data into actionable insights that help the organization make informed decisions, optimize operations, and uncover new opportunities. They will also collaborate with the Director of Information Technology and with the Director of Epic Systems to develop a data warehouse for current and future uses.

ESSENTIAL FUNCTIONS:
Data Collection and Extraction : Gathers data from various sources, such as databases, spreadsheets, APIs, or external data sets, and ensures the data is clean, accurate, and relevant;
Data Cleaning and Preparation : Identifies and corrects errors or inconsistencies in data, such as missing values or outliers, to ensure the data is ready for analysis;
Data Analysis and Interpretation : Uses statistical methods and data analysis techniques (e.g., regression analysis, clustering, trend analysis) to identify patterns, trends, and insights within the data;
Data Visualization : Creates charts, graphs, dashboards, and other visual representations of data using tools like Excel, Tableau, Power BI, or Python to help stakeholders understand key findings;
Reporting and Presentation : Compiles reports and presentations that summarize the results of the analysis, translating complex data insights into clear, actionable recommendations for decision-makers;
Database Management : Manages and maintains databases to ensure the organization has access to up-to-date, accurate information. This can include setting up a database warehouse, database queries, updating records, and managing data pipelines;
Collaboration with Stakeholders : Works with department heads, managers, or other stakeholders to understand their data needs, define key metrics (KPIs), and tailor analyses to address specific business questions;
Identifying Trends and Anomalies : Monitors data to identify significant trends, anomalies, or potential issues. Alerts the relevant teams when patterns indicate an opportunity or risk;
Data Model Development : Develops predictive or descriptive data models that can be used to forecast trends, assess risks, or improve operations. This can include building algorithms or machine learning models;
Tool and Software Usage : Uses data analysis tools such as Tableau, SQL, R, Python, Excel, or specialized software like SAS to analyze large datasets and automate routine tasks;
Performance Monitoring : Tracks the performance of specific projects, campaigns, or strategies by analyzing data and providing insights into success metrics;
Problem Solving : Use data to address specific business problems, such as optimizing marketing efforts, improving operational efficiency, or identifying customer preferences and behaviors.
Data Governance and Compliance : Ensure that data is handled in compliance with data privacy regulations (e.g., GDPR, HIPAA) and that appropriate data security protocols are followed.
Automation of Reporting : Design automated reporting systems to ensure that key metrics are available in real-time for stakeholders, reducing manual data processing tasks.
Continuous Improvement : Continuously improve data collection processes, analysis techniques, and reporting methodologies to enhance the accuracy and impact of data-driven insights.
Other Duties as Assigned.
ORGANIZATIONAL RESPONSIBILITIES:     Performs work in alignment with BestCare's mission, vision, values;
Supports the organization's commitment to equity, diversity, and inclusion by fostering a culture of open-mindedness, cultural awareness, compassion, and respect for all individuals;
Strives to meet annual Program/Department goals and supports the organization's strategic goals;
Adheres to the organization's Code of Conduct, Business Ethics, Employee Handbook, and all other policies, procedures, and relevant compliance standards;
Understands and maintains professionalism and confidentiality per HIPAA, 42 CFR, and Oregon Statutes;
Attends required program/staff meetings and completes assigned training timely and satisfactorily;
Ensures that any required certifications and/or licenses are kept current and renewed timely;
Works independently as well as participates as a positive, collaborative team member;
Performs other organizational duties as needed.

QUALIFICATIONS:

EDUCATION AND/OR EXPERIENCE:
Bachelor's degree in Computer Science, Information Systems, Information Science, Health Information Management, or Actuary required
4-7 years' experience with using data analysis tools such as SAS, SQL, Tableau, Crystal Reports (or other similar applications), and with building and coding data infrastructure required
3 years' minimum experience with healthcare data using electronic health system data and data development required
Demonstrated success with using data to influence organization strategy, workflows, or results
LICENSES AND CERTIFICATIONS:     Must maintain a valid Oregon Driver License or ability to obtain one upon hire, and be insurable under the organization's auto liability coverage policy (minimum 21 years of age and with no Type A violations in the past 3 years, or three (3) or more Type B violations)
PREFERRED:     Epic electronic health record system and data experience and proficiency preferred
Bilingual in English/Spanish a plus
REQUIRED COMPETENCIES:  Must have demonstrated competency or ability to attain competency for each of the following within a reasonable period:    Demonstrated ability to use data analysis tools and software effectively;
Demonstrated ability to use data to influence organization strategy, workflows, or results;
Proficiency with electronic health record system and data development;
Strong analytical and problem-solving skills;
Strong verbal, written and interpersonal communication skills
High proficiency in MS Office 365, databases, virtual meeting platforms, internet, and ability to learn new or updated software;
Strong interpersonal and customer service skills;
Strong organizational skills and attention to detail, accuracy, and follow-through;
Excellent time management skills with a proven ability to meet deadlines;
Critical thinking skills
Ability to maintain strict confidence as required by HIPAA, 42 CFR, and Oregon Statutes;
Ability to build and maintain positive relationships;
Ability to function well and use good judgment in a high-paced and at times stressful environment;
Ability to manage conflict resolution and anger/fear/hostility/violence of others appropriately and effectively;
Ability to work effectively and respectfully in a diverse, multi-cultural environment;
Ability to work independently as well as participate as a positive, collaborative team member.
TOOLS AND EQUIPMENT USED:  Computer/laptop, copy/fax/scanning machines, printer, telephone, or multi-line phone.

WORK ENVIRONMENT/PHYSICAL DEMANDS:  This position is eligible for a hybrid work schedule. The work environment is respectful, multi-cultural and inclusive, and the characteristics described above are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. The position requires the employee to dress in a manner that meets the standards for professional attire at Best Care or per department-or job-specific requirements (See Dress Code Policy in Employee Handbook). Other conditions/demands include:    Primarily indoors (95%)
Prolonged periods sitting at a desk and working on a computer/laptop, with occasional standing and walking
Exerts force or lifts/carries up to 10-20 pounds at times
Pushes/pulls 50-75 pounds occasionally
Continuous use of arms, wrists, hands to perform repetitive tasks/motions
Occasional grasping/squeezing and reaching above or below shoulder-level
Must be able to hear alarms/telephone/audio/normal speaking voice
Must have clarity of vision: Near ( 20" to   20')
Must be able to drive motor vehicle to perform job
May be exposed to communicable disease

At Allstate, great things happen when our people work together to protect families and their belongings from life's uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers' evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. Job Description Founded by The Allstate Corporation in 2016, Arity is a data and analytics company focused on improving transportation. We collect and analyze enormous amounts of data, using predictive analytics to build solutions with a single goal in mind: to make transportation smarter, safer, and more useful for everyone. At the heart of that mission are the people that work here-the dreamers, doers and difference-makers that call this place home. As part of that team, your work will showcase both your intelligence and your creativity as you tackle real-world problems and put your talents towards transforming transportation. That's because at Arity, we believe work and life shouldn't be at odds with one another. After all, we know that your unique qualities give you a unique perspective. We don't just want you to see yourself here. We want you to be yourself here. Arity is committed to supporting an inclusive and diverse environment where you can thrive and learn from others. Architect - Real-Time Traffic Engineering Team The Engineering Team Our Real-Time Traffic Engineering Team is at the forefront of innovation in high-throughput, low-latency computing on cloud platforms. Our engineers are passionate about building solutions that enable real-time decision-making at scale, creating state-of-the-art, highly available, and low-downtime systems. They tackle complex challenges across telematics, enterprise engineering, and high-scale platform development, pushing the boundaries of cloud-native architecture and distributed systems. Within an Agile, collaborative environment, our engineers own projects from conception through deployment, operating with a focus on trust, transparency, and reliability. If designing and architecting cutting-edge real-time traffic solutions excites you, we'd love to meet you. Job Profile Summary The Architect on our Real-Time Traffic Engineering Team is a technical leader responsible for designing and implementing scalable architecture solutions for real-time, high-performance systems. Working alongside a team of skilled architects, you'll address high-throughput, low-latency computing challenges, enabling resilient, high-performance systems. In this role, you'll collaborate with cross-functional teams, ensuring alignment with business objectives and delivering strategic improvements to support real-time scalability and uptime demands. The Role As a Technical Architect in our Real-Time Traffic Engineering Team, you thrive on transforming ideas into real, scalable solutions-be it through design, code, or architectural frameworks. You will work in close collaboration with other architects, bringing deep expertise in high-throughput computing and cloud-native systems, readily addressing the unique challenges of high-scale, low-latency infrastructure. Your ability to navigate tool selection, trade-offs, and implementation will be key to our success. Key Responsibilities <ul> <li>Collaborate on Complex Systems Architecture: Work with fellow architects to lead analysis, design, and development of high-throughput, low-latency solutions, crafting architectures across multiple logical and physical dimensions. Present comprehensive documentation and support team implementation efforts. </li> <li>Enhance Existing Architectures: Continuously identify and optimize architectural components, ensuring scalability, resilience, and performance within real-time computing systems. </li> <li>Develop and Leverage Patterns: Contribute to creating and promoting reusable architectural patterns, practices, and reference architectures that align with our organization's blueprint. </li> <li>Consult and Advise: Act as a strategic consultant on real-time traffic engineering architecture, providing insights on how business drivers and emerging technologies can align with enterprise objectives. </li> <li>Champion Effective Designs: Promote best practices in architectural design, enhancing efficiency and reliability across our solutions. </li> <li>Stakeholder Engagement: Partner with director and AVP-level stakeholders in technical and business areas to deliver high-impact solutions aligned with strategic goals. </li> <li>Drive Standardization and Innovation: Influence prioritization for enterprise benefits and risk reduction, encouraging adoption of best practices in design and architecture. </li> <li>Knowledge Sharing and Mentorship: Share findings and architectural insights with the team and stakeholders, helping define and guide best practices. </li> <li>Collaborative Development: Work closely with technical and non-technical team members to deliver highly available, scalable solutions while ensuring efficiency and low latency. </li> </ul>Required Technologies and Skills <ul> <li>Database Technologies: Extensive experience with SQL and NoSQL databases. </li> <li>Programming Languages: Proficiency in Java/JVM, Golang, Python, and Bash scripting. </li> <li>Version Control: Experience with GitLab and GitHub. </li> <li>Containerization and Infrastructure: Expertise with Docker for containerized applications. </li> <li>Infrastructure as Code: Experience with Terraform, CloudWatch, and cloud infrastructure automation. </li> <li>Cloud Platforms: Proficiency in Amazon Web Services (AWS) or Google Cloud Platform (GCP), including serverless offerings such as Lambda, EKS, EventBridge, and SQS, or equivalent services from other cloud providers. </li> <li>High-Throughput, Low-Latency Computing: Proven ability to design and implement solutions optimized for real-time, high-performance, and low-latency requirements. </li> <li>Highly Available Systems: Expertise in designing systems with low downtime and built-in fault tolerance. </li> </ul>Skills Amazon Web Services (AWS), Big Data, Building Architecture, Cloud Infrastructure, Data Analysis, Scalable Architectures, Software Project Planning, Strategic Management Compensation Compensation offered for this role is $134,400.00 - 217,350.00 annually and is based on experience and qualifications. The candidate(s) offered this position will be required to submit to a background investigation. Joining our team isn't just a job - it's an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good. You'll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, we've proven that Allstate empowers everyone to lead, drive change and give back where they work and live. Good Hands. Greater Together. Allstate generally does not sponsor individuals for employment-based visas for this position. Effective July 1, 2014, under Indiana House Enrolled Act (HEA) 1242, it is against public policy of the State of Indiana and a discriminatory practice for an employer to discriminate against a prospective employee on the basis of status as a veteran by refusing to employ an applicant on the basis that they are a veteran of the armed forces of the United States, a member of the Indiana National Guard or a member of a reserve component. For jobs in San Francisco, please click "here" for information regarding the San Francisco Fair Chance Ordinance. For jobs in Los Angeles, please click "here" for information regarding the Los Angeles Fair Chance Initiative for Hiring Ordinance. To view the "EEO is the Law" poster click "here". This poster provides information concerning the laws and procedures for filing complaints of violations of the laws with the Office of Federal Contract Compliance Programs To view the FMLA poster, click "here". This poster summarizing the major provisions of the Family and Medical Leave Act (FMLA) and telling employees how to file a complaint. It is the Company's policy to employ the best qualified individuals available for all jobs. Therefore, any discriminatory action taken on account of an employee's ancestry, age, color, disability, genetic information, gender, gender identity, gender expression, sexual and reproductive health decision, marital status, medical condition, military or veteran status, national origin, race (include traits historically associated with race, including, but not limited to, hair texture and protective hairstyles), religion (including religious dress), sex, or sexual orientation that adversely affects an employee's terms or conditions of employment is prohibited. This policy applies to all aspects of the employment relationship, including, but not limited to, hiring, training, salary administration, promotion, job assignment, benefits, discipline, and separation of employment.

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.
We are currently seeking a  Data Engineer w/Data Lakehouse (Onsite)  to join our team in Salt Lake City, Utah (US-UT), United States (US).
We are looking for a Data Engineer to join our fast growing team. This person will be responsible for expanding Cloud based data pipeline architecture for the various cross functional Tax teams. The ideal candidate has experience building robust data pipelines and reporting tools. However, someone with a strong application development background with keen interest in data engineering would be considered. The candidate will be collaborating extensively with Engineering, Tax Compliance and Tax Reporting teams to support functional use-cases and take data driven decisions.
Job Responsibilities Include:
Develop domain and data models to provide standardized reporting solutions to the firm (and understand differences between the two)
Design and develop data ingest and transform processes
Develop automation, governance and reporting solutions to provide firm and regulatory mandated controls
Work as part of a global team using Agile software methodologies
Partner with Tax risk, compliance and reporting teams
Use data to drive change throughout the Tax business
Basic Qualifications:
Minimum 5 years of relevant experience as a Data Engineer
5+ years of experience with SQL and relational databases
5+ years of experience with building workflows (ETL pipelines)
Preferred Skills:
Experience with data architecture, modeling and infrastructure
Proficiency in Python, Spark and the Hadoop ecosystem
MS/BS in Computer Science or relevant industry experience.
Experience working with large and disparate datasets
Self-starter, motivated, and good communication skills
Problem solver with attention to detail who can see complex problems in the data space through end to end
Willingness to work in a fast paced environment
Strong sense of ownership and driven to manage tasks to completion
Interest in applying technical knowledge to Financial Services industry
Bachelor's degree or equivalent required
#INDFSINS
#L1-NAM
About NTT DATA
NTT DATA is a $30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies.Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us atus.nttdata.com
NTT DATA endeavors to make https://us.nttdata.comaccessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at https://us.nttdata.com/en/contact-us.  This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here. If you'd like more information on your EEO rights under the law, please click here. For Pay Transparency information, please click here.

Our work matters. We help people get the medicine they need to feel better and live well. We do not lose sight of that. It fuels our passion and drives every decision we make. Job Posting Title Sr. IT Software Engineer - GCP (Sr. Data Engineer) - RemoteJob Description The Sr. Software Engineer - GCP (Sr. Data Engineer - GCP) is responsible for leading the design of technology solutions to ensure they meet all resiliency, stability, non-functional, functional and operational readiness use cases. This position is responsible for owning the technology solutions within their area, including proactive monitoring and alerting, technological roadmap and communication of overall health and future sustainability. We are looking for someone with: <ul> <li>Proficiency in GCP services such as Cloud Storage, BigQuery, CloudSQL, Dataflow, AirFlow, Composer and others. </li><li>Strong programming skills in languages used in cloud development such as Python etc. </li></ul>Responsibilities <ul> <li>Lead design to ensure the technology solutions meet all resiliency, stability, non-functional, functional and operational readiness use cases </li><li>Lead ongoing development, maintenance and support of existing systems and platforms </li><li>Manage work direction, lead, influence, and provide feedback to other team members </li><li>Participate in staffing plans to identify subject matter experts (SMEs) and provide feedback for staff performance reviews </li><li>Own technology solutions within area, including proactive monitoring and alerting, technological roadmap and communication of overall health and future sustainability </li><li>Drive innovation & continuous improvement </li><li>Other duties as assigned </li></ul>Minimum Qualifications <ul> <li>Bachelor's degree in Computer Science or related area of study, or equivalent combination of education and/or relevant work experience; High School Diploma or GED equivalent required </li><li>5 years of experience with application development or packaged software implementations </li><li>Must be eligible to work in the United States without need for work visa or residency sponsorship </li></ul>Preferred Technical Qualifications: <ul> <li>Experience working with large data models and data architecture principles. </li><li>Proficiency in GCP services such as Cloud Storage, BigQuery, CloudSQL, Dataflow, Composer and others. </li><li>Strong programming skills in languages used in cloud development such as Python. </li><li>Understanding of cloud computing principals, including infrastructure as a service(IaaS), Platform as a Service(PaaS), and Software as a Service(SaaS). </li><li>Experience working with Google Cloud SDK and APIs to interact with GCP services programmatically and automate tasks. </li><li>Knowledge of containerization technologies such as Docker and container orchestration platforms like Kubernetes for deploying and managing containerized applications on GCP. </li><li>Understanding of serverless computing concepts and experience developing serverless applications using GCP services like Cloud Functions and Cloud Run. </li><li>Experience setting up CI/CD pipelines using tools like GitHub to automate software deployment on GCP. </li><li>Proficiency in development tools and IDEs such as Google Cloud Shell, Cloud Code for Visual Studio Code or Cloud Tools for IntelliJ. </li></ul>Additional Qualifications <ul> <li>Ability to speak up to address risk and opportunities </li><li>Strong problem-solving and analysis skills </li><li>Ability to transition abstract concepts into stable and supportable software solutions </li><li>Ability to develop unbiased options and recommendations to technical problems and unbiased comparisons </li><li>Strong traits of decisiveness and judgment </li><li>Ability to drive innovation and be forward thinking </li><li>Excellent documentation skills </li></ul>Preferred Qualifications <ul> <li>Experience working in environment with regulatory compliance requirements (HIPAA, PCI, etc.) </li><li>Previous experience working an in Agile/Product Delivery model </li><li>Previous experience in PBM / health care industry </li><li>Understanding of security implications of domain </li></ul>Minimum Physical Job Requirements <ul> <li>Ability to travel up to 5% of the time </li><li>Ability to work a flexible schedule including weekends and shifts outside of Prime's core business hours of 9:00 a.m. to 3:00 p.m. as needed for technical support and/or project needs </li><li>Constantly required to sit, use hands to handle or feel, talk and hear </li><li>Frequently required to reach with hands and arms </li><li>Occasionally required to stand, walk and stoop, kneel, and crouch </li><li>Occasionally required to lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds </li><li>Specific vision abilities required by this job include close vision, distance vision, color vision, peripheral vision, depth perception and ability to adjust focus </li></ul>Reporting Structure <ul> <li>Reports to a Manager in the Information Technology department </li></ul> Potential pay for this position ranges from $87,200.00 - $139,400.00 based on experience and skills. Pay range may vary by 8% depending on applicant location. To review our Benefits, Incentives and Additional Compensation, visit our Benefits Page and click on the "Benefits at a glance" button for more detail. Prime Therapeutics LLC is proud to be an equal opportunity and affirmative action employer. We encourage diverse candidates to apply, and all qualified applicants will receive consideration for employment without regard to race, creed, color, religion, gender, sexual orientation, gender identity/expression, national origin, disability, age, genetic information, veteran status, marital status, pregnancy or related condition (including breastfeeding), expecting or parents-to-be, or any other basis protected by law. We welcome people of different backgrounds, experiences, abilities, and perspectives including qualified applicants with arrest and conviction records and any qualified applicants requiring reasonable accommodations in accordance with the law. Prime Therapeutics LLC is a Tobacco-Free Workplace employer. Positions will be posted for a minimum of five consecutive workdays.

Experience : 04 - 12 years.Location : Chennai ,Bengaluru, Mumbai , Pune.Key Skills and Experience: <ul><li>As an Azure Data Engineer, we are looking for candidates who possess expertise in the following:</li><li>Databricks</li><li>Data Factory</li><li>SQL</li><li>Pyspark/Spark</li></ul> Roles and Responsibilities: <ul><li>As a part of our dynamic team, you will be responsible for:</li><li>Designing, implementing, and maintaining data pipelines</li><li>Collaborating with cross-functional teams to understand data requirements.</li><li>Optimizing and troubleshooting data processes</li><li>Leveraging Azure data services to build scalable solutions.</li></ul>

Role: Data EngineerLocation: Mumbai and Bengaluru(Onsite) You will have the following responsibilities:<ul><li>Design Analyse relevant internally and externally sourced data (raw data) to generate BI and Advanced Analytics datasets based on your stakeholders’ requirements</li><li>Design data pipelines to curate sourced data into the inhouse data warehouse</li><li>Design data marts to facilitate dataset consumption out of the inhouse data warehouse by business and IT internal stakeholders</li><li>Design data model changes that align with the inhouse data warehouse standards</li><li>Define migration execution activities to move data from existing database solutions to the inhouse data warehouse Engineer</li><li>Regular housekeeping of raw data and data stored in the inhouse data warehouse</li><li>Build and maintenance of data pipelines and data platforms</li><li>Build data solution prototypes</li><li>Explore ways to enhance data quality and reliability</li><li>Identify and realize opportunities to acquire better data (raw data) </li><li>Develop analytical tooling to better support BI and Advanced Data Analytics activities</li><li>Execute data migration from existing databases to the inhouse data warehouse</li><li>Promote and champion data engineering standards and best-in-class methodology</li></ul>You will have the following qualifications:<ul><li>Bachelor’s or master’s degree in computer science, Information Technology, Engineering or related quantitative discipline</li><li>AWS Certified Data Engineer – Associate</li><li>Snowflake SnowPro Core Certification</li><li>4+ years of experience in data engineering or relevant working experience in a similar role, preferably in the financial industry</li><li>Strong understanding or practical experience of at least one common Enterprise Agile Framework e.g., Kanban, SAFe, SCRUM, etc.</li><li>Strong understanding of ETL, data warehouse and BI and Advanced Data Analytics concepts</li><li>Deep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate, etc.</li><li>Experience with databases and data warehouses - Snowflake, PostgreSQL, MS SQL</li><li>Strong programming skills with advanced knowledge of Java and/or Python</li><li>Experience in building data models</li><li>Strong critical-thinking, analytical and problem-solving skills</li><li>Excellent communicator with team-oriented approach</li></ul>

What We Do
The CERT Cyber Mission Readiness (CMR) directorate fortifies the U.S. and its partners against cyber threats. We design large and small-scale exercises, facilitate tabletop scenarios, run cybersecurity contests, and create open-source tools to bolster cyber defense capabilities. Actively partnering with sponsors, CMR identifies and addresses vulnerabilities to advanced cyber adversaries.
Central to CMR is a culture of collaboration and dedication. Committed to arming our nation and allies with the tools to combat cyber threats, we seek passionate individuals who are technologically inclined and value teamwork. The right attitude, coupled with a thirst for knowledge, is paramount. We foster continuous professional growth through extensive training, mentorship, and cross-learning.
Within the CMR directorate is the Operational Readiness and Evaluation (ORE) team. ORE intensifies the Cyber Workforce's defense posture. Collaborating with SEI teams and governmental units, we assess operational capabilities against established benchmarks, shaping strategies for maximum mission assurance. Leveraging innovative simulation technology, we develop high-end virtual training arenas and design challenging scenarios, striving to be at the pinnacle of cyber readiness.
ORE champions a unified and progressive culture. Driven to uplift the national cybersecurity workforce, we invite individuals with a zeal for technology, collaboration, and ongoing learning. Our ethos revolves around comprehensive training, mentorship, and skill-sharing.
Position Summary
As a Senior Data Engineer, you will be integral to our efforts in developing data architectures and analytics frameworks that support complex analysis and operational missions. Your role involves not only maintaining robust data solutions but also directly engaging with mission partners to assess and enhance their data engineering capabilities. Your expertise will be vital in defining new work roles and creating tailored training programs to empower our government partners.
Requirements:
You have BS in Computer Science, Engineering, Mathematics, or a related discipline with ten (10) years of experience; OR MS in the same fields with eight (8) years of experience; OR PhD in the same fields with five (5) years of experience.
Willingness to travel up to 25%, including international travel, supporting SEI's mission.
Must pass a background check and be eligible for a Department of Defense security clearance.
Duties:
Design and implement effective data pipelines and architectures to support advanced data analysis and mission-critical operations.
Manage the data lifecycle from modeling to database architecture, ensuring integrity and accessibility of data.
Develop and optimize tools for data extraction, transformation, and loading (ETL).
Utilize data science algorithms and machine learning to address specific challenges faced by Mission Partners.
Work collaboratively with Mission Partners to evaluate and improve their data engineering and analysis programs.
Define new work roles and develop customized training, exercise, and simulation programs to enhance the skills and capacities of individual team members and groups.
Ensure data systems comply with cybersecurity controls and policies tailored to the defense sector.
Knowledge, Skills, and Abilities:
Joining ORE provides a chance to enhance your skills. While prior experience with the following is advantageous, it's not mandatory:
Strong proficiency in object-oriented programming languages such as Python, Java, and SQL.
Expertise in cyber data processing, management, and visualization, including experience with tools like Elasticsearch, Apache NiFi, Kafka, and Logstash.
Comprehensive knowledge in data science and machine learning, both supervised and unsupervised.
Demonstrable experience with Big Data platforms and tools such as Jupyter Lab, ROCK NSM, and ALEX.
Excellent communication skills with the ability to work effectively in a team environment and engage with government Mission Partners.
Commitment to ongoing learning and professional development in data engineering and cybersecurity.
Desired Experience:
Previous roles in government or military sectors dealing with cybersecurity, including identifying and eliminating cyber threats, large-scale cyber data collection via log and sensor instrumentation, and cyber data management.
Experience in educational roles, particularly in instructional design, delivering training and instructional programs in data-related fields, instrumenting, collecting, and analyzing learner experience data.
Why work here?
Join a world-class organization that continues to have a significant impact on software.
Work with cutting-edge technologies and dedicated experts to solve tough problems for the government and the nation.
Be surrounded by knowledgeable staff with broad expertise across AI/ML, cybersecurity, software engineering, risk management, and policy creation.
Get 8% monthly contribution for your retirement, without having to contribute yourself.
Get tuition benefits to CMU and other institutions for you andyour dependent children.
Enjoy a healthy work/life balance withflexible work arrangements and paid parental and military leave.
Get access to university resources including mindfulness programs, childcare and back-up care benefits, a monthly transit benefit on WMATA, free transportation on the Pittsburgh Regional Transit System.
Enjoy annual professional development opportunities; attend conferences and training or obtain a certification and get reimbursed for membership in professional societies.
Qualify for relocation assistance and so much more.
Joining the CMU team opens the door to an array of exceptional benefits available to eligible employees.
Those employees who are  benefits eligible have the opportunity to experience the full spectrum of advantages from comprehensive medical, prescription, dental, and vision insurance to an enticing retirement savings program offering a generous employer contribution. You can also unlock your potential with tuition benefits and take well-deserved breaks with ample paid time off and observed holidays. Finally, rest easy knowing you are covered by life and accidental death and disability insurance.
Other perks include a free Pittsburgh Regional Transit bus pass, our Family Concierge Team to help navigate childcare needs, fitness center access, and so much more!
For a comprehensive overview of the benefits that may beawaiting you, explore our Benefits page.
At Carnegie Mellon, we value the whole package when extending offers of employment. Beyond just credentials, we consider the role and responsibilities, your invaluable work experience, and the knowledge gained through education and training. We acknowledge and appreciate your unique skills and the diverse perspective you bring. Your journey with us is about more than just a job; it's about finding the perfect fit for your professional growth and personal aspirations.
Are you interested in an exciting opportunity with an exceptional organization?! Apply today!
Location
Arlington, VA, Pittsburgh, PA   Job Function
Software/Applications Development/Engineering   Position Type
Staff - Regular   Full Time/Part time
Full time   Pay Basis
Salary   More Information:
Please visit  "Why Carnegie Mellon"  to learn more about becoming part of an institution inspiring innovations that change the world.

Click here to view a listing of employee benefits

Carnegie Mellon University is an Equal Opportunity Employer/Disability/Veteran .

Statement of Assurance

Orzota Data Engineer Interview Guide

Overview

Orzota Data Engineer Salary

Orzota Data Engineer Interview Process

Orzota Data Engineer Interview Questions

Orzota Data Engineer Jobs