Data Architect - DOT Apps

East Millinocket, Maine, United States

DMV IT Service

@dmvitservice

View all jobs at DMV IT Service

Apply now Apply later

Job Title: Data Architect - DOT Apps

 Location: East Millinocket, ME

 Employment Type: Contract

About Us:

 DMV IT Service LLC is a trusted IT consulting firm, established in 2020. We specialize in optimizing IT infrastructure, providing expert guidance, and supporting workforce needs with top-tier staffing services. Our expertise spans system administration, cybersecurity, networking, and IT operations. We empower our clients to achieve their technology goals with a client-focused approach that includes online training and job placements, fostering long-term IT success.

Job Purpose:

We are seeking a highly skilled Senior Developer / Data Architect with deep expertise in Oracle technologies, data modeling, and automated ETL development. This individual will lead efforts to architect and implement robust, scalable data repositories, and serve as a trusted advisor on modern data practices. The role requires both strategic insight and hands-on technical execution in a hybrid environment.

Requirements

Key Responsibilities

  • Act as a subject matter expert for Oracle database platforms, both on-premises and in cloud environments.
  • Design, build, and maintain enterprise-class data repositories with high performance and reliability.
  • Develop and automate ETL pipelines to integrate data from flat files, databases, and API endpoints.
  • Utilize Oracle Analytics Cloud (OAC) for data visualization and reporting.
  • Write and optimize complex SQL and PL/SQL procedures, functions, scripts, and views.
  • Apply best practices in dimensional modeling and tabular data modeling to support analytics and BI initiatives.
  • Capture and translate complex business requirements into technically sound, scalable solutions.
  • Implement rigorous error handling, logging, and metadata documentation standards.
  • Mentor junior and senior developers on technical design, best practices, and Oracle tools.
  • Create system architecture diagrams, process documentation, and training materials.
  • Investigate emerging technologies and recommend appropriate solutions to meet evolving organizational needs.
  • Collaborate closely with internal teams, leadership, and external vendors across various projects.
  • Support and lead data migration, system expansion, and modernization efforts.

Required Skills & Experience

  • Minimum 5 years’ experience in a Data Architect or Senior Developer role.
  • Proven experience developing fully automated ETL solutions from diverse data sources.
  • Senior-level expertise with Oracle database technologies—on-prem and cloud-based.
  • Mastery of SQL and PL/SQL with the ability to develop sophisticated logic and workflows.
  • Advanced knowledge of dimensional data modeling and tabular model design.
  • Experience with Oracle Analytics Cloud (OAC).
  • Strong understanding of API integration for data refresh and synchronization.
  • Ability to act as a technical mentor and provide architectural guidance to teams.
  • Detail-oriented with strong documentation, commenting, and metadata creation skills.
  • Self-motivated, capable of working independently with minimal supervision.

Apply now Apply later

* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰

Job stats:  0  0  0
Category: Architecture Jobs

Tags: APIs Architecture Consulting Consulting firm Data visualization ETL Model design Oracle Pipelines SQL

Region: North America
Country: United States

More jobs like this