Senior Data Engineer
Lereta Llc, Pomona, CA, United States
901 Corporate Center Dr, Pomona, CA 91768, USA
Description
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 maintains 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 on 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
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities. This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr
Description
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 maintains 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 on 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
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities. This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.
#J-18808-Ljbffr