Data Engineer - Canada - Morningstar Credit Ratings, LLC

Description

The Role:
In this role, you will take responsibility for developing automated data processing, maintaining, testing, and optimizing data pipelines that enable the end-to-end data flow of Morningstar Data Dictionary through our data platform. You are also responsible for ensuring quality of data processing that includes data security, fault tolerance, performance, scale and event based operational engineering processes. The ideal candidate will have a passion for data, metadata driven solution design and secured data processing technology, operating in Public Cloud platform. Also, candidate should demonstrate excellent problem solving, communication and a good understanding of financial investment data. Understanding data lineage management using metadata is a plus. Your track record for establishing best engineering practices, applying innovation and data pipeline management to make solid design decisions sets you apart from your peers.

Job responsibilities:

• Hands-on data cleaning, wrangling and preparation for Morningstar Data Dictionary content release.

• Maintain and optimize data pipelines for Morningstar Data Dictionary product through our data platform.

• Automate data workflows such as data ingestion, aggregation, and ETL processing.

• Contribute to dataset physical schema enhancements with attribute management using metadata requirements to support various use cases (for example taxonomy, data lineage, etc.)

• Partner with architect, quality assurance (QA), and business analyst (BA) to identify opportunities to improve current Morningstar Data Dictionary release process, as well as to deliver other projects according to requirements, in collaboration with program and product management, technology leadership and development teams

Qualifications:

• Advanced SQL skills and experience with various relational database management systems (e.g. MySQL, PostgreSQL, MS SQL, etc.)

• Experience in test driven development (TDD) practice

• Experience in container (e.g., Docker) based solution development

• Experience in applying and implementing authorization and encryption in data processing and storage level as part ETL

• Experience in physical database schema design

• 3+ years of experience with Python

• Hands-on experience with ETL tools, along with configuration driven data transformation development

• Experience with public cloud infrastructure, primarily Amazon Web Services (AWS)

• Self-motivated, excellent work ethic, strong interpersonal and communication skills

• Ability to work independently and in a team environment

• Ability to communicate complex ideas, problems and solutions in ways that are consumable by different audiences in both written and spoken manner

• Excellent problem-solving skills

Nice to have:

• Possess Bachelor's degree in Computer Science, Information Systems, Engineering or related field of study

• Good understanding of NoSQL databases (e.g. MongoDB, etc)

• Experience in Java programming language and framework

• Experience with working on large datasets

Morningstar is an equal opportunity employer.

The Role:
In this role, you will take responsibility for developing automated data processing, maintaining, testing, and optimizing data pipelines that enable the end-to-end data flow of Morningstar Data Dictionary through our data platform. You are also responsible for ensuring quality of data processing that includes data security, fault tolerance, performance, scale and event based operational engineering processes. The ideal candidate will have a passion for data, metadata driven solution design and secured data processing technology, operating in Public Cloud platform. Also, candidate should demonstrate excellent problem solving, communication and a good understanding of financial investment data. Understanding data lineage management using metadata is a plus. Your track record for establishing best engineering practices, applying innovation and data pipeline management to make solid design decisions sets you apart from your peers.

Job responsibilities:

• Hands-on data cleaning, wrangling and preparation for Morningstar Data Dictionary content release.

• Maintain and optimize data pipelines for Morningstar Data Dictionary product through our data platform.

• Automate data workflows such as data ingestion, aggregation, and ETL processing.

• Contribute to dataset physical schema enhancements with attribute management using metadata requirements to support various use cases (for example taxonomy, data lineage, etc.)

• Partner with architect, quality assurance (QA), and business analyst (BA) to identify opportunities to improve current Morningstar Data Dictionary release process, as well as to deliver other projects according to requirements, in collaboration with program and product management, technology leadership and development teams

Qualifications:

• Advanced SQL skills and experience with various relational database management systems (e.g. MySQL, PostgreSQL, MS SQL, etc.)

• Experience in test driven development (TDD) practice

• Experience in container (e.g., Docker) based solution development

• Experience in applying and implementing authorization and encryption in data processing and storage level as part ETL

• Experience in physical database schema design

• 3+ years of experience with Python

• Hands-on experience with ETL tools, along with configuration driven data transformation development

• Experience with public cloud infrastructure, primarily Amazon Web Services (AWS)

• Self-motivated, excellent work ethic, strong interpersonal and communication skills

• Ability to work independently and in a team environment

• Ability to communicate complex ideas, problems and solutions in ways that are consumable by different audiences in both written and spoken manner

• Excellent problem-solving skills

Nice to have:

• Possess Bachelor's degree in Computer Science, Information Systems, Engineering or related field of study

• Good understanding of NoSQL databases (e.g. MongoDB, etc)

• Experience in Java programming language and framework

• Experience with working on large datasets

Morningstar is an equal opportunity employer.

Morningstar's hybrid work environment gives you the opportunity to work remotely and collaborate in-person each week. We've found that we're at our best when we're purposely together on a regular basis, at least three days each week. A range of other benefits are also available to enhance flexibility as needs change. No matter where you are, you'll have tools and resources to engage meaningfully with your global colleagues.

When you find a position you're interested in, click the 'Apply' button. Please fill out this form completely, attaching your resume and cover letter in the approved format. Read the job requirements carefully and make sure to attach writing or design samples as required. Applicants must submit their resume and other information through our corporate website to be considered for a job at Morningstar. No phone calls, please.

Step 2

You will receive an email notification to confirm that we've received your application.

Step 3

If you are called in for an interview, a representative from Morningstar will contact you to set up a date, time, and location. Be prepared for a rigorous interview process. To make sure you're a good fit for Morningstar and we're a good fit for you, we'll schedule time for you to meet with multiple staff members at all levels of the company. Expect to return for multiple interviews as part of the process. A representative from Morningstar will contact you with the results of your interview—either with a job offer or to let you know our plans for the position.

Applicants With Disabilities Who Need Accommodation

Morningstar is committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please call or email and let us know the nature of your request and your contact information.

Please note:

• We only accept calls from applicants who need accommodation related to a disability. Please, no calls with unrelated questions or requests.
• Please be sure to include the title and location of the open position you're interested in when you leave a message.

US Applicants: Morningstar is an E-Verify program participant.

Morningstar is strongly committed to creating and preserving equal opportunity for all employees and applicants. We make all employment decisions—including recruitment, hiring, compensation, training, promotion, transfer, discipline, termination, and other personnel matters—without regard to race, color, ancestry, religion, sex, national origin, age, disability, protected veteran status, marital status, sexual orientation, genetic information, citizenship, gender identity and expression, parental status, or other legally protected characteristics or conduct.