Data Integration Engineer

This position is no longer available.

To apply, email your résumé to:
resume@children.org

Children International
2000 East Red Bridge Road
Kansas City, MO 64131

Title: Data Integration Engineer
Reports to: Director of Data Services
About Children International

Children International is a nonprofit humanitarian organization working to eradicate poverty around the world. At CI, we believe that every child matters and that it is simply unacceptable that over a billion children live in poverty. The CI approach is to invest in our kids and youth by providing a safe place, a caring team and a path out of poverty through programs in health, education, empowerment and employment. We provide this support for nearly 220,000 children in 13 agencies working in 10 countries around the world.

The work Children International does on behalf of children in poverty is funded primarily through a one-to-one sponsorship model. We are transforming our funding model to dramatically increase the support we provide our kids. Additionally, we are taking our programs from good to great by elevating our people systems and practices worldwide. That’s where you come in.

Position summary

The data integration engineer is an expert with a deep understanding of integration technologies and architecture, who works to model, execute and manage data integration practices that ingest, transform and provision data across various sources into an organized and unified view. They will contribute to the strategy and architecture for managing the enterprise’s data, define and implement the data integration architecture to address IT and business objectives, and manage data integration best practices. This role will support the groups performing business intelligence and analysis activities.

Responsibilities

  • Plan, develop, execute and manage the integration of data across the enterprise’s data assets
  • Design, develop, test, document and optimize scalable ETL packages\routines, data integration and data quality processes to populate systems such as a data warehouse, data vault, data lake, operational data stores, business intelligence, and other systems from source data
  • Troubleshoot data issues within and across the business, recommending solutions
  • Proactively analyze and evaluate business databases to identify and propose improvements and optimization
  • Develop and execute test plans and scenarios including data design, tool design, and data extract/transform
  • Work with IT, business and data management teams to understand data needs and develop solutions
  • Develop standards, designs, data maps; develop and modify functions, programs, routines, and stored procedures to export, transform and load data
  • Establish development standards and best practices for data integration solutions and lead code review sessions to ensure the implementation of standards
  • Collaborate with IT to design and model application data structures, storage, and integration following enterprise-wide architecture standards across legacy, web, cloud and purchased package environments
  • Analyze complex data elements and systems, data flow, dependencies and relationships
  • Track industry trends and recommend enterprise data integrations to accommodate users’ needs and business processes
  • Collaborate with the data services team to identify, evaluate and recommend appropriate technologies and strategies for building products and delivering services, from business intelligence, business analysis, and data services perspectives
  • Collaborate with the data services team to create and adhere to data governance and data quality guidelines, appropriately communicating data governance and quality issues when discovered
  • Work on multiple concurrent deadline-driven projects.
  • Support the groups performing business analysis and business intelligence activities

Personal Characteristics & Qualifications

Required
  • BS in computer science, applied mathematics, engineering or other technology-related field or an equivalent number of years’ experience (5 or more)
  • Experience in data integration, data warehouse, big-data-related initiatives, development and implementation
  • Demonstrable expertise with ETL, ELT for data warehouse, data vault, data lake and databases on large or complex data sets
  • Experience in architecture patterns and data integration design principles
  • Demonstrable knowledge and expertise maintaining physical and logical data models
  • Demonstrable knowledge and expertise with data modeling – OLAP and OLTP
  • Effective time management
Preferred
  • Knowledge about various architectures, patterns and protocols, such as ODBC, JDBC, unified data management architecture (UDM), event-driven architecture, real-time data flows, non-relational repositories, data virtualization, cloud enablement, etc.
  • Knowledge of and experience with data integration platforms such as MS SQL Server Integration Services (SSIS), Oracle Data Integrator, Informatica Platform, IBM InfoSphere
  • Knowledge of and experience with visualization tools, such as PowerBI and Tableau, SQL Server Reporting Services
  • Ability to regularly learn and adopt new technology
  • Demonstrable expertise with T-SQL, Powershell and performance tuning on SQL Server
  • Knowledge of and experience with the design, development and implementation of tables, views, stored procedures, functions, scripts, etc. to collect, process and present data
  • Ability to speak Spanish

This site uses cookies to improve your experience. You can restrict cookies through your browser; however that may impair site functionality.

GOT IT