SQL Database Developer
The Team:
Fueling the technologies that drive our products and support our company’s infrastructure, the Technology team within our Corporate team consists of talented developers, network architects, and IT experts who help make technology one of Morningstar’s core strengths. Though our technologists represent a range of skills and knowledge bases, they all view technology as a craft and care deeply about creating positive user experiences. From Agile methodologies to mobile applications, to software as a service (SaaS) delivered from our private cloud, we push technology’s boundaries to build scalable, elegant solutions that help investors reach their financial goals.
The Role:
The Database Developer will be a leader in a wide variety of responsibilities critical to the implementation of our next generation data platform. This person will be responsible for the design, construction, and, maintenance of warehousing processes, which includes ETL/ELT, ODS/Warehouse data modeling, metadata definitions and scripting. In this role the SQL Developer will design analytical SQL, data models, work very closely with our project managers, business analysts, data architects, ETL developers, and DBAs to ensure the requirements are well understood. This position will be based in our Chicago office.
Responsibilities
+ Design analytical SQL.
+ Optimize SQL queries and ETL processes.
+ Design tables, distributions, and organize and materialized views.****
+ Develop user defined functions, aggregates, and table functions.
+ Translate user requirements and needs into database schema and table design.
+ Implement and support data calculation, collection, and harvesting.
+ Design and construct databases in both Netezza as well as SQL Server.
+ Work closely with business analysts and data architects to support tactical and strategic objectives.
Requirements
+ A bachelor’s degree in computer science or a related field.
+ Minimum of three years’ experience of prior Analytical SQL experience.
+ Skills in database design with some data modeling skills, as well as proficiency with ANSI SQL-99.
+ Minimum of three years’ experience with Java, C/C++, Python, and/or Shell Scripting.
+ Proven SQL skills in performance tuning and creating efficient stored procedures and functions.
+ Knowledge of SQL window functions as well as data visualization tools, and applications.
+ Financial or accounting industry knowledge very helpful.
Morningstar is an equal opportunity employer.