Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Data Engineer – ETL Developer

J

Jobs for Humanity

Data Engineer – ETL Developer

Arlington, VA
Full Time
Paid
Similar Jobs
  • Responsibilities

    Job Description

    ** Job Title :**

    Data Engineering & Architecture Consultant

    ** Travel Requirement :**

    None

    ** Clearance Requirement :**

    Active Secret

    ** What You Will Do :**

    We are seeking consultants who specialize in data engineering and architecture to help clients make the most of their data. Our consultants work closely with clients to provide a range of data analytics and data science services, including data querying, wrangling, engineering, visualization, business intelligence (BI), predictive analytics, machine learning (ML), and artificial intelligence (AI). These services help our clients define their information strategy, gain valuable insights, make data-driven decisions, reduce costs, increase trust, and improve efficiency.

    • Deliver a comprehensive range of data science services to support the mission of National Security clients.

    • Collaborate with clients to understand their requirements, gather feedback, and communicate results effectively.

    • Work closely with other data science and analytics professionals in our Defense & Security segment to provide data science, data analytics, and business intelligence services in cross-functional teams.

    • Collaborate with cross-functional teams as a data engineer and ETL (Extract, Transform, Load) developer, handling various data types and file formats.

    • Manage ETL functions, develop, build, test, and maintain scalable data pipeline architectures and tools.

    • Work with data integration and management tools, as well as databases.

    • Gather requirements, design, implement, and test database systems.

    • Design and develop databases using Structured Query Language (SQL) and create complex queries involving joins, subqueries, aggregation, indices, common table expressions, and query optimization.

    • Manipulate and move data of different types and file formats using Python.

    • Prepare and provide data for data science and machine learning purposes.

    • Demonstrate strong understanding of relational databases, columnar data warehouses, data lakes, NoSQL, and other storage types.

    • Work with cloud-based databases and ETL architecture.

    • Utilize Azure and Databricks in projects.

    • Design and build scalable and secure distributed systems.

    • Create technical process documentation.

    • Effectively present ideas, methods, and results to clients, and explain technical concepts to non-technical audiences.

    • Successfully work on remote projects and hybrid on-site projects in the DC metro area.

    ** What You Will Need :**

    • An ACTIVE and CURRENT SECRET federal security clearance

    • B.S. in Computer Science, Information Systems, or a similar analytical and computational discipline.

    • At least 3 years of relevant professional experience.

    • Proficiency in designing and developing databases using Structured Query Language (SQL) and performing complex queries.

    • Expertise in developing complex data pipelines and extract-transform-load (ETL) processes.

    • Ability to manipulate and move data of different types and file formats using Python.

    • A strong understanding of various types of data storage.

    • Experience working with cloud-based databases and architecture.

    • Familiarity with Azure and Databricks.

    • Ability to work on remote projects and hybrid on-site projects in the DC metro area.

    ** What Would Be Nice To Have :**

    • An ACTIVE and CURRENT TOP SECRET federal security clearance

    • M.S. in Computer Science, Information Systems, or a similar analytical and computational discipline.

    • At least 6 years of relevant professional experience.

    • Experience in architecting data solutions in Azure.

    • Experience using Databricks.

    • Familiarity with DevOps and container technologies (Docker/Kubernetes).

    • Ability to implement basic automation and continuous integration/continuous deployment (CI/CD).

    • Experience with microservices architecture and API gateways.

    • Technical expertise in data models, data mining, data cleansing, and segmentation techniques.

    • Experience with source code version control technologies, such as Git.

    • Ability to code and debug stored procedures.

    • Experience supporting Federal National Security organizations.

    ** What We Offer :**

    At Guidehouse, we provide a comprehensive total rewards package that includes competitive compensation and flexible benefits, reflecting our commitment to creating an inclusive and supportive workplace.

    Our benefits include:

    • Medical, Rx, Dental & Vision Insurance

    • Personal and Family Sick Time & Company Paid Holidays

    • Eligibility for discretionary variable incentive bonus

    • Parental Leave and Adoption Assistance

    • 401(k) Retirement Plan

    • Basic Life & Supplemental Life Insurance

    • Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts

    • Short-Term & Long-Term Disability Insurance

    • Student Loan PayDown

    • Tuition Reimbursement, Personal Development & Learning Opportunities

    • Skills Development & Certifications

    • Employee Referral Program

    • Corporate Sponsored Events & Community Outreach

    • Emergency Back-Up Childcare Program

    • Mobility Stipend

    _ About Guidehouse_
    Guidehouse is committed to Equal Employment Opportunity/Affirmative Action. We value and strive for diversity in our workforce. All qualified applicants will receive consideration for employment without regard to race, color, national origin, ancestry, citizenship status, military status, protected veteran status, religion, creed, physical or mental disability, medical condition, marital status, sex, sexual orientation, gender, gender identity or expression, age, genetic information, or any other protected characteristic, status or activity.

    Guidehouse will consider qualified individuals with criminal histories for employment in a manner consistent with applicable law or ordinance, including the Fair Chance Ordinance of Los Angeles and San Francisco.

    If you require accommodation due to a disability in order to access opportunities at Guidehouse, please contact Guidehouse Recruiting at 1-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com. We respect your privacy and will handle your request confidentially, using the information provided solely for the purpose of providing the necessary accommodation.

    Note: Guidehouse does not accept unsolicited resumes from search firms or staffing agencies. All unsolicited resumes submitted become the property of Guidehouse, and Guidehouse will not be obligated to pay a placement fee.