Data Modeler

Job Title: Data Modeler (Contract) Company: Big Four Client Location: Remote Work Authorization: U.S. Citizen or Green Card Holder Pay Rate: $50-$60 per hour (W2), depending on experience Duration: 9+ Months Overview: We are seeking an experienced Data Modeler to lead the design, development, and optimization of enterprise-grade data solutions. This role involves architecting sophisticated ETL workflows, managing large-scale cloud data integrations, and designing performant data models to support analytics and reporting. The ideal candidate will have strong leadership skills, deep technical expertise in Informatica PowerCenter, IICS, and Amazon Redshift, and the ability to collaborate effectively across business and technical teams. Key Responsibilities: • ETL Development & Leadership: Architect, develop, and optimize complex ETL workflows using Informatica PowerCenter and IICS to manage data extraction, transformation, and loading from multiple sources into Amazon Redshift and other platforms. • Cloud Data Integration: Lead the implementation of cloud-based data integration solutions using Informatica Intelligent Cloud Services (IICS), ensuring seamless connectivity between on-premises and cloud environments. • Data Modeling: Design and maintain advanced logical and physical data models to support data warehousing and analytics initiatives, emphasizing scalability, performance, and accuracy. • Data Warehousing: Drive schema design, indexing, partitioning, and query performance tuning in Amazon Redshift for efficient handling of large-scale datasets. • Data Analysis: Conduct data profiling, cleansing, and validation to identify patterns, anomalies, and opportunities, producing actionable insights for business stakeholders. • Performance Optimization: Monitor and fine-tune ETL workflows, Redshift queries, and data pipelines to ensure optimal performance and cost efficiency. • Collaboration & Mentorship: Partner with business analysts, data scientists, and engineers to translate business requirements into technical specifications, while mentoring junior team members and promoting technical excellence. • Data Governance: Uphold strong data quality, consistency, and integrity through validation, audit controls, and governance best practices. • Documentation & Best Practices: Maintain comprehensive documentation for ETL processes, data models, workflows, and configurations; champion data engineering best practices across teams. Requirement Skills & Qualifications: • Experience: • 10–15 years of hands-on experience designing and implementing complex ETL workflows with Informatica PowerCenter. • 5+ years of experience with Informatica Intelligent Cloud Services (IICS) for cloud-based data integration and orchestration. • 8+ years of experience in data modeling (conceptual, logical, and physical) for data warehousing and analytics environments. • 7+ years of experience as a Data Analyst, performing data profiling, cleansing, and reporting to support business intelligence. • Technical Skills: • Expertise with Amazon Redshift, SQL performance tuning, and data warehouse design. • Strong proficiency in data integration, ETL architecture, and data governance frameworks. • Experience with cloud data ecosystems and hybrid integration patterns. • Soft Skills: • Strong communication and leadership abilities. • Proven capability to collaborate in cross-functional, remote environments. • Excellent analytical and problem-solving skills. Preferred Skills & Qualifications: • Experience with additional data integration tools or cloud platforms (e.g., AWS Glue, Azure Data Factory, or Snowflake). • Familiarity with Agile/Scrum delivery methodologies. • Prior experience mentoring or leading small technical teams.