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.