Data Engineer

About the role

The Data Engineer will be responsible for a wide variety of tasks which include all aspects of the development and delivery of data solutions and maintaining the enterprise data warehouse. You will work closely with business analysts, product managers, quality assurance and business stakeholders to effectively implement data solutions.

Responsibilities

• Develop and deliver data solutions that comply with development standards.
• Maintaining a relational database schema. This includes defining tables, relationships and constraints to ensure data integrity.
• This includes building and maintaining data pipelines, optimizing performance of database environments and automating data processes.
• Effectively assist in day-to-day tasks / activities in coordination with a team of developers to effectively meet the deliverables and schedule of a data solution component within a larger application project.
• Lend support to various business and technology teams as necessary during design, development and delivery to ensure solid, scalable, robust data solutions.
• Support and maintain data and database systems to meet business delivery specifications and needs.

Qualifications

• Required: 5+ years proven experience in a data-centric role within a collaborative data and technology team.
• Writing and optimizing complex SQL queries to extract large datasets.
• Using data transformation tools like SSIS.
• Advanced SQL knowledge and proficiency in working with relational databases.
• Hands-on experience with data warehouse solutions.
• Proficiency with the SQL query language, preferably Microsoft T-SQL.
• A strong understanding of data modeling and best practices in data governance.
• Exceptional oral and written communication skills, facilitating effective cross-functional collaboration.