Data Warehouse Architect

Join to apply for the Data Warehouse Architect role at ConsultNet Technology Services and Solutions

5 days ago Be among the first 25 applicants

Join to apply for the Data Warehouse Architect role at ConsultNet Technology Services and Solutions

Get AI-powered advice on this job and more exclusive features.

Title : Data Warehouse Architect

Location : Uncasville, CT (3 days onsite)

Target Start Date : ASAP

Type : (C, CTH, D) : Direct Hire (open to Contract to hire)

Pay Rate / Salary (Ranges OK) : $130K / Year

This position is responsible for the strategic design of enterprise-wide data and information architecture, aligning with overall enterprise architecture goals. The role focuses on scalable data modeling and database design while balancing accessibility, performance, and security. The individual will define and enforce architecture standards, policies, and naming conventions for structured data across the organization. They will also lead efforts to translate strategic business needs into practical, enterprise-level data architecture solutions.

Title : Data Warehouse Architect

Location : Uncasville, CT (3 days onsite)

Target Start Date : ASAP

Type : (C, CTH, D) : Direct Hire (open to Contract to hire)

Pay Rate / Salary (Ranges OK) : $130K / Year

This position is responsible for the strategic design of enterprise-wide data and information architecture, aligning with overall enterprise architecture goals. The role focuses on scalable data modeling and database design while balancing accessibility, performance, and security. The individual will define and enforce architecture standards, policies, and naming conventions for structured data across the organization. They will also lead efforts to translate strategic business needs into practical, enterprise-level data architecture solutions.

Primary Responsibilities :

Design and develop architecture for all components of the data warehouse, including ETL strategy, staging, aggregation, analytics delivery, and data quality.

Implement data storage strategies and oversee health monitoring, performance optimization, and security for data systems.

Manage capacity planning across data warehouse and analytical platforms.

Collaborate with senior IT and business leaders to identify, prioritize, and support data and information requirements.

Resolve complex technical issues related to BI tools, databases, and data pipelines.

Improve business intelligence performance through effective data indexing, filtering, and caching.

Develop training and coaching programs for end users to maximize BI tool efficiency and adoption.

Define and implement data quality metrics and validation procedures.

Research emerging technologies and present business cases for enterprise-wide BI adoption.

Create and execute testing and QA procedures to ensure high-quality data outputs and insights.

Contribute to highly complex cross-functional projects with minimal supervision.

Secondary Responsibilities :

Mentor and coach junior technical team members.

Provide support for mission-critical applications operating in a 24 / 7 / 365 enterprise environment.

Accurately document and report time and activity logs as required.

Ensure compliance with HIPAA regulations and industry best practices in data privacy and handling.

Minimum Qualifications :

Option 1 :

Master's degree in Computer Science, Engineering, or a related field

4+ years of progressive experience in Information Technology

2+ years in a Data Warehouse Engineer or related role involving data analysis, programming, and BI development

Hands-on experience with BI tools (e.g., Teradata, SAS, Cognos, Unica) and ETL tools (e.g., Informatica)

Ability to obtain and maintain any relevant certifications or licenses

Option 2 :

Bachelor's degree in Computer Science, Engineering, or related field

10+ years of progressive experience in Information Technology

Same BI / ETL tool and experience requirements as above

Preferred Competencies :

Deep understanding of software development lifecycle (SDLC), COBIT, and ITIL frameworks

Proficiency in enterprise-class ETL tools, especially Informatica

Advanced knowledge of SQL and enterprise data platforms such as Teradata

Strong analytical thinking and critical problem-solving skills

Excellent verbal and written communication skills

Commitment to data integrity, security, and organizational data strategy

Demonstrated initiative, self-awareness, and leadership potential

Welcome to ConsultNet and the family of companies, Tekne, SaltClick, TechBridge, and OmniMedia. As a premier national provider of technology talent and solutions, our expertise spans across project services, contract-to-hire, direct placement, and managed services both onshore and nearshore.

Celebrating more than 25 years of partnership with a diverse client base, we've crafted rewarding opportunities for our consultants, fostering high-performing teams that deliver impactful results.

Over the last few years thousands of consultants have found their calling with us in roles that have made a meaningful impact on their lives, enhanced their career, challenged them, and propelled them towards achieving their personal and professional goals. At the ConsultNet family of companies, we believe effective communication is crucial in aligning the right job with your unique skills and professional aspirations. To us, it's all about the personal approach we take and the values we uphold.

Our comprehensive service offerings cover a wide range of technology positions across key markets nationwide. Client more at .

We champion equality and inclusivity, proudly supporting an Equal Opportunity Employer policy. We welcome applicants regardless of Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other status protected by law.

Seniority level

Seniority level

Entry level

Employment type

Employment type

Full-time

Job function

Job function

Information Technology

Industries

Gambling Facilities and Casinos

Referrals increase your chances of interviewing at ConsultNet Technology Services and Solutions by 2x

Sign in to set job alerts for Data Warehouse Architect roles.

Were unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr