Senior Programmer Analyst MaineDOT Data Warehousing Team

OVERVIEW:

The Department of Administrative and Financial Services (DAFS) Office of Information Technology (MaineIT) provides information technology support to over 13000 employees. MaineIT oversees large scale enterprise applications that support the critical and diverse business needs of the State of Maine and its agencies.

MaineIT is seeking a highly talented individual who will represent ourC.A.R.E.values in all that they do. At MaineIT we:

• PracticeCustomer-focus ensuring that our customers are heard and their needs are met.
• Hold ourselves to a high level ofAccountabilityby being transparent with our stakeholders.
• Maintain an effective level ofResponsivenessby providing timely updates in a proactive manner.
• Strive to provideEmpathydriven people-focused services by applying emotional intelligence skills and behaviors.

JOB DESCRIPTION:

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. This positionis responsible forthe analysis design development configuration implementation and maintenance of enterprise databases and data analytics systems includingMaineDOTsData Marts and centralized Data Warehouse.

Potential candidates should be confident in their database and data warehousing skillsets asalarge portionof assignments will require these skillsets.Database design implementation and support responsibilities might also extend towork forour application development and geospatial teams as needed.

WHAT IS IN IT FOR YOU

• TheMaineDOTstrives to support economic opportunity and quality of life byresponsiblyproviding theircustomersthe safest and most reliable transportation system possible given available resources.We can feel good about helping to support them in that mission.

• You will bedeveloping data solutions that inform business decisions being made at the very highest levels ofMaineDOTmanagement.

• There will be opportunitiesto help shape the future direction of the DB/DW team as we look towards modernizing existing processes and blazepathstowardsnewlyemerging datadomains.

• You couldadd your individual style to our evolving team culture.Collaboration is key.Fresh ideas and perspectives are most welcome.

• Do you like being surrounded by smart peopleThenour division isa good place to find yourself.You will be interacting with lots of talented IT professionals and lots of very experienced business partnersdaily.This includes manyMaineDOTengineersand specialistswho are subject matterexpertsin the areas in which they serve.

• There will be endless opportunities toaskquestionslearn share and teach.

• You will help us define what our new cloud-based reality looks like as we continue to migrate more-and-more databases applications and services to the cloud.

• There will be manyof opportunities to discuss what the future of AI means to us and how we can bestleverageallits potential.

• Things tend to evolve quickly within our team and within our division.This helps to keep boredom at bay andprovides tremendous opportunities for thosewho like to contribute their experience and ideas towards our shared organizational goals.

WHAT WILL YOU DO

• AsSeniorProgrammerAnalystwithinthe Database and Data Warehousing Team you willbe expected to serve as a senior Technical Lead on complex data-intensiveprojects.This might often include designing testing implementing deploying and supporting Extract Transform and Load operations.At times it will involve designing and implementing new subject areas within our Enterprise Data Warehouse and/or relatedDataMarts.It will also includea great varietyof other data-related assignments in support of both our analytical and transactional databases.
• Assignments related to database designimplementation and supportwill be common.This will include both Online Transactional Processing systems (OLTP) as well as Online Analytical Processing systems (OLAP).
• Senior Programmer Analysts are expected to be able to mentor and train less experienced developers in complex technical concepts when the needarises andare expected to begood studentswhen new processes and/or technologies are introduced to the team.
• Our existing systems and processes also include a fair amount of operational and maintenance needs and that will be part of the ongoing responsibilities as well.
• Assignmentsoftenrequirefrequent interaction with both technical partners as well as business stakeholders.Related requirements gathering analysis and documentationassignments are common and should beexpected.Employees in this classification are competent to work at the highest technical level under limited supervision.

KNOWLEDGE SKILLS AND ABILITIES REQUIRED:

• Knowledge ofdata systemdesign techniques

• Knowledge ofSystemsDevelopmentLife Cycle(SDLC)and documentation standards.

• Knowledge of structured systems methodologies

• Knowledge ofhigher-levelprogramming 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 coordinate the activities of and provide technical support to project teams

Four (4) years of computer programming experience utilizing higher level languages including two (2) years at the Programmer Analyst level or equivalent -OR- a Bachelors Degree in Computer Sciences including two (2) years at the Programmer Analyst level or equivalent. A Masters Degree in Computer Science may be substituted for one (1) year of programming experience.

BENEFITS OF WORKING FOR THE STATE OF MAINE:

No matter where you work across Maine state government you find employees who embody our state mottoDirigo or I leadas they provide essential services to Mainers every day. We believe in supporting our workforces health and wellbeing with a valuable total compensation package including:

• Work-Life Balance Rest is essential. Take time for yourself using13 paid holidays 12 days of sick leaveand3 weeks of vacation leaveannually. Vacation leave accrual increases with years of service and overtime-exempt employees receive personal leave.
• Health Insurance Coverage The State of Maine pays85%-100%of employee-only premiums($11857.68-$13950.24annual value) depending on salary. Use this chart to find thepremium costsfor you and your family including the percentage of dependent coverage paid by the State.
• Health Insurance Premium Credit Participation decreases employee-only premiums by 5%. Visit the Office of Employee Health and Wellness for more information aboutprogram requirements.
• Dental Insurance The State of Maine pays 100% of employee-only dental premiums ($365.28 annual value).
• Retirement Plan The State of Maine contributes 14.11% of pay to the Maine Public Employees Retirement System (MainePERS) on behalf of the employee.
• Gym Membership Reimbursement Improve overall health with regular exercise and receive up to $40 per month to offset this expense.
• Health and Dependent Care Flexible Spending Accounts Set aside money pre-tax to help pay for out-of-pocket health care expenses and/or daycare expenses.
• Public Service Student Loan Forgiveness The State of Maine is a qualified employer for this federal program. For more information visit theFederal Student Aid office.
• Living Resources Program Navigate challenging work and life situations with our employee assistance program.
• Parental leaveis one of the most important benefits for any working parent. All employees who are welcoming a childincluding fathers and adoptive parentsreceiveforty-two (42) consecutive calendar days of fully paid parental leave. Additional unpaid leave may also be available under theFamily and Medical Leave Act.
• Voluntary Deferred Compensation Save additional pre-tax funds for retirement in a MaineSaves 457(b) account through payroll deductions.

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 anything less than full-time.

Theres a job and then theres 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 youre looking for a great next step and want to feel good about what you do wed 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 youre currently reading this and hesitating to apply for that reason we encourage you to go for it! Let us know how your experience and passion set you apart.

If you require a paper application please download and print one HERE