Job Description Summary
In this role you will own the data and solution architecture and drive data component delivery for multiple business subject areas within the Finance Data Lake (FDL).
You will be the data architect for highly complex projects that require knowledge of two or more specialized data architecture areas, in-depth business domain understanding and project management expertise.
Roles and Responsibilities
Drive the data domain technical and business discussions to define future features and architectural direction across the product portfolio and required data domains
Coordinate data architecture outcomes with Solution Architects, Product Owners, Developers and other stakeholders.
Review, analyze and develop data requirements for business domains within the product portfolio, applying a cohesive data architecture viewpoint.
Engineer and implement operationally resilient data components and frameworks; and drive reusability and ensure extensibility throughout the data architecture.
Design complex batch and near-real time data ingestion and transformation pipelines.
Provide thought leadership on data architecture and design, data modeling principles, usage of cloud data services & big data approaches.
Ensure modern tools and techniques are leveraged for each component.
Lead data profiling and data analysis for source systems, manually maintained data, machine or sensor generated data and target data repositories.
Use operational metrics and lean principles to tune loads and queries for performance, lower total run costs and meet or exceed data delivery SLAs.
Simultaneously support multiple projects across multiple data domains.
Effectively monitor and control costs in the organization.
For roles outside USA :
Bachelor's Degree in Computer Science or STEM Majors (Science, Technology, Engineering and Math) with significant experience.
For roles in USA :
Bachelor's Degree in Computer Science or STEM Majors (Science, Technology, Engineering and Math) with a minimum of 8 years of experience
Desired Characteristics :
Technical Expertise :
Design, development and administration experience in several DBMS platforms such as : Oracle, Postgres, MySQL, MPP (e.g.
Terdata, Greenplum), in-memory (SingleStore (MemSQL))
Cloud and open-source database, analytic, streaming and big data services and related development technologies (e.g., Spark, Java, Python, Scala, EMR, Hadoop, Hive, NoSQL, Hudi, Glue, Kafka, notebooks)
Multiple years of experience and expert knowledge of SQL query, function and stored procedure development and tuning using various database management systems
Exposure to unstructured datasets and ability to handle XML, JSON file formats and object stores (S3)
Multiple years of ELT / ELT experience (Informatica, Talend)
BI and analytic reporting tools (Spotfire, Tableau, OBIEE)
Working knowledge of replication technologies, such as HVR or GoldenGate.
Business Acumen :
Proven ability to negotiate with business stakeholders and technology partners to agree on requirements, scope, responsibilities, dependencies, budgets and timelines
Proficient at managing multiple competing priorities
Capacity to lead multiple virtual and global interdisciplinary teams
In-depth business experience in one or more corporate finance / treasury functions, including : AR, AP, working capital, cash management, banking, FX, payments and close processing
Experience with complex financial ERP, back office and trading source systems
Strong oral and written communication and executive presentation skills
Relocation Assistance Provided : No