Principal Data Engineer

What you'll do...

Position:
Principal Data Engineer

Job Location:

300 Elliott Avenue W., Seattle, WA 98119

Duties:
Understands the priority order of requirements and service level agreements. Defines and identifies the most suitable sources for required data that is fit for purpose, referring to external sources as required. Performs initial data quality checks on the extracted data. Reviews the deliverables of junior associates and provides guidance on data source and quality. Builds the infrastructure required for optimal transformation and integration from a wide variety of data sources using appropriate data integration technologies.

Uses modern tools, techniques, and architectures to partially or completely automate the most common, repeatable and tedious data preparation and integration tasks. Deploys pipelines using scheduling and orchestration frameworks. Evaluates impacts of data issues and risks at an early stage. Identifies needs and creates methods to fuse and reshape complex, multi-source data and make it usable for modeling. Updates knowledge of current and emerging big data analytics and data science trends and techniques.

Assembles large, complex data across all data platforms (for example, relational, dimensional, No

SQL) and data tools. Builds complex logical and conceptual models and provides guidance to team on physical data models. Identifies and defines the appropriate techniques for exposing data toother systems. Reviews and provides guidance and inputs on all data modeling activities to team members. Creates and maintains critical data documentation and metadata that allows data to be understood and leveraged as a shared asset.

Assists in defining data modeling standards and foundational best practices. Provides inputs to the architectural design to make best use of the available resources, given goals, and expected loads. Reviews the solution and application design to ensure it meets business, technical, and data requirements. Identifies language and libraries to use in the development process. Maps test cases to business and functional requirements.

Creates proof of concepts. Reviews and troubleshoots code in line with final designs. Identifies and recommends the appropriate testing methodology. Identifies the environment(s) for deployment. Identifies and recommends modifications of application based on different environment requirements. Identifies modifications needed for scalability and drives the change. Monitors applications in production and leads development of patches where required. Reviews and ensures all code documentation is complete and updated periodically.

Analyzes the business problem within one's discipline and questions assumptions to help the business identify the root cause. Identifies and recommends approach to resolve the business problem to create effective technology focused solutions. Sets relevant deliverables based on the established success criteria and define key metrics to measure progress and effectiveness of the solution. Quantifies business impact.

Minimum education and experience required:
Bachelor's degree or the equivalent in Computer Science, Software Engineering or related field and 5 years of post-bachelor's progressively responsible experience in software engineering, data engineering, database engineering, business intelligence, business analytics or related field; OR Master's degree or the equivalent in Computer Science, Software Engineering or related field and 3 years of experience in software engineering, data engineering, database engineering, business intelligence, business analytics or related field.

Skills required:

Experience designing and implementing data pipelines using Apache Spark and PySpark. Experience building and maintaining data lakes using AWS. Experience developing ETL workflows using Apache Airflow. Experience writing complex SQL queries and performance tuning. Experience implementing data modeling and data warehousing solutions (Snowflake and Databricks). Experience programming in Python for data engineering tasks. Experience using CI/CD tools (Git Hub Actions and Terraform) for data pipeline deployment.

Expe…