Job Title: Senior Data Engineer

Company Name: LERETA

Job Details: $114k-$140k/yrRemoteFull,Time

Job Url: https://hiring.cafe/viewjob/iazvqyq11yudg2ji

Job Description: Posted 15h agoSenior Data Engineer@ LERETAView All JobsWebsitePomona, California, United States$114k-$140k/yrRemoteFull TimeResponsibilities:Define enterprise data architecture, Lead ELT framework modernization, Design scalable data ingestion patternsRequirements Summary:Bachelor’s degree in CS or Information Systems; 10+ years in software design/development, focus on data engineering; strong Azure, Snowflake, SSIS/SSRS, Power BI, Power Platform skills.Technical Tools Mentioned:Azure Data Factory, Azure Data Lake Storage Gen2, Snowflake OpenFlow, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, Power Automate, Power Query, Visual Studio, Azure DevOps, Advanced SQL development, Microsoft Excel, Git-based version control and CI/CD practices
The Senior Data Engineer leads the design, modernization, and operational support of the enterprise data platform. This role is responsible for architecting, optimizing, and supporting enterprise data integration, warehousing, reporting, and automation solutions across Azure, Snowflake, Microsoft BI technologies, and the Power Platform. 
Key Responsibilities: 

Defines and implements enterprise data architecture leveraging Azure Data Factory (ADF), Azure Data Lake Storage (ADLS Gen2), Azure SQL, Snowflake, Snowflake OpenFlow, SSIS, SSRS, Power BI, Power Automate, and Power Query. 


Leads conversion of SSIS packages to Azure Data Factory, Snowflake OpenFlow and modern ELT frameworks 


Designs scalable ingestion patterns to prevent duplicate extracts and enable incremental loading 


Optimizes long-running data extractions and improves pipeline performance 


Manages and tunes Snowflake warehouses for performance and cost efficiency 


Develops and supports Power BI datasets, data models, and enterprise reporting solutions 


Supports and modernizes SSRS reporting and downstream Power Platform dependencies 


Develops automation workflows using Power Automate to streamline operational processes 


Utilizes advanced Excel capabilities for analysis, reconciliation, validation, and business support 


Establishes best practices for data modeling, environment promotion (Dev/QA/Prod), naming conventions, monitoring, and operational support 


Provides Tier 2 / Tier 3 production support for data integration and reporting platforms 


Participates in Agile/Scrum ceremonies including sprint planning, backlog refinement, and progress reporting. 


Identifies obsolete fact tables, unused reports, and redundant processes to streamline the data ecosystem 


Partners with leadership to provide visibility into sprint progress, platform health, and modernization initiatives 


Leverages Ataccama ONE for governance, data quality monitoring, and metadata management 




Integrates and maintain Ataccama data quality workflows to support enterprise data governance 



This position will perform other duties as assigned based on the needs of the department.
Salary range: $114,280 - $140,000
Core Competencies:

Strong communication skills with the ability to translate technical concepts to business stakeholders


Strong analytical and problem-solving abilities


High attention to detail and data accuracy


Strong work ethic with a sense of ownership and accountability


Ability to prioritize effectively in a production support and development environment


Collaborative team player with the ability to work cross-functionally

Required Education & Experience: 

Bachelor’s degree in Computer Science, Information Systems, or equivalent field
10+ years of experience in software design and development, with the majority of time focused in a data engineering role 
Required Technical Skills:

Azure Data Factory 

 

Azure Data Lake Storage (Gen2) 

 

Snowflake (data modeling, performance tuning, streams & tasks) 

 

Snowflake OpenFlow 

 

SQL Server Integration Services (SSIS) 

 

SQL Server Reporting Services (SSRS) 

 

Power BI (data modeling, DAX, report optimization) 

 

Power Automate 

 

Power Query 

 

Visual Studio 

 

Azure DevOps 

 

Advanced SQL development and tuning 

 

Microsoft Excel (advanced formulas, pivot tables, data validation) 

 

Git-based version control and CI/CD practices 

 

Agile / Scrum methodology 

 

Enterprise production support experience