insightsoftware

Principal Data Engineer

insightsoftware

full-time

Posted on:

Location Type: Remote

Location: Remote • 🇺🇸 United States

Visit company website
AI Apply
Apply

Job Level

Lead

Tech Stack

CloudOracle

About the role

  • Evaluate and lead efforts to normalize the database architecture and optimize data models for performance and scalability
  • Assess current database bottlenecks, long-running queries, and performance issues, designing and implementing optimization strategies
  • Design data architecture patterns to migrate business logic from Oracle stored procedures to proper application tiers in collaboration with application engineers
  • Develop database modernization roadmap for read-optimization and tighter integration with modern BI tools
  • Lead strategic decisions on database patterns, indexing strategies, partitioning, and data lifecycle management
  • Evaluate and replace our custom-built database deployment tool with enterprise-grade solutions
  • Design and implement robust database deployment pipelines across multiple environments
  • Architect database CI/CD processes that ensure reliability, repeatability, and auditability of schema changes
  • Lead database migration strategies from write-optimized to read-optimized architectures
  • Design and implement database observability, monitoring, and alerting solutions
  • Analyze and optimize long-running queries and database performance issues impacting customer experience
  • Design and implement database changes that support cloud-native application patterns
  • Collaborate with Solution Architect on data strategy and phased database modernization approaches
  • Work closely with Principal Application Engineers to ensure application and database architectures are optimally aligned
  • Mentor and teach engineering teams on database best practices, performance optimization, and modern data patterns
  • Drive adoption of database standards and hold teams accountable to data quality and performance requirements

Requirements

  • Minimum 10+ years of hands-on database engineering and architecture experience, with at least 5 years focused on enterprise-scale database systems
  • 8+ years of deep Oracle database expertise including performance tuning, query optimization, and enterprise-scale deployments
  • Proven track record of modernizing legacy database architectures and migrating business logic from databases to application tiers
  • Strong experience with database deployment automation, CI/CD pipelines, and enterprise database tooling
  • Experience with database normalization, data modeling, and designing for both transactional and analytical workloads
  • Understanding of read-optimization patterns, indexing strategies, and integration with modern BI platforms
  • Bachelor's degree in Computer Science, Engineering, or equivalent work experience.
Benefits
  • Health insurance
  • 401(k) matching
  • Flexible work hours
  • Paid time off
  • Remote work options

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard skills
database architecturedata modelingperformance tuningquery optimizationdatabase deployment automationCI/CD pipelinesdatabase normalizationread-optimizationindexing strategiescloud-native application patterns
Soft skills
leadershipmentoringcollaborationstrategic decision-makingcommunication
Certifications
Bachelor's degree in Computer ScienceBachelor's degree in Engineering
Woolpert

Cloud Data Engineer

Woolpert
Juniorfull-time$60k–$65k / year🇺🇸 United States
Posted: 1 hour agoSource: boards.greenhouse.io
AzureCloudJavaScriptPythonSQLTableau
Blizzard Entertainment

Data Engineer

Blizzard Entertainment
Mid · Seniorfull-time$78k–$143k / yearCalifornia · 🇺🇸 United States
Posted: 3 hours agoSource: activision.wd1.myworkdayjobs.com
AirflowAWSAzureBigQueryCloudETLGoogle Cloud PlatformOraclePython
Capital Technology Group

Data Engineer

Capital Technology Group
Mid · Seniorfull-time$110k–$165k / year🇺🇸 United States
Posted: 7 hours agoSource: boards.greenhouse.io
AirflowAmazon RedshiftBigQueryCloudETLPySparkPythonSparkSQL
Ensono

Data Engineer

Ensono
Mid · Seniorfull-time$114k–$148k / year🇺🇸 United States
Posted: 8 hours agoSource: boards.greenhouse.io
CloudETLJavaPythonScalaServiceNowSQL
GaP Solutions

Data Engineer – Human Capital

GaP Solutions
Mid · Seniorfull-timeDistrict of Columbia · 🇺🇸 United States
Posted: 9 hours agoSource: www.paycomonline.net
AWSEC2ETLPythonSQL