Prestige Staffing
Overview
Senior Data Architect with Informatica Cloud & Snowflake Cloud Experience Our client is a global consulting firm with over 10,000 entrepreneurial, action and results-oriented professionals in over 40 countries: "We take a hands-on approach to solving our clients' problems and assisting them in reaching their potential. Our culture celebrates independent thinkers and doers who positively impact our clients and shape our industry." Team
Our client is seeking a Senior Data Architect with a passion for data management and architecture to advance our corporate IT division. In this hybrid role, your expertise will be instrumental in the development and enhancement of our internal data warehouse and business intelligence systems, which support over 18 diverse business units. Your responsibilities will include designing, constructing, and improving our SQL data warehouse, ETL processes, and Azure environments, as well as resolving data and database issues. Success in this role requires meticulous attention to detail, proficiency with the Azure data stack, and a comprehensive understanding of data architecture principles. This is a hybrid role working 3 days onsite in one of our hub offices. How you will contribute
Develop data architecture strategies aligned with our company's goals. Lead the redesign of the current SQL-based data warehouse for scalability, performance, and cost-efficiency. Design and oversee ETL development. Consolidate and standardize ETL processes using specialized tools. Collaborate with ERP and other teams to review and integrate Master Data Management (MDM) requirements. Support our data governance program to ensure data quality, security, and compliance. Utilize Informatica for seamless data integration and management. Improve existing and new subject areas within our SQL data warehouse. Maintain high standards of data quality, consistency, and security across various sources. Gather requirements and set data architecture standards in partnership with stakeholders. Create and maintain comprehensive data models, flowcharts, and governance protocols. Promote and implement best practices for data stewardship, integration, and warehousing. Supervise and enhance data infrastructure for optimal performance and scalability. Offer specialized knowledge on data organization, analytics, and cleansing. Manage sensitive data with the highest level of discretion and adherence to ownership protocols. Train users on new data components and data domain usage. Qualifications
Bachelor’s degree or equivalent from an accredited institution in Computer Science. Minimum 5 years of experience in data architecture, integration, and management. Prior professional services experience preferred. Proven success in deploying Informatica Cloud and Snowflake solutions. Strong experience with the Azure data stack. Well-versed in data structures and algorithms. Ability to work with stakeholders to assess potential risks. Ability to analyze existing tools and databases and provide software solution recommendations. Ability to translate business requirements into non-technical, lay terms. High-level experience in methodologies and processes for managing large-scale databases. Demonstrated experience in handling large data sets and relational databases. High-level written and verbal communication skills. Knowledge of building modern data reporting solutions in cloud technologies, including Power BI, is a plus. Knowledge of enterprise data, data warehousing, and Azure cloud data platforms. Experience with integrating multiple source systems, such as Salesforce and custom-developed systems using REST API. Experience with modeling, warehousing, and ETL methodologies using cloud-based technologies in the Microsoft stack (Microsoft SQL Server/Blob Storage) as well as non-Microsoft technology such as Snowflake. Must be authorized to work in the US without the need for employment-based sponsorship now or in the future. Job Details
Employment type: Full-time Job function: Engineering and Information Technology Industries: Professional Services and Financial Services
#J-18808-Ljbffr
Senior Data Architect with Informatica Cloud & Snowflake Cloud Experience Our client is a global consulting firm with over 10,000 entrepreneurial, action and results-oriented professionals in over 40 countries: "We take a hands-on approach to solving our clients' problems and assisting them in reaching their potential. Our culture celebrates independent thinkers and doers who positively impact our clients and shape our industry." Team
Our client is seeking a Senior Data Architect with a passion for data management and architecture to advance our corporate IT division. In this hybrid role, your expertise will be instrumental in the development and enhancement of our internal data warehouse and business intelligence systems, which support over 18 diverse business units. Your responsibilities will include designing, constructing, and improving our SQL data warehouse, ETL processes, and Azure environments, as well as resolving data and database issues. Success in this role requires meticulous attention to detail, proficiency with the Azure data stack, and a comprehensive understanding of data architecture principles. This is a hybrid role working 3 days onsite in one of our hub offices. How you will contribute
Develop data architecture strategies aligned with our company's goals. Lead the redesign of the current SQL-based data warehouse for scalability, performance, and cost-efficiency. Design and oversee ETL development. Consolidate and standardize ETL processes using specialized tools. Collaborate with ERP and other teams to review and integrate Master Data Management (MDM) requirements. Support our data governance program to ensure data quality, security, and compliance. Utilize Informatica for seamless data integration and management. Improve existing and new subject areas within our SQL data warehouse. Maintain high standards of data quality, consistency, and security across various sources. Gather requirements and set data architecture standards in partnership with stakeholders. Create and maintain comprehensive data models, flowcharts, and governance protocols. Promote and implement best practices for data stewardship, integration, and warehousing. Supervise and enhance data infrastructure for optimal performance and scalability. Offer specialized knowledge on data organization, analytics, and cleansing. Manage sensitive data with the highest level of discretion and adherence to ownership protocols. Train users on new data components and data domain usage. Qualifications
Bachelor’s degree or equivalent from an accredited institution in Computer Science. Minimum 5 years of experience in data architecture, integration, and management. Prior professional services experience preferred. Proven success in deploying Informatica Cloud and Snowflake solutions. Strong experience with the Azure data stack. Well-versed in data structures and algorithms. Ability to work with stakeholders to assess potential risks. Ability to analyze existing tools and databases and provide software solution recommendations. Ability to translate business requirements into non-technical, lay terms. High-level experience in methodologies and processes for managing large-scale databases. Demonstrated experience in handling large data sets and relational databases. High-level written and verbal communication skills. Knowledge of building modern data reporting solutions in cloud technologies, including Power BI, is a plus. Knowledge of enterprise data, data warehousing, and Azure cloud data platforms. Experience with integrating multiple source systems, such as Salesforce and custom-developed systems using REST API. Experience with modeling, warehousing, and ETL methodologies using cloud-based technologies in the Microsoft stack (Microsoft SQL Server/Blob Storage) as well as non-Microsoft technology such as Snowflake. Must be authorized to work in the US without the need for employment-based sponsorship now or in the future. Job Details
Employment type: Full-time Job function: Engineering and Information Technology Industries: Professional Services and Financial Services
#J-18808-Ljbffr