Data Modeler

  • Denver, PA
  • Posted 2 days ago | Updated 3 hours ago

Overview

On Site
$70 - $80 per hour
Contract - W2
Contract - 6 Month(s)

Skills

Data Warehouse
Database
ETL
Systems Administration

Job Details



Data Modeler


BCforward is currently seeking a highly motivated Data Modeller



Position Title: Data Modeller


Location: Remote


Anticipated Start Date: 11/07/2025


Please note this is the target date and is subject to change. BCforward will send an official notice ahead of a


confirmed start date.


Expected Duration: 6+ months


Job Type: Contract - Onsite


Pay Range: $60/hr - $70/hr


Please note that actual compensation may vary within this range due to factors such as location, experience, and job


responsibilities, and does not encompass additional non-standard compensation (e.g., benefits, paid time off, per diem,


etc.).



We are seeking an experienced and motivated Project Manager to lead the refreshing and updating of us


Supplier Code of Conduct. This role is crucial in ensuring our suppliers adhere to our high standards of ethical


conduct, compliance, and sustainability. The ideal candidate will have a strong background in project


management, familiarity with supply chain practices, and an understanding of ethical compliance standards.



Key Responsibilities (Supplier Code of Conduct):



  • Data Modeler - ETL Development & Leadership: Architect, develop, and optimise sophisticated ETL workflows using Informatica PowerCenter and IICS to manage data extraction, transformation, and loading from diverse sources into Amazon Redshift and other platforms.

  • Cloud Data Integration: Lead implementation of data integration solutions using IICS to connect on-premises and cloud-based systems, ensuring scalability, reliability, and seamless data flow.

  • Data Modelling: Design and maintain advanced logical and physical data models to support enterprise-level data warehousing, analytics, and reporting needs, ensuring performance and scalability.

  • Data Warehousing: Spearhead development and optimization of Amazon Redshift data structures, including schema design, indexing, partitioning, and query performance tuning for large-scale datasets.

  • Data Analysis: Conduct in-depth data profiling, cleansing, and analysis to uncover trends, anomalies, and actionable insights, delivering high-impact reports and dashboards to stakeholders

  • Performance Optimization: Proactively monitor and optimize ETL processes, Redshift queries, and data pipelines to ensure high performance, cost efficiency, and reliability.

  • Collaboration & Leadership: Partner with business analysts, data scientists, and cross-functional teams to gather requirements, translate them into technical specifications, and mentor junior team members.

  • Data Governance: Enforce data quality, consistency, and integrity through robust validation, error handling, and governance practices.

  • Documentation & Best Practices: Maintain comprehensive documentation of ETL processes, data models, workflows, and configurations while promoting best practices in data engineering.



Required Qualifications:


Experience:



  • 10-15 years of hands-on experience with Informatica PowerCenter for designing and implementing complex ETL workflows.

  • 5+ years of experience with Informatica Intelligent Cloud Services (IICS) for cloud-based data integration and orchestration.

  • Extensive experience (8+ years) in data modelling (conceptual, logical, and physical) for data warehousing and analytics solutions.

  • 7+ years of experience as a Data Analyst, performing advanced data profiling, analysis, and reporting to support business decision-making.



Benefits:


BCforward offers all eligible employees a comprehensive benefits packag,e including, but not limited to major medical, HSA, dental, vision, employer-provided group life, voluntary life insurance, short-term disability, long-term disability, and 401k.



About BCforward:


Founded in 1998 on the idea that industry leaders needed a professional service, and workforce management expert, to


fuel the development and execution of core business and technology strategies, BCforward is a Black-owned firm providing


unique solutions supporting value capture and digital product delivery needs for organizations around the world.


Headquartered in Indianapolis, IN with an Offshore Development Center in Hyderabad, India, BCforward's 6,000


consultants support more than 225 clients globally.


BCforward champions the power of human potential to help companies transform, accelerate, and scale. Guided by our


core values of People-Centric, Optimism, Excellence, Diversity, and Accountability, our professionals have helped our clients


achieve their strategic goals for more than 25 years. Our strong culture and clear values have enabled BCforward to


become a market leader and best in class place to work.


BCforward is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against based on disability.


To learn more about how BCforward collects and uses personal information as part of the recruiting process, view our and . As part of the recruitment process, we may ask for you to disclose and provide us with various categories of personal information, including identifiers, professional information, commercial information, education information, and other related information. BCforward will only use this information to complete the recruitment process.


This posting is not an offer of employment. All applicants applying for positions in the United States must be legally authorized to work in the United States. The submission of intentionally false or fraudulent information in response to this posting may render the applicant ineligible for the position. Any subsequent offer of employment will be considered employment at-will regardless of the anticipated assignment duration.


Interested candidates please send resume in Word format Please reference job code 246788 when responding to this ad.




Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.