In A Nutshell
Plan an end-to-end model for data flows to ensure integrations are in line with the goals and objectives of Uncommon Schools.
Responsibilities
Integration Design:
- Act as data integration expert, moving and transforming data between applications in our environment and the Uncommon data warehouse, making sure data integrity is maintained throughout.
- Implement APIs to automate data transfer based on architecture guidelines.
Integration, Maintenance, and Support:
- Provide Tier 3 support to IT Support and Product Managers on integrations with the data warehouse or between applications; train IT Support to support common issues where possible.
- Select and implement the appropriate tools, software, applications, and systems to support integration technology goals.
- Provide implementation support and guidance for APIs and custom integrations between products and systems post-deployment.
- Ensure user adoption of new processes by creating training materials and providing mentorship, guidance, support and performance feedback to end users of our integrations and data sets.
Subject Matter Expert and Stakeholder Representative:
- Independently create detailed communication and change management plans for workstreams including simple, creative ways to explain complex information for clear decision-making.
- Understand and represent stakeholders’ goals and use cases to determine the future state of organizational integrations.
- Understand and champion the appropriate long-term vision for integrations at Uncommon.
- Research and discover new methods to connect data sets from disparate systems and make data accessible to stakeholders.
Governance and Security:
- Monitor integrations and report on effectiveness, accuracy, and security, updating as needed.
- Preserve a repository of all integration artifacts in order to maintain a current and accurate view of the larger data picture.
- Assess and determine governance, stewardship, and frameworks for managing integrations across the organization.
- Provide input on the strategic direction of the enterprise architecture roadmap.
Skillset
- Bachelor’s Degree.
- 5-6 years of experience.
- Experience working with at least one of the following languages: Python, JavaScript , C#, or Java.
- Experience in building and maintaining integrations in RESTful and SOAP environments.
- Skilled in the ability to write and maintain complex SQL queries.
- Understanding of Internet and Intranet applications, emerging web technologies, and industry trends.
- Proficient in using source control and continuous integration workflows.
- Strong grasp of data automation tools (e.g. Apache Airflow).
- Strong grasp of data modeling tools (e.g. dbt).
- Excellent problem-solving skills while consistently providing high levels of customer service.
- Attention to detail and the ability to prioritize and meet deadlines.
- Demonstrated ability to diagnose issues, identify root causes, and implement effective solutions.
- Experience providing documentation/visibility into key aspects of projects (e.g. progress, achievements, etc.) for senior leadership and other partners.