Top 2 Data warehouse architect Jobs in Portland Me

Data Architect
RitePros —Portland, ME
- Azure
- Computer Science
- 5 years
Big Data Engineer
RitePros —Portland, ME
- Computer Science
- 5 years
- DevOps

More jobs to discover

Find similar jobs that you might be interested in.

Big Data Engineer
RitePros —Portland, ME
Collaborate with System Architects to design, develop, test, and implement efficient Snowflake data models aligned with enterprise data warehousing standards.
Senior Anaplan Solutions Architect
Liberty Mutual —Portsmouth, NH
Responsible in partnership with the Product Owner and Manager to develop a strategic roadmap for the platform making incremental but steady progress towards…
$156,000 - $281,000 a year

Show more similar jobs

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Data Warehouse Sr. Manager
Huntington Bank —Columbus, OH
Understand and translate the technical design from the Data Architect team into implemented physical data models that meet data governance, enterprise…
Lead ETL Developer- Enterprise Data Warehouse (EDW)
Huntington Bank —Columbus, OH
As a technical leader, you will partner across engineering, architecture, QA, and business teams to deliver high-quality, reliable data solutions.
$70,000 - $140,000 a year

Show more jobs in cities nearby

I want to receive the latest job alert for data warehouse architect in portland me

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

data warehouse architect jobs near portland me

Data Architect jobs in Delray Beach, FL

Data Architect jobs in Ohio

Data Annotation jobs in Philadelphia, PA

Data Architect jobs in Grand Rapids, MI

Landscape Architect jobs in Philadelphia, PA

Data Center Manager jobs in Columbus, OH

Data Architect jobs in Maryland

Data Center Technician jobs in Los Angeles, CA

Big Data Architect jobs in Orlando, FL

Big Data Architect jobs in Naperville, IL

Data Center Technician jobs in Fresno, CA

Big Data Architect jobs in Kansas City, MO

Data Scientist jobs in Kansas City, MO

Remote Data Entry jobs in Anchorage, AK

Data Architect

RitePros
Portland, ME

Apply Now

Job Details

Qualifications

Data integrity assurance
Data model design
Performance tuning
Systems integration
Content creation for technical audiences
Engineering development testing
Data modeling projects
Data validation techniques
System performance optimization
Integration Architecture Design (Architecture design skills)
Enterprise solutions implementation
Scalable systems
Schema design
Data integrity and documentation
Data Architecture Design (Architecture design skills)
Data integrity process (data warehousing)
Enterprise Integration
Improving database performance
Software documentation
Scalability
Unit testing
Metadata
Analysis (software development lifecycle)
System tuning
Data performance optimization
Technical writing experience within technology
Scalability and Performance Testing (system development)
Design (software development lifecycle)
Metadata management

Full Job Description

Data Architect with Bachelor’s Degree in Computer Science, Computer Information Systems, Information Technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.

Job Duties and Responsibilities:

Design, define, and maintain enterprise data architecture supporting analytical, operational, and regulatory-driven systems across multiple business domains.
Lead requirements analysis by working closely with business stakeholders, subject matter experts, QA, and engineering teams to translate business needs into scalable data solutions.
Develop and maintain conceptual, logical, and physical data models for data warehouses, data marts, operational data stores, and enterprise applications using industry-standard modeling tools.
Architect and guide ETL and data integration frameworks, including data ingestion, transformation, validation, and error-handling processes across heterogeneous source systems.
Design and optimize database schemas and structures to support high-volume, high-availability enterprise data platforms.
Establish and enforce data quality, data governance, and data stewardship standards to ensure accuracy, consistency, and auditability of enterprise data.
Perform forward and reverse engineering of database designs and conduct impact analysis for schema and data changes.
Support performance tuning, capacity planning, and optimization of databases and ETL processes to meet scalability and availability requirements.
Lead or contribute to master data management (MDM) initiatives, including customer, product, vendor, and identity domains.
Architect data solutions integrating data from multiple enterprise systems, including ERP, legacy platforms, and external data sources.
Produce and maintain comprehensive technical documentation, including architecture diagrams, data models, mapping documents, design specifications, and validation artifacts.
Provide technical leadership and mentoring to data engineers, developers, and analysts throughout the data platform lifecycle.
Participate in testing activities, including unit testing, system testing, performance testing, and volume testing, to ensure system readiness prior to QA and production deployments.
Collaborate with executive leadership to support technology roadmaps, long-term data strategies, and enterprise architecture initiatives.
Support production systems by assisting with issue analysis, defect resolution, and continuous improvement of data platforms.

Work Experience required for the Position:

Minimum of 5 years of progressively responsible professional experience in the field of data architecture, data modeling, and enterprise data management.
Hands-on experience in enterprise data architecture design, including defining data standards, integration patterns, and scalable data platforms.
Demonstrated experience in conceptual, logical, and physical data modeling for complex enterprise systems.
Proven experience designing and supporting ETL and data integration frameworks, including data ingestion, transformation, validation, and error handling.
Experience working with relational and/or analytical databases, including schema design, performance tuning, and optimization.
Strong background in data quality, data governance, metadata management, and auditability.
Experience collaborating with business stakeholders, QA teams, and engineering teams to translate functional requirements into technical data solutions.
Experience supporting testing activities, including unit testing, system testing, performance testing, and volume testing of data pipelines.
Ability to produce and maintain technical documentation, such as architecture diagrams, data models, mapping documents, and design specifications.
Experience working in complex, multi-system enterprise environments, including legacy systems and modern data platforms.

Environment / Technologies involved:

Enterprise Data Architecture aligned with TOGAF standards, including conceptual, logical, and physical data modeling; master data management (MDM); metadata management; data governance; and enterprise data quality frameworks.
Big Data and analytics platforms including Hadoop ecosystem technologies (Hive, HDFS, Solr), real-time data streaming using Apache Kafka, and distributed and parallel data warehouse architectures supporting large-scale financial and pension data processing.
Cloud-based data platforms and hybrid architectures utilizing Amazon Web Services (AWS), Microsoft Azure, Oracle Cloud and Oracle Fusion, including cloud-native data lakes, data warehouses, and data virtualization technologies such as Dremio.
Relational and analytical database technologies including Oracle (Enterprise Editions), PostgreSQL, MySQL, Microsoft SQL Server, Teradata, Amazon Redshift, and NoSQL data stores such as MongoDB and Cassandra.
ETL, data integration, and orchestration technologies including Alteryx, Informatica, IBM DataStage, Microsoft SSIS, Kafka-based streaming pipelines, batch and incremental data processing frameworks, and workflow orchestration using Camunda, Autosys, and UC4.
DevOps, automation, and containerization technologies including Docker, CI/CD pipelines, Jenkins, Git and Bitbucket, Maven, and automated deployment and monitoring frameworks.
Business intelligence, reporting, and advanced analytics tools including Tableau, SAS, Cognos, Business Objects, OBIEE, SSRS, and enterprise-level dashboarding solutions.
Programming and scripting languages including Java, Python, Scala, SQL/PL-SQL, and UNIX/Linux shell scripting.
Enterprise security and compliance technologies including Kerberos authentication, role-based access control (RBAC), encryption of data at rest and in transit, and secure enterprise data access models.
AI-assisted architecture, design, and productivity tools including ChatGPT, Claude, Grok, and related generative AI platforms for solution design, documentation, and analysis.

Work location is Portland, ME with required travel to client locations throughout USA.

Rite Pros is an equal opportunity employer (EOE).

Please Mail Resumes to:
Rite Pros, Inc.
565 Congress St, Suite # 305
Portland, ME 04101.

Email: [email protected]

Apply Now

Refine Your Search

data warehouse architect jobs in portland me

Data Architect

Big Data Engineer

More jobs to discover

Explore jobs in cities nearby

I want to receive the latest job alert for data warehouse architect in portland me

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected