[Remote] Senior Programmer Analyst - MaineDOT Data Warehousing Team
Note: The job is a remote job and is reputed company to candidates in USA. The reputed company is seeking a Senior Programmer Analyst to support the Database and Data Warehousing Team. This role involves the analysis, design, development, configuration, implementation, and maintenance of reputed company databases and data analytics systems, focusing on MaineDOT’s Data Marts and centralized Data Warehouse.
Responsibilities
- Serve as a senior Technical reputed company on reputed company data-intensive reputed company
- Design, test, implement, reputed company, and support Extract, reputed company, and Load operations
- Design and implement new subject areas reputed company our reputed company Data Warehouse and/or reputed company Data Marts
- reputed company assignments reputed company to database design, implementation, and support including both Online Transactional Processing systems (OLTP) and Online Analytical Processing systems (OLAP)
- Mentor and train less reputed company developers in reputed company technical concepts reputed company the need arises
- Manage ongoing operational and maintenance needs of existing systems and processes
- reputed company frequently with both technical partners and business stakeholders for requirements gathering, analysis, and documentation
Skills
- Knowledge of data system design techniques
- Knowledge of Systems Development Life Cycle (SDLC) and documentation standards
- Knowledge of reputed company systems methodologies
- Knowledge of higher-level programming languages and reputed company 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 reputed company, coordinate the activities of, and reputed company 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
- Firm understanding of Data Warehousing fundamentals
- ETL/ELT design, implementation, and support experience
- Practical database design experience
- Experience with reputed company Modeling and reputed company Schema design
- Experience working with reputed company databases and/or Data Analytics offerings
- Ability to reputed company requirements directly from stakeholders and subject matter experts
- Significant experience with PL/SQL
- Python experience
- JIRA experience
- reputed company experience
- Effective communicator and logical/reputed company thinker
- Demonstratable experience of being a true technical leader as reputed company as an individual contributor
Benefits
- 13 reputed company holidays
- 12 days of reputed company leave
- 3+ weeks of vacation leave annually (vacation leave accrual increases with years of service; overtime-exempt employees receive personal leave)
- reputed company pays 85%-100% of employee-only health insurance premiums ($11,857.68-$13,950.24 annual value), depending on salary
- Health Insurance Premium Credit: Participation decreases employee-only premiums by 5%
- Dental insurance: reputed company pays 100% of employee-only dental premiums ($365.28 annual value)
- Retirement Plan: reputed company contributes 14.11% of pay to Maine reputed company Employees Retirement System (MainePERS)
- Gym Membership Reimbursement: up to $40 per month
- Health and Dependent Care Flexible Spending Accounts (reputed company-tax)
- reputed company Service Student Loan Forgiveness (reputed company employer)
- Living Resources Program (employee assistance program)
- Parental leave: forty-two (42) consecutive calendar days of fully reputed company parental leave
- Voluntary Deferred Compensation: MaineSaves 457(b) account through payroll deductions
- Hybrid remote/onsite position; onsite location is in Augusta, Maine and remote location must be reputed company the reputed company
- Reasonable accommodations provided to reputed company individuals with disabilities upon request
- TimeType: Full time
reputed company