Employer Active
Job Alert
You will be updated with latest job alerts via emailJob Alert
You will be updated with latest job alerts via emailNot Disclosed
Salary Not Disclosed
1 Vacancy
Job Family:
Software Development & Support (Digital)
Travel Required:
Clearance Required:
What You Will Do:
The Data Engineer will work closely with clients solutions architects and technical/functional leads across Guidehouse digital teams and market segments to support client projects and provide solutions for growth efforts and capabilities build out.
Function as a key data team member to develop data pipelines transformation rules embedding compliance rules and controls to ensure data quality and regulatory compliance.
Extract data from vendor systems transform into canonical models and upload to tools like Snowflake ensuring data integrity and consistency across enterprise data platforms.
Work collaboratively with data scientists analytics engineers business analysts solution architects and compliance teams to design build test and deploy data products and pipelines that satisfy functional and regulatory requirements.
Analyze data dependencies and structures to optimize data flow and ensure efficient data processing across complex enterprise systems.
Support data integration initiatives including API-based data ingestion real-time data processing and batch data transformation workflows.
What You Will Need:
US Citizen Green Card Green Card EAD
Bachelors degree. Additional Four(4) years of experience will be needed in lieu of the degree
5 years of experience in data tools pipelines and data transformation techniques
Strong proficiency in programming languages like SQL and Python with demonstrated expertise in data manipulation and analysis
Experience with ETL/ELT tools and processes (Snowflake preferred) for large-scale data processing and transformation
Proven ability to work collaboratively with diverse teams and contribute to complex data engineering projects
Understanding financial data regulations and compliance requirements with ability to embed compliance controls in data processes
Technical Requirements:
Core Programming Skills: Strong SQL knowledge and Python proficiency for data processing and automation
Database Technologies: Experience with DB2 and Snowflake for data storage retrieval and management
Data Integration: Experience with data integration techniques and APIs for connecting disparate data sources
ETL/ELT Processing: Hands-on experience with data extraction transformation and loading processes
Data Modeling: Understanding of data modeling schema design and database management principles
Cloud Platforms: Knowledge of cloud platforms and Big Data technologies for scalable data solutions
Data Analysis: Ability to analyze data dependencies and structures to optimize data architecture
Understanding of data modeling schema design and database management with focus on creating efficient and scalable data structures.
Knowledge of cloud platforms and Big Data technologies to support modern data engineering solutions.
What Would Be Nice To Have:
Certifications: - Snowflake Certified Data Engineer or AWS Certified Data Analytics Specialty.
Additional Technologies:
Experience with data orchestration tools (Airflow Prefect Dagster)
Knowledge of streaming data technologies (Kafka Kinesis)
Familiarity with data quality and data governance tools
Experience with version control systems (Git) and CI/CD pipelines
Understanding of data lineage and metadata management
Experience in the Financial Services industry.
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
Parental Leave
401(k) Retirement Plan
Group Term Life and Travel Assistance
Voluntary Life and AD&D Insurance
Health Savings Account Health Care & Dependent Care Flexible Spending Accounts
Transit and Parking Commuter Benefits
Short-Term & Long-Term Disability
Tuition Reimbursement Personal Development Certifications & Learning Opportunities
Employee Referral Program
Corporate Sponsored Events & Community Outreach
annual membership
Employee Assistance Program
Supplemental Benefits via Corestream (Critical Care Hospital Indemnity Accident Insurance Legal Assistance and ID theft protection etc.)
Position may be eligible for a discretionary variable incentive bonus
About Guidehouse
Guidehouse is an Equal Opportunity EmployerProtected Veterans Individuals with Disabilities 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.
All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @ or . Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.
If any person or organization demands money related to a job opportunity with Guidehouse please report the matter to Guidehouses Ethics Hotline. If you want to check the validity of correspondence you have received please contact . Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicants dealings with unauthorized third parties.
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.
Full-Time