SQL, Python & Snowpark Development
· Write expert-level SQL for complex transformations, data quality controls, performance tuning, and analytical data products.
· Develop advanced Python and Snowpark components for data processing, orchestration, automation, testing, and operational tooling.
· Create maintainable technical documentation, runbooks, data mappings, and knowledge-transfer materials.
Snowflake Cortex, AI & Advanced Capabilities
· Evaluate and implement appropriate Snowflake Cortex AI capabilities, including governed use of large language model functions and related AI services.
· Partner with architecture and analytics stakeholders to assess AI or machine-learning use cases, data readiness, security, and productionization requirements.
· Stay current with Snowflake platform releases and recommend practical adoption of new capabilities based on business value, risk, and total cost.
Responsibilities
Snowflake Data Engineering & Pipeline Development
· Design, develop, test, deploy, and support complex batch, incremental, and near-real-time data pipelines on Snowflake.
· Build reusable, metadata-driven data ingestion and transformation frameworks that are scalable, observable, and maintainable.
· Apply advanced Snowflake capabilities such as Dynamic Tables, Streams, Tasks, Snowpipe or Snowpipe Streaming, Snowpark, secure data sharing, and zero-copy cloning where appropriate.
· Develop robust error handling, data reconciliation, monitoring, alerting, and restart or recovery patterns for production pipelines.
Performance, Reliability & Cost Optimization
· Optimize complex SQL workloads, warehouse sizing, clustering strategies, storage patterns, and query performance.
· Monitor and improve platform reliability, workload concurrency, data freshness, and Snowflake credit consumption.
· Troubleshoot data, code, orchestration, and performance issues across development and production environments.
Architecture, Design & Engineering Standards
· Contribute to solution architecture, logical and physical data modeling, technical design, and design reviews.
· Implement engineering standards for modularity, code quality, CI/CD, source control, testing, documentation, and deployment automation.
· Design solutions aligned with enterprise security, privacy, data governance, role-based access control, and audit requirements.
| Location | Dallas, TX |
| Job Type | Contractor |
| Industry | Computer/IT Services |
| Salary | $60 Per Hour |
| Year Founded | 2005 |
| Headquarters | Farmington Hills, Michigan, US |
| Website | https://www.prolim.com/ |
Qualifications
Required Experience & Education
· Minimum 8 years of hands-on experience developing enterprise solutions on cloud data platforms.
· Minimum 5 years of hands-on Snowflake data engineering and platform development experience.
· Demonstrated experience designing and delivering complex, production-grade data pipelines and data transformation frameworks.
· Expert-level SQL, including complex query development, performance tuning, data modeling, and troubleshooting.
· Advanced Python development skills for production data engineering, automation, testing, and integration use cases.
· Strong working knowledge of modern data engineering practices, orchestration, CI/CD, source control, automated testing, monitoring, and operational support.
· Experience with Snowflake security, governance, role-based access control, data sharing, and performance or cost optimization.
· Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field, or equivalent practical experience.
Preferred Qualifications
· SnowPro Core certification strongly preferred; SnowPro Advanced: Data Engineer or another relevant Snowflake certification is highly desirable.
· Experience in healthcare, life sciences, biotechnology, pharmaceutical, or another regulated data environment preferred.
· Architecture and solution-design experience, including data modeling, design reviews, and technical decision documentation, preferred.
· Experience with Snowflake Cortex AI and governed AI-enabled data solutions preferred.
· Knowledge of machine-learning concepts, feature pipelines, model data preparation, MLOps, or model deployment patterns is a plus.
PROLIM is a leading provider of end-to-end IT, PLM and Engineering Services and Solutions for Global 1000 companies. They understand business as much as technology, and help their customers improve their profitability and efficiency by providing high value technology consulting, staffing, and project management outsourcing services.
Their IT and PLM consulting offerings include; Advisory, PLM Software/Services, Program Management, Solution Architecture Training/Staffing, Cloud Solutions, Servers/Networking, Infrastructure, ERP Practices and QA Services. Engineering services include Data Translation, CAD/CAM/CAE, Process & Product Engineering, Prototyping, and Testing/Validation within a wide range of markets and industries.
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesImprove your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder