Role Description : Data Architect 10 to 15 years of experience

The key responsibilities will be

• Develop data architecture and lead the delivery of end-to-end data, integration, reporting solution for Utilities Systems cloud and hybrid hosting
• Analyze business requirements, conduct data & integration impact analysis.
• Develop enterprise data landscape, conceptual data model and logical data model
• Understanding of data requirements for ETRM systems and associated data structures (Risk, Pricing, Contracts etc)
• Develop physical data modelling and database designs.
• Design databases to meet and exceed different non fictional requirements High availability, zero data loss, cyber security, high resilience, high performance, structured and un-structured data, time series data with resolution of as low as 10 ms, huge volumetric.
• Design data migration, data quality solution.
• Support Business Analysts and Solutions architects to design the systems.
• Conduct Database activities such as database creation, management, testing, programming on database, data engineering, reverse data engineering, reporting, analytics, data migration etc based on project requirement
• Lead data engineers/development to implement the solutions as per design

Mandatory data skills

• Data and Integration Architecture
• Expertise in one or many of below
• Oracle/MySQL database design and development
• Mongodb /Casandra design and development
• Azure Data Architecture
• Excellent stakeholder communication skills
• Ability to lead and guide data team in the project/program and get the work done.
• Data Landscape ( As-Is and To-Be ) and Data Flows
• Conceptual Data Model and Canonical Modelling
• Logical Data Model and Physical Data Model
• Data Definition and Integration specification
• DDL , DML , DCL , TCL concepts and scripting
• Data engineering and reverse data engineering
• Master Data and Data Management
• Data Entity to Application mapping - Master , Create , Update , Read & Delete
• Requirements analysis , data impact analysis , integration impact analysis
• Data Entity and Attribute Definition Data constraints, validation rules , consistency and defaulting rules Tools Sparx EA , SQL developer , Toad etc.
• Database programming - PL/SQL and similar ones
• Application of Data science for energy/electricity forecasting
• Experience in architecting Python, R , mongo db, oracle db based forecasting solution hosted in cloud.
• Experience/knowledge on Talend , ADF and SOA based data integration
• Experience in implementation of reporting and visualization solution using Power BI

About FSTONE

Established in 2004, FSTONE is one of the largest and fastest-growing staffing firms in the U.S. The growth of our company is a direct result of our global client service delivery model powered by our state-of-the-art A.I. proprietary talent acquisition platform, certified processes, and passionate client teams.

FSTONE, a certified Minority Business Enterprise (MBE), has firmly established itself as a dominant player in the U.S. staffing and workforce solutions sector, distinguished by its rapid growth and extensive service range. Catering to over 50 prominent clients across diverse industries such as Pharmaceutical & Life Sciences, Banking and Financial Services, Technology, and Healthcare, we offer a comprehensive array of services, including Contingent, Permanent, Statement of Work (SOW), and Payrolling staffing services. Our partner for life ethos drives our approach, blending passionate personnel, proven processes, and cutting-edge technologies to deliver unparalleled service and value to our clients.

Thanks and Regards,

Aman Singh