Database Administrator - Data Architect
Augusta, Maine, United States
Full Time Senior-level / Expert USD 69K - 93K
State of Maine
Maine.gov - Official site includes links to services available online, Governor, state agencies, Legislature, US Congressional delegation, state parks, and tax information.Location: Augusta,Maine,United States
OFFICE OF INFORMATION TECHNOLOGY, MAINE IT
MAINE DEPARTMENT OF TRANSPORTATION APPLICATION DEVELOPMENT TEAM
Opening Date: April 22, 2024
Closing Date: May 6, 2024
Job Class Code: 0189
Grade: 29
Salary: $69,535.44 - $93,838.19/Annually (includes 15% recruitment & retention stipend and eligible for 5% training bonus)
Position Number: 025000039
You are a talented senior-level professional who is driven toward success. You are a go-getter, always seeking ways to expand your knowledge, and encourage others to do the same. You enjoy clearing hurdles as you strive for excellence. If this describes you, we want you on our TEAM!!
OVERVIEW:
The Department of Administrative and Financial Services (DAFS) Office of Information Technology provides information technology support to over 13,000 employees. MaineIT oversees large-scale enterprise applications that support the critical and diverse business needs of the State of Maine and its agencies. This position will be part of our MaineDOT apps team supporting all the applications used by the Maine Department of Transportation.
MaineIT is looking for a qualified and skilled individual who is self-motivated to be a part of a highly technical team supporting MaineDOT and who will represent our C.A.R.E. values in all they do. At MaineIT we:
- Practice Customer-focus, ensuring that our customers are heard, and their needs are met.
- Hold ourselves to a high level of Accountability by being transparent with our stakeholders.
- Maintain an effective level of Responsiveness by providing prompt updates in a proactive manner.
- Strive to provide Empathy driven, people-focused services by applying emotional intelligence skills and behaviors.
BRIEFLY ABOUT THE JOB:
This advanced technical and analytical position involves designing, developing, and supporting highly complex databases, data analysis, data modeling, and data integrations, supporting MaineDOT’s Enterprise Data Warehouse and other MaineDOT systems. Candidates are expected to have strong problem-solving and organizational skills, excellent attention to detail, multitasking ability, able to lead an IT team and interact effectively with our business partners.
WHAT IS IN IT FOR YOU?
Hybrid Work Opportunity – This position is a hybrid remote/onsite position. The onsite location is in Augusta, Maine and the remote location must be within the state of Maine.
- You will have an opportunity to have fun, learn and develop new skills while working with a highly talented and dedicated team of software developers and key stakeholders at MaineDOT.
- You will be analyzing issues and design solutions resulting in projects of various sizes.
- You will help resolve technical issues to provide system functionality and data integration.
- You will have the opportunity to add to your experience and ability in a collaborative working environment.
- You will experience new and different challenges on an ongoing basis.
WHAT WILL YOU DO?
Your job as a Data Architect will have responsibility for supporting MaineDOT’s Enterprise Data Warehouse solution and a Data Integration strategy for all MaineDOT systems. Other duties will include:
- Translating business requirements into databases, data warehouses, and data streams.
- Creating procedures to ensure data accuracy and accessibility.
- Analyzing, planning, and defining data architecture framework, including security, reference data, metadata, and master data.
- Creating and implementing data management processes and procedures.
- Collaborating with other teams within the organization to devise and implement data strategies, build models, and assess shareholder needs and goals.
- Researching data acquisition opportunities.
- Developing application programming interfaces (APIs) to retrieve data.
Work will involve frequent communications with our MaineDOT Business Partners, MaineDOT AppDev peers, Software Vendors, and other MaineIT Technical Staff.
Preference will be given to candidates who display a high-level skill set in the following areas:
- Data Analysis
- Data Modeling and Design
- Data Migration Tools Knowledge
- Data Integration / API Development
- Database development standards
- Oracle Analytics Cloud
- Strong oral and written communications
- Strong desire to provide great Customer Service
- Ability to define and resolve complex technical problems independently and in a team environment.
MINIMUM QUALIFICATIONS
- Eight (8) years of progressively responsible and increasingly complex work experience in computer programming, analysis, and design with at least four (4) years of database analysis and design experience. A Masters Degree in Computer Science may substitute for one (1) year of the general computer programming/analysis/design experience.
Preference will be given to those who submit a cover letter with their resume to be considered for an interview.
The selected candidate will be required to sucessfully pass the required background checks as a condition of employment.
Benefits of working for the State of Maine:
No matter where you work across Maine state government, you find employees who embody our state motto—"Dirigo" or "I lead"—as they provide essential services to Mainers every day. We believe in supporting our workforce's health and wellbeing with a valuable total compensation package, including:
- Work-Life Fit – Rest is essential. Take time for yourself using 13 paid holidays, 12 days of sick leave, and 3+ weeks of vacation leave annually. Vacation leave accrual increases with years of service, and overtime-exempt employees receive personal leave.
- Health Insurance Coverage – The State of Maine pays 85%-100% of employee-only premiums ($10,523.28-$12,380.40 annual value), depending on salary. Use this chart to find the premium costs for you and your family, including the percentage of dependent coverage paid by the State.
- Dental Insurance – The State of Maine pays 100% of employee-only dental premiums ($350.40 annual value).
- Retirement Plan – The State contributes the equivalent of 13.41% of the employee's pay towards the Maine Public Employees Retirement System (MainePERS).
State employees are eligible for an extensive and highly competitive benefits package, covering many aspects of wellness. Learn about additional wellness benefits for State employees from the Office of Employee Health and Wellness.
Note: Benefits may vary somewhat according to specific collective bargaining agreements and are prorated for part-time employment.
There's a job and then there's purposeful, transformative work. Our aim is to create a workplace where you can learn, grow, and continuously refine your skills. Applicants demonstrate job requirements in differing ways, and we appreciate that many skills and backgrounds can make people successful in this role.
As an Equal Opportunity employer, Maine State Government embraces a culture of respect and awareness. We are committed to creating a strong sense of belonging for all team members, and our process ensures an inclusive environment to applicants of all backgrounds including diverse race, color, sex, sexual orientation or gender identity, physical or mental disability, religion, age, ancestry, national origin, familial status or genetics.
If you’re looking for a great next step, and want to feel good about what you do, we’d love to hear from you. Please note reasonable accommodations are provided to qualified individuals with disabilities upon request.
Thinking about applying?
Research shows that people from historically excluded communities tend to apply to jobs only when they check every box in the posting. If you’re currently reading this and hesitating to apply for that reason, we encourage you to go for it! Let us know how your lived experience and passion set you apart.
Apply to this jobTags: API Development APIs Architecture Computer Science Data analysis Data management Data warehouse Oracle R Research Security
Perks/benefits: Career development Competitive pay Health care Home office stipend Insurance Salary bonus Wellness
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Marketing Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open MLOps Engineer jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Analyst Intern jobs
- Open Product Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Research Scientist jobs
- Open Azure Data Engineer jobs
- Open Junior Data Engineer jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs