Know ATS Score
CV/Résumé Score
  • Expertini Resume Scoring: Our Semantic Matching Algorithm evaluates your CV/Résumé before you apply for this job role: Data Engineer (Mid).
United States Jobs Expertini

Urgent! Data Engineer (Mid) Job Opening In Parsons – Now Hiring Imagine Believe Realize, LLC

Data Engineer (Mid)



Job description

Overview


Do you want to help build a portfolio of next-generation mobile-enabled data collection systems and enterprise portals?

As a Data Engineer at IBR, you will support the Agile based engineering of robust, secure, and scalable enterprise web portal solutions hosted in AWS.

This position will work closely with the solutions delivery team to support the operations team performing Deployment, Systems Integration Testing, and Operations & Maintenance activities.



Responsibilities

  • Plan, create, and maintain data architectures, ensuring alignment with business requirements
  • Obtain data, formulate dataset processes, and store optimized data
  • Identify problems and inefficiencies and apply solutions
  • Determine tasks where manual participation can be eliminated with automation.
  • Identify and optimize data bottlenecks, leveraging automation where possible
  • Create and manage data lifecycle policies (retention, backups/restore, etc)
  • In-depth knowledge for creating, maintaining, and managing ETL/ELT pipelines
  • Create, maintain, and manage data transformations
  • Maintain/update documentation
  • Create, maintain, and manage data pipeline schedules
  • Monitor data pipelines
  • Create, maintain, and manage data quality gates (Great Expectations) to ensure high data quality
  • Support AI/ML teams with optimizing feature engineering code
  • Expertise in Spark/Python/Databricks, Data Lake and SQL
  • Create, maintain, and manage Spark Structured Steaming jobs, including using the newer Delta Live Tables and/or DBT
  • Research existing data in the data lake to determine best sources for data
  • Create, manage, and maintain ksqlDB and Kafka Streams queries/code
  • Data driven testing for data quality
  • Maintain and update Python-based data processing scripts executed on AWS Lambdas
  • Unit tests for all the Spark, Python data processing and Lambda codes
  • Maintain PCIS Reporting Database data lake with optimizations and maintenance (performance tuning, etc)
  • Streamlining data processing experience including formalizing concepts of how to handle lake data, defining windows, and how window definitions impact data freshness.
  • Qualifications

  • 5+ years of IT experience focusing on enterprise data architecture and management
  • Must be able to obtain a Public Trust security clearance
  • Bachelor degree required
  • Experience in Conceptual/Logical/Physical Data Modeling & expertise in Relational and Dimensional Data Modeling
  • Experience with Databricks, Structured Streaming, Delta Lake concepts, and Delta Live Tables required Additional experience with Spark, Spark SQL, Spark DataFrames and DataSets, and PySpark Data Lake concepts such as time travel and schema evolution and optimization Structured Streaming and Delta Live Tables with Databricks a bonus
  • Experience leading and architecting enterprise-wide initiatives specifically system integration, data migration, transformation, data warehouse build, data mart build, and data lakes implementation / support Advanced level understanding of streaming data pipelines and how they differ from batch systems Formalize concepts of how to handle late data, defining windows, and data freshness Advanced understanding of ETL and ELT and ETL/ELT tools such as SSIS, Pentaho, Data Migration Service etc Understanding of concepts and implementation strategies for different incremental data loads such as tumbling window, sliding window, high watermark, etc.

    Familiarity and/or expertise with Great Expectations or other data quality/data validation frameworks a bonus Understanding of streaming data pipelines and batch systems Familiarity with concepts such as late data, defining windows, and how window definitions impact data freshness
  • Advanced level SQL experience (Joins, Aggregation, Windowing functions, Common Table Expressions, RDBMS schema design, Postgres performance optimization) Indexing and partitioning strategy experience
  • Debug, troubleshoot, design and implement solutions to complex technical issues
  • Experience with large-scale, high-performance enterprise big data application deployment and solution
  • Understanding how to create DAGs to define workflows
  • Familiarity with CI/CD pipelines, containerization, and pipeline orchestration tools such as Airflow, Prefect, etc a bonus but not required
  • Architecture experience in AWS environment a bonus Familiarity working with Kinesis and/or Lambda specifically with how to push and pull data, how to use AWS tools to view data in Kinesis streams, and for processing massive data at scale a bonus Experience with Docker, Jenkins, and CloudWatch Ability to write and maintain Jenkinsfiles for supporting CI/CD pipelines Experience working with AWS Lambdas for configuration and optimization Experience working with DynamoDB to query and write data Experience with S3
  • Knowledge of Python (Python 3 desired) for CI/CD pipelines a bonus Familiarity with Pytest and Unittest a bonus
  • Experience working with JSON and defining JSON Schemas a bonus
  • Experience setting up and management Confluent/Kafka topics and ensuring performance using Kafka a bonus Familiarity with Schema Registry, message formats such as Avro, ORC, etc.

    Understanding how to manage ksqlDB SQL files and migrations and Kafka Streams
  • Ability to thrive in a team-based environment
  • Experience briefing the benefits and constraints of technology solutions to technology partners, stakeholders, team members, and senior level of management
  • Physical Demands and Work Environment

    While this position primarily involves sedentary work in an office environment and/or home-office environment, there are some physical demands associated with the role, including:

  • Extended periods of sitting and working at a computer workstation.
  • Occasional lifting and carrying of equipment or materials weighing up to 20 pounds.
  • Occasional travel to client sites or meetings may be required.
  • Work may need to be performed in a fast-paced environment requiring quick thinking and rapid judgements.
  • Additionally, flexible work arrangements may be available based on business needs.
  • Employee will be exposed to a wide variety of clients in differing functions, personalities, and abilities.
  • About IBR

    Imagine Believe Realize, LLC (IBR) is an emerging small business focused on delivering software and systems engineering solutions to government and commercial clients.

    Our talent acquisition strategy is tailored to career seeking candidates who embrace continuous learning and desire to grow as a professional in the software/systems engineering industry.

    We strive to enhance our team members ability to thrive in the workplace by creating a proper work/life balance and first-class benefits package that includes:

  • Nationwide medical, dental, and vision insurance
  • 3 weeks of Paid Time Off and 11 Paid Federal Holidays
  • 401k matching
  • Life Insurance, Short-Term Disability, and Long-Term Disability at no cost to our employees
  • Flexible spending accounts and Dependent Care spending accounts
  • Wellness incentives
  • Reimbursement for professional development and certifications
  • Training assistance opportunities
  • Upon hire and in compliance with federal law, all persons hired are required to verify identity and eligibility to work in the United States, and to complete the required employment eligibility verification and background check.

    IBR is a Federal Contractor.

    Imagine Believe Realize, LLC is proud to be an Equal Opportunity and Affirmative Action Employer.

    We do not discriminate based upon race, age, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.”


    Required Skill Profession

    Computer Occupations



    Your Complete Job Search Toolkit

    ✨ Smart • Intelligent • Private • Secure

    Start Using Our Tools

    Join thousands of professionals who've advanced their careers with our platform

    Rate or Report This Job
    If you feel this job is inaccurate or spam kindly report to us using below form.
    Please Note: This is NOT a job application form.


      Unlock Your Data Engineer Potential: Insight & Career Growth Guide


    • Real-time Data Engineer Jobs Trends in Parsons, United States (Graphical Representation)

      Explore profound insights with Expertini's real-time, in-depth analysis, showcased through the graph below. This graph displays the job market trends for Data Engineer in Parsons, United States using a bar chart to represent the number of jobs available and a trend line to illustrate the trend over time. Specifically, the graph shows 207475 jobs in United States and 5 jobs in Parsons. This comprehensive analysis highlights market share and opportunities for professionals in Data Engineer roles. These dynamic trends provide a better understanding of the job market landscape in these regions.

    • Are You Looking for Data Engineer (Mid) Job?

      Great news! is currently hiring and seeking a Data Engineer (Mid) to join their team. Feel free to download the job details.

      Wait no longer! Are you also interested in exploring similar jobs? Search now: .

    • The Work Culture

      An organization's rules and standards set how people should be treated in the office and how different situations should be handled. The work culture at Imagine Believe Realize, LLC adheres to the cultural norms as outlined by Expertini.

      The fundamental ethical values are:
      • 1. Independence
      • 2. Loyalty
      • 3. Impartiality
      • 4. Integrity
      • 5. Accountability
      • 6. Respect for human rights
      • 7. Obeying United States laws and regulations
    • What Is the Average Salary Range for Data Engineer (Mid) Positions?

      The average salary range for a varies, but the pay scale is rated "Standard" in Parsons. Salary levels may vary depending on your industry, experience, and skills. It's essential to research and negotiate effectively. We advise reading the full job specification before proceeding with the application to understand the salary package.

    • What Are the Key Qualifications for Data Engineer (Mid)?

      Key qualifications for Data Engineer (Mid) typically include Computer Occupations and a list of qualifications and expertise as mentioned in the job specification. Be sure to check the specific job listing for detailed requirements and qualifications.

    • How Can I Improve My Chances of Getting Hired for Data Engineer (Mid)?

      To improve your chances of getting hired for Data Engineer (Mid), consider enhancing your skills. Check your CV/Résumé Score with our free Tool. We have an in-built Resume Scoring tool that gives you the matching score for each job based on your CV/Résumé once it is uploaded. This can help you align your CV/Résumé according to the job requirements and enhance your skills if needed.

    • Interview Tips for Data Engineer (Mid) Job Success
      Imagine Believe Realize, LLC interview tips for Data Engineer (Mid)

      Here are some tips to help you prepare for and ace your job interview:

      Before the Interview:
      • Research: Learn about the Imagine Believe Realize, LLC's mission, values, products, and the specific job requirements and get further information about
      • Other Openings
      • Practice: Prepare answers to common interview questions and rehearse using the STAR method (Situation, Task, Action, Result) to showcase your skills and experiences.
      • Dress Professionally: Choose attire appropriate for the company culture.
      • Prepare Questions: Show your interest by having thoughtful questions for the interviewer.
      • Plan Your Commute: Allow ample time to arrive on time and avoid feeling rushed.
      During the Interview:
      • Be Punctual: Arrive on time to demonstrate professionalism and respect.
      • Make a Great First Impression: Greet the interviewer with a handshake, smile, and eye contact.
      • Confidence and Enthusiasm: Project a positive attitude and show your genuine interest in the opportunity.
      • Answer Thoughtfully: Listen carefully, take a moment to formulate clear and concise responses. Highlight relevant skills and experiences using the STAR method.
      • Ask Prepared Questions: Demonstrate curiosity and engagement with the role and company.
      • Follow Up: Send a thank-you email to the interviewer within 24 hours.
      Additional Tips:
      • Be Yourself: Let your personality shine through while maintaining professionalism.
      • Be Honest: Don't exaggerate your skills or experience.
      • Be Positive: Focus on your strengths and accomplishments.
      • Body Language: Maintain good posture, avoid fidgeting, and make eye contact.
      • Turn Off Phone: Avoid distractions during the interview.
      Final Thought:

      To prepare for your Data Engineer (Mid) interview at Imagine Believe Realize, LLC, research the company, understand the job requirements, and practice common interview questions.

      Highlight your leadership skills, achievements, and strategic thinking abilities. Be prepared to discuss your experience with HR, including your approach to meeting targets as a team player. Additionally, review the Imagine Believe Realize, LLC's products or services and be prepared to discuss how you can contribute to their success.

      By following these tips, you can increase your chances of making a positive impression and landing the job!

    • How to Set Up Job Alerts for Data Engineer (Mid) Positions

      Setting up job alerts for Data Engineer (Mid) is easy with United States Jobs Expertini. Simply visit our job alerts page here, enter your preferred job title and location, and choose how often you want to receive notifications. You'll get the latest job openings sent directly to your email for FREE!