Data Integration Engineer

Role Descriptions: Role - Data Integration Engineer |

Location - Primary - Dallas | Secondary - Tampa

Job Description Minimum 8 years of experience in Data Management| with strong expertise in analytical datawarehousing and enterprisescale data platforms| contributing to the delivery of complex datasolutions. Minimum 3 years of hands-on experience with Snowflake Cloud Data Warehouse| includinguse of advanced features and performance optimization for large| concurrent analytics workloads. Strong experience with AWS cloud architecture| designing and supporting scalable| secure| andcostefficient data solutions using core AWS services. Design| develop| and maintain complex SQL and PLSQL procedures to supporthighperformance data integration and transformation processes. Experience developing data integration solutions using Snowflake services such as Snowpark|Streams| Tasks| and Snowpipe to implement both realtime and batch data pipelines within anAWS ecosystem. Strong knowledge of logical and physical data modeling| enabling effective analytics|reporting| and business intelligence solutions. Hands-on experience developing dimensional data models| including slowly changingdimensions (SCDs) and multiple fact table designs| aligned with analytics best practices. Solid experience across data lifecycle management| including data lineage| profiling|mapping| integration| validation| cleansing| masking| subsetting| archiving| purging|virtualization| and metadata management. Implement and adhere to data quality and testing standards| supporting unit testing| systemintegration testing| and UAT| to ensure productionready data solutions. Perform SQL performance tuning| proactive monitoring| and root cause analysis of datapipeline and platform issues| driving timely and effective resolution. Actively participate in Agile delivery teams| contributing to sprint planning| story implementation|estimation| and documentation using Jira. Collaborate closely with peers| architects| and stakeholders| and provide guidance to juniorengineers through code reviews and knowledge sharing. Demonstrate strong verbal and written communication

Essential Skills: Role - Data Integration Engineer | Location - Primary - Dallas | Secondary - Tampa Job Description Minimum 8 years of experience in Data Management| with strong expertise in analytical datawarehousing and enterprisescale data platforms| contributing to the delivery of complex datasolutions. Minimum 3 years of hands-on experience with Snowflake Cloud Data Warehouse| includinguse of advanced features and performance optimization for large| concurrent analytics workloads. Strong experience with AWS cloud architecture| designing and supporting scalable| secure| andcostefficient data solutions using core AWS services. Design| develop| and maintain complex SQL and PLSQL procedures to supporthighperformance data integration and transformation processes. Experience developing data integration solutions using Snowflake services such as Snowpark|Streams| Tasks| and Snowpipe to implement both realtime and batch data pipelines within anAWS ecosystem. Strong knowledge of logical and physical data modeling| enabling effective analytics|reporting| and business intelligence solutions. Hands-on experience developing dimensional data models| including slowly changingdimensions (SCDs) and multiple fact table designs| aligned with analytics best practices. Solid experience across data lifecycle management| including data lineage| profiling|mapping| integration| validation| cleansing| masking| subsetting| archiving| purging|virtualization| and metadata management. Implement and adhere to data quality and testing standards| supporting unit testing| systemintegration testing| and UAT| to ensure productionready data solutions. Perform SQL performance tuning| proactive monitoring| and root cause analysis of datapipeline and platform issues| driving timely and effective resolution. Actively participate in Agile delivery teams| con

Data Integration Engineer

Primary - Dallas

Secondary - Tampa

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.