In A Nutshell
Lead on design, implementation, and maintenance of data integration solutions, including a focus on data validation, audit, reconciliation, and documentation.
Responsibilities
- Proactively monitor integration processes, identify discrepancies through reconciliation, and resolve issues to maintain data integrity, quality and accuracy.
- Develop and implement data integration solutions that ensure the seamless flow of data between different systems and databases.
- Collaborate with software developers, database administrators, and business analysts to understand data requirements and translate them into technical specifications.
- Maintain data mapping documents and integration workflows to ensure proper documentation and knowledge sharing.
- Monitor data integration processes and perform troubleshooting to resolve any issues.
- Support development and execution of roadmap to systemize data flows and reporting for key pathways program areas.
- Guide the streamlining and automation of ad-hoc and standardized reporting functions.
- Ensure integration processes comply with data governance and security policies.
- Work closely with cross-functional teams, including DIIT, business units, and external vendors and partners to ensure data integration aligns with business goals.
- Optimize data integration processes to improve performance, reduce processing time, and enhance system efficiency.
Skillset
- A master’s degree from an accredited college or university with specialization in an appropriate field of physical, biological, environmental or social science and three years of responsible full-time research experience in the appropriate field of specialization.
- Must have 5 to 7 years of Business Intelligence experience such as IBM Cognos Studio, SAP Business Objects, Tableau Cloud, Tableau Workbook Tableau Flow and Power BI.
- Must have experience in using Relations Databases, MS SQL Server database, Oracle database, or Snowflake database.
- Strong knowledge of Data Warehouse and ETL tools such as Snowflake, Informatica and Tableau Flow, and able to write back on database such as Snowflake.
- Strong communications skills and confidently able to convey ideas to the team and colleagues.
- Strong ability to translate complex data concepts and technical information to business stakeholders.
- Ability to work in fast-changing environments and adapt to new tools, technologies, and integration approaches.
- Willingness to stay up to date with emerging technologies and methodologies in data integration and management.
- Excellent communication skills to work across IT, data, and business teams.
- Experience in SQL language using complex queries, multiple sources, adding, updating, and deleting data, and strongly be able to perform data comparison.
- Experience in financial reporting, preferably in public education.