Data ArchitectNextiva is looking for a result-oriented, self-starter and a self-motivated candidate who can manage multiple time-sensitive assignments. The ideal candidate for this role will be working in an agile environment while maintaining a close partnership with application architects and SMEs. The candidate is responsible for three core areas: designing and implementing various Data Warehouse solutions, developing data policies and documentation related to Data Warehouse data models and technical specs, and leading design, development, and implementation of DW solutions by liaising between DW Engineers/Business Systems Analysts and BI Analysts.Responsibilities include performing all necessary data related tasks which could include data design, data quality, metadata management, data governance or data architecture. Work directly on complex data integration projects and design/develop solutions aligned with overall objectives of Nextiva. Understand and evaluate business requirements that impact the Nextiva BI reports, partners, and other internal and external customers. Liaises with data creators to support project planning, training, guidance on standards, and the efficient creation/maintenance of high-quality data. Contributes to policies, procedures, and standards as well as technical requirements. Execute the data & analytics strategy and define continuous improvement goals of data quality, governance and processes. Lead communication across various lines of businesses and technology partners to constantly monitor, collect, review, and roadmap business data requirements, and related technology solutions. Ensure compliance with the latest data standards supported by the company, and brand, legal, information security (data security and privacy compliance). Maintain knowledge of functional technology of the data management systems as they change with upgrades and new releases. Accountable to design robust, scalable database and data extraction, transformation and loading (ETL) solutions. Document data models for domains to be deployed including a logical data model, candidate source lists, and canonical formats. Develop data ingestion store specifications identifying source systems and the tables and fields to ingest. Develop data object pipeline specifications including detailed field level mapping, business rules, data quality rules, etc. Creates, updates, and enhances metadata policies, processes and catalogs. Create database tables, views, procedures, functions and rollback scripts. Perform database/ETL code reviews and deployments. Develop database scripts and tools to facilitate the automation process. Assist and support BI/Reporting Analyst teams with queries and database related issues. Knowledge of modern data architectures, data structures, data optimization techniques, analytical tools, and data warehouse design. Design data integration pipelines from various sources RDBS, Files, REST API's and Cloud applications. Validate accuracy of data between multiple systems and document data gaps. Communicate issues, risks, and concerns proactively to project management.Requirements include 10+ years of proven experience in end-to-end implementation data warehousing applications. 10+ years of strong experience in large database platforms, including Oracle, SQL Server, Teradata and Postgres. 5+ years of proven experience as a Data Architect in Data Warehousing projects. 10+ years of strong experience with enterprise ETL tools like informatica power center, SSIS, Talend or Pentaho. Understanding of information management concepts such as controlled vocabularies, authority control, data modeling, and schema design. Strong knowledge of end-to-end data lifecycle across traditional & cloud data warehouses, relational databases, operational data stores, business intelligence reporting, and big data analytics. Strong understanding of data governance, metadata management, data quality, data modeling, and data architecture concepts.
Experience creating conceptual and logical data models. Knowledge of data technology products and components for Big Data and Cloud (Data Lakes, and similar). REST API, XML and JSON file format knowledge. Strong experience writing complex SQL's, procedures, functions and views. Ability to work collaboratively in a complex, rapidly changing, and culturally diverse environment. Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience. Comfortable working in a dynamic environment where digital is still evolving as a core offering.Preferred Qualifications Must have: Dimensional Data Modelling, Erwin or ER Studio or Toad data modeler - Expert Metadata management, Data Quality and Data Governance. Excellent technical documentation skills including high level/detailed technical design documents and source to target mapping specs. Informatica Power Center, Informatica iics,Talend, Data Stage, Microsoft SSIS or similar ETL tool. Pentaho Data Integration Studio (Spoon) is a big plus. Oracle, Postgres Microsoft Power BI Advanced SQL, PL/SQL, Procedures and Functions Postman, Rest API, JSON, XML Java or Python is a plus Confluence,Sharepoint, Git and Jira Salesforce,Oracle ERP, BICC - Nice to have Excellent written and oral communication Education: Bachelor's or Master's Degree in Statistics, Math, Computer Science, Management Information Systems, Data Analytics or another quantitative discipline, or equivalent work experience