Data Engineer – Mid-Level

Overview

Title: Data Engineer

Location: 100% Remote

Duration: 12+ Months contract (Potential to extend)

• 5-10 years as a Data Engineer
• Technical and design expertise
• Interview process: 2 rounds; 1st round will be technical; 2nd round will be with a business facing partner (half hour each round)

The Data Analysis Engineer is accountable for designing, creating, and maintaining data pipelines and data models (using various data preparation and storage technologies) for Projects within the Risk Assurance Data and System. You are expected to work as our lead engineer partner with our Data Analysis, IT Teams, partners, and developers to drive the design and oversee the technical side of the delivery

• Accountable for designing, developing, testing, cataloging, and maintaining Data Software and Data Pipeline solutions for the Corporate Risk and Compliance functions
• Analyze raw data/data sets in various data technology environments
• Combine raw information from different sources and technologies
• Identify opportunities for data acquisition
• Work collaboratively with IT teams and peer engineers to ensure data duplication is minimized and solutions are aligned to the overall strategic IT roadmap
• Accountable for delivering clean, secure, performant code/technology components that meet all the non-functional requirements
• Participate in Design Reviews, peer code reviews and Impact Assessment Sessions to identify appropriate solutions
• Create test data, relevant supporting documentation and supports deployment, for small to medium complex solutions
• Comfortable working within an agile framework to ensure solutions are delivered efficiently – identify opportunities to improve the development process
• Supports discussions on design approaches to solving business problems
• Maintains broad knowledge in Data sources and Analytics applications/self-service areas which support the Corporate Risk and Compliance function
• Works with the COE to enhance guidelines, standards, and methodologies – partner with peers to ensure consistency
• Actively participate in the appropriate communities of practice
• Assumes responsibility for providing a high level of customer service and takes personal accountability for outcomes
• The ability to multitask and prioritize work in a fast-paced environment
• Accountable to leading our data related design, modeling, and data solution delivered and proactively address issues that are identified
• Assumes responsibility for providing a high level of customer service and takes personal accountability for outcomes
• Leading other developers and analyst through design concepts
• Excellent teamwork, interpersonal, and communication skills
• Ability to develop relationships at all levels of the business
• The ability to multitask, prioritize and work in a fast-paced environment

• Strong experience (5-10 years) in a technical data, data modeling, and/or data analytics role, specifically in technical design, development, and implementation
• 5-10 years’ experience as a data engineer/modeling or in a similar role
• Strong knowledge of Excel, Power BI, Snowflake, Jira, Confluence, Databricks & Alteryx
• Experience to understand the reporting requirements and build out data models for reporting in Power BI and Snowflake
• Expert knowledge of and experience with a Data modeling and Engineering toolset, SQL, Data Modeling, multiple file formats (JSON, XML, etc), data security and data profiling
• Proficient in working with SQL and creating stored procedures and other integration techniques
• Some experience with cloud data storage technologies (Azure), analytics tools, end-to-end data architecture patterns and data governance concepts
• Experience in the full software delivery lifecycle on business development projects including data analysis, process mapping, business requirements, solution design, functional and technical specification, coding, source code management, test plans, and go-live release notes
• Familiar with Agile and Dev Ops concepts and tools
• Strong analytical, critical thinking & influencing skills

• Bachelor’s degree in information management, data analytics, computer science, or a similar field
• Expertise and hands-on experience working with complex and large data sets in a multi-system and technology environment (this can be built with IT support)
• Python skills