Data Engineer, Senior Consultant

Data Engineer, Senior Consultant

16 Jun 2024
Georgia, Atlanta, 30361 Atlanta USA

Data Engineer, Senior Consultant

Vacancy expired!

Overview

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 and navigate significant regulatory pressures with a focus on transformational change, business resiliency, and technology-driven innovation. Across a range of advisory, consulting, outsourcing, and digital services, we create scalable, innovative solutions that prepare our clients for future growth and success. The company has more than 10,000 professionals in over 50 locations globally. Guidehouse is a Veritas Capital portfolio company, led by seasoned professionals with proven and diverse expertise in traditional and emerging technologies, markets, and agenda-setting issues driving national and global economies. For more information, please visit: www.guidehouse.com.

Responsibilities

Our Data IT Strategy consultants help our clients improve business value through optimizing the efficiency and effectiveness of their IT capabilities. This high performing group plays a critical role in multi-disciplinary strategy teams. We enable our clients to understand, plan for, and realize strategic opportunities presented by information technology through a collection of capabilities such as Enterprise IT Management, Mission Enablement, and IT Transformation.

The Data Engineer is responsible for the maintenance, synchronization, cleaning, and migration of transactional data in a hybrid environment with both on-prem and highly modern cloud based microservices environment. The Data Engineer works with the product teams in order to understand, analyze, document and efficiently implement to deliver streaming as well as batch oriented data for synchronizing legacy and modern data stores ensuring data integrity.

The Data Engineer provides support to the Application database design to aid in eliminating data duplication and enabling selective event based and schedule based data transfer to endpoints within the cloud and legacy environment as required. The Data Engineer drives towards programmatic pipeline generation and orchestration to enhance repeatability and rapid deployment, using out of the box thinking, AWS native capabilities and CI/CD tools while utilizing established design patterns and methods.

Job Responsibilities:

  • The successful candidate will be able to rapidly develop technical solutions working closely with the integrated product teams and developers with minimal direction from senior or lead resources
  • Understand data needs and be able to construct data pipelines for automating event driven bi-directional selective data replication, along with micro-batch and batch based data pipelines
  • Standardization of data processing modules to deliver modularity and enhance reusability
  • Utilize identified tools and services such as AWS Glue, Python, Streamsets, Step functions and Lambda, Kinesis Data Streams and Data Firehose
  • Create and maintain standards and best practices for data and pipeline standards

Qualifications

Requirements:
  • 5+ years of Data Engineering experience with a heavy focus on data warehousing work using SQL Server, MySQL, NoSQL
  • Experience in designing, implementing, testing, deploying, and maintaining stable, secure, and scalable data engineering solutions and pipelines in support of data and analytics use
  • Must understand data warehouse concepts - star schemas, fact tables, dimensions, partitioning
  • Ability to partner with data analysts and business units to develop code from source to target mapping for the development of new data warehouse, data lake and/or data marts
  • Experience in developing ETL and ELT procedures
  • Ability to partner with business units to understand data usage
  • Understanding of column level security
  • Expert at stored procedures, SQL code
  • Excellent presentation and interpersonal skills - communication is key
  • Experience using the Agile methodology
  • Ability to solve problems and resolve issues independently
  • Willingness and ability to mentor junior team members if requested
  • Excellent command of Microsoft Office (Word, Excel, PowerPoint)
  • Ability to work collaboratively and individually while maintaining customer focus
  • Demonstrated ability to learn new techniques and troubleshoot code without support

Nice to Have:
  • Master's degree in computer science or related
  • Proficiency with Python or R, especially for data manipulation and analysis
  • Experience working with cloud infrastructure services like Azura and Amazon Web Services
  • Knowledge of ETL tools (e.g. Alteryx)
  • Knowledge of BI Tools (e.g. Tableau, Power BI)
  • Relevant professional certifications
  • Prior consulting experience
  • Business development experience


Minimum Degree required: Bachelor's degree in Computer Science or related discipline

Additional Requirements

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

Disclaimer

Disclaimer

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

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

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

Position may be eligible for a discretionary variable incentive

Related jobs

Job Details

Jocancy Online Job Portal by jobSearchi.