Senior Programmer Analyst - MaineDOT Data Warehousing Team
About The Position
The Maine Office of Information Technology (OIT) is seeking a Senior Programmer Analyst to support the Maine Department of Transportation (MaineDOT) Database and Data Warehousing Team. The position analyzes, designs, develops, configures, implements, and maintains enterprise databases and data analytics systems, including MaineDOT’s Data Marts and centralized Data Warehouse. Database design, implementation, and support may also extend to application development and geospatial teams. The Senior Programmer Analyst serves as a senior technical lead on complex, data-intensive projects. Work may include designing, testing, implementing, deploying, and supporting ETL operations; creating new subject areas in the Enterprise Data Warehouse and related Data Marts; and supporting analytical and transactional databases, including OLTP and OLAP systems. The role includes operational and maintenance work, requirements gathering, analysis, documentation, and frequent interaction with technical partners and business stakeholders. The employee works at the highest technical level under limited supervision, mentors and trains less experienced developers, and adapts to new team processes and technologies. This is a hybrid telework and onsite position based in Augusta, Maine. All work, including telework, must be completed within Maine. The position is not eligible for visa sponsorship or STEM OPT extensions.
Requirements
- Four years of computer programming experience using higher-level languages, including two years at the Programmer Analyst level or equivalent; OR a bachelor's degree in Computer Sciences, including two years at the Programmer Analyst level or equivalent. A master's degree in Computer Science may substitute for one year of programming experience.
- Knowledge of data system design techniques.
- Knowledge of Systems Development Life Cycle (SDLC) and documentation standards.
- Knowledge of structured systems methodologies.
- Knowledge of higher-level programming languages and enterprise-class application development tools.
- Ability to diagnose and correct system malfunctions.
- Ability to adapt and enhance application software.
- Ability to design, conduct, and evaluate system testing.
- Ability to lead and coordinate project team activities and provide technical support.
- Ability to work at the highest technical level under limited supervision.
Nice To Haves
- Firm understanding of data warehousing fundamentals.
- Experience designing, implementing, and supporting ETL/ELT.
- Practical database design experience.
- Experience with dimensional modeling and Star Schema design.
- Experience working with Oracle databases and/or data analytics offerings.
- Ability to gather requirements directly from stakeholders and subject matter experts.
- Significant experience with PL/SQL.
- Python experience.
- JIRA experience.
- GitHub experience.
- Effective communication skills and logical, structured thinking.
- Demonstrable experience as both a technical leader and an individual contributor.
Responsibilities
- Analyze, design, develop, configure, implement, and maintain enterprise databases and data analytics systems, including MaineDOT Data Marts and its centralized Data Warehouse.
- Serve as a senior technical lead on complex, data-intensive projects.
- Design, test, implement, deploy, and support Extract, Transform, and Load operations.
- Design and implement new subject areas within the Enterprise Data Warehouse and related Data Marts.
- Perform database design, implementation, and support for analytical and transactional systems, including OLTP and OLAP systems.
- Support operational and maintenance needs of existing systems and processes.
- Gather requirements, conduct analysis, and prepare documentation in coordination with technical partners and business stakeholders.
- Mentor and train less experienced developers in complex technical concepts.
- Learn and apply new processes and technologies introduced to the team.
- Lead, coordinate, and provide technical support to project teams.
Benefits
- 13 paid holidays, 12 days of sick leave, and more than three weeks of vacation leave annually; vacation accrual increases with years of service, and overtime-exempt employees receive personal leave.
- The State pays 85%–100% of employee-only health insurance premiums, depending on salary.
- Health insurance premium credit reducing employee-only premiums by 5% for participants who meet program requirements.
- The State pays 100% of employee-only dental insurance premiums.
- The State contributes 14.06% of pay to the Maine Public Employees Retirement System (MainePERS).
- Gym membership reimbursement of up to $40 per month.
- Health and dependent care flexible spending accounts.
- Eligibility for Public Service Student Loan Forgiveness.
- Living Resources employee assistance program.
- Forty-two consecutive calendar days of fully paid parental leave for employees welcoming a child, including fathers and adoptive parents; additional unpaid leave may be available under the Family and Medical Leave Act.
- Voluntary deferred compensation through a MaineSaves 457(b) account.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
