Chris Charles

Chris Charles Email and Phone Number

Staff Engineer - Data at Paylocity @ Paylocity
1400 American Ln, Schaumburg, Illinois 60173, us
Chris Charles's Location
New York City Metropolitan Area, United States, United States
About Chris Charles

★ ★ ★ CAREER SUMMARY ★ ★ ★ » Strategic, proactive data design and development professional with more than 15 years of experience driving Data Engineering in corporate environments. » Exceptional hands-on Staff Data Engineer with extensive experience in architecting OLAP data models and cloud data platforms.» Extensive experience with defining product requirements and detailed test plans to ensure quality and timely deliverables from diverse teams. » Excel in building partnerships and delivering projects that accelerate revenue growth and expand market reach. » Recognized as a key subject matter expert for data model and ETL design, build and testing initiatives.» Manager of the Apache Airflow group on LinkedIn: https://www.linkedin.com/groups/7037800» Member of DAMA - the Data Management Community (www.dama.org)★ ★ ★ TECHNICAL SKILLS SUMMARY ★ ★ ★» Data Warehouse Design: using Kimball and/or Inmon approaches. » ETL / ELT Development: via coding, (Python / Apache Airflow) or GUI tools, (Azure Data Factory, Informatica)» Cloud-based Development: Spark / DataBricks, AWS, S3, Azure, Terraform, Redshift, Snowflake.» BI Development: Tableau, BO, Cognos.» MDM Development: Oracle UCM, Microsoft MDS.» Databases: Snowflake, Redshift, Vertica, Oracle, SQL Server, MySQL, Postgres, Netezza, Teradata.» Scripting Languages: Bash shell scripts, Python, Perl, PL/SQL, T-SQL.» Programming Languages: Python, Java, C#, C++. » Methodologies: Agile (Certified Scrum Master), Waterfall.★ ★ ★ CAREER ACCOMPLISHMENTS ★ ★ ★» Designed and built greenfield Airflow environment, including key python libraries, Airflow operators, and unit tests, and documenting design patterns and coding standards. » Designed and implemented mission-critical dimensional data models containing high visibility metrics. » Converted in-house Data Warehouse load processes to the AWS cloud via Python / Apache Airflow / Redshift.» Fundamentally redesigned core ETL of enterprise financial data warehouse to conform to design / coding standards and simplify future maintenance.» Established platform standards for design, development, deployment, administration, governance and training when introducing Master Data Management (MDM) technology into the enterprise domain.

Chris Charles's Current Company Details
Paylocity

Paylocity

View
Staff Engineer - Data at Paylocity
1400 American Ln, Schaumburg, Illinois 60173, us
Website:
paylocity.com
Employees:
1
Chris Charles Work Experience Details
  • Paylocity
    Staff Engineer - Data
    Paylocity Aug 2023 - Present
    Schaumburg, Illinois, Us
    Paylocity's all-in-one software platform gives HR pros a way to easily manage daily tasks in payroll, benefits, talent, and workforce management.I am a Staff Data Engineer at Paylocity, responsible for the design, development and maintenance of data pipelines using Python, Apache Airflow, Snowflake, dbt, AWS and PySpark. I am also responsible for defining and enforcing coding standards, creating unit tests and CI/CD pipelines, and mentoring engineers.
  • Brightwheel
    Staff Data Engineer
    Brightwheel Jan 2022 - Aug 2023
    San Francisco, California, Us
    Brightwheel is the fastest growing and top reviewed product in early education - a $100B US market.I was the Staff Data Engineer at brightwheel, responsible for the design, development and maintenance of the company's Redshift Data Warehouse. I maintained and used Apache Airflow within our Kubernetes cluster and locally via Docker. I created our cloud infrastructure using AWS Cloudformation. I designed and populated our Data Warehouse via Airflow dags and dbt models. I documented our data infrastructure, set coding standards, created unit tests and CI/CD pipelines, and mentored engineers and data analysts.
  • Mars
    Senior Data Engineer
    Mars May 2021 - Jan 2022
    Mclean, Virginia, Us
    For over a century, Mars has been one of the world’s leading manufacturers of confectionery and pet food.I was the Senior Data Engineer on the Advanced Machine Learning team at Mars. The main project I worked on was to enable the global traceability of a single Mars product from the point of sale all the way back to the farmers who provided the ingredients to make that product. I was also heavily involved in documenting best practices for Python / Spark development.
  • Hagerty
    Senior Data Engineer
    Hagerty Dec 2019 - May 2021
    Traverse City, Mi, Us
    Hagerty is an insurance company that is the global leader in collector car insurance.I was a Senior Data Engineer at Hagerty, specializing in Apache Airflow, Cloud Data Engineering and Master Data Management. My initial focus was to help establish the Apache Airflow pipeline infrastructure, including Python functions for commonly used pipeline functionality, custom Airflow Operators for common pipeline patterns, Amazon AWS cloud infrastructure, unit and integration tests, and documenting best practices and coding standards. After the basic pipeline infrastructure was established, I created data pipelines with Airflow, populating a Data Lake in Amazon AWS and a Data Warehouse in Snowflake. I also helped establish the company's Master Data Management system. My role at Hagerty included overseeing the design for new pipeline projects, reviewing code to ensure it meets our standards, and mentoring engineers.
  • Babycenter
    Senior Data Engineer
    Babycenter Jan 2016 - Sep 2019
    New York, New York, Us
    BabyCenter is the #1 pregnancy and parenting digital destination.• Worked as part of cross-functional teams to develop, refine, and scale data management and analytics systems.• Worked closely with internal teams to help define problems and design solutions to derive insights from our data.• Built and maintained processes to clean, move, load, and summarize data. • Designed and maintained automated processes for summarizing data for a wide variety of internal teams.• Built and automated data processes using tools like Apache Airflow and AWS. • Built and maintained internal data applications using Python.
  • One Kings Lane
    Senior Data Engineer
    One Kings Lane Dec 2014 - Dec 2015
    New York, Ny, Us
    An online flash-sale retailer specializing in home decor with over $200 million in annual revenue.• Responsible for the design, development and maintenance of the Data Warehouse and Big Data platforms.• Assisted in the development of new ETL Jobs integrating multiple data sources.• Wrote efficient Python and SQL from business requirements.• Wrote integration scripts for pushing data from HBase to Hive and then on to Vertica.• Wrote Oozie XML scripts for Hadoop workflow scheduling. • Wrote Pig scripts to transform HDFS data and store in Hive tables.• Maintained and tuned the Vertica database.• Worked closely with business analysts for data acceptance, change management, and ensure quality.• Provided advice and guidance to the various teams working with data and searching for insight.
  • Autodesk
    Senior Software Engineer - Etl / Mdm
    Autodesk Jan 2012 - Jun 2014
    San Francisco, Ca, Us
    A multinational software corporation making software for architecture, engineering, construction, manufacturing, media and entertainment industries with $2.2 billion in annual revenue. • Directed data integration from SQL Server and Oracle databases (Siebel, SAP and Salesforce) into ODS, Data Warehouse and revenue-focused Data Mart by utilizing Informatica Power Center.• Introduced critical, high-visibility Industry-related metrics into Data Warehouse, Data Mart and downstream Business Object Universe to streamline how company reports revenue. • Platform Lead for Microsoft Master Data Services (MDS) technology, establishing standards for design and development, (including use of design patterns and web services), deployment, administration, governance and training materials for end-users. • Managed and executed projects for Customer/Account Master Data Management (MDM) system, Siebel Universal Customer Master (UCM) by performing integration of source systems with UCM and data cleansing software, Trillium. • Conducted performance optimization of UCM database through data cleansing initiatives.
  • Cbs Interactive
    Etl Data Warehouse Engineer
    Cbs Interactive Apr 2011 - Dec 2011
    San Francisco, Ca, Us
    An online content network for information and entertainment with several websites covering news, sports, entertainment, technology and business generating $600 million in annual revenue. • Led entire ETL process through analysis, design, coding, testing, implementation and troubleshooting initiatives. • Developed and resolved data integration challenges in Data Warehouse with innovative ETL design in both batch and near real-time environments.
  • Shutterfly.Com
    Data Warehouse Engineer
    Shutterfly.Com Apr 2007 - Feb 2011
    San Jose, Ca, Us
    An Internet-based image publishing service known for its photo book line, the flagship product. • Designed and developed mission-critical Marketing and Finance-related analytic Data Warehouses and Data Marts utilizing the Agile Scrum methodology. • Collaborated with business end-users on analysis requirements and ensured requirements were met throughout entire projects. • Executed projects for Marketing Campaign Management Systems while verifying compliance with current Sarbanes-Oxley standards. Technologies used: Oracle, Informatica Power Center, SQL Server, Perl, Unix (Bash) shell scripts, and PL/SQL for ETL processes, and Cognos, SQL, and PL/SQL for Business Intelligence reporting. We used the Rally application in conjunction with JIRA and Perforce for coordinating the Agile methodology and implementing version control.
  • Celera
    Senior Software Engineer
    Celera Oct 2001 - Apr 2007
    A biotechnology company focusing on genetic sequencing and related technologies. • Completed design/implementation of a Data Warehouse using PL/SQL and Java scripts embedded in an Oracle database. • Led engineering team as a senior designer/developer of a LIMS system for controlling fifty Polymerase Chain Reaction (PCR) machines running in parallel to integrate a Plate Tracking module into LIMS using customized ActivityBase software. • Accessed data within LIMS by designing and implementing Oracle schemas and writing Java applications to implement Bioinformatics algorithms. • Authored Visual Basic programs to control Plate Cranes and feed plates to dispensing and PCR machines.
  • Id Business Solutions (Idbs)
    Senior Software Engineer
    Id Business Solutions (Idbs) Mar 1995 - Sep 2001
    A software company whose products aid the drug development process.• Lead designer / developer of a Data Warehouse utilizing the star schema model of Oracle 8i Enterprise Edition. • Designed and implemented the Oracle database for the company’s High-Throughput Assay Screening application – ActivityBase.• Trained new developers and consultants to show them how to create, customize and maintain product databases. • Wrote many programs, utilities and sub-modules using Microsoft Visual C++. • Modularized ActivityBase code using static and Dynamic Link Libraries (DLLs), reducing the size of the application and allowing shared access to standard functionality.

Chris Charles Skills

Data Warehousing Sql Etl Agile Methodologies Data Modeling Oracle Databases Python Big Data Pl/sql Java Business Intelligence Hadoop Database Design Mysql Unix Informatica Scrum Analytics Integration Microsoft Sql Server Data Integration Perl Performance Tuning Amazon Web Services Teradata Enterprise Software Shell Scripting Hbase Master Data Management Web Services Linux Cognos Data Management Vertica Redshift Netezza Oozie Airflow Certified Scrum Master Csm Visual C# Technical Documentation Reference Data Sqoop Redshift Spectrum Pandas

Chris Charles Education Details

  • University Of California, Berkeley
    University Of California, Berkeley
    Data Warehousing & Business Intelligence
  • Udacity
    Udacity
    Data Streaming
  • University Of California, Berkeley
    University Of California, Berkeley
    Technical Communication
  • Sheffield Hallam University
    Sheffield Hallam University
    Computer Science

Frequently Asked Questions about Chris Charles

What company does Chris Charles work for?

Chris Charles works for Paylocity

What is Chris Charles's role at the current company?

Chris Charles's current role is Staff Engineer - Data at Paylocity.

What is Chris Charles's email address?

Chris Charles's email address is c_****@****hoo.com

What is Chris Charles's direct phone number?

Chris Charles's direct phone number is +151050*****

What schools did Chris Charles attend?

Chris Charles attended University Of California, Berkeley, Udacity, University Of California, Berkeley, Sheffield Hallam University.

What are some of Chris Charles's interests?

Chris Charles has interest in Poverty Alleviation, Animal Welfare, Education, Environment.

What skills is Chris Charles known for?

Chris Charles has skills like Data Warehousing, Sql, Etl, Agile Methodologies, Data Modeling, Oracle, Databases, Python, Big Data, Pl/sql, Java, Business Intelligence.

Who are Chris Charles's colleagues?

Chris Charles's colleagues are Sherri Small, Mba, Ssgb, Jessica Tinsley, Tiffany Smith, Sam Checketts, Greg O'connell, Hector Alicea, Naga Pujitha Mamidala.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.