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

Aperia Data Engineer Interview Guide

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


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

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

Overview

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

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

Aperia Data Engineer Interview Questions

Summary Join Aperia Solutions, a leader in SaaS solutions for the Payments & Compliance, and Defense & Security sectors. Since its founding in 1999, Aperia has specialized in business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, and Vietnam, Aperia is a fast-paced, global organization committed to enhancing efficiency in compliance and risk operations. Our clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia offers engaging challenges, a vibrant culture, and opportunities to define your career path. Job Description Aperia is seeking a SAFe-focused Product Manager of Investigative Products to support our Government, Defense & Security (GDS) team. As a key product management leader, you will be responsible for defining and executing our product strategy within the government sector. This includes aligning product development with market needs, driving product adoption, and ensuring successful product. Collaboration with product managers, business line owners, designers, clients, and partners is key, requiring adept diplomatic skills to navigate complex organizational dynamics. We are looking for a qualified candidate ready to work with cutting-edge technologies in an innovative organization. The Director of Investigative Products & Product Management should have experience in leading investigative product strategies and driving strategic technology partnerships while supporting Growth and Customer Success initiatives. Core Responsibilities <ul><li>Develop and maintain a GDS product roadmap in collaboration with Aperia's CTO, CIO, and GDS leadership, ensuring it meets market and client needs.</li><li>Lead product management efforts, including the ideation, development, and launch of innovative customer solutions using agile methodologies.</li><li>Engage with government stakeholders to identify and validate product requirements, ensuring alignment with strategic goals.</li><li>Deliver presentations and demonstrations tailored to existing and prospective government clients and partners to drive product engagement.</li><li>Represent Aperia at industry events, trade shows, and government forums, advocating for our product offerings and strategies.</li><li>Lead Partnership Programs, pre-sales Solutions Engineering, and Product Strategy to support product management objectives.</li><li>Support Marketing by providing insights to develop strategic messaging for GDS products, enhancing market positioning.</li><li>Ensure transparency and alignment through consistent communication with team members, leadership, and stakeholders.</li><li>Manage multiple projects and priorities effectively using agile and SAFe practices, with a focus on product management.</li></ul>Technical Skills & Experience <ul><li>Extensive experience in product management using agile and SAFe methodologies.</li><li>Strong presentation and communication skills, both verbal and written.</li><li>Experience designing and delivering solutions for insider threat, common operating picture (COP) and multi-source investigative analysis use cases to federal law enforcement and intelligence groups</li><li>Deep understanding of key industry solutions and competitive technologies</li><li>Proficiency in business operations tools (SharePoint, MS Office Suite, Visio, Excel etc.).</li></ul>Preferred Qualifications <ul><li>15+ years of experience within FVEY law enforcement and/or intelligence organizations.</li><li>Strong project management skills including budgeting and scheduling.</li><li>Ability to manage dynamic and competing priorities to support GDS revenue growth.</li><li>Criminal Justice degree(s) or certification(s).</li><li>Experience crafting marketing messages showcasing technology differentiators for government use cases.</li></ul>Education and Certifications <ul><li>Degree in Business Administration, Computer Science, Engineering (or equivalent) or a related field.</li></ul>Eligibility Requirements <ul><li>U.S. Citizen with eligibility for US Government clearance is mandatory.</li><li>This position is not eligible for sponsorship.</li></ul>Job Type <ul><li>Full-time</li></ul>Schedule <ul><li>Monday to Friday</li></ul>Work Location <ul><li>Remote, with up to 25% travel (CONUS & OCONUS)</li></ul>Benefits <ul><li>Comprehensive health, dental, and vision insurance</li><li>401(k) matching</li><li>Paid time off and parental leave</li><li>Education reimbursement and fitness membership</li><li>Volunteer time off</li></ul> This job description is not exhaustive; additional responsibilities may be assigned. Principals only; recruiters, please do not contact this job poster. Unsolicited services or offers are not welcome. *Aperia Privacy Policy: This document contains confidential, proprietary information and may not be reproduced or copied without Aperia's express authorization.*

<h3>Summary </h3>
Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, and Vietnam, Aperia is a fast-paced, global organization that strives to improve efficiency in compliance, risk, and customer service operations. Aperia’s clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia promises a great challenge, culture, and opportunities to forge your own path.
<h3>Job Description </h3>
At Aperia, we rely on a dynamic team of developers. We’re seeking a Business Analyst who is ready to work with new technologies and architectures in a forward-thinking organization that’s always pushing boundaries.
<h3>RESPONSIBILITIES</h3>
<ul>
<li>Join our team in the critical role of the Business Analyst.</li>
<li>Work with our internal client to define and refine business needs into actionable user stories and tasks.</li>
<li>Serve as a liaison between the Client team, Development team, and Data Warehouse team under the Delivery Lead / Product Owner.</li>
<li>Be instrumental in data identification, data analysis, unit testing, and managing user testing & sign off.</li>
<li>Demonstrate attention to detail, a sense of ownership, good interpersonal skills, and excellent documentation skills.</li>
<li>Increase efficiency in the development process and reduce exceptions, bugs, and test failures.</li>
</ul>
<h3>QUALIFICATIONS</h3>
<ul>
<li>A Bachelor’s degree in a computer or engineering discipline.</li>
<li>5 years of experience as a Business Analyst.</li>
<li>Solid knowledge of SDLC (Waterfall) and Agile development methodologies.</li>
<li>Strong ability to transform and extract required details from higher-level business requests.</li>
<li>Working knowledge of query language such as SQL.</li>
<li>High level of comfort in Excel/Access for manipulating data.</li>
<li>A solid understanding of testing and test case development.</li>
</ul>
<h3>Preferred Skills, Experience, and Education: </h3>
<ul>
<li>Knowledge of JAVA and Angular.</li>
<li>Knowledge of prototyping applications such as Axure.</li>
</ul>
<h3>Eligibility Requirements</h3>
<ul>
<li>Must be willing to submit to a background investigation and drug test as part of the selection process.</li>
<li>This position is not eligible for sponsorship.</li>
</ul>
<h3>Job Type</h3>
<ul>
<li>Full-time (hybrid)</li>
</ul>
<h3>Schedule</h3>
<ul>
<li>Monday to Friday</li>
</ul>
<h3>Benefits</h3>
<ul>
<li>Health insurance & Health savings account.</li>
<li>Dental insurance.</li>
<li>Vision insurance.</li>
<li>401(k) matching.</li>
<li>Life insurance.</li>
<li>Paid time off.</li>
<li>Parental leave.</li>
<li>Disability insurance.</li>
<li>Childcare assistance.</li>
<li>Education reimbursement.</li>
<li>Fitness membership.</li>
<li>Volunteer time off.</li>
</ul>
#J-18808-Ljbffr

Summary Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, and Vietnam, Aperia is a fast-paced, global organization that strives to improve efficiency in compliance, risk, and customer service operations. Aperia's clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia promises a great challenge, culture, and opportunities to forge your own path. Job Description At Aperia, we rely on a dynamic team of developers. We're seeking a Business Analyst who is ready to work with new technologies and architectures in a forward-thinking organization that's always pushing boundaries. RESPONSIBILITIES <ul><li>We are looking for a person to join our team in a critical role of the Business Analyst.</li><li>You will work with our internal client defining and refining the business needs into actionable user stores and tasks</li><li>Working directly for the Delivery Lead / Product Owner, you will serve a liaison between Client team, Development team and Data Warehouse team</li><li>You will be instrumental in data identification, data analysis, unit testing and managing user testing & sign off.</li><li>We are looking for someone with attention to detail, a sense of ownership, good interpersonal skills and excellent documentation skills.</li><li>Your work will increase efficiency in the development process and reduce exceptions / bugs / test failures.</li></ul>QUALIFICATIONS <ul><li>A Bachelor's degree in a computer or engineering discipline</li><li>5 years of experience as a Business Analyst</li><li>Solid knowledge of SDLC (Waterfall) and Agile development methodologies.</li><li>Strong ability to transform / extract required details from higher level business requests</li><li>Working knowledge of query language such as SQL</li><li>High level of comfort in excel / access manipulating data</li><li>A solid understanding of testing and test case development</li></ul>Preferred Skills, Experience, and Education: <ul><li>Knowledge of JAVA, Angular</li><li>Knowledge of prototyping applications such as Axure</li></ul>Eligibility Requirements <ul><li>Must be willing to submit to a background investigation and drug test as part of the selection process.</li><li>This position is not eligible for sponsorship.</li></ul>Job Type <ul><li>Full-time (hybrid)</li></ul>Schedule <ul><li>Monday to Friday</li></ul>Benefits <ul><li>Health insurance & Health savings account</li><li>Dental insurance</li><li>Vision insurance</li><li>401(k) matching</li><li>Life insurance</li><li>Paid time off</li><li>Parental leave</li><li>Disability insurance</li><li>Childcare assistance</li><li>Education reimbursement</li><li>Fitness membership</li><li>Volunteer time off</li></ul> This job description is not intended to be all-inclusive. An employee may also perform other reasonable related business duties as assigned by their immediate supervisor or management. Principals only. Recruiters please don't contact this job poster. DO NOT contact us with unsolicited services or offers.

Summary Join Aperia Solutions, a leader in SaaS solutions for the Payments and Compliance industries. Aperia is a Texas-based fintech and managed consultancy firm that creates custom SaaS applications and other software-based solutions for the payments, banking, and processing industry. Founded in 1999, Aperia offers business intelligence, risk management, compliance, and customer intelligence platforms. With offices in Dallas, Washington DC, Poland, and Vietnam, Aperia is a fast-paced, global organization that strives to improve efficiency in compliance, risk, and customer service operations. Aperia's clients include banks, processors, payment facilitators, merchant service providers, independent sales organizations, and government entities. A career at Aperia promises a great challenge, culture, and opportunities to forge your own path. Job Description At Aperia, you'll be part of a team that puts customers first, embraces each day with excitement, and strives for excellence in everything you do. We work deeply within the payments space to enable our customers to be compliant, manage risk and develop products that deliver exactly what they need. What this means for you is a shared passion for innovation and making a difference for the people we serve. As a Senior Product Manager, you will play a pivotal role in shaping the strategic direction of our SaaS solutions within the Payments and Compliance industries. Operating within the SAFe Agile framework, you will be responsible for defining the product vision, strategy, and roadmap, ensuring alignment with market needs, customer expectations, and business goals. As a Senior Product Manager, you are a bar raiser, this means you come with: <ul><li>Passion and skill to build not good but great product experiences</li><li>Customer centricity in running product research and developing hypotheses</li><li>Business mindset to align product opportunities to business outcomes</li><li>Analytical thinking to research and analyze qualitative and quantitative data</li><li>Consistency in planning, prioritizing and delivering outcomes</li><li>Attitude to continue to build a great company for us and our customers</li></ul> You will make an impact by: Leading the product development in our payments space. You will be responsible for defining the shared experiences across our device ecosystem (web, mobile). You will partner closely with design, user research and engineering to define the future of our applications as we migrate to the cloud. All shared experiences, such as the navigation, dashboard feed, settings, notifications, login, and permission management will be managed by your team. You will also partner closely with the engineering team to help make the longer-term architecture and partner integration decisions. This is a hybrid people leader role that has product responsibility for global teams. This role will transition to a manager role once we have an established multi-year roadmap. In this role you will have the following objectives: <ul><li>Work with a front-end engineering team, data analytics and design to build the next version of our applications</li><li>Partner with product teams to understand the multi-product use cases</li><li>Define and execute on a rolling 4 quarter roadmap.</li><li>Define and track success metrics for the team charter.</li><li>Product Strategy and Vision: Define and communicate the product vision, strategy, and roadmap in alignment with business objectives, market trends, and customer feedback.</li><li>Market Analysis and Insights: Conduct market research, gather industry insights, and analyze competitive landscapes to identify market opportunities and guide product decisions.</li><li>Roadmap Development: Collaborate with cross-functional teams to create and prioritize the product roadmap, considering market demands and technology advancements.</li><li>Requirement Definition: Gather and translate customer needs and business requirements into clear product features, user stories, and acceptance criteria.</li><li>Stakeholder Engagement: Engage with internal and external stakeholders, including customers, sales, marketing, and development teams, to gather feedback and drive product enhancements.</li><li>Release Planning and Coordination: Work closely with Agile teams in release planning, sprint reviews, and retrospectives, ensuring timely and successful product delivery.</li><li>Product Performance Analysis: Monitor product performance, analyze key metrics, and iterate on strategies to enhance product value and customer satisfaction.</li><li>Risk Management: Identify potential risks and challenges in product development, proposing mitigating strategies to ensure successful delivery.</li><li>Leadership and Collaboration: Lead and inspire cross-functional teams, fostering a collaborative environment to achieve product goals and milestones.</li><li>Continuous Improvement: Drive continuous improvement initiatives in Agile processes, methodologies, and product development practices.</li></ul> Qualifications: <ul><li>Bachelor's degree in Computer Science, Business, or related field; Master's degree preferred.</li><li>Proven experience with at least 5 years as Product Manager.</li><li>Experience within the SaaS industry, preferably in Payments and Compliance domains.</li><li>In-depth knowledge of Agile methodologies and experience working within a SAFe Agile environment.</li><li>Strong analytical, strategic thinking, and problem-solving skills, with the ability to translate complex concepts into actionable plans.</li><li>Excellent communication, presentation, and leadership abilities, with a track record of influencing cross-functional teams.</li><li>Proficiency in product management tools (e.g., Jira, Confluence) and a data-driven approach to decision-making.</li><li>Ability to thrive in a fast-paced, global environment while managing multiple priorities and stakeholders.</li></ul> When applying for this position, in addition to a resume, we'd greatly appreciate a cover letter addressing why you are interested. Be creative and tell us your story. We also welcome any examples of work products or related experience. Job Type <ul><li>Full-time</li></ul> Schedule <ul><li>Monday to Friday</li></ul> Work Location <ul><li>Vietnam: Ho Chi Minh City / Danang</li><li>US: Dallas, TX</li></ul> Benefits <ul><li>Health insurance </li><li>Dental insurance</li><li>Paid time off</li><li>Parental leave</li><li>Childcare assistance</li><li>Education reimbursement</li></ul> This job description is not intended to be all-inclusive. An employee may also perform other reasonable related business duties as assigned by their immediate supervisor or management. Principals only. Recruiters please don't contact this job poster. DO NOT contact us with unsolicited services or offers.

Summary: As a Data Engineer at Meta, you will shape the future of people-facing and business-facing products we build across our entire family of applications (Facebook, Instagram, Messenger, WhatsApp, Reality Labs, Threads). Your technical skills and analytical mindset will be utilized designing and building some of the world's most extensive data sets, helping to craft experiences for billions of people and hundreds of millions of businesses worldwide.In this role, you will collaborate with software engineering, data science, and product management teams to design/build scalable data solutions across Meta to optimize growth, strategy, and user experience for our 3 billion plus users, as well as our internal employee community.You will be at the forefront of identifying and solving some of the most interesting data challenges at a scale few companies can match. By joining Meta, you will become part of a world-class data engineering community dedicated to skill development and career growth in data engineering and beyond.Data Engineering: You will guide teams by building optimal data artifacts (including datasets and visualizations) to address key questions. You will refine our systems, design logging solutions, and create scalable data models. Ensuring data security and quality, and with a strong focus on efficiency, you will suggest architecture and development approaches and data management standards to address complex analytical problems.Product leadership: You will use data to shape product development, identify new opportunities, and tackle upcoming challenges. You'll ensure our products add value for users and businesses, by prioritizing projects, and driving innovative solutions to respond to challenges or opportunities.Communication and influence: You won't simply present data, but tell data-driven stories. You will convince and influence your partners using clear insights and recommendations. You will build credibility through structure and clarity, and be a trusted strategic partner. Required Skills: Data Engineer, Product Analytics Responsibilities: Conceptualize and own the data architecture for multiple large-scale projects, while evaluating design and operational cost-benefit tradeoffs within systems Create and contribute to frameworks that improve the efficacy of logging data, while working with data infrastructure to triage issues and resolve Collaborate with engineers, product managers, and data scientists to understand data needs, representing key data insights visually in a meaningful way Define and manage Service Level Agreements for all data sets in allocated areas of ownership Determine and implement the security model based on privacy requirements, confirm safeguards are followed, address data quality issues, and evolve governance processes within allocated areas of ownership Design, build, and launch collections of sophisticated data models and visualizations that support multiple use cases across different products or domains Solve our most challenging data integration problems, utilizing optimal Extract, Transform, Load (ETL) patterns, frameworks, query techniques, sourcing from structured and unstructured data sources Assist in owning existing processes running in production, optimizing complex code through advanced algorithmic concepts Optimize pipelines, dashboards, frameworks, and systems to facilitate easier development of data artifacts Influence product and cross-functional teams to identify data opportunities to drive impact Mentor team members by giving/receiving actionable feedback Minimum Qualifications: Minimum Qualifications: Bachelor's degree in Computer Science, Computer Engineering, relevant technical field, or equivalent 7 years of experience where the primary responsibility involves working with data. This could include roles such as data analyst, data scientist, data engineer, or similar positions 7 years of experience with SQL, ETL, data modeling, and at least one programming language (e.g., Python, C++, C#, Scala or others.) Preferred Qualifications: Preferred Qualifications: Master's or Ph.D degree in a STEM field Public Compensation: $173,000/year to $242,000/year bonus equity benefits Industry: Internet Equal Opportunity: Meta is proud to be an Equal Employment Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion, color, national origin, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender, gender identity, gender expression, transgender status, sexual stereotypes, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law. Meta participates in the E-Verify program in certain locations, as required by law. Please note that Meta may leverage artificial intelligence and machine learning technologies in connection with applications for employment. Meta is committed to providing reasonable accommodations for candidates with disabilities in our recruiting process. If you need any assistance or accommodations due to a disability, please let us know at accommodations-extfb.com.

Description Summary:The Senior Data Engineer will be responsible for designing, developing, and maintaining the data warehouse and analytics architecture to fulfill the organization's business analysis and reporting requirements. This role also involves mentoring team members and providing strategic recommendations to support the organization's goals. Duties to include, (but not limited to): <ul><li>Create and maintain optimal data pipeline architecture.</li><li> Assemble data sets that meet business requirements.</li><li> Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, APIs, and Infor/AWS data lake tools.</li><li> Focus on gathering and cleaning data to ensure its quality and accuracy.</li><li> Build analytics tools that utilize the data pipeline to provide actionable insights to business customers.</li><li> Run tests on designs to isolate errors.</li><li> Identify and implement internal process improvements.</li><li> Collaborate with business and technology stakeholders to develop and maintain data warehouse and data analytics platform architecture and utilization.</li><li> Collaborate with Business Analysts to develop analysis, reports, dashboards, visualizations, and metrics as business needs dictate.</li><li> Utilize source control and change management practices for documentation and collaboration.</li><li> Mentor and guide others on the team to help them develop their skills and knowledge. </li><li> Create data models to support analysis and reporting.</li><li> Participate in developing data strategies and aligning them with the organization's goals. </li><li> Provide recommendations on critical technical decisions regarding data, architecture, infrastructure, and systems. </li><li> Provide occasional after-hours support on an as-needed basis.</li><li> Perform other duties as assigned.</li></ul> A Data Engineer will possess and/or demonstrate the ability to: <ul><li>Provide first-rate IT assistance and solutions.</li><li> Collaborate closely with stakeholders from across the entirety of WSC to understand their data needs and deliver insights. </li><li> Remain highly organized, flexible, and able to react well to immediate issues with attention to detail and deadlines.</li><li> Be a self-initiator and work with minimal supervision independently and/or with teammates.</li><li> Lead data engineering projects, overseeing their execution from start to finish. </li><li> Write and debug complex SQL/Transact-SQL/ OLAP queries/code.</li><li> Learn innovative technologies and keep abreast of the latest technological advances.</li><li> Be motivated by the desire to make a difference in the business through collaboration with IT and business stakeholders.</li></ul> Education / Experience: <ul><li>Possess a minimum of a two-year degree from an accredited college or university in information technology, mathematics, computer science or a related field and a minimum of 5 years of related experience.</li><li> Strong analytical ability, judgment, and problem analysis techniques.</li><li> Strong written and verbal communication skills.</li><li> Strong technical communication skills with a variety of audiences.</li><li> Experience developing reports and visualizations in Power BI and other tools.</li><li> Experience with Infor CSDE/M3, Microsoft Dynamics 365, Phocas, or Birst Analytics a plus, but not required.</li><li> Project participation experience, including understanding of application lifecycle management.</li><li> Proficient with source control and change management practices.</li><li> A successful history of manipulating, processing, and extracting value from disconnected datasets.</li></ul> Working Demands / Physical Requirements: <ul><li>General office conditions with continuous sitting with heavy computer usage.</li><li> Occasional short-term out-of-town travel for educational purposes.</li><li> Occasional after-hours support.</li><li> Ability to lift up to 50 pounds.</li></ul> Reports to: Business Intelligence Director Conclusion: The Senior Data Engineer will exemplify the high standards that have come to be associated with WSC. As an ESOP owner, acting with honor, integrity, and positivity is imperative.

Overview This is a hybrid role - 2 days remote and 3 days in the Malvern, PA office. CubeSmart is currently seeking a Senior (Sr) Data Engineer to join the Information Technology team at our corporate office in Malvern, PA. The Sr Data Engineer will be responsible for the design, development, and implementation of data products and services used to build and enrich the Cloud Data Platform at Cubesmart. Who we are: At CubeSmart, we're intentional about culture. You can experience it everywhere from our mission statement of "genuine care" to our "It's What's Inside That Counts" tagline to calling each other "teammates" rather than employees. This spirit fosters a fun and collaborative environment that has resulted in our rapid growth and being recognized amongst the top in our industry. CubeSmart's award-winning team is made up of people who genuinely care. Teammates care about our customers and the life events and/or business needs they are facing. Teammates are passionate, responsible and understanding. The CubeSmart team is made up of people who have a can-do attitude, are committed to their own success and the success of the company, and lead by example. If this sounds like a team and culture that matches your personal values and motivations, we want to hear from you. Responsibilities This role will also be responsible for the development and maintenance of the data products and services used to build and enrich the Cloud Data Platform. The role will serve as a technical expert to analyze the needs of CubeSmart's applications and business data requirements and produce optimal solutions according to their needs and specifications, and in alignment with CubeSmart's design standards. This individual will be part of the team building a data and analytics platform leveraging the Databricks Data Intelligence Platfrom in the Azure cloud. This will include designing and building the data ingestion and ETL pipelines and processes to create and manage the cloud Lakehouse environment. In addition, this person will be engaged with the Revenue Management and Analytics teams to help created optimized solutions for the Cloud. Responsibilities <ul><li>Collaborate with program manager(s), application development, and data consumers to develop data ingestion and ETL pipelines required to enable CubeSmart data consumers to onboard processes to the Cloud Data Platform</li><li>Build new or enhance existing Data Products and Services used within the Cloud Data Platform</li><li>Provide support as needed to other projects or programs that are consumers of the Cloud Data Platform</li><li>Perform code reviews and mentor junior team members as needed and provide mentorship to analytics users of the Cloud Data Platform</li><li>Collaborate with 3rd party vendors to understand externally sourced data and incorporate into CubeSmart's data environment, in adherence with CubeSmart's data design standards</li></ul> Qualifications <ul><li>Bachelor's degree in Computer Science, Information Technology or a related discipline</li><li>7+ years of experience in Data Engineering, Cloud Data Warehousing, Real-time Data Processing including Streaming and Transactional Systems</li><li>Strong skills in SQL, Python, and PySpark</li><li>Experience with Azure data services (Azure Databricks, Azure SQL, Azure Data Factory and Databricks ML Flow) or equivalent is preferred</li><li>Full understanding of the Software Development Life Cycle (SDLC) and experience with Agile software development processes</li><li>Solid understanding of cloud DevOps capabilities, preferably Azure DevOps</li><li>Experience creating and managing CI/CD pipelines and processes</li><li>Experience with MongoDB (or similar non-relational database platform) or PostgreSQL is a plus</li><li>Experience with Microsoft .Net is a plus</li></ul> Knowledge, Skills, Abilities and Personal Characteristics <ul><li>Service orientation towards business-focused 24x7 support and service mentality</li><li>Ability to work within a team environment, showing an openness to collaborate with technical and business peers, with the ability to step up and take on new challenges in response to changing business conditions</li><li>Ability to learn quickly, adapt work processes to adhere with best practices</li><li>Ability to clearly convey technical information to both technical and non-technical audiences</li><li>Collaborative individual who creates open channels of communications and encourages technical dialogue across the department and who is capable of mentoring junior team members</li><li>Well-developed analytical and problem-solving abilities</li><li>Ability to work on multiple tasks and projects at once, with the ability to properly prioritize one's own work and the work of others</li></ul> We are an Equal Opportunity Employer, Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity. #LI-MT1

Zions Bancorporation's Enterprise Technology and Operations (ETO) team is transforming what it means to work for a financial institution. With a commitment to technology and innovation, we have been providing our community, clients and colleagues the best experience possible for over 150 years. Help us transform our workforce of the future, today. We are seeking a Master Data Management (MDM) Data Engineer to join Zions Bancorporation. The MDM Data Engineer plays a key role in the analysis and design of new and enhanced digital capabilities for our master data management platform that will enable simple and delightful experiences for our partners and customers. The Master Data Management (MDM) Data Engineer will: <ul><li>Partner with data & integration product teams to implement master data management solutions.</li><li>Conduct discovery work for new attributes and sources being added to MDM system, understanding what the impacts will be from a probabilistic matching engine (PME)/deduplication standpoint, and analyzing the results.</li><li>Coordinate with Solution Architects & Data Solutions Designers to utilize reusable solution design patterns that meet enterprise standards.</li><li>Conduct research and discovery in support of upgrades, cloud enablement, continuous delivery, and other modern engineering practices.</li><li>Participate in root cause analysis with appropriate subject matter experts to identify and address root causes to production issues.</li><li>Demonstrate strong analytical, organizational, and problem-solving skills.</li><li>Strong focus on long-term strategy, application stability, refactoring and re-usability.</li><li>Other duties as assigned.</li></ul> Qualifications: <ul><li>6+ years of experience supporting, designing and developing applications using IBM Master Data Management (MDM) Advanced Edition (Physical), with expertise in master data management concepts, including PME, deduplication, and survivorship.</li><li>Experience with development of data integration solutions with expertise in data modeling, data quality and data profiling.</li><li>Working knowledge of Data-as-a-Service (DaaS) and API management concepts and how to use these with different types of integration technologies. Experience with REST APIs, JSON, SOAP Web Services, XML, XSD, WSDL, Python, and Kafka.</li><li>Ability to elicit, gather and analyze user requirements.</li><li>Strong leadership experience.</li><li>Ability to communicate well with business stakeholders.</li><li>Expertise in Banking, Insurance and financial services.</li><li>Requires a Bachelor's degree in Computer Science, Computer Engineering, Information Systems or related field. A combination of education and experience may meet requirements.</li></ul> Location: This position can be located 100% remote within the United States or will be a hybrid work from schedule with a minimum of three days per week in the office if you are located within 50 miles of the new Zions Technology Center in Midvale, UT. Pay Range: $115,000 - $160,000 (Based upon relatable skills/experience) Benefits: <ul><li>Medical, Dental and Vision Insurance - START DAY ONE! </li><li>Life and Disability Insurance, Paid Parental Leave and Adoption Assistance </li><li>Health Savings (HSA), Flexible Spending (FSA) and dependent care accounts</li><li>Paid Training, Paid Time Off (PTO) and 11 Paid Federal Holidays</li><li>401(k) plan with company match, Profit Sharing, competitive compensation in line with work experience </li><li>Mental health benefits including coaching and therapy sessions</li><li>Tuition Reimbursement for qualifying employees </li><li>Employee Ambassador preferred banking products</li><li>Employees may, at the company's discretion, be eligible for a bonus.</li></ul> Apply now if you have a passion for impactful outcomes, enjoy working collaboratively with co-workers, and want to make a difference for the clients and communities we serve.

Key Responsibilities•Ability to breakdown complex problems using appropriate design patterns and best practices demonstrating a strong knowledge foundation and a sound approach to problem-solving.•Ability to build automated pipelines that integrate and transport software through reliable secure and governed channels from conception to production. Ability to The Selected candidate will be responsible for the design development and administration of data management solutions that align with the business needs of the organization.•Design relational databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and security as well as customer-defined deliverables.•Create build and lead the implementation of strategies and roadmaps for enterprise and department level data projects. Collaborate with internal and external personnel including senior management system architects' software developers database administrators design analysts and information modeling experts to determine project requirements and capabilities and strategize development and implementation timelines.•Work alongside data engineers to develop comprehensive automated ELT/ELT workflows that align with database design.•Manage source data access security configure authentication and authorization manage and enforce data policies and standards.•Document and organize findings including data retrieval stand up libraries.•Collaborate with Business Analysts to gather business requirements for Analytics and Reporting.•Build and modify tables views and optimize SQL queries indexes as needed.•Responsible for implementing security on developed Dashboards in accordance with security and access requirements.•Good to have Insurance Domain language understanding.Required Skills•Has at least 10+ years of relevant experience in Data Engineering especially ADF Python PySpark SparkSql Sql and Databricks programming and cloud data ingestion data pipelines handling structured and semi-structured data formats like JSON XML. Must have experience in building ETL/ELT Data warehouses/lakes for Real time event driven scenarios.•Good to have Insurance Domain language understanding. Experience in development of Power BI backend development includes Sql relevant experience•Engage in prototyping designing developing publishing Power BI Reports.•Develop Power BI Data models and recommend best practices for report creation and visualizations.•Implement security in reports and dashboards.•Troubleshooting and resolving issues related to performance environments monitoring and operability of Power BI reports Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.

Aperia Data Engineer Interview Guide

Overview

Aperia Data Engineer Salary

Aperia Data Engineer Interview Process

Aperia Data Engineer Interview Questions

Aperia Data Engineer Jobs