project44
We make supply chains work.
Chicago, IL

Principal Data Engineer at project44

| Chicago
Sorry, this job was removed at 11:29 a.m. (CST) on Friday, February 25, 2022
Find out who's hiring in Chicago.
See all Data + Analytics jobs in Chicago
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Why project44?  

Our mission is to usher in a new era of trust and predictability to transportation and logistics, but there’s still a lot of work to be done. The industry is massive, as is the opportunity. We’re looking for bright, ambitious individuals to join our growing global team and help us enable a more productive and successful world. We’re changing the way the world ships, and we’re looking for you to help us get there!   

About the role:

As a Principal Data Engineer at project44, you'll have opportunities to work on ETL pipeline, support & solve various data integration challenges and improve overall data warehouse and data lake processing.

What you'll be doing:

  • Design and development ETL/ELT using Python/Java with Snowflake, Postgres and other data stores. Be able to develop & automate a project through its entire lifecycle.
  • Knowledge in Data Warehouse/Data Mart design and implementation. Be able to develop a project through its entire lifecycle.
  • Build distributed, reusable, and efficient backend ETLs.
  • Implementation of security and Data protection
  • Providing guidance on new technologies and continuous improvement in best practices
  • Researching, implementation and development of software development tools
  • Understand repeatable automated processes for building the application, test it, document it, and deploy it at scale.
  • Work collaboratively with insights and data science teams to understand end user requirements to provide technical solutions and for the implementation of new features and data pipelines.
  • Establish quality processes to deliver a stable and reliable solution
  • Efficient in writing complex SQL, stored procedures in Snowflake, Postgres, BigQuery
  • Preparing documentation (Data Mapping, Technical Specifications, Production Support, data dictionaries, test cases, etc.) for all projects
  • Coach junior team members and help your team to continuously improve by contributing to tooling, documentation, and development practices

You could be a great fit if you have:

Experience & Education

  • 8+ Years of experience in leading Data Engineering efforts
  • 3+ Years of experience in Snowflake, Oracle and knowledge in No SQL database like MongoDB
  • 3+ Years of experience in Python/Java
  • 3+ Years of experience in ETL Developer role with deep knowledge of data processing tools like Airflow, Argo workflow.
  • 4+ yrs experience with data engineering and operations, including administering production-level, always-on, high throughput, complex OLTP RDBMS
  • Strong experience in building data warehouse solutions and Data Modeling.
  • Strong ETL performance-tuning skills and the ability to analyze and optimize production volumes and batch schedules.
  • Experience with ETL, GCP, Unix/Linux, Helm Charts as well as Git or other version control systems
  • Expertise in operational data stores and real time data integration
  • Expert level skill in modeling, managing, scaling and performance tuning high-volume transactional database.
  • Bachelor's Degree in computer science or equivalent experience.

Technical Skills

  • Strong programming/scripting knowledge in building and maintaining ETL using Java, SQL, Python, Bash, Go.
  • In-depth hands-on knowledge of public clouds - GCP(preferred)/AWS, PostgreSQL (version 9.6+), ElasticSearch, MongoDB, MySQL/MariaDB, Snowflake, BigQuery
  • Participate in an on-call rotation to mitigate any data pipeline failures
  • Strong experience with Kafka or equivalent event/streaming based systems
  • Experience with Docker, Kubernetes.
  • Develop and deploy CICD pipelines for Data Engineering
  • Experience and knowledge of optimizing database performance and capacity utilization to provide high availability and redundancy
  • Proficiency with high volume OLTP Databases and large data warehouse environments.
  • Ability to work in a fast-paced, rapidly changing environment
  • Understanding of Agile and its implementation for Data Warehouse Development

Professional Skills/Competency

  • Focus on development/ improvement of framework to support repeatable and scalable solutions
  • Demonstrates excellent communication and interpersonal skills; able to communicate clearly and concisely
  • Takes initiative to recommend/ develop innovative approaches to getting things done
  • Is a team player and encourages collaboration

Diversity & Inclusion

We're designing the future of how the world moves and is connected through trade and global supply chains. We can only deliver a truly world-class product and experience if our teams are as diverse and unique communities we are building for. So it's up to us to create a company where anyone can bring their authentic self to work everyday. We're constantly working to improve, and we accept our responsibility to elevate the voices left in the margins. It's on every one of us.

Our focus on inclusion manifests in the way we hire, the customers we serve, and the regions we prioritize. We're building a company that every one of us at project44 is proud to work for: a company that celebrates you for being you.

We pride ourselves on celebrating everyone — project44 is an equal opportunity employer actively working on creating a diverse and inclusive work environment where underrepresented groups can thrive. If you share our values and our passion for helping the way the world moves, we’d love to review your application!

For any needed accommodations during the hiring process, please email [email protected] Even if you don’t meet 100% of the above qualifications, you should still seriously consider applying. Studies show that you can still be considered for a role if you meet just 50% of the role’s requirements.

More about project44 

Since 2014, project44 has been transforming the way one of the largest, most important global industries does business. As transportation and logistics continues to evolve and customer expectations around delivery become more demanding, industry technology must rise to the occasion. In just a few short years, we’ve created a digital infrastructure that eliminates the inefficiencies caused by dated technology and manual processes. Our Advanced Visibility Platform is used by the world’s leading brands to track shipments, collaborate with supply chain partners, drive operational efficiencies, and create outstanding customer experiences.  

See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Where we are

Located in the iconic art deco Merchandise Mart with impressive views of the Chicago river. The neighborhood is home to some of Chicago's best restaurants, retail, and is accessible by public transit.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • TypeScriptLanguages
    • ReactLibraries
    • DjangoFrameworks
    • FlaskFrameworks
    • SpringFrameworks
    • GCPFrameworks
    • KubernetesFrameworks
    • SpinnakerFrameworks
    • KafkaFrameworks
    • NodeJSFrameworks
    • DockerFrameworks
    • Neo4jDatabases
    • PostgreSQLDatabases
    • RedisDatabases
    • SnowflakeDatabases
    • ElasticsearchDatabases
    • Google AnalyticsAnalytics
    • MixpanelAnalytics
    • TableauAnalytics
    • SnowflakeAnalytics
    • FigmaDesign
    • MiroDesign
    • PendoDesign
    • FullStoryDesign
    • Aha!Management
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement
    • Monday.comManagement
    • HootsuiteCMS
    • DocuSignCRM
    • LinkedIn SalesNavigatorCRM
    • SalesforceCRM
    • SalesloftCRM
    • SendGridEmail
    • MarketoLead Gen
Previous
Next

What are project44 Perks + Benefits

project44 Benefits Overview

project44 is proud to offer comprehensive benefits to support the physical and financial health of our team members and their families.

Culture
Volunteer in local community
project44 encourages team members to give back to the communities in which we work, serve and live. Each year project44 team member's receive time to volunteer for an organization of choice.
Partners with Nonprofits
project44 finds opportunities to support the causes that our team members care about most. In 2020, we donated to 43 different non-profit partners around the world.
Friends outside of work
Eat lunch together
Intracompany committees
project44 encourages team members to connect. You can find team members gathering for culture committee, breakfast club, gaming events, sports leagues, various clubs and much more.
Daily sync
Open door policy
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Unconscious bias training
Diversity Employee Resource Groups
Our Team Member Communities (TMC) are continuously evolving to provide our team members meaningful ways to engage around common causes, interests, and conversations.
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
project44's disability insurance covers 60% of weekly/monthly earnings up to pre-identified limits and premiums are 100% employer paid.
Dental Benefits
project44 partners with Guardian to bring team members (2) dental plan choices. Preventive care is 100% covered and both plans also include orthodontic coverage for children and adults.
Vision Benefits
project44 partners with EyeMed for vision insurance. Plans assist in paying for eye exams, lenses, frames and contacts.
Health Insurance Benefits
project44 provides team members with health insurance optionality through Blue Cross Blue Shield for both individual and family plans, PPO or HDHP w/ HSA. project44 covers a large portion of premiums.
Life Insurance
project44 offers 100% employer paid life and AD&D insurance. Coverage includes 1x team member's annual salary for basic life and 1x a team member's annual salary for AD&D.
Wellness Programs
project44 provides team members with a monthly stipend to support wellness related expenses.
Onsite Gym
Mental Health Benefits
Through our Blue Cross Blue Shield medical insurance plans, team members can find a variety of in network providers for mental health related services.
Retirement & Stock Options Benefits
401(K)
Company Equity
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
project44 is proud to provide birth mothers with 16 weeks paid, primary care givers with 12 weeks paid and secondary care givers with 8 weeks paid and flexible return and ramp up for all.
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Return-to-work program post parental leave
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Commuter Benefits
project44 commuter benefits allow team members to set aside tax-free dollars to pay for eligible commuting expenses. Did you know the CTA runs directly into the Merchandise Mart?
Company Outings
At project44 we love to celebrate - the big things, the small things and everything in between. Our team can be found gathering in office and offsite for holiday parties, milestones & team building.
Game Room
Why have 1 game room when you can have 2, 1 of which links to our expansive rooftop deck overlooking the Chicago River. From Packman to Hoop Shots to board games to ping pong tables, let's have fun!
Stocked Kitchen
Our kitchen is fully stocked with breakfast foods, a wide variety of snacks, hot & cold drinks and cold brew on tap.
Some Meals Provided
On Monday's & Wednesday's we provide team members with lunch credit via Sharebite. For every meal we eat, meals are donated to children in need via City Harvest. It's a win, win.
Happy Hours
Parking
Parking is available at a number of nearby lots, including the Mart Parc.
Recreational Clubs
project44 sponsors various team member leagues year round from bowling to volleyball to run club to soccer to whirlyball.
Fitness Subsidies
Our wellness benefit provides monthly reimbursement to team members for fitness related expenses.
Professional Development Benefits
Job Training & Conferences
Diversity Program
Lunch and learns
Cross functional training encouraged
Promote from within
Time allotted for learning
Online course subscriptions available
Paid industry certifications

An Insider's view of project44

How does your team reward individual success?

We win as a team while recognizing individuals make an impact in a big way. Team members are regularly celebrated at global town hall meetings, in-office celebrations, and through our recognition tool, Bonusly. Celebrating the success of our team members is a responsibility of everyone at project44 and a primary way in which we enrich our culture.

Jenny Bebout

VP, Product

How do you collaborate with other teams in the company?

At project44 we are all working with a shared goal, taking project44 to the next level by obsessing over our customers. This goal allows for our team, regardless of position or seniority level, to collaborate by living our company values and being direct and honest in our communication.

Luz

Creative Director

What are some things you learned at the company?

I've learned spring, kafka, docker, k8s, postgres, mongo, and gotten AWS certified. I've learned how and when to build a microservice. I've learned how to design for scalability and resiliency. I've learned how to give and receive useful feedback on PRs. I've learned how awesome it is to come into work every day and like the people you work with.

Ben

Software Engineer

How do your team's ideas influence the company's direction?

The quality of our team is the foundation of project44. We’ve built a strong culture of innovation, contributing to our success in solving complex challenges. There’s shared understanding and respect in knowing teamwork is most effective with Real Talk. The trust we have in our team allows for the open flow of ideas that are valued and executed on.

Jett

Founder & CEO

What makes someone successful on your team?

Our people's unique perspectives, backgrounds and voices coming together allow us to innovate and create best in class products and experiences. We embrace growth mindsets, agility and passion. We are fanatical about operating with a solutions and service oriented approach and bring a touch of grit to everything we do.

Kendall

VP, Talent Attraction & Development

More Jobs at project44