Senior Data Engineer
LERETA, LLC, Pomona, CA, United States
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.
#J-18808-Ljbffr
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.
#J-18808-Ljbffr