Job Description
** Job Family :**
Data Engineering & Architecture Consulting
** Travel Required :**
None
** Clearance Required :**
Active Secret
** What You Will Do :**
Our consultants focusing on data engineering and architecture help clients maximize the value of their data. These high performing individuals works with clients to implement the full spectrum of data analytics and data science services, from data querying and wrangling to data engineering, to data visualization, dashboarding, and business intelligence (BI), to predictive analytics, machine learning (ML), and artificial intelligence (AI). 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.
Provide the full spectrum of data science services to support the mission of National Security clients.
Engage clients to define requirements, elicit feedback, and communicate results.
Collaborate with other data science and analytics professionals across our Defense & Security segment and provide data science / data analytics / business intelligence services on cross-functional teams delivering other consulting services as well.
Work as a data engineer and ETL (Extract, Transform, Load) developer for various data types and file types in collaboration with cross-functional teams.
Manage ETL functions and develop, build, test, and maintain scalable data pipeline architectures and tools.
Work with data integration and management tools and databases.
Gather requirements, design, implement, and test database systems.
Design and develop databases with Structured Query Language (SQL) and develop complex queries involving joins, subqueries, aggregation, indices, common table expressions, and query optimization.
Move and manipulate data of different types and file types using Python.
Provide and prepare data to enable data science and machine learning.
Demonstrate strong understanding of relational databases, columnar data warehouses, data lakes, NoSQL, and other storage types.
Work in cloud-based databases and ETL architecture.
Work with Azure and Databricks.
Design and build distributed systems for scalability and security.
Write technical process documentation.
Communicate/present ideas, methods, and results to clients, and explain technical topics to non-technical audiences.
Operate successfully on remote projects as well as 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 similar analytical and computational discipline.
3+ years of relevant professional experience.
Proficiency designing and developing databases with Structured Query Language (SQL) and performing complex queries.
Proficiency developing complex data pipelines and extract – transform – load (ETL) processes.
Proficiency moving and manipulating data of different types and file types using Python.
Strong understanding of different types of data storage.
Experience working in cloud-based databases and architecture.
Familiarity with Azure and Databricks.
Ability to support 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 similar analytical and computational discipline.
6+ years of relevant professional experience.
Experience architecting data solutions in Azure.
Experience using Databricks.
Familiarity with DevOps and container technologies (Docker/Kubernetes).
Ability to implement basic automation and CI/CD.
Experience with micro services architecture and API gateways.
Technical expertise with 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 :**
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 Stipend
_ About Guidehouse_
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.