Data Engineer - ETL Developer

Company: Guidehouse
Location: Sterling
Posted on: March 20, 2023

Job Description:

Job Family:Data Engineering & Architecture ConsultingTravel Required:NoneClearance Required:NoneWhat You Will Do: Our consultants on the Advanced Analytics & Intelligent Automation (AAIA) team help clients maximize the value of their data and automate business processes. This high performing team works with clients to implement the full spectrum of data analytics and data science, from data engineering and data wrangling to data visualization and dashboarding, to predictive analytics, machine learning, and artificial intelligence as well as robotic process automation (RPA). Our services enable our clients to define their information strategy, enable mission critical insights and data-driven decision making, reduce cost and complexity, increase trust, and improve operational effectiveness. Our consultants focus on client services, while also supporting business development, internal firm initiatives, and ongoing professional development. - Belong to a collaborative AAIA team. - Focus on client services, while also supporting business development, internal firm initiatives, and professional development in data engineering or data science software, methods, and consulting. - Support client engagements as a data engineer partnering with data scientists, analysts, and cross-functional teams to discover, collect, cleanse, and refine data for analysis and modeling. - Perform complex data queries. - Manage ETL (Extract, Transform, Load) functions and develop, build, test, and maintain scalable data pipeline architectures and tools. - Work with data integration and management tools and databases. - Understand client needs and translate them to technical requirements. What You Will Need:

• U.S. citizenship and ability to obtain a Public Trust clearance.
• B.S./B.A. in Computer Science, Information Systems, or similar computational discipline.
• 3+ years of relevant professional experience as a data engineer.
• Expertise designing and developing interrogating databases with Structured Query Language (SQL) to develop complex queries involving joins, subqueries, aggregation, indices, common table expressions, and query optimization.
• Experience developing complex data pipelines and extract - transform - load (ETL) processes and performing data engineering for various types of data, files, and repositories.
• Experience using tools such as IBM Infosphere / DataStage, Informatica, or similar ETL tools.
• Ability to move and manipulate data of different types and file types using Python.
• Technical expertise with data models, data mining, data cleansing, and segmentation techniques.
• Skills in applying pattern recognition techniques to large structured, semi-structured, and unstructured data sets to automate and optimize data wrangling (extract, transform, clean, evaluate, normalize/standardize, and organize) from disparate sources.
• Experience as a data engineer to provide and prepare data to enable data science and machine learning.
• Strong understanding of relational databases, columnar data warehouses, NoSQL, and other storage types.
• Experience gathering requirements, designing, implementing, and testing database systems.
• Knowledge/experience designing and building distributed systems for scalability and security.
• Understanding of Agile development methodologies.
• Strong consulting skills: identifying and addressing needs, building relationships, being flexible, being creative, communicating effectively to technical and non-technical stakeholders.What Would Be Nice To Have:
  • Familiarity with DevOps and container technologies (Docker/Kubernetes).
  • Ability to instrument basic automation and CI/CD.
  • Experience using Databricks.
  • Experience with micro services architecture and API gateways.
  • Experience with source code version control technologies such as Git.
  • Ability to code and debug stored procedures.
  • Experience programming in Java.
  • Understanding of NoSQL databases.
  • Experience architecting data solutions in cloud environments (AWS, Azure, GCP).
  • Ability to support business development including RFP/RFQ/RFI responses or white papers.
  • Knowledge of and experience supporting the Federal sector.What We Offer:Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.Benefits include:
    • Medical, Rx, Dental & Vision Insurance
    • Personal and Family Sick Time & Company Paid Holidays
    • Position may be eligible for a discretionary variable incentive bonus
    • Parental Leave and Adoption Assistance
    • 401(k) Retirement Plan
    • Basic Life & Supplemental Life
    • Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
    • Short-Term & Long-Term Disability
    • 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 StipendAbout GuidehouseGuidehouse is an Equal Employment Opportunity / Affirmative Action employer. 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 basis protected by law, ordinance, or regulation.Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.If you have visited our website for information about employment opportunities, or to apply for a position, and you require an accommodation, please contact Guidehouse Recruiting at 1- or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation. Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.

Keywords: Guidehouse, Sterling , Data Engineer - ETL Developer, Engineering , Sterling, Virginia