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

Hive Data Engineer Interview Guide

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


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

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

Overview

What Hive Looks for in a Data Engineer

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.

Hive Data Engineer Interview Process

Interview Tips

You are tasked with keeping track of a customer’s addresses in your database.

However, customer’s addresses change whenever they move. We want to keep track of their moving history as well as the person that moves in afterwards.

How would you create or modify a schema to keep track of these address changes?

Create a schema to keep track of customer address changes

Address Schema

Data Modeling

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 work as a data engineer for a city-wide bicycle rental company. The company wants to predict future bicycle rental volumes using historical data collected from multiple sources, such as station logs, weather files, and event schedules. You are given access to raw source files that are updated daily.

How would you design an end-to-end data pipeline to prepare and serve data for downstream predictive modeling of bicycle rental demand?

Design an end-to-end data pipeline to process and serve data for predicting bicycle rental volumes.

Bicycle Rental Data Pipeline

Batch & Stream Processing

Hive Data Engineer Interview Questions

<h3>Job Description</h3><div>Job Description<div>This position is part of a bid process associated with a Statement of Work. Candidates are encouraged to submit their information and resumes highlighting their relevant experience.Position Title: Reporting Analyst Location: Springfield, VA Clearance Required: Top Secret/SCI. Must be able to pass CI PolyJob SummaryHive Group is seeking a technical consultant to provide technical support to our Federal government customers. This individual will work directly with clients to understand key elements of client business processes and then work onsite to implement and operate software products and service offerings by performing key tasks. They will thrive on their personal and direct contributions that help our clients achieve substantial benefits from our suite of software products.Key Responsibilities<ul><li>Automate integration tasks, data processing, and report generation using scripting (e.g., Python, PowerShell) to enhance efficiency and accuracy.</li><li>Effectively manage multiple priorities and adapt quickly to shifting client requests and demands.</li><li>Collaborate with external contractors on the PRISM COTS product to facilitate data exchange, understand their requirements, and propose optimized data solutions.</li><li>Apply security best practices to integrate systems, protect sensitive data, and ensure accurate data reporting.</li><li>Utilize Business Intelligence (BI) and data visualization tools (e.g., Tableau, Power BI) to create insightful dashboards and reports that inform business decisions. </li><li>Support end-users with training and technical assistance on integrated systems and data reporting tools ensuring users can effectively utilize data for decision-making. </li></ul>Qualifications<ul><li>Minimum Bachelor’s Degree in a Computer Science or related field</li><li>Minimum three years of overall integration, data migration, and/or report development</li><li>experience</li><li>Strong SQL skills</li><li>Excellent written and oral communication skills</li><li>Strong attention to detail and follow-through skills</li><li>Excellent customer service skills</li><li>Must be able to work in a collaborative team environment </li></ul>Physical Requirements:<ul><li> Qualified candidates will need to be able to commute to and move/traverse throughout    the work facility.</li></ul>A Commitment to Equal OpportunityHive Group is an Equal Employment Opportunity and Affirmative Action employer dedicated to fair and unbiased employment decisions. We do not discriminate based on race, color, sex (including gender and transgender status), age, religion, national origin, disability, marital status, veteran status, domestic partner or civil union status, gender identity, medical condition, genetic information, sexual orientation, or any other status protected by applicable federal, state, and local laws.Our hiring and promotion decisions are based exclusively on an individual’s qualifications and suitability for the role.Protecting Your InformationStay vigilant against fraudulent job offers and individuals impersonating Hive Group Talent Acquisition Specialists. Hive Group will never request payment details or money during the application process. Official communications will only come from email addresses ending in @hive-llc.com or @applytojob.com — not from free email services like Gmail or messaging platforms such as WhatsApp.If you receive suspicious messages requesting payment or personal information, please report them immediately to talentacquisition@hive-llc.com. Powered by JazzHR4GTMxa2pcN</div></div>

<h3>Job Description</h3><div>Job Description<div>This position is part of a bid process associated with a Statement of Work. Candidates are encouraged to submit their information and resumes highlighting their relevant experience.Position Title: Technical Integration and Reporting Analyst Location: Springfield, VA Clearance Required: Top Secret/SCI. Must be able to pass CI PolyJob SummaryHive Group is seeking a technical consultant to provide technical support to our Federal government customers. This individual will work directly with clients to understand key elements of client business processes and then work onsite to implement and operate software products and service offerings by performing key tasks. They will thrive on their personal and direct contributions that help our clients achieve substantial benefits from our suite of software products.Key Responsibilities<ul><li>Responsible for the design, testing, and deployment of system integration points</li><li>Provides technical direction and guidance in the design and integration of enterprise business solutions</li><li>Supports technical progress reviews and project schedule inputs</li><li>Authors technical documentation, such as Standard Operating Procedures (SOP), Interface Control Documents (ICD), Detailed Functional Designs (DFD), and Architecture Diagrams</li><li>Coordinates and directs COTS tool interfaces throughout the project lifecycle</li><li>Fully knowledgeable in all aspects of program, technical and functional areas</li><li>Coordinates and establishes interrelationships between multiple and related technologies and/or programs within an enterprise</li><li>Creates application and database SQL reports in coordination with key stakeholders</li><li>Automate report generation using scripting (e.g., Python, PowerShell) to enhance efficiency and accuracy.</li><li>Collaborate with external contractors on the PRISM COTS product to facilitate data exchange, understand their requirements, and propose optimized data solutions.</li><li>Utilize Business Intelligence (BI) and data visualization tools (e.g., Tableau, Power BI) to create insightful dashboards and reports that inform business decisions.</li><li>Support end-users with training and technical assistance on integrated systems and data reporting tools ensuring users can effectively utilize data for decision-making.</li><li>Address critical issues in application architecture, to include functional and technical designs</li><li>Provides technical troubleshooting to support application and operating systems</li><li>Recommends innovative solutions to gaps</li><li>Coordinates and reviews work of assigned staff</li></ul>Qualifications <ul><li>Bachelor's Degree </li><li>Minimum of four (4) years of experience in providing customer support consulting environment which requires a high degree of technical competence</li><li>Minimum of two (2) years of experience within the last four years in implementing and/or maintaining an enterprise systems interface</li><li>Advanced skills and systems development knowledge of a COTS tool technical architecture to include business process and functional capabilities</li><li>Demonstrated skills in using integration techniques and technologies including web service protocols and languages including SOAP-based XML, application programmatic interfaces (APIs), service-oriented architecture, database information exchange</li><li>Experience in Oracle DBMS and Oracle-based SQL</li><li>Experience in Linux and Windows Server operating systems, including command line interfaces (CLI)</li><li>Experience in effectively leading technical review meetings, creating and presenting briefs</li><li>Experience applying COTS product knowledge to provide technical and system design guidance to the application development team</li><li>Experience leading or supporting business application specialists and integration analysts in the implementation of software designs, configurations, and system testing (preferred)</li><li>Knowledge of ERP software architectures, such as Momentum, PeopleSoft, etc. (preferred)</li></ul>Physical Requirements:<ul><li> Qualified candidates will need to be able to commute to and move/traverse throughout    the work facility.</li></ul>A Commitment to Equal OpportunityHive Group is an Equal Employment Opportunity and Affirmative Action employer dedicated to fair and unbiased employment decisions. We do not discriminate based on race, color, sex (including gender and transgender status), age, religion, national origin, disability, marital status, veteran status, domestic partner or civil union status, gender identity, medical condition, genetic information, sexual orientation, or any other status protected by applicable federal, state, and local laws.Our hiring and promotion decisions are based exclusively on an individual’s qualifications and suitability for the role.Protecting Your InformationStay vigilant against fraudulent job offers and individuals impersonating Hive Group Talent Acquisition Specialists. Hive Group will never request payment details or money during the application process. Official communications will only come from email addresses ending in @hive-llc.com or @applytojob.com — not from free email services like Gmail or messaging platforms such as WhatsApp. Powered by JazzHRM1lJaC05Bt</div></div>

<h3>Job Description</h3><div>Job Description<div>This position is part of a bid process associated with a Statement of Work. Candidates are encouraged to submit their information and resumes highlighting their relevant experience. Position Title: Software Engineer Location: Hanover, MD Clearance Required: Top Secret/SCI Position Overview: Join a collaborative and mission-driven team where your contributions directly support the Army’s readiness and modernization goals. The Software Engineer (Journeyman) supports the design, development, testing, and maintenance of mission-critical software applications, ensuring compliance with security and quality standards. Key Responsibilities:<ul><li>Develop, debug, and maintain software applications in support of program objectives.</li><li>Participate in Agile development cycles and code reviews.</li><li>Write scripts and automation tools to support system integration.</li><li>Support software documentation and version control using Git.</li><li>Collaborate with engineers and analysts to meet functional requirements.</li><li>Ensure security hardening and RMF compliance of applications.</li></ul>Qualifications:<ul><li>Bachelor’s degree in Computer Science or related field.</li><li>3–5 years of experience in software development.</li><li>Proficiency in Java, Python, or C++, and version control systems.</li><li>Familiarity with DoD software development standards.</li><li>Active Top Secret/SCI clearance required.</li></ul>A Commitment to Equal Opportunity Hive Group is an Equal Employment Opportunity and Affirmative Action employer dedicated to fair and unbiased employment decisions. We do not discriminate based on race, color, sex (including gender and transgender status), age, religion, national origin, disability, marital status, veteran status, domestic partner or civil union status, gender identity, medical condition, genetic information, sexual orientation, or any other status protected by applicable federal, state, and local laws. Our hiring and promotion decisions are based exclusively on an individual’s qualifications and suitability for the role. Protecting Your Information Stay vigilant against fraudulent job offers and individuals impersonating Hive Group Talent Acquisition Specialists. Hive Group will never request payment details or money during the application process. Official communications will only come from email addresses ending in @hive-llc.com or @applytojob.com — not from free email services like Gmail or messaging platforms such as WhatsApp. If you receive suspicious messages requesting payment or personal information, please report them immediately to talentacquisition@hive-llc.com.Powered by JazzHRPql9p7ED3w</div></div>

<h3>Job Description</h3><div>Job Description<div>This position is part of a bid process associated with a Statement of Work. Candidates are encouraged to submit their information and resumes highlighting their relevant experience. Position Title: Senior Software Engineer Location: Hanover, MD Clearance Required: Top Secret/SCI Position Overview: Join a collaborative and mission-driven team where your contributions directly support the Army’s readiness and modernization goals. The Senior Software Engineer leads the development and implementation of secure, scalable, and maintainable software systems supporting national defense missions. This role drives architecture, performance optimization, and compliance with cybersecurity requirements. Key Responsibilities:<ul><li>Lead design and architecture of software solutions across classified systems.</li><li>Develop and maintain high-performance applications using secure coding practices.</li><li>Integrate software with existing infrastructure, databases, and middleware.</li><li>Conduct peer reviews, testing, and validation of code for mission-critical reliability.</li><li>Ensure software solutions meet RMF and cybersecurity standards.</li><li>Mentor junior developers and support Agile team planning.</li></ul>Qualifications:<ul><li>Bachelor’s degree in Computer Science or related field (Master’s preferred).</li><li>10+ years of software engineering experience including secure/classified systems.</li><li>Expertise in object-oriented programming and distributed systems design.</li><li>Proficiency with modern development stacks and DevSecOps tools.</li><li>Active Top Secret/SCI clearance required.</li></ul>A Commitment to Equal Opportunity Hive Group is an Equal Employment Opportunity and Affirmative Action employer dedicated to fair and unbiased employment decisions. We do not discriminate based on race, color, sex (including gender and transgender status), age, religion, national origin, disability, marital status, veteran status, domestic partner or civil union status, gender identity, medical condition, genetic information, sexual orientation, or any other status protected by applicable federal, state, and local laws. Our hiring and promotion decisions are based exclusively on an individual’s qualifications and suitability for the role. Protecting Your Information Stay vigilant against fraudulent job offers and individuals impersonating Hive Group Talent Acquisition Specialists. Hive Group will never request payment details or money during the application process. Official communications will only come from email addresses ending in @hive-llc.com or @applytojob.com — not from free email services like Gmail or messaging platforms such as WhatsApp. If you receive suspicious messages requesting payment or personal information, please report them immediately to talentacquisition@hive-llc.com.Powered by JazzHRfnVHvYKBhY</div></div>

Hive Group is an agile, mission-driven government contracting firm transforming how federal agencies approach procurement and acquisition. We are evolving from a services first model to become a product focused innovator, building scalable tools that improve government acquisition outcomes and modernize the procurement experience. As a small business with an entrepreneurial spirit, we value initiative, creativity, and leadership at every level.
Position Overview :
Hive Group is seeking a Senior Product Manager to lead the development of innovative products that serve the government procurement and acquisition community. This role will balance the immediate needs of our federal clients with Hive Group’s long-term technical and business goals, ensuring that the solutions we build today can scale across agencies and lead to lasting impact.
As one of our first senior product hires, you will also play a key role in establishing product management practices, building processes from scratch, and mentoring technical teams that are newer to formal product environments. You will work closely with company leadership, cross-functional teams, and government stakeholders to help define the future of Hive Group’s product offerings.
Key Responsibilities :
Define and lead product vision, strategy, and roadmaps that align client requirements with Hive Group’s corporate product goals.
Work directly with government clients and users to deeply understand mission needs and procurement challenges.
Translate client needs and market opportunities into actionable product requirements, epics, and user stories; manage and prioritize product backlogs.
Partner with engineering and delivery teams to develop scalable, reusable solutions that can serve multiple clients and markets.
Build and implement product management systems and processes — including backlog management, release planning, user feedback loops, and documentation — in an environment where formal development practices are still maturing.
Foster product-oriented thinking and mentor cross-functional teams with varied levels of experience in product delivery.
Manage risks, track dependencies, and drive on-time, high-quality product releases.
Work with leadership to identify opportunities for productization, commercialization, and broader market impact.
Contribute to proposals, product demonstrations, and business development efforts.
Participate in occasional onsite client and team events in the National Capital Region (NCR).
Qualifications :
Bachelor’s degree in a relevant field; advanced degree a plus.
8+ years of product management experience, with at least 4 years delivering digital products in a government contracting, procurement, or acquisition-related environment.
Strong ability to balance client-specific objectives with broader corporate technical and scaling goals.
Demonstrated success establishing product management practices and systems in growing, entrepreneurial organizations.
Deep understanding of government contracting and procurement processes, including compliance considerations (FAR, DFARS, CMMC, Section 508, FedRAMP, etc.).
Exceptional client engagement and stakeholder management skills — with direct experience working with federal agency customers.
Proficient in agile methodologies and tools (Jira, Confluence, etc.).
Strong leadership and mentoring skills; ability to inspire and develop cross-functional teams.
Excellent communication — written and verbal — across technical and non-technical audiences.
Public Trust clearance (or ability to obtain).
Preferred :
Experience developing SaaS products or scalable platforms in federal markets.
Familiarity with secure DevSecOps, CI / CD, and modern development environments.
Background in government procurement and acquisition solutions strongly preferred.
Experience with modular architectures and reusable service components.
Compensation and Benefits
The estimated compensation range for this position is between $205,000 and $225,000 annually, based on benchmarks in the Washington, D.C. metropolitan area. This range reflects a good faith estimate for all experience levels. At Hive Group, salary decisions are influenced by several factors, including but not limited to the role, location, and the combination of education, training, skills, certifications, competencies, and relevant work experience.
Hive Group offers a competitive and comprehensive benefits package, including health insurance (medical, dental, vision), life and disability insurance, retirement contributions, paid leave, federal holidays, professional development opportunities, and lifestyle benefits.
A Commitment to Equal Opportunity
Hive Group is an Equal Employment Opportunity and Affirmative Action employer dedicated to fair and unbiased employment decisions. We do not discriminate based on race, color, sex (including gender and transgender status), age, religion, national origin, disability, marital status, veteran status, domestic partner or civil union status, gender identity, medical condition, genetic information, sexual orientation, or any other status protected by applicable federal, state, and local laws.
Our hiring and promotion decisions are based exclusively on an individual’s qualifications and suitability for the role.
Protecting Your Information
Stay vigilant against fraudulent job offers and individuals impersonating Hive Group Talent Acquisition Specialists. Hive Group will never request payment details or money during the application process. Official communications will only come from email addresses ending in @ hive-llc.com or @ applytojob.com — not from free email services like Gmail or messaging platforms such as WhatsApp.
If you receive suspicious messages requesting payment or personal information, please report them immediately to [emailprotected] .

#J-18808-Ljbffr

<h3>Job Description</h3><div>Job Description<div>OverviewCTG is seeking to fill a Data Engineer opening for our client in San Antonio, TX.Location: San Antonio, TX Duration: Permanent PlacementDuties:<ul><li>Work with big data systems and complex structured and unstructured data sets.</li><li>Support government data acquisition, analysis, and sharing efforts.</li><li>Design and maintain software infrastructure for big data scaled ingestion, including integrating new data sources, modifying existing sources, implementing testing, establishing monitoring, and troubleshooting.</li><li>Lead the department in achieving strategic goals, ensuring data integrity, and fostering a collaborative, innovative work environment.</li></ul>Skills:<ul><li>Proficiency in Java (unit and integration testing) and Python; familiarity with SQL schemas and statements.</li><li>Expertise in ETL creation and processing, code debugging, and data modeling design/troubleshooting from ingest to visualization.</li><li>Strong experience with Apache NiFi (administration and building/troubleshooting data flows), AWS S3 (bucket administration), and data flow solutions such as Kafka and AWS SQS.</li><li>Familiarity with JSON, XML, SQL, compressed file formats, and YAML configuration files.</li><li>Proficiency with Maven, GitLab, VSCode, IntelliJ/PyCharm, and Linux OS (BASH).</li><li>Ability to decompose technical problems and troubleshoot both system and dataflow issues.</li><li>Strong documentation and training skills in technical domains.</li><li>Desired: experience with Apache Airflow, Mage AI, Kubernetes, Docker, and Amazon SQS/SNS administration.</li></ul>Experience:<ul><li>Current active TS/SCI eligible Security Clearance.</li><li>Minimum 9 years of experience in software development/engineering, data engineering, database engineering, or related fields (additional 4 years of relevant experience may substitute for a BS degree).</li><li>Experience with unit and integration testing, data extraction, custom translation development, data prep and labeling, and multiple log formats (JSON, XML, etc.).</li><li>Familiarity with Agile environments and cyber/network security operations preferred.</li><li>Experience conducting data model reviews, developing custom logic for data modification, and administering databases and ODBC drivers.</li></ul>Education:<ul><li>Bachelor’s degree in Computer Science, Engineering, or related field preferred; equivalent experience accepted per qualifications above.</li><li>Must be DoD IAT II certified or higher.</li></ul>Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role.To Apply: To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Nicole Shaw at Nicole.Shaw@ctg.com. Kindly forward this to any other interested parties. Thank you!The expected base salary for this position ranges from $150,000 to $196,000. Salary offers are based on a wide range of factors including relevant skills, training, experience, education, market factors, and where applicable, licensure or certifications obtained. In addition to salary, a competitive benefit package is also offered.</div></div>

Database Developer Experience: 4+ years Location: Bangalore Must Have: SQL Development, Azure Data Factory, ETL Processes The Ideal candidate will have a strong command of SQL, experience with ETL processes, and a deep understanding of data modelling and database performance tuning. Key Responsibilities:<ul><li>Design, develop, and maintain complex relational databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL).</li><li>Write efficient and optimized SQL queries, stored procedures, functions, views, and triggers.</li><li>Develop and maintain ETL pipelines for data integration and transformation using tools like SSIS, Azure Data Factory, Informatica PowerCenter.</li><li>Design and implement data models (normalized and denormalized) for transactional and analytical purposes.</li><li>Monitor, maintain, and improve database security, integrity, and availability.</li></ul> Required Skills and Qualifications: <ul><li>4+ years of hands-on experience in database development and management.</li><li>Strong proficiency in SQL and emajor RDBMS (SQL Server, PostgreSQL, Oracle, MySQL).</li><li> ETL tools Azure Data Factory, Informatica PowerCenter, Snowflake.</li><li>building ETL pipelines to load data into Snowflake</li><li>data modelling concepts (star schema, snowflake, normalization).</li><li>performance tuning and query optimization.</li><li>version control systems (e.g., Git) and CI/CD pipelines.</li><li>Experience with cloud-based databases (e.g., Azure SQL, AWS RDS, Google Cloud SQL).</li></ul> Interested Candidates Kindly connect:8180989161swati.aghor@talentcorner.in

Job Overview: The Senior Data Engineer will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our data warehouse. The ideal candidate should have hands-on experience with ETL tools as noted below with strong data analysis skills, and the ability to work with large datasets. <ul><li>Design, develop, and maintain ETL automations using Informatica Cloud and Azure Data Factory </li></ul><ul><li>Develop and Maintain Datawarehouse objects like tables, views and security roles in MS Azure Data Warehouse and Snowflake. </li></ul><ul><li>Extract data from various sources, such as databases, flat files, and APIs, process and post it to required destination storage such as SQL database, Azure blob, Azure table storage, Azure Service Bus, Snowflake, FTP, API etc. </li></ul><ul><li>Transform and cleanse data to ensure data quality and integrity across the data platform. </li></ul><ul><li>Load data into the data warehouses, ensuring data consistency and accuracy. </li></ul><ul><li>Optimize ETL processes for performance, scalability, and reliability. </li></ul><ul><li>Design and develop data dashboards using Microsoft Power BI. </li></ul><ul><li>Work closely with data architects, analysts, and developers to support data integration initiatives. </li></ul><ul><li>Implement data validation, data quality checks, and data security measures across all databases. </li></ul><ul><li>Troubleshoot and resolve data issues, performance bottlenecks, and ETL failures. </li></ul><ul><li>Implement best practices for data warehousing, data modeling, and ETL development. </li></ul><ul><li>Document ETL processes, data mappings, and configurations. </li></ul><ul><li>Strong expertise in writing SQL queries and SQL stored procedures. </li></ul> Total Rewards: <ul><li>Benefits, subject to election and eligibility: Medical, Dental, Vision, Disability, Paid Time Off (including paid parental leave, vacation, and sick time), 401k with company match, Tuition Reimbursement, and Mileage Reimbursement</li><li>Annual bonus based on performance and eligibility</li><li>It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.</li></ul> Requirements: <ul><li>A minimum of 5 years of experience with relational databases, ETL, and data warehouse required. </li><li>Advanced level knowledge of industry leading ETL tools such as Informatica Intelligent Cloud Services and Azure Data Factory </li><li>Strong experience in SQL programming and relational database concepts. </li><li>Hands on experience working with Python, </li><li>Bachelors degree in Computer Science or a related field with five years of related experience, or Masters degree in Computer Science or a related field with at least three years of related experience required. </li><li>Ability to work with different functional groups and levels of employees to effectively and professionally achieve results. </li><li>Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast-paced </li></ul> Company Overview: Keurig Dr Pepper (NASDAQ: KDP) is a leading beverage company in North America, with a portfolio of more than 125 owned, licensed and partners brands and powerful distribution capabilities to provide a beverage for every need, anytime, anywhere. We operate with a differentiated business model and world-class brand portfolio, powered by a talented and engaged team that is anchored in our values. We work with big, exciting beverage brands and the #1 single-serve coffee brewing system in North America at KDP, and we have fun doing it! Together, we have built a leading beverage company in North America offering hot and cold beverages together at scale. Whatever your area of expertise, at KDP you can be a part of a team thats proud of its brands, partnerships, innovation, and growth. Will you join us? We strive to be an?employer of choice, providing a culture and opportunities that empower our team of ~29,000 employees to grow and develop. We offer robust benefits to support your health and wellness as well as your personal and financial well-being. We also provide employee programs designed to enhance your professional growth and development, while ensuring you feel valued, inspired and appreciated at work. Keurig Dr Pepper is an equal opportunity employer and recruits qualified applicants and advances in employment its employees without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, age, disability or association with a person with a disability, medical condition, genetic information, ethnic or national origin, marital status, veteran status, or any other status protected by law.

<div data-field="overview" class="jd-overview">Northside Hospital is award-winning, state-of-the-art, and continually growing. Constantly expanding the quality and reach of our care to our patients and communities creates even more opportunity for the best healthcare professionals in Atlanta and beyond. Discover all the possibilities of a career at Northside today.</div><div data-field="responsibilities" class="jd-responsibilities">OCCUPATIONAL SUMMARYThe Business Data Engineer for Business Intelligence & Data Strategies (BIDS) team is responsible for delivering solutions in both the BI space and Enterprise Data Warehouse (EDW) to benefit Northside Hospital (NSH).  Assists in the design, build and maintain the data infrastructure in order to transform data into actionable insights that can be used to inform business decisions through effective data pipelines. Develops accurate high quality BI reporting, visualizations, analytics and results driven solutions via any of the technologies supported in NSH. The position also requires strategic enterprise data deliverables including but not limited to; properly structuring data in the Enterprise Data Warehouse (EDW), optimizing end user consumables from the EDW, creating mechanisms for non-system specific data to be incorporated into the EDW.  This includes data or solution architecting, data architecting, and maintaining ETL best practices for operations of the EDW.   PRIMARY DUTIES AND RESPONSIBILITIES<ol style="margin-top: 0in;"><li>Collects, defines and translates business requirements into technical data solutions for the building and development of efficient reporting, data pipelines and analytical tools throughout the Finance division and other functional areas of the organization.</li><li style="margin-bottom: 0in;">Understands, efficiently uses and actively contributes to the development of business intelligence tools throughout the organization, which align with strategic goals and initiatives.</li><li style="margin-bottom: 0in;">Contributes to the design, build and maintenance of dashboards, scorecards and reporting analytics to user and scope specifications.</li><li style="margin-bottom: 0in;">Maintains mechanisms to administer manual or automated population of data tables in support of recurring reporting.</li><li style="margin-bottom: 0in;">Design, build and maintenance of data pipelines to optimize data retrieval and insights for specific business needs.</li><li style="margin-bottom: 0in;">Produces technical documentation for programming and reporting efforts.</li><li style="margin-bottom: 0in;">Generates and analyzes data to respond to routine and ad-hoc end user requests.</li><li style="margin-bottom: 0in;">Assist with special systems and analytics projects.</li><li style="margin-bottom: 0in;">Identifies opportunities and recommendations for process improvement within the organization, including process automation and data audits.  Responsible for programming and implementation of said improvements.</li></ol></div><div data-field="qualifications" class="jd-qualifications">KNOWLEDGE SKILLS AND ABILITIES/LICENSE OR CERTIFICATION REQUIRED<ol><li>S. in Computer Science/Information Systems, Industrial Engineering, or related field</li><li>0-2 years related work experience</li><li>Ability to quickly learn and synthesize new technologies</li><li>Aptitude for programming, Structured Query Language (SQL), Data Modeling and/or application design</li><li>Excellent communication, presentation and design skills</li><li>Excellent analytical skills interpreting meaning from data</li><li>Must have excellent technical aptitude and an affinity for data and analysis. </li><li>Must also have the aptitude to learn, engage and utilize new vendor applications and tools quickly. </li></ol>KNOWLEDGE SKILLS AND ABILITIES/LICENSE OR CERTIFICATION PREFERRED<ol><li>1-2 years’ experience in a healthcare environment</li><li>Experience and/or coursework related to scripting, programming and automation</li><li>Experience and/or coursework with database environments - IBM Netezza , Microsoft SQL Server, Oracle.</li><li>Experience and/or coursework with ETL software </li><li>Experience and/or coursework with developing with Business Intelligence Visualization software : Tibco Spotfire, Tableau, PowerBI or Qlikview </li><li>Experience and/or coursework with Python, R, Javascript, CSS, HTML, UNIX, PERL, Powershell or other scripting langages. </li><li>Familiarity with Data mining, Data modeling for applications and data warehousing, Data cleansing, Data and Data standardization  </li></ol></div>

<h3>Job Description</h3><div>Job Description<div>OverviewCTG is seeking to fill a Data Engineer – Data Modeling opening for our client in Houston, TX.Location: Houston, TX Duration: 6 monthsDescription: The Data Engineer – Data Modeling will design and implement data models for applications and related systems, translating business needs into logical and physical data models. The role requires strong expertise in data modeling tools and techniques, including ERWin, MDM, and/or ETL, to support data integration, governance, and analytics initiatives.Duties:<ul><li>Collaborate with business analysts, developers, and stakeholders to gather requirements and translate them into data models.</li><li>Design, develop, and maintain logical and physical data models to support business processes and reporting needs.</li><li>Implement data architecture standards, governance, and best practices.</li><li>Utilize modeling tools such as ERWin or equivalent for data design and documentation.</li><li>Support data integration processes using ETL/ELT frameworks.</li><li>Optimize database performance and data structures for scalability and efficiency.</li><li>Ensure data integrity, consistency, and quality across systems.</li><li>Provide technical guidance and mentorship on data modeling concepts and practices.</li></ul>Skills:<ul><li>Strong understanding of data modeling concepts and methodologies.</li><li>Expertise in data modeling tools (e.g., ERWin).</li><li>Proficiency in SQL for data analysis, optimization, and transformation.</li><li>Hands-on experience with ETL/ELT tools and processes.</li><li>Familiarity with data warehousing and business intelligence platforms.</li><li>Knowledge of master data management (MDM) principles.</li><li>Experience with Snowflake or other modern cloud data platforms (preferred).</li></ul>Experience:<ul><li>5+ years of experience in data engineering, data modeling, or related fields.</li><li>Proven track record in designing and implementing scalable data models.</li><li>Experience working with relational databases, data warehouses, and cloud platforms.</li><li>Background in supporting enterprise-level data integration and analytics solutions.</li></ul>Education:<ul><li>Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field (or equivalent work experience).</li></ul>Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required.CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services for this role.To Apply: To be considered, please apply directly to this requisition using the link provided. For additional information, please contact Jamie Robinson at Jamie.Robinson@ctg.com. Kindly forward this to any other interested parties. Thank you!</div></div>

Question	Topic	Difficulty	Ask Chance
Address Schema	Data Modeling	Medium	Very High
Swipe Payment API	Data Modeling	Easy	High
Bicycle Rental Data Pipeline	Batch & Stream Processing	Medium	High