Job Title: Data Architect
Department: Information Technology
Location: Pittsburgh, PA
Summary of the Position:
The Data Architect will leverage their business and expert technical knowledge to act as Lead Architect on major data programs and Enterprise Data initiatives. The Data Architect will develop production ready data models by integrating multiple sources of data while also working with business and technical teams to understand business strategy and objectives, gather information, and ensure business requirements are being fulfilled throughout the entire data & analytics lifecycle.
Primary Functions of the Position:
- Drives project knowledge back to the enterprise data model and ensures that it evolves correctly
- Leads the design, development, implementation and maintenance of complex data systems and solutions
- Develops conceptual, logical, and physical data models to support data analysis and business intelligence
- Creates and maintains current- and target-state data architectures
- Defines and manages standards, guidelines, and processes to ensure data quality
- Ensures technology solutions are in alignment with data architecture principles and target state
- Oversees end-to-end data life cycle management activities
- Works with IT teams, business analysts and data analytics teams to understand data consumers’ needs and develop solutions
- Evaluates and recommends emerging technologies for data management, storage, and analytics
- Collects and understands business requirements and translate those requirements into an actionable data warehouse plan.
- Utilizes knowledge of multi-dimensional and tabular design patterns and identifies solutions that leverage these modeling techniques.
- Works within the SDLC framework in multiple environments and understands the complexities and dependencies of the data warehouse build within those constraints.
- Leads the data design of solutions for large projects and programs; through expert knowledge translates high-level business requirements into data models and appropriate metadata, test data, and data quality standards
- Directs and controls large specialist teams to undertake the delivery of a comprehensive data-centric project
- Manages senior business stakeholders to secure strong engagement for the solution and ensure that the delivery of the project aligns to longer-term strategic roadmaps
- Works closely with external suppliers to ensure the solution makes best use of technology and meets requirements
- Simplifies the existing data architecture, delivering reusable services and cost saving opportunities in line with the policies and standards of the group
- Responsible throughout the entire project lifecycle for the end-to-end solution of the project and compliance with enterprise data model and logical data groups
- Provides clear, continuous, and consistent data architecture leadership at a detailed level within the project
Education and Experience Requirements:
- Bachelor’s degree in Computer Science, Engineering or related field
- 5+ years of experience in data warehousing, data modeling and/or data analysis
- 5+ years of experience in BI/Data Warehousing
- 5+ years of experience with data pipelines and architecture/engineering. 5+ years of experience in SQL/ coding
- Cloud based project implementation.
- Experience with database technologies (e.g., SQL, NoSQL, Oracle, Hadoop, Teradata)
- SnowflakeDB experience a plus.
- Experience in banking and/or financial services would be highly beneficial
Essential Skills and Abilities:
- Good knowledge of data management, data integration, and database development techniques
- Ability to relate architectural decisions and recommendations to business needs
- Ability to regularly learn and adopt new technology
- Strong analytical and problem-solving skills
- Ability to communicate across all levels of the organization and work with diverse projects teams
- Able to respond, when needed, 24/7 if system issues arise
- Effectively work in a highly dynamic and fast-paced environment
- Strong organizational skills
- Troubleshoot issues quickly and provide fixes in a timely manner
- Adapt quickly to changing priorities and manage multiple deadlines
TriState Capital Bank provides equal employment opportunity and advance in employment to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.
TriState Capital Bank is an Equal Opportunity Employer.
TriState Capital Bank provides equal employment opportunity and advance in employment to qualified persons regardless of race, color, sex, religion, national origin, age, sexual orientation, gender identity, disability, veteran status, or other categories protected by law.
TriState Capital Bank is an Equal Opportunity Employer.