Senior Data Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and enhance data pipelines and workflows for the ingestion, transformation, and delivery of enterprise data.

• Integrate both structured and semi-structured data from Oracle Fusion, on-premises databases, cloud applications, APIs, and external systems into Snowflake.

• Conduct data cleansing, validation, enrichment, and implement quality controls.

• Monitor and optimize pipelines and storage solutions for scalability, performance, and cost efficiency.

• Enforce data governance, security, and compliance protocols.

• Collaborate with architects, analysts, and data scientists to facilitate Power BI analytics, reporting, AI/ML, and self-service applications.

• Provide technical guidance on pipeline architecture, coding standards, and system optimization.

• Mentor junior engineers and promote knowledge sharing within the Data & Analytics team.

• Assess and incorporate emerging technologies, tools, and methodologies.

• Work with business stakeholders to comprehend use cases, translate requirements, and deliver effective solutions.

⛳️ Requirements

• A Bachelor’s degree in Computer Science, Data Science, Software Engineering, or a related quantitative discipline is required, or a combination of education and applicable work experience.

• At least five years of experience in data engineering, data integration, and optimization.

• Demonstrated experience in developing and maintaining enterprise-scale data solutions on Snowflake, with Power BI serving as the primary reporting and semantic layer.

• Familiarity with integrating data from Oracle Fusion (ERP/EPM) along with other on-premises and cloud applications.

• Proven experience collaborating with business stakeholders and senior leadership to achieve data-driven results.

• Experience in migrating data from legacy and enterprise source systems to contemporary cloud data platforms, including source-to-target mapping, data validation, and reconciliation processes.

• Expertise in scalable data pipelines and architectures within Snowflake.

• Proficient in using ELT/ETL orchestration tools such as Azure Data Factory or Airflow.

• Experience with cloud object storage solutions like OCI Object Storage or Azure Blob.

• Strong skills in SQL and Python, particularly with Snowflake SQL and dbt.

• In-depth knowledge of relational databases and enterprise source systems, including Oracle Fusion (ERP/EPM) and SQL Server.

• Experience in planning and executing migrations from source systems, including historical data conversion, validation and reconciliation, and cutover planning.

• Familiarity with data governance and security frameworks, including metadata management, lineage, role-based access controls, and privacy-by-design principles.

• Ability to collaborate effectively across technical and business teams while translating requirements into sustainable solutions.

• Skills in identifying and resolving performance issues in cloud-based data environments, including optimizing Snowflake queries and warehouse performance, as well as tuning Power BI semantic models and refresh processes.

• Excellent communication and leadership abilities, with a talent for mentoring peers and promoting best practices.

• A keen interest in emerging technologies, especially AI and ML applications in data engineering, including Snowflake Cortex and Power BI Copilot.

• Willingness to work during Pacific Time business hours.

🏝️ Benefits

• A fantastic corporate culture and a values-driven work environment.

• A picturesque 20-acre campus featuring a creek and walking trails.

• On-site wellness center offering personal training, fitness classes, and massage services.

• Engaging company events.

• Company donation matching and volunteer rewards.

• Opportunities for career development.

• Profit-sharing bonus.