Senior Software Engineer

| Chicago

Our Team: 
Technology drives our business. Our team is made up of talented software engineers, infrastructure engineers, leaders and UX professionals. We care about technology as a craft and a differentiator. We bring our global products to market with a mix of software, cloud, data centers, infrastructure, design and grit.  

Our Product Groups: 
Individual Investor – building products like Morningstar.com and mobile apps for individuals like yourself 
Institutional Investor – developing some of our flagship products like Morningstar Direct for institutional investors and our Advisor products for financial advisors 
Workplace – this is where we build and provide our hosted digital advice platform for Retirement plans, 401K’s, etc. (what some call robo-advisors) 
Data – this is the heart of Morningstar where all data is sourced, collected, transformed, calculated and distributed across the world 

 

The Role:

As a Data Engineer with a strong background in Microsoft database and AWS technologies, you will work as part of the Workplace Data team to design and develop data migration strategies from on-prem to the cloud.  This position also provides opportunities to work on a wide variety of projects to solve valuable analytics and business problems. The ideal candidate is a diligent, hardworking individual with a strong Microsoft SQL background, a good working knowledge of AWS, who is able to learn new systems and processes rapidly.
 
Responsibilities: 

  • Design and document logical and physical database models to cater to a variety of business requirements.
  • Develop advanced T-SQL code for implementing application business logic using stored procedures, views, and functions.
  • Collaborate with other Database Administrators, Engineers, and Architects, as well as Applications/ Business teams to support enterprise applications.
  • Develop data warehouse objects and processes for supporting business intelligence, including ETL, fact/dimension tables.
  • Design and implement reports and dashboards existing tools and 3rd-party solutions.
  • Assist in the migration of existing databases to AWS.

 
Minimum Requirements: 

  • Bachelor's Degree in MIS or Computer Science related field.
  • 5+ of experience in design, development, and maintenance of Microsoft SQL Server databases.
  • 5+ years of experience with SQL Server 2008 R2 & Later TSQL, Database Design, & Schema Principles.
  • Experience using MS SQL Server Management Studio.
  • Strong organizational, analytical, and communication skills, both oral and written.

 
To Stand Out: 

  • Experience using AWS.
  • Experience with database performance analysis & indexing principles.
  • Familiarity with source control concepts and tools.
  • Experience with data visualization platforms.

 

Morningstar is an equal opportunity employer.

Read Full Job Description

Technology we use

  • Engineering
    • .NETLanguages
    • C#Languages
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • ScalaLanguages
    • D3JSLibraries
    • ReactLibraries
    • AngularJSFrameworks
    • Backbone.jsFrameworks
    • Ember.jsFrameworks
    • ExpressFrameworks
    • FlaskFrameworks
    • Node.jsFrameworks
    • PlayFrameworks
    • SpringFrameworks
    • Maria DBDatabases
    • MemcachedDatabases
    • Microsoft SQL ServerDatabases
    • MySQLDatabases
    • PostgreSQLDatabases

Location

22 W. Washington , Chicago, IL 60602

What are Morningstar Perks + Benefits

Culture
Volunteer in Local Community
Open Office Floor Plan
Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Company Equity
Child Care & Parental Leave Benefits
Generous Parental Leave
Flexible Work Schedule
Vacation & Time Off Benefits
Unlimited Vacation Policy
Generous PTO
Paid Volunteer Time
Sabbatical
Perks & Discounts
Casual Dress
Commuter Benefits
Happy Hours
Parking
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement

Additional Perks + Benefits

Compensation at Morningstar is more than a salary. It’s about making positive contributions to both life and work. We give our diverse workforce the choice and flexibility they need to maintain their health, retirement plans, time, and professional growth.

More Jobs at Morningstar85 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Sales
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Design + UX
new
Chicago
Product
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Design + UX
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Project Mgmt
new
Chicago
Operations
new
Chicago
Product
new
Chicago
Data + Analytics
new
Chicago
Content
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Marketing
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Project Mgmt
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Finance
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Product
new
Chicago