Data Architect - DOT Apps

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.