• Cloud Data Architect (Secret)

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

    Interested in working with talented people to help develop innovative solutions to some of society’s most complex and challenging problems?  We are Guidehouse, a leading consulting firm serving the public sector and commercial clients with specialized capabilities in strategy, technology, and risk management.  You may not yet know our name, but we have a rich history.  Guidehouse is a combination of PwC’s former public sector practice and Navigant’s deep expertise in energy, financial services and healthcare.


    We offer an exciting, fast-paced environment that fosters intellectual growth and rewards individuals based on impact, not tenure. Our firm is at the forefront of an emerging model solving complex problems that stretch across government and private companies, affording our people the opportunity to be on the cutting edge of the consulting profession. By focusing on markets facing transformational change, technology-driven innovation, and significant regulatory pressure, our employees also develop and deploy world class knowledge and problem solving that leads to breakthrough solutions.


    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.


    About Guidehouse 

    With a unique blend of large firm resources and an entrepreneurial collaborative culture, Guidehouse is where your purpose, passion, and expertise transforms organizations.

    Guidehouse is a leading global provider of consulting services to the public and commercial markets with broad capabilities in management, technology, and risk consulting. We help clients address their toughest challenges with a focus on markets and clients facing transformational change, technology-driven innovation and significant regulatory pressure. Across a range of advisory, consulting, outsourcing, and technology/analytics services, we help clients create scalable, innovative solutions that prepare them for future growth and success.  Headquartered in Washington DC, the company has more than 7,000 professionals in more than 50 locations.

    If you’re passionately motivated to make a difference and deliver exceptional work, we invite you to learn more about your career opportunities at www.guidehouse.com

    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 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-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 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.


    Rewards and Benefits

    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