• Cloud Data Architect (Secret)

    Job Locations US-Washington DC | US-VA-McLean
    Client Services
    Regular Full-Time
  • Overview

    What do you get when you bring together the brightest minds and place them into an exciting, fast-paced environment that fosters intellectual growth and rewards based on impact, not tenure?


    You get one of the fastest growing consulting companies in the United States. While we may be a new name in consultancy, we were born from a storied one. Guidehouse was founded in 2018 as an evolution of PwC Public Sector with a mission to help our clients deliver on their mission; providing bold new strategies that catalyze transformative results across all ends of the enterprise. We embrace brilliance. We embrace independence. Join us.


    Build the future of Data Science as part of the Artificial Intelligence Center of Excellence (CoE). The CoE is a unique team within Guidehouse, focusing on solving our client’s most important challenges using Data and Advanced Analytics, AI, and Automation. As one of the top Public Sector professional services firms, the CoE works on a huge variety of projects; from predictive analytics models to support our healthcare and financial services divisions, to open source analysis for federal agencies, and deep learning initiatives for advanced analysis. As part of Guidehouse’s Data Analytics team, you will work on high-impact and high-visibility projects, helping to shape not only Guidehouse’s current business, but its long term strategy.


    This role involves working in a complex, multi-functional, Agile team environment with other data scientists, engineers, and UI/UX developers to develop and productionize analytics solutions. The Cloud Data Architect is involved in many aspects of a customer engagement; from the collaboration with other team members and customers to help stakeholders discover the information hidden in vast amounts of data, and help them make smarter decisions to deliver even better products. The primary focus will be in applying data mining techniques, doing statistical analysis, data preparation and building high quality prediction systems integrated with cloud enabled products.

    • 5+ years in a data engineering role with demonstrable experience with data systems, data integration, data mining, AI, big data platforms, and automating machine learning components.
    • Min. 1 year of experience with below technologies is mandatory.
    • HDInsight
    • Databricks * Strong experience in Azure Big Data Technologies like Azure Data Lake, HDInsights etc.
    • Microsoft Cognitive Services.
    • Strong experience in any database technology (SQL Server / Azure Cosmos DB)
    • Strong experience in at least one programming language (i.e. C#, Python, R).
    • Experience implementing and automating models created by data science teams (i.e. Spark, Scala, Hive, Python, R, etc.)
    • Experience with data modeling and normalization concepts.
    • Experience with data visualizations tools like SSRS, PowerBI & Tableau.
    • Experience architecting and building data marts, warehouses, etc.
    • Experience working with different query languages (i.e. PL-SQL, T-SQL).
    • Understanding and experience working with cloud infrastructure services like Azure, Amazon Web Services & Google Cloud. Azure preferred.
    • Experience working with code repositories and continuous integration (i.e. Git, Jenkins, etc.)
    • Understanding of development and project methodologies.
    • Ability to work collaboratively in teams with other specialized individuals.
    • Able to work in a fast-paced, technical environment.




    • Bachelor’s degree in Computer Science, Engineering, Applied Mathematics, Statistics, Data Management or related fields.
    • 3+ years experience in the data warehouse space preferably with cloud based Data Warehouse technologies (i.e. RedShift)
    • 2+ years experience in the Big Data space (Hadoop, Spark, HDInsight).
    • 2+ years experience building Data Lakes
    • 3+ years experience in custom ETL design, implementation and maintenance.
    • 2+ years experience working with either a MapReduce or an MPP system.
    • 2+ years experience with object-oriented programming languages.
    • 2+ years experience with schema design and dimensional data modeling.
    • 3+ years experience in creating SQL statements.
    • Experience analyzing data to identify deliverables, gaps and inconsistencies.
    • Experience managing and communicating data warehouse plans to internal clients.
    • At least one Cloud certification in AWS or Azure
    • Security Clearance: Secret


    Additional Desired Skills: 

    • 2+ years of experience in building cloud Data Lakes to support Data Analytics and Machine Learning tasks.
    • 1+ years of experience in AWS Redshift, schema design, system performance & optimization, capacity planning. Preferably AWS Big Data Architect Certification or equivalent.
    • Proven ability to design, develop, and maintain data warehousing and ETL work flows for large data sets and interact with various sources
    • Knowledge of industry standard ETL tools (AWS Glue or other 3rd party), as well as writing your own utilizing Python is preferred
    • Working experience with Amazon Web Services (S3, EC2, RedShift, EMR)
    • Experience in data analytics, business intelligence, or data science
    • Hands-on experience as a DBA as well as knowledge in using advanced SQL/MYSQL queries (analytical functions)
    • Strong programming and scripting skills (Python experience is a plus)



    Additional Requirements


    • This position requires successful completion of a background check and employment verification.
    • The successful candidate must not be subject to employment restrictions from a former employer (such as a non-compete) that would prevent the candidate from performing the job responsibilities as described.


    Guidehouse is an affirmative action and equal opportunity employer. Employment decisions will be made without regard to race, color, religion, sex, age, national origin, military status, veteran status, handicap, physical or mental disability, sexual orientation, gender identity, genetic information or other characteristics protected by law.


    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-571-633-1711 or via email at RecruitingAccommodation@guidehouse.com. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.


    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
    • Parental Leave and Adoption Assistance
    • 401(k) Retirement Plan
    • Student Loan Paydown
    • Basic Life & Supplemental Life
    • Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
    • Short-Term & Long-Term Disability
    • Tuition Reimbursement, Personal Development & Learning Opportunities
    • Skills Development & Certifications
    • Employee Referral Program
    • Corporate Sponsored Events & Community Outreach
    • Emergency Back-Up Childcare Program


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed