Top 3 Data warehouse analyst sql Jobs in Portland, Me

Data Architect
RitePros —Portland, ME
- Azure
- Computer Science
- 5 years
IT Specialist
RitePros —Portland, ME
- On call
- Azure
- Computer Science
- 3 years
BI Consultant
RitePros —Portland, ME
- On call
- Azure
- Computer Science
- 3 years

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Data Analyst
Rogue Fitness —Columbus, OH
Bachelor's degree in a relevant field (Finance, Accounting, Economics, Statistics, Data Analytics, or similar).
Education Systems Data Analyst I (SY26-27)
Columbus City Schools —Columbus, OH
Possession of a bachelor's degree with significant coursework (21 semester or 32 quarter hours) in computer science, mathematics, or a closely related field,…
$36.67 an hour
10d

I want to receive the latest job alert for data warehouse analyst sql 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 analyst sql jobs near portland, me

IT Technician jobs in 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

Entry Level It Paid Training jobs in New York, NY

It Technician jobs in Union County, NJ

Sterile Processing Technician jobs in Virginia Beach, VA

Health Information Technician jobs in Michigan

It Technician jobs in Vacaville, CA

It Technician jobs in Mooresville, NC

Veterinary Technician jobs in Richmond, VA

It Technician jobs in Little Rock, AR

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 analyst sql jobs in portland, me

Data Architect

IT Specialist

BI Consultant

Explore jobs in cities nearby

I want to receive the latest job alert for data warehouse analyst sql in portland, me

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected