Data Engineer

PROLIM Global Corporation is hiring a Data Engineer for one of our top clients.Location: Plano, TX - OnsiteDuration: 6 MonthsJob Type: ContractExperience Required: 8-10 YearsJob SummaryWe 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 ResponsibilitiesDesign, 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 Skills10+ 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 SkillsPythonSQLJava and/or ScalaExperience 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.EducationBachelor's degree in Computer Science, Information Technology, Engineering, Data Science, or a related field is preferred.