Data Architect

DATA ARCHITECT

POSITION DESCRIPTION

Location:USStatus:PermanentDepartment:ImplementationsFTE:1.0Division:Digital ChannelsJob Code: Role Purpose and ContextThe Data Architect’s role is to strategically design and implement large scale data migrations/ conversions into Fiserv’s products using Microsoft SQL Server 2016 through the current version. Additionally, the Data Architect will be called upon to design and implement highly custom large scale database solutions that augment Fiserv’s products. On occasion, the Senior Database Architect will be asked to evaluate, size and select technology components, such as software, hardware, and data storage systems, for database management systems and application databases across the organization.

Focusing more broadly on projects that impact multiple areas of Fiserv’s products, the Senior Database Architect will work and communicate directly with internal and external clients using both analytical skills and subject matter expertise in financial applications to gather requirements, design solutions and execute implementations.

The Data Architect will function as an escalation point for go live events, troubleshooting, and resolution designs. The Data Architect will directly participate in hiring process for new associate candidates and may be called on to manage project staffing allocations and work hour approvals. This role requires serving as a critical key player in the influence and development of reusable department-wise tools.

You will be required to respond to occasional requests for additional off-hour work in the event of an emergency client incident or critical business need.Key RelationshipsCareer TrackThis is a senior technical position within the organisation and will work alongside Project Managers, Business Analysts, Technical Leads, Solution Architects, and Developers to deliver quality project outcomes to clients.

Direct reports

None.

Reporting line

Reporting to DBE Manager or Team Lead. Technical Skills, Knowledge and Qualifications

• 6 - 8+ years technical expertise in database and ETL development with Microsoft SQL Server technologies - primarily T-SQL and SSIS.
• Extensive development experience in analysis, modelling and design of database solutions.
• Integration Services, ETL and BI tools
• Possess strong database fundamentals and experience in writing Unit test cases and test scenarios
• Technical understanding of network, PC, and platform operating systems, including Microsoft Windows Server 2008 through current version.
• Application development understanding of Microsoft .NET technologies - primarily Powershell scripting, ASP.NET and C#.
• Technical understanding of the different phases of the Software Development Life Cycle (SDLC) including waterfall and agile methodologies.
• Understanding and technical knowledge of cloud-based technologies.
• Have a grasp of SQL Server High Availability Solutions including Always On, Database Mirroring and Log Shipping concepts.
• Able to effectively communicate verbally and in writing; in large meeting settings and when presenting to large groups; in both technical and non-technical arenas.
• Able to understand and convey technical issues to non-technical associates, and vice-versa.
• Able to develop and maintain effective working relationships across enterprise level lines.
• Able to identify issues warranting escalation.
• Bachelor’s degree in Computer Science, Information Technology and/or equivalent relevant work experience.

TravelUp to 15-20 % (domestic and international). 700Status:

30% Development

• Perform extensive analysis of database entities, relationships and attributes.
• Design and develop ETL (Extract, Transform and Load) processes using Transact-SQL (T-SQL) and Microsoft SQL Server Integration Services (SSIS).
• Optimize ETL processes and T-SQL code performance using Microsoft SQL Server best practices and query/index/table performance tuning.
• Participate in both data design and data processing sessions for assigned projects and teams.
• Create migration/conversion designs that meet the project's business, system and data requirements.
• Create written data migration/conversion plans and data file/data model specifications that meet the project's business, system and data requirements.
• Reverse engineer existing migration/conversion processes and data models including designing and utilizing Microsoft SQL Server Profiler traces.
• Research and review data for presentation, accuracy and compliance within the business/system needs.
• Review with team members/client and other database Architect’s the content, accuracy and completeness of data models, file specifications and migration/conversion processes.
• Communicate and collaborate with client management and client data specialists in the design and delivery of data migration/conversion processes.
• Respond to data design and/or data processing problems and find solutions in a timely manner.
• Identify appropriate resources and work with them to research and resolve any open data-related issues.
• Mentor staff by reviewing deliverables and offering team assistance whenever needed.
• Possesses a deep knowledge of both the product and the technology; use both to design/architect business solutions.
• May serve as a pursuit manager or a technical lead within given project/business opportunity.
• Will be called on as a technical consultant to unassigned projects and sales opportunities.

PermanentTask Management & Completion

• Create tasks based on technical specifications and give accurate work and task estimates.
• Prioritise and complete tasks based on importance and urgency.
• Monitor and report accurately on task progress.
• Ensure that tasks marked as complete have been tested to ensure that they meet all stated requirements.
• Remain focused on long-term goals when executing against short-term objectives.

15%Client Communication and Management

• Strive to exceed the expectations and requirements of stakeholders.
• Provide consultancy to project delivery teams for the design and implementation of data storage, access, reporting and business intelligencecomponents of Fiserv solutions.

10%Code Quality

• Identify and raise awareness of inconsistencies in specifications and implementation.
• Lead code reviews to identify opportunities to ensure compliance with corporate guidelines and improve the quality of the team’s output.

15%Technical Design Decisions

• Consult to understand business and technical requirements and apply these to make sound design choices that are consistent with industry standards and best practice patterns.
• Validate technical approaches and decisions through prototyping and proof of concepts, constructive criticism and debate in adherence to the various solutions technical and design consultation processes.

5%Department:

5% Documentation and Knowledge Sharing

• Proactively research and identify tools and processes to deliver improved efficiency and robustness in implementation of database components.
• Create high quality documentation (including technical design documents) that meets the needs and expectations of stakeholders.
• Contribute to the continuous improvement of reference material by proactively filling gaps, correcting mistakes and resolving ambiguity. Seek review from colleagues on your proposed changes.