Data Engineer

PROLIM Global Corporation is hiring a Data Engineer for one of our top clients.

Location: Plano, TX - Onsite

Duration: 6 Months

Job Type: Contract

Experience Required: 8-10 Years


Job Summary


We are seeking an experienced Data Engineer with strong Insurance domain experience to join our team in Plano, TX. The ideal candidate will have extensive hands-on experience in ETL/ELT, Snowflake, Tableau, data pipeline development, data architecture, and data modeling .


The candidate will be responsible for developing and maintaining scalable data pipelines, designing high-performance data architectures, optimizing data platforms, and delivering reliable data solutions for business and analytics needs.


Key Responsibilities

• Design, develop, debug, and maintain robust and automated data pipelines to ingest data from multiple sources.
• Build scalable ETL/ELT workflows for extracting, transforming, cleansing, and loading data.
• Design and maintain large-scale data lakes, data warehouses, and enterprise data architectures .
• Develop data transformation processes to ensure data quality, consistency, accuracy, and accessibility .
• Design and implement efficient data models to support reporting, analytics, and business intelligence requirements.
• Develop and optimize Snowflake databases, data warehouses, tables, views, queries, and data processing workflows.
• Perform SQL query tuning and performance optimization across databases and cloud data platforms.
• Monitor data pipelines and troubleshoot failures, performance issues, and data quality problems.
• Work with SQL/NoSQL databases and cloud infrastructure to improve reliability and performance.
• Develop and maintain Tableau dashboards and visualizations to support business reporting and analytics.
• Collaborate with data scientists, analysts, business stakeholders, and other engineering teams to understand data requirements.
• Implement data validation, reconciliation, and quality checks throughout the data lifecycle.
• Ensure appropriate data security, privacy, governance, and compliance practices are followed, particularly for sensitive insurance data.
• Participate in production support, root-cause analysis, troubleshooting, and continuous improvement of data platforms.
• Document data pipelines, data models, technical processes, and operational procedures.

Required Skills

• 10+ years of experience in Data Engineering or related data-focused roles.
• Strong Insurance domain experience is required.
• Strong hands-on experience with ETL/ELT development and data integration.
• Strong hands-on experience with Snowflake .
• Strong hands-on experience with Tableau , including dashboard and data visualization development.
• Strong knowledge of data warehousing, data lakes, and data architecture .
• Strong SQL development and query optimization skills.
• Experience with data transformation, cleansing, validation, and quality processes.
• Experience designing scalable and high-performance data pipelines.
• Strong understanding of data modeling and enterprise data warehouse concepts.
• Experience working with cloud-based data platforms and infrastructure.
• Strong analytical, troubleshooting, and problem-solving skills.

Preferred / Desirable Skills

• Python
• SQL
• Java and/or Scala
• Experience with SQL and NoSQL databases.
• Experience with cloud data platforms.
• Experience with data governance, security, privacy, and compliance.
• Experience working with data scientists, analysts, and business stakeholders.

Education


Bachelor's degree in Computer Science, Information Technology, Engineering, Data Science, or a related field is preferred.