Data Warehousing Specialists-(4CI -9276)
Job Description
Job Title: Data Warehousing Specialists
Location: White Plains, NY
Employer: 4Consulting, Inc
Position Type: Full Time
Worksite: Remote
Position Summary
4Consulting, Inc is seeking a qualified Data Warehousing Specialists to support technology consulting, application development, systems analysis, testing, data management, cybersecurity, infrastructure, or project delivery services for client projects. The selected candidate will perform duties consistent with the client’s project requirements and company delivery standards.
Essential Duties and Responsibilities
The candidate will be responsible for:
- Develop and optimize complex SQL and Redshift queries for large-scale data transformation and analytics.
- Build and maintain AWS-based ETL and data ingestion pipelines using Glue, S3, and Redshift.
- Develop Python-based queries and apply GenAI tools for data profiling, code generation, and quality assurance.
- Support dashboards, data quality activities, troubleshooting, and collaboration across distributed teams.
Minimum Qualifications
The position requires:
| Education | Bachelor’s degree in Computer Science, Information Technology, Engineering, Business, or related field, or equivalent combination of education and experience. |
| Experience | 3–5 years of experience in ETL, SQL, cloud data engineering, Python, and data pipeline development. |
| Technical Skills | SQL, AWS Redshift, AWS Glue, Amazon S3, Python, ETL, Jinja, Amazon Bedrock |
| Business / Domain Skills | Data Warehousing, Data Integration, Data Transformation, Revenue Cycle Management, Healthcare Data, EDI Data |
| Communication | Ability to communicate with technical and business stakeholders. |
| Documentation | Ability to prepare project documentation, status updates, and deliverables. |
| Work Authorization | Must be legally authorized to work in the United States. Sponsorship may be considered where permitted by company policy and project requirements. |
Certification Required
None
Travel Required
None
Supervisory Role
No
Preferred Qualifications
- Experience with Amazon Bedrock, Langflow, Claude, or similar GenAI platforms.
- Experience with Superset or other dashboarding and data visualization tools.
- Experience working with healthcare transaction, EDI, or revenue-cycle data.
Equal Employment Opportunity Statement
4Consulting, Inc is an Equal Opportunity Employer. Employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, citizenship status, immigration status where protected by law, or any other legally protected status. All candidates will be evaluated based on job-related qualifications, experience, skills, availability, and ability to perform the essential duties of the position.