Data Transformation Engineer Job Addison Texas USA,IT/Tech

Work From Home - TX
7711 Center Ave
Ste 200
Addison, TX 75001, USA

Work From Home - CA
7711 Center Avenue
Suite 200
Huntington Beach, CA 92647, USA

Work From Home - GA
7711 Center Avenue
Suite 200
Huntington Beach, GA 92647, USA

Work From Home - CO
7711 Center Avenue
Suite 200
Huntington Beach, CO 92647, USA

Work From Home - FL
7711 Center Avenue
Suite 200
Huntington Beach, FL 92647, USA

Comprehensive benefits package including medical, dental, vision, and life insurance
Performance-based bonuses
to reward your contributions*
Paid time off to recharge and maintain a healthy work-life balance
Flexible work options, including remote and hybrid opportunities, if eligible
Retirement Plan (401k)with company-matched contributions
Education Advancement,for employees and qualified dependents, via the Confie Enablement Scholarship Fund
Fitness Reimbursement – up to $15/month for gym memberships
Inclusive workplace
through a strong commitment to Diversity, Equity, and Inclusion
Employee Assistance Program –confidential support for personal or professional challenges, at no cost
Extra Perks
– optional plans for disability, hospital indemnity, health advocate program, universal life, critical illness, accident insurance, and even pet insurance

Purpose

Work under the guidance and supervision of the Director of Enterprise Architecture to build Confie's next-generation Enterprise Data Solutions. Require expertise in implementing and maintaining data solutions on Snowflake data cloud environments that drive critical business insights and operations. Responsible for developing robust data models, creating efficient ELT processes, and optimizing performance to support the organization's data needs

Design and develop data pipelines, ELT workflows to populate the cloud Data Lake and Data Warehouse on Snowflake with transformation tools (e.g., Coalesce, Where Scape, Azure Data Factory) and replication tools (e.g., Fivetran, Airbyte, etc.)

Translate business requirements into technical specifications; establish and define details, definitions, and requirements of applications, components, and enhancements

Design and develop robust and scalable data pipelines to support data integrations using Snowflake, Coalesce, Python, Airflow, and Fivetran

Design and develop Snowflake data objects (tables, views, stored procedures, udf's, etc.)

Implement ELT (Extract, Load, Transform) processes using Snowflake's features, such as Snow Pipe, Streams, and Tasks

Perform data cleaning, analysis, and integration using Python

Ability to work with multiple data sources and types (structured/semi-structured/unstructured)

Design and implement efficient data models and schemas within Snowflake to support reporting, analytics, and business intelligence needs

Monitor and optimize query performance and resource utilization within Snowflake using query profilling, query optimization techniques, and workload management features

Identify and resolve performance bottlenecks and optimize data warehouse configurations for maximum efficiency

Implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it

Monitor data pipelines for timely and accurate completion

Stay up-to-date with industry trends and advancements in data engineering, continuously improving the team's technical knowledge and skills

On-call support

Qualifications and Education Requirements

4+ years of professional experience in data engineering, designing and implementing data pipelines, and building data infrastructure

4+ years of strong experience required in Snowflake data cloud and ETL development, including Snowflake procedures, udf's in Python and SQL, streams, tasks, Snowpipe, and working with semi-structured data

3+ years of strong experience…