Data Engineer/Database Developer

Young Life - Colorado Springs, CO

Full-time - Mid Level

Hybrid - Colorado Springs, CO

Religious, Grantmaking, Civic, Professional, and Similar Organizations

About the position

The Data Engineer/Database Developer position at Young Life is a hybrid role that combines responsibilities in both database administration and data integration development. This role is crucial for maintaining the organization's database systems while also leading the development of new data integrations that support the mission of Young Life. The successful candidate will report to the Director of Data Architecture and Integrations and will work closely with the Data Integration Lead to design and manage integration workflows. This position requires a strong understanding of data warehousing and the ability to collaborate with cross-functional teams, including Analytics, to create and optimize complex data structures. In this role, you will be responsible for designing, developing, and deploying integration processes using the Boomi Integration Platform or equivalent technologies. This includes creating and maintaining documentation for integration processes, collaborating with stakeholders to gather requirements, and ensuring seamless integration of systems and applications. You will also implement data mapping, transformation, and orchestration, monitor integration processes for efficiency, troubleshoot issues, and provide support and maintenance for integrations. Additionally, you will conduct unit testing and participate in integration testing for all processes, as well as provide training and support to team members on the Boomi platform. As a Database Developer, your responsibilities will include backing up data and databases, restoring or recovering data as needed, and optimizing databases for performance through indexing and tuning techniques. You will manage views, stored procedures, functions, and other database structures, while also monitoring and maintaining database access, security, and software. Identifying and resolving data-related issues will be a key part of your role, along with developing necessary database documentation. This position requires excellent analytical and problem-solving skills, strong interpersonal abilities, and effective communication skills to express complex technical concepts in business terms. The role also involves some travel and requires a commitment to ethical handling of private data, including financial and healthcare data.

Responsibilities

• Design, develop, and deploy integration processes using the Boomi Integration Platform or equivalent.
• Create and maintain integration process documentation.
• Collaborate with stakeholders to gather integration requirements and specifications.
• Collaborate with IT and business teams to ensure seamless integration of systems and applications.
• Implement data mapping, transformation, and orchestration.
• Monitor integration processes and ensure they are running efficiently and effectively.
• Troubleshoot and resolve integration issues, providing support and maintenance for integrations.
• Conduct unit testing and participate in integration testing for all integration processes.
• Provide training and support to other team members on the Boomi platform.
• Backup data and databases.
• Restore and/or recover data as required.
• Optimize databases for optimal performance including implementing indexing and other tuning techniques.
• Manage views, stored procedures, functions, and other database structures.
• Monitor and maintain database access and security and database software.
• Identify, respond, and fix data related issues.
• Develop database documentation as needed.

Requirements

• Minimum of a college degree in a computer-related field desired (experience may be considered in lieu of education for a proven staff member).
• Three years' experience in the computer field, including hands-on as a Database Developer.
• Must maintain current technical knowledge through courses and self-study, and pursue relevant certifications.
• Ability to lead medium to large sized technology projects.
• Excellent analytical, problem-solving and conceptual skills.
• Very strong interpersonal skills and ability to work well with others within and across the organization.
• Excellent verbal and written communication skills with an ability to express complex technical concepts in business terms.
• Excellent attention to detail.
• Good multitasking abilities.
• Work with manager to determine time estimates and production schedules for approved projects.
• Proactively communicate project status and/or issues to management.
• Work under minimal supervision.
• Able to work on multiple projects simultaneously.

Nice-to-haves

• Experience with the Boomi Integration Platform.
• Knowledge of data warehousing concepts.
• Familiarity with cloud and on-premises applications.