EMPLOYMENT COMPLIANCE
Immigration and Employment Compliance
Review 4Ci's immigration, employment eligibility, LCA, Public Access File, wage-and-hour, and workplace compliance commitments.
View DetailsINFORMATION TECHNOLOGY · 4CI -9748
Database
Architect
Hackensack, NJ · Hybrid · Full Time
LocationHackensack, NJ
Work arrangementHybrid
Employment typeFull Time
EngagementLong Term
Experience10+ Years
Reference4CI -9748
THE OPPORTUNITY
Help shape dependable
enterprise platforms.
4Consulting, Inc is seeking a qualified Database Architects 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.
What you’ll do
- Lead onshore and offshore development and production support teams through sprint planning, code reviews, release readiness, incident management, and technical delivery, ensuring consistent development practices and operational reliability.
- Design and optimize PostgreSQL data warehouse architecture, including dimensional models, data structures, partitioning strategies, analytical reporting layers, and database performance standards.
- Develop and maintain complex PL/pgSQL procedures, functions, and high-volume ETL/ELT pipelines while implementing data transformations, reconciliation processes, logging, and performance optimization strategies.
- Own data quality and production issue resolution by investigating upstream data failures, schema changes, and downstream reporting impacts; implement root-cause fixes, proactive monitoring, and preventive controls while communicating risks and status to stakeholders.
What you bring
- Experience designing and supporting enterprise data warehouse and analytical reporting environments, including reporting datasets, aggregated data structures, business intelligence extracts, and downstream analytical workflows.
- Experience managing end-to-end data processing and reporting operations, including data reconciliation, data quality controls, incremental data loads, source-data changes, and resolution of upstream and downstream data issues.
- Experience translating business reporting requirements into data models, analytical datasets, reporting solutions, and operational controls that support reliable and consistent business decision-making.
- Experience leading distributed technical teams, coordinating production support, managing release readiness, and collaborating with business stakeholders to prioritize issues, communicate risks, and maintain critical data services.
Preferred experience
PostgreSQLPL/pgSQLAdvanced SQLData WarehousingETL/ELTDatabase Performance TuningData ModelingHigh Availability and Disaster RecoveryDatabase SecurityProduction Support
Equal opportunity
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.