Job SummaryAssists junior staff members and works with other developers and production Database Administrators to ensure scalable, efficient and optimized solutions. Works closely with customers, management, business analysts, and team members to understand business requirements that drive the analysis and design of quality technical solutions. Designs, develops, maintains and improves data structures, queries, reporting solutions, extract-transform-load (ETL) processes and data warehousing strategies for all mission critical projects. Ensures solutions are aligned with business and Information Technology strategies and comply with the organization's architectural standards. Works closely with team members on the daily execution of deliverables and assists less experienced team members as needed.
Job Duties and Responsibilities - Works on multiple, moderately complex, enterprise-wide projects requiring technical expertise. Participates in systems and data analysis, design, development, integration, and enhancement activities, as well as related maintenance and production support.
- Assists in the development of project scope and serves as a project point of contact when necessary. Participates in project-planning sessions with customers, business analysts, and team members to analyze development requirements, provide design recommendations for complex systems, and recommend methods and assignments.
- Conducts unit tests ensuring systems meet the needs of customer and line-of-business based on technical documentation. Provides ongoing maintenance of web applications and/or client/server applications or tools, depending upon previous involvement with projects.
- Manages unresolved production support issues across multiple areas of expertise. Provides design recommendations, develops application and custom integration solutions, including major enhancements and interfaces.
- Makes modifications to existing software applications and modules in accordance with technical specifications and division standards. Reviews efforts to ensure compliance to application standards.
- Follows documented and approved Systems Development Life Cycle (SDLC) process and makes recommendations toward the development of reusable routines or components, including object-oriented base class reuse.
- Translates business and technical requirements into cross-functional business application systems, providing custom integration solutions, including major system enhancements. Collaborates with team members in setting development guidelines
- Provides application support as needed during regular and after hours.
- Remains informed and proficient regarding applicable industry technical innovations, trends, standards and new developments. Maintains current skills and remains knowledgeable regarding new tools and computer languages as applicable.
- Each team member is expected to be aware of risk within their functional area. This includes observing all policies, procedures, laws, regulations and risk limits specific to their role. Additionally, they should raise and report known or suspected violations to the appropriate Company authority in a timely fashion.
- Performs other related duties as required.
The information on this description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.
Minimum Education:- Bachelor's degree in computer science, information systems or a related field or an equivalent combination of education and experience.
Minimum Experience:- Five years of related experience including data design and project management, using multiple programing languages, and using and managing metadata
Required Knowledge, Skills, & Abilities:- Knowledge of data modeling and designing databases
- Solid understanding of systems development life cycle (SDLC), software best practices and development methodologies
- Strong technologist with excellent data analysis and ETL skills
- Knowledge of various databases such as MySQL and Oracle
- Knowledge of scripting languages such as C# and VB.Net
- Knowledge of Master Data Management (MDM) and Governance
- Knowledge of System DBA
- Understanding of multiple programming languages, systems, as well as data design and project management methodologies.
- Strong architecture, design, and development skills
- Understanding of building data warehouses for analytical and business intelligence solutions
- Understanding of business solutions that the data warehouse serves
- Strong analytical and diagnostic skills
- Skill in developing and organizing high-quality documentation
- Skill and flexibility managing multiple projects with large volumes of data in a rapidly changing environment
- Skill troubleshooting issues in a multi-tier environment
- Skill working with both business team members and technologists
- Leadership skills with an emphasis on teamwork
