Senior Programmer Analyst - MaineDOT Data Warehousing Team
About The Position
The Department of Administrative and Financial Services (DAFS) Office of Information Technology (MaineIT) 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. MaineIT is seeking a highly talented individual who will represent our C.A.R.E. values in all that 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 timely updates in a proactive manner. Strive to provide Empathy driven, people-focused services by applying emotional intelligence skills and behaviors. 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 position is responsible for the analysis, design, development, configuration, implementation, and maintenance of enterprise databases and data analytics systems, including MaineDOT’s Data Marts and centralized Data Warehouse. Potential candidates should be confident in their database and data warehousing skillsets, as a large portion of assignments will require these skillsets. Database design, implementation, and support responsibilities might also extend to work for our application development and geospatial teams as needed.
Requirements
- 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.
- 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, coordinate the activities of, and provide technical support to project teams
Nice To Haves
- A Masters Degree in Computer Science may be substituted for one (1) year of programming experience.
- Firm understanding of Data Warehousing fundamentals
- ETL/ELT design, implementation, and support experience
- 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 communicator and logical/structured thinker
- Demonstratable experience of being a true technical leader as well as an individual contributor
Responsibilities
- Serve as a senior Technical Lead on complex data-intensive projects.
- Designing, testing, implementing, deploying, and supporting Extract, Transform, and Load operations.
- Designing and implementing new subject areas within our Enterprise Data Warehouse and/or related Data Marts.
- Support analytical and transactional databases, including Online Transactional Processing systems (OLTP) as well as Online Analytical Processing systems (OLAP).
- Mentor and train less experienced developers in complex technical concepts.
- Perform operational and maintenance needs for existing systems and processes.
- Frequent interaction with both technical partners, as well as business stakeholders.
- Related requirements gathering, analysis, and documentation assignments.
Benefits
- 13 paid holidays
- 12 days of sick leave
- 3+ weeks of vacation leave annually
- Health Insurance Coverage (State pays 85%-100% of employee-only premiums)
- Health Insurance Premium Credit (decreases employee-only premiums by 5%)
- Dental Insurance (State pays 100% of employee-only dental premiums)
- Retirement Plan (State contributes 14.11% of pay to MainePERS)
- Gym Membership Reimbursement (up to $40 per month)
- Health and Dependent Care Flexible Spending Accounts
- Public Service Student Loan Forgiveness eligibility
- Living Resources Program (employee assistance program)
- Parental leave (42 consecutive calendar days of fully paid leave for welcoming a child)
- Voluntary Deferred Compensation (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
