Data Architect - DOT Apps
East Millinocket, Maine, United States
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Architecture Consulting Consulting firm Data visualization ETL Model design Oracle Pipelines SQL
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.