Senior Software Engineer (Data)

| Chicago

Job Duties:

Architect, develop, and maintain new data models, database schemas, procedures, and processes (10%). Architect, create, re-organize, and maintain new and existing ETL processes for B2B data synchronization and warehousing (10%). Provide database reporting, monitoring, and support, as well as SQL performance analysis and optimization (10%). Responsible for upgrading the databases and applying security standards to databases (30%). Architect and migrate the databases to Cloud providers like Amazon (40%). This position requires intermittent annual international travel (less than 5%).

 

 

Job Requirements:

·         Bachelor’s degree in Computer Science, Mathematics, or closely related Engineering field.

·         5 years of experience as Developer, Software Engineer, or in a related position.

·         5 years of design and development experience with relational database management systems, such as Microsoft SQL Server.

·         5 years of experience with design of new transactional and new analysis schemas.

·         5 years of experience with design, development, and organization of new ETL processes.

·         5 years of experience in creating Stored Procedures and Functions.

·         5 years of experience with supporting ETL jobs in production.

·         5 years of experience in working with RDBMS technologies like SQL Server, Oracle, Netezza etc.

·         3 years of experience with Bash.

·         3 years of experience in deploying and automating ETL processes in Production.

·         3 years of experience in fine tuning the ETL processes and Stored Procedures for better performances.

·         1 year of experience with ETL tools (SQL Server Integration Services, Informatica, or other).

·         1 year of experience with DBA.

·         Understanding of AWS concepts, including RDS, EC2, DynamoDB, and S3.

·         Understanding of PowerShell Scripting.

·         Understanding of Database automated deployment technologies.

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 Morningstar86 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Developer
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Sales
new
Chicago
Design + UX
new
Chicago
Finance
new
Chicago
Marketing
new
Chicago
Sales
new
Chicago
Content
new
Chicago
Internships
new
Chicago
Sales
new
Chicago
Sales
new
Chicago
Internships
new
Chicago
Operations
new
Chicago
Sales
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Data + Analytics
new
Chicago
Developer
new
Chicago
Developer
new
Chicago
Operations
new
Chicago
Operations
new
Chicago
Finance
new
Chicago
Design + UX
new
Chicago
Content
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Finance
new
Chicago
Developer
new
Chicago
Product
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
Project Mgmt
new
Chicago
Data + Analytics
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Design + UX
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Project Mgmt
new
Chicago
Marketing
new
Chicago
Data + Analytics
new
Chicago
Data + Analytics
new
Chicago
Finance
new
Chicago
Design + UX
new
Chicago
Design + UX
new
Chicago
Content
new
Chicago
Developer
new
Chicago