KPMG Associate, Data Engineer in Irvine, California
Associate, Data Engineer
Requisition #: 36610
Practice Area: Business Support Services
Location: Irvine, CA; Atlanta, GA; Chicago, IL; New York, NY; Philadelphia, PA; Knoxville, TN
Innovate. Collaborate. Shine. Lighthouse – KPMG's Center of Excellence for Advanced Analytics – has both applied data science, AI, and big data architecture capabilities. Here, you'll work with a diverse team of sophisticated data and analytics professionals to explore the solutions for clients in a platform-diverse environment. This means your ability to find answers is limited only by your creativity in leveraging a vast array of techniques and tools. Be a part of a high-energy, diverse, fast-paced, and innovative culture that delivers with the agility of a tech startup and the backing of a leading global consulting firm. For you, that translates into the chance to work on a wide range of projects – covering technologies and solutions from AI to optimization – and the power to have a real impact in the business world. So, bring your creativity and pioneering spirit to KPMG Lighthouse.
KPMG is currently seeking an Associate to join our- Center of Excellence for Advanced Analytics.
Rapidly prototype, develop, and optimize D&A implementations to tackle the BI/EDW/Big Data and Data Science needs for a variety of Fortune 1000 corporations and other major organizations
Develop and maintain D&A solutions on premise/cloud/KPMG-hosted/hybrid infrastructure; be the team champion of some mainstream BI/EDW/Big Data toolsets like Tableau, Alteryx, Informatica, Pentaho, Er-Win and Power Designer
Play the role of data owner in cross-disciplinary teams; Build logical/physical data models
Discover, profile, acquire, process, model, and own data for the solutions; Implement data processing pipelines, data mining/science algorithms, and visualization engineering to help clients distill insights from rich data sources, including social media, news, internal/external documents, emails, financial data, client data and operational data
Help in research and experiment of leading/emerging BI/EDW/Big Data methodologies, such as serverless data lake, AWS Redshift, Athena, Glue, GCP BigQuery, and MS PowerBI and apply them to real client solutions
From data engineering point of view, help in the process for pursuing innovations, target solutions, and extendable platforms for Lighthouse, KPMG and client
Minimum of one year of relevant data engineering experience in related industries, preferably professional services with experience or knowledge of RDBMS design, data modeling, MPP EDW system implementation; Ability to pick up and learn new technologies quickly
Bachelor's Degree, Master's Degree or PhD from an accredited college/ university in Computer Science, Computer Engineering or related field
Hands-on experience and knowledge in: BI/EDW/Big Data toolsets (Tableau, Alteryx, Informatica, Pentaho, Er-Win, and Power Designer); Linux/Unix/Windows/.NET; Market-leading fluency of SQL and several programming languages (Bash/ksh/PowerShell; Python/Perl/R)
Hands-on experience and knowledge in distributed computing architecture, massive-parallel processing big data platforms like Hadoop, MapReduce, HDFS, Spark, Hive/Impala, H-Base/MongoDB/Casandra and Teradata/Netezza/Redshift
Hands-on experience or knowledge in mainstream cloud infrastructures: AWS, MS Azure and GCP; their D&A related Microservices; Ability to implement data lake and serverless data lake
Ability to travel up to eighty percent of the time; Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future
KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an equal opportunity employer. All qualified applicants are considered for employment without regard to race, color, creed, religion, age, sex/gender, national origin, ancestry, citizenship status, marital status, sexual orientation, gender identity or expression, disability, physical or mental handicap unrelated to ability, pregnancy, veteran status, unfavorable discharge from military service or military status, genetic information, genetic disposition and or carrier status, domestic violence status, personal appearance, family responsibility, matriculation or political affiliation, status with regard to public assistance, or other legally protected status. KPMG maintains a drug-free workplace. KPMG will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable local, state or federal law (including San Francisco Ordinance number 131192). No phone calls or agencies please.
KPMG offers a range of medical insurance options to meet your needs as well as prescription drug coverage, health care flexible spending accounts, and dependent day care flexible spending accounts.
Personal Time Off (PTO)
Up to 30 PTO Days per year (depending on job classification/level/years of service).
401(k) and Pension Plans
Dependent Care Flexible Spending Account
Health Care Flexible Spending Account
Mortgage Assistance Program
Hyatt Legal Plan
Benefits vary by employment status.