- Develop, construct, test, and maintain architecture to support data access and data warehousing
- Provide technical assistance and advice for stakeholders including data, design, and product teams to assist with data related technical issues
- Identify ways to improve data reliability, efficiency, and quality
- Apply creative problem-solving skills to data efforts in a way that satisfies stakeholder requests which lay groundwork for future successes
- Assists Director of Data Architecture and Integration to plan and set tactical direction with business adoption and application of appropriate technology to support business need
Data Integration
- Assemble large, complex sets of data that meet business requirements
- Develop required solutions for optimal extraction, transformation, and loading of data from various data sources and types
- Create and/or modify data marts and lead in the design of solutions to support the business and analytics
- Suggest changes to enhance the design, function, and development of new/existing data structures
Governance
- Prepare the necessary documentation and visuals to ensure clarity in data lineage and firm understanding of developed data solutions.
- Provide guidance to junior members of the integration team and business-embedded analysts related to data usage and governance
- Provide guidance and leadership to business partners of the standards around data governance practices
- Maintain, uphold, and suggest changes to enhance governance standards for the Data Architecture and Integration team
EDUCATION and EXPERIENCE:
- Four-year college degree or equivalent work experience involving Data Integration Initiatives and Database Development.
- 2+ years of experience in solution development, data integration, and data warehousing
- 3+ years of demonstrated experience working with various business units defining and understanding business problems and solutions.
- 2+ years working with and understanding of containerization, microservices, and DevOps processes.
- Demonstrated knowledge with SQL, Python, SSIS, or similar technologies