Data Engineer at Millennium Trust Company (Chicago, IL)

Sorry, this job was removed at 8:58 a.m. (CST) on Monday, December 20, 2021
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.

MILLENNIUM TRUST COMPANY is a rapidly growing, leading financial services company offering specialized retirement and institutional services. Whether clients are managing corporate retirement assets, running a business, or wanting choice beyond traditional asset options, we provide flexible and digital solutions to support our clients’ success. Ultimately, we aim to educate and increase access to investments to help our clients on their journey to retirement readiness, but do not provide investment advice.

Millennium Trust has experienced year-to-year double digit growth and prides itself on its strong, progressive culture. We have been recognized for our tremendous growth on lists, such as Crain’s Fast 50 and Inc. 5000, and have also been recognized for our positive workplace culture on the 2019 Best Places to Work in Illinois list, as well as the 2019 Model Workplace Award and 2018 Champion for Young Professionals Award from the Greater Oak Brook Chamber of Commerce. Millennium Trust employees live out the values of Do Right, Excel, Collaborate, Innovate and Celebrate and deliver the brand promise of going “Above and Beyond,” so each client experiences the highest level of service.

We are always looking to expand our growing team with dynamic and enthusiastic individuals. If you enjoy a collaborative, fun environment that encourages career development, Millennium Trust is the place for you!


POSITION SUMMARY:

The Data Engineer empowers business leaders to make decisions and drive outcomes. We are a data first enterprise, focused on delivering data assets to several clients – internal & external to our company. This role will engage with Business leaders, Analysts, Data Stewards, Application & Technology Architects, and third-party providers. The candidate will work to enhance data consistency, quality, accessibility, coherency & analysis; improve functionality and streamline data processes. Provide direct support to the business & operational teams, supporting data needs and strengthen targeted business strategies. The candidate will also work closely with the Business, Operations & Technology areas to help in the development of the Data Warehouse, Data Marts & Business Intelligence Tools.


ESSENTIAL JOB FUNCTIONS:

  • Facilitate the development of logical data models and physical database designs optimized for performance, availability, and reliability.
  • Work with the Database Architect to help design and manage the Enterprise data model which spans internal systems, as well as, external third-party processing systems for the collective benefit of Marketing, Operations, Sales and Executive teams.
  • Help design and implement OLAP databases & associated reporting.
  • Work with Cloud databases such as Azure SQL
  • Proficient in Data Reporting tools such as Power BI, Tableau
  • Highly experienced with Transact-SQL, designing stored procedures, functions & triggers
  • Help develop the data warehouse / Business Intelligence strategy ensuring rapid delivery while taking responsibility for applying standards, principles, theories, and concepts.
  • Json, AWS kinesis, AZURE pipeline tool
  • Support the data governance initiatives, and drive efforts in defining data standards, designing classification taxonomies, developing data management processes, ensuring proper meta-data management.
  • Support the collection, maintenance and analysis of data using various internet and database search tools.
  • Support manual and automated data clean-up.
  • Demonstrates an understanding of data points needed to provide insights to support strategies.
  • Work cross-functionally with other internal business units, such as, marketing and operations.
  • Help track and provide metrics, status updates and reports for data-related projects.
  • Collaborate with database architect and IT team members on project goals.
  • Performs additional duties as may be required.

EDUCATION, EXPERIENCE AND SKILLS REQUIRED:

  • Bachelor’s degree in computer science, software/computer engineering, or applied mathematics.
  • At least 5 years or more of work experience in data management disciplines including data integration, modeling, optimization, and data quality, and/or other areas directly relevant to data engineering responsibilities and tasks.
  • The ideal candidate will have a combination of IT skills, data governance skills, analytics skills, and knowledge of the Financial Services Industry.
  • Ensure that the data users and consumers use the data provisioned to them responsibly through data governance and compliance initiatives.
  • Work with data governance teams and participate in vetting and promoting content created in the business and by data stewards to the curated data catalog.
  • Strong analytic skills related to working with unstructured datasets.
  • Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
  • A successful history of manipulating, processing, and extracting value from large disconnected datasets.
  • Intellectual curiosity to find new and unusual ways of how to solve data management issues.
  • Ability to approach data organization challenges while keeping an eye on what is important.
  • Technical experience with databases/data management, Salesforce.com or another CRM tool.
  • Experience designing, building, and maintaining data processing systems
  • Strong experience with advanced analytics tools for Object-oriented/object function scripting using languages such as R, Python, or others.
  • Strong ability to design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata, and workload management. The ability to work with both IT and business in integrating analytics and data science output into business processes and workflows.
  • Strong experience with SQL programming languages.
  • Strong experience with PowerBI, SSRS.
  • Strong experience in working with and optimizing existing ETL processes and data integration and data preparation flows and helping to move them in production.
  • Exceptional analytical skills and strong attention to detail.
  • Capable of respectful, strong working relationships with business units from non-technical users to technical leads on projects to developers.
  • Strong client service orientation.
  • Ability to effectively execute tasks in a high-pressure environment.
  • Ability to prioritize, plan and take initiative.
  • Strong verbal and written communication skills; positive attitude; ability to work as team member.
  • Highly self-motivated and directed.

PREFERRED SKILLS: 

  • Experience in a high availability environment preferred.
  • Knowledge of ITIL/ITSM Foundational practices and framework.
  • Knowledge of Agile/Scrum methodologies
  • Knowledge of DevOps, JIRA, Confluence
  • Technical certifications a plus.
  • Strong Vendor management skills.

OTHER REQUIREMENTS:

  • Infrequent travel; may need own transportation from time to time.
  • Ability to work occasional overtime and weekends.
  • Successful completion of background check.
Read Full Job Description
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • C#Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • SqlLanguages
    • jQueryLibraries
    • ReactLibraries
    • Node.jsFrameworks
    • MongoDBDatabases
    • MySQLDatabases
    • Google AnalyticsAnalytics
    • IllustratorDesign
    • PhotoshopDesign
    • ConfluenceManagement
    • DrupalCMS
    • SalesforceCRM
    • Salesforce Marketing CloudEmail

Location

Our company is located in the heart of Oak Brook, within steps of Oakbrook Center mall.

An Insider's view of Millennium Trust Company

What are some social events your company does?

Our MTC culture is defined by our employees for our employees. The primary aspect of our culture that makes us so unique is our ability to “Celebrate”. From charity events to social gatherings, we provide employees with multiple opportunities to learn more about one another, give back to others and expand our professionals skills!

Rebecca Karnoscak

Senior Human Resources Coordinator

What does your typical day look like?

I collaborate with our internal business users to gather requirements for projects and enhancements. I develop these solutions using both no-code and code methodologies in Salesforce. It's rewarding knowing that we're making life easier for both our internal and external clients through streamlined, automated processes, and shorter turnaround time.

Alec Dorner

IT Business Developer/Analyst

How has your career grown since starting at the company?

I started out as a Sales & Marketing Coordinator at MTC in 2013. I’ve since been promoted twice, and asked to lead our MTCulture Team. I test-drove my leadership skills early on by volunteering for opportunities to lead small meetings/projects, join internal and external committees, organize events and workshops. I always welcome a challenge!

Lauren Schulz

AVP, Regional Director, Custody Services

How do you make yourself accessible to the rest of the team?

Throughout the transition to a virtual work environment, I have continued with a “virtual” open door policy. I give visibility into my workload and transparency about my availability through the use of MS teams, email and open dialogue on current and upcoming projects.

Rachel Guinan

Accounting Manager

What are Millennium Trust Company Perks + Benefits

Millennium Trust Company Benefits Overview

We provide a full range of competitive benefits, augmented by what we'll call 'soft' benefits like our state-of-the-art office building with fitness center (free access/membership) and business-casual dress code.

Culture
Volunteer in local community
Partners with Nonprofits
Eat lunch together
Intracompany committees
Open door policy
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Diversity Employee Resource Groups
Health Insurance & Wellness Benefits
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Retirement & Stock Options Benefits
401(K) Matching
Performance Bonus
Child Care & Parental Leave Benefits
Generous Parental Leave
Family Medical Leave
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Perks & Discounts
Casual Dress
Professional Development Benefits
Tuition Reimbursement
We offer eligible employees a company funded contribution applied to a qualified higher education student loan. This benefit helps employees pay off their student loans faster and save money.
Lunch and learns
Promote from within
Time allotted for learning

More Jobs at Millennium Trust Company

Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Millennium Trust Company's full profileSee more Millennium Trust Company jobs