Principal Software Engineer, Data R5367

$150,000 - $150,000/Yr

OREGON EMPLOYMENT DEPARTMENT - Lake Oswego, OR

Full-time - Senior

Lake Oswego, OR

About the position

As a Principal Data Software Engineer, you will play a crucial role in influencing technical designs and implementing a new data platform. This position focuses on quality implementation while guiding other data engineers, building a platform that ingests content from various teams and provides application-specific data sets. The role offers opportunities for exploring new capabilities, investing in data development, mentoring software developers, and balancing life priorities.

Responsibilities

• Work with a team of data engineers and be accountable for designs and high-quality deliveries as an individual contributor
• Help team members grow by mentoring newer engineers
• Participate in the innovative advancements of our product platform and collaborate with agile team members
• Promote opportunities for refactoring and identify areas of optimization
• Research and leverage commercial products, libraries, and tools to solve problems
• Participate in design sessions with engineers, architects, and product managers, providing constructive feedback during sprint retrospectives
• Use automation, including continuous integration, automated deployments, and automated unit and functional testing
• Mentor and provide guidance to junior developers

Requirements

• 12+ years' experience in an Agile, full-stack software development environment with a focus on big data designs and implementations, ideally with SaaS and/or micro service-based systems
• Expert knowledge of data management and pipeline systems, practices, and standards
• Expert analytical and design skills, including the ability to abstract information requirements from real-world processes
• Expert experience in Star and Snowflake schema data modelling
• Expertise in data transformations (ELT, ETL), data quality, data cleansing, and data profiling using dbt Labs' DBT
• Expertise in Data Cataloging and Master Data Management concepts
• Expertise in both SQL and NoSQL implementations; experience with Microsoft SQL Server, Snowflake, and Postgres
• Experience with SQL profiling, performance tuning, and data ingestion into Data Warehouses
• Strong critical thinking skills with the ability to identify and influence others on the best solution
• Ability to drive results through collaboration, software programming, and technical problem solving

Benefits

• Medical
• Dental
• Vision
• Retirement