Data Engineer

Job Summary
:
Pitch Book, a Morningstar company, is seeking a Data Engineer to join their Product and Engineering team. In this role, you will build data pipelines, manipulate data for analysis, and ensure data governance while collaborating with various stakeholders to enhance customer experiences through data-driven solutions.

Responsibilities
:

• Apply unified data technologies to support advanced and automated business analytics

• Design, develop, document, and maintain database and reporting structures used to compile insights

• Define, develop, and review extract, load, and transform (ELT) processes and data modeling solutions

• Consistently evolve data processes and techniques following industry best practices

• Build data models to be used for reports and dashboards used to translate business data into insights, identify and prioritize operational improvement opportunities, and measure business KPIs

• Contribute to the ongoing improvement of quality assurance standards and procedures

• Support the vision and values of the company through role modeling and encouraging desired behaviors

• Participate in various company initiatives and projects as requested

Qualifications
:
Required
:

• Bachelor's degree in a related field (Computer Science, Engineering, etc.)

• 2+ years of experience in data engineering roles, including creating and maintaining data pipelines, data modeling, and data architecture

• 3+ years of experience in advanced SQL, including expert-level skills in querying large datasets from multiple sources and developing automated reporting

• 2+ years of experience in Python, with skills for diverse components of data pipelines, including scripting, data manipulation, custom extract, transform and loads, and statistical/regression analysis

• Expertise in extract, transform, and load (ETL) and extract, load, transform (ELT) processes and pipelines, platforms (e.g. Airflow), and distributed messaging (e.g. Kafka)

• Experience with tools that capture and control data modeling change management (e.g. SQLMesh)

• Proficiency in data storage solutions, data warehousing, and cloud-based data platforms (e.g. Snowflake)

• Knowledge and applicable working experience establishing and ensuring data governance, data quality, and compliance standards

• Exceptional problem-solving skills

• Excellent communication and collaboration skills with the ability to engage with non-technical stakeholders

• Must be authorized to work in the United States without the need for visa sponsorship now or in the future

Preferred
:

• Experience working with enterprise technologies (CRM, ERP, Marketing Automation Platforms, Financial Systems, etc.) is a plus

Company
:
Pitch Book offers financial data and tools on companies, deals, investors, and markets to support sales and business development. Founded in 2007, the company is headquartered in Seattle, USA, with a team of  employees. The company is currently Late Stage.