Top 9 Sql server data architect/technical Jobs in Maine

Data Architect
RitePros —Portland, ME
- Azure
- Computer Science
- 5 years
Database Architect
RitePros —Portland, ME
- Azure
- 5 years
- Engineering
Software Developer
RitePros —Portland, ME
- Azure
- Computer Science
- Mid-level
Solution Architect
RitePros —Portland, ME
- Azure
- Management
- Computer Science
Application Architect
RitePros —Portland, ME
- Azure
- Computer Science
- Office

Other jobs to consider

Find your next job by exploring related positions.

Data Specialist
Portland Public Schools, Maine —Portland, ME
Proficiency in data collection and survey design, including developing forms and processes that support accurate, low-burden data entry.
$70,000 - $90,000 a year
Business Intelligence Specialist
General Dynamics - Bath Iron Works —Bath, ME
Bachelor’s Degree in the field of Computer Science, Data Science, or a related technical field is preferred. Analyze user requirements and, based on findings,…
10d

Show more related jobs

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Data Architect / Data Analyst
TRA'BIAN ENTERPRISES —Columbus, OH
Function as a business analyst when needed to bridge gaps between business understanding and technical implementation.
Associate Data Cloud Business Transformation Architect
Deloitte —Columbus, OH
Leading implementations of Salesforce Data Cloud and Marketing Cloud, including technical requirements gathering, solution design, configuration, and activation…
$110,700 - $218,300 a year

Show more jobs in cities nearby

I want to receive the latest job alert for sql server data architect/technical in maine

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

sql server data architect/technical jobs near maine

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

sql server data architect/technical jobs in maine

Data Architect

Database Architect

Software Developer

Solution Architect

Application Architect

Other jobs to consider

Explore jobs in cities nearby

I want to receive the latest job alert for sql server data architect/technical in maine

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected