Data Architect with Snowflake and data base

3 weeks ago


Irving, United States Resource Informatics Group Full time
Data Architect w/ Snowflake & cloud experience
Job Description :
We are looking for a Lead Snowflake Data Architect, who will be responsible to plan, design, develop and maintain the data architecture, data models and standards for various Data Integration & Data warehouse projects in snowflake. Ensure new features and subject areas are modelled to integrate with existing structures and provide a consistent view. Develop and maintain documentation of the data architecture, data flow and data models of the data warehouse appropriate for various audiences. Provide direction on adoption of Cloud technologies (Snowflake ) and industry best practices in the field of data warehouse architecture and modelling.

providing technical leadership to large enterprise scale projects. You will also be responsible for preparing estimates and defining technical solutions to proposals (RFPs). This role requires a broad range of skills and the ability to step into different roles depending on the size and scope of the project.

Responsibilities: -
• Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence and deployment infrastructure diagrams.
• Take ownership of technical solutions from design and architecture perspective for projects in presales phase as well as on- going projects.
• Prior experience with application delivery using an Onshore/Offshore model
• Experience with gathering end user requirements and writing technical documentation
• Time management and multitasking skills to effectively meet deadlines under time-to-market pressure
• Suggest innovative solutions based on new technologies and latest trends to sales team.
• Review the architectural/ technological solutions for ongoing projects and ensure right choice of solution.
• Work closely with sales team and clients to understand their business, capture requirements, identify pain areas, accordingly, propose an ideal solution and win business.

Required:
• Must have total 14+ yrs. in IT and 3+ years' experience working as a snowflake Data Architect and 8+ years in Data warehouse, ETL, BI projects.
• Must have experience at least two end to end implementation of Snowflake cloud data warehouse and 3 end to end data warehouse implementations on-premise preferably on Oracle.
• Expertise in Snowflake - data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and
standard DWH and ETL concepts
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
• Expertise in deploying Snowflake features such as data sharing, events and lake-house patterns
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Deep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake,
dimensional modelling)
• Experience with data security and data access controls and design
• Experience with AWS or Azure data storage and management technologies such as S3 and ADLS
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
• Must have expertise in AWS or Azure Platform as a Service (PAAS).
• Certified Snowflake cloud data warehouse Architect (Desirable).
• Should be able to troubleshoot problems across infrastructure, platform and application domains.
• Must have experience of Agile development methodologies
• Strong written communication skills. Is effective and persuasive in both written and oral communication
  • Data Architect

    7 days ago


    Irving, United States Object Technology Solutions, Inc. Full time

    OTSI (Object Technology Solutions, Inc.) has an immediate opening for Data ArchitectRole: Data ArchitectLocation : Irving, TX ( Hybrid/ 3 days onsite)Duration : 12 + MonthsJOB DESCRIPTION:The ideal candidate will have experience in customer-facing roles and success leading deep technical architecture discussions with senior customer executives, Enterprise...

  • Data Architect

    1 week ago


    Irving, United States Object Technology Solutions, Inc. Full time

    OTSI (Object Technology Solutions, Inc) has an immediate opening for a Data Architect Lcoation - Irving, TX (Hybrid) Job Description:The ideal candidate will have experience in customer-facing roles and success leading deep technical architecture discussions with senior customer executives, Enterprise Architects, IT Management and Developers to drive Data...

  • Data Architect

    1 week ago


    Irving, United States Talent Groups Full time

    Job Title: Cloudera Hadoop Architect Irving TX (Hybrid 3 days WFO) OR RemoteFull-TimePrimary Skills: Spark, Hadoop, ETL, Cloudera•Experience handling Peta bytes of data in Hadoop•Strong experience in Code migration engagements like Data stage to PySpark•Build Frameworks for transformation/Code quality•Performance Optimization•Able to advise...

  • Data Architect

    1 week ago


    Irving, United States Talent Groups Full time

    Job Title: Cloudera Hadoop Architect Irving TX (Hybrid 3 days WFO) OR RemoteFull-TimePrimary Skills: Spark, Hadoop, ETL, Cloudera•Experience handling Peta bytes of data in Hadoop•Strong experience in Code migration engagements like Data stage to PySpark•Build Frameworks for transformation/Code quality•Performance Optimization•Able to advise...

  • Data Modeler

    1 week ago


    Irving, United States Newt Global Full time

    Title:-    Data Modeler Location:- Irving TX Long Term Contract  Role Description: Exp- Exp in traditional, dimensional, UML modeling. Erwin, Magic draw(preferred) Strong in SQL, Python. Banking domain exp Data Modeler /Data Architect


  • Irving, United States QTS Data Centers Full time

    QTS Data Centers is seeking a Critical Environment Supervisor (Data Center Facilities) to work at our expanding Irving, TX (Dallas)data center campus. Quality Technology Services (QTS) is a leading provider of data center solutions across a diverse footprint spanning more than 9 million square feet of QTS Mega Data Centers throughout North America...


  • Irving, United States InfoVision Inc. Full time

    Job title: Azure Solutions ArchitectDuration: Long-termLocation: Irving, TX Qualifications:· Over 20+ years of experience in Data & BI technologies and program with excellent leadership and communication skills· Should have led and executed complex programs on Data in both on-prem and cloud environments (Azure cloud is mandatory)· Should have led at least...


  • Irving, United States InfoVision Inc. Full time

    Job title: Azure Solutions ArchitectDuration: Long-termLocation: Irving, TX Qualifications:· Over 20+ years of experience in Data & BI technologies and program with excellent leadership and communication skills· Should have led and executed complex programs on Data in both on-prem and cloud environments (Azure cloud is mandatory)· Should have led at least...


  • Irving, United States QTS Data Centers Full time

    The Development Project Engineer is primarily responsible for assisting with the design, preconstruction and construction activities on a given project(s). The Development Project Engineer will interact on a daily basis with Facilities, Contractors, Designers, Engineers, Commissioning Agents, Vendors, and Data Center Operations & Corporate real estate...


  • Irving, United States IDR (Internal Data Resources) Full time

    Oracle Techno-Functional Solutions Architect – Brinker International Responsibilities In this role, you will be leading a team of Business Systems Analyst (BSA) responsible for the management, support, and enhancement of Oracle Fusion applications You will be responsible for designing, implementing, and optimizing applications to meet the specific needs...

  • SQL Data Engineer

    2 days ago


    Irving, United States Saxon Global Full time

    Location: 2 days onsite - Tuesday and Thursday (mainly Thursday) Project: 2 major areas of work Data and decision making Transforming themselves from platform to digital Moving away from data movements to more real time data streaming solutions Can also go with enterprise teams and collaborate with them and build solutions there ETL data modeling and...


  • Irving, United States Vistra Corporate Services Company Full time

    Description Key Accountabilities Actively participate in the design and evolution of the enterprise Data Strategy. Drive the delivery of the Data Strategy and Data Architecture solutions across the Vistra eco system incorporating multiple business units and locations, third party contractors and Managed service providers, i.e. enterprise...

  • Data Architect

    2 hours ago


    Irving, United States High 5 Full time

    day one onsite location is Irving, TX 75039. 12 to 15 years of data integration, data architecture, and data engineering experience § SME in data Architecture Vision, Strategy, Innovation, Design, Standards, Roadmap, Data Modeling, Data Architecture best practices/patterns and features needed for End-to-End Data Product Lifecycle management § Strong...


  • Irving, TX, United States IDR (Internal Data Resources) Full time

    Oracle Techno-Functional Solutions Architect – Brinker International Responsibilities In this role, you will be leading a team of Business Systems Analyst (BSA) responsible for the management, support, and enhancement of Oracle Fusion applications You will be responsible for designing, implementing, and optimizing applications to meet the specific needs...

  • GenAI Data Engineer

    4 days ago


    Irving, United States Incedo Inc. Full time

    Title- GenAI Data EngineerFulltimeLocation – Irving TX/Piscataway New JerseyNeed 8 Years of experience very strong profile today ASAP Role Description: Data Engineer/GenAI Data Engineer As a GenAI Developer at Incedo, you will play a critical role in shaping the future of AI by developing and deploying cutting-edge GenAI applications, specifically focusing...

  • GenAI Data Engineer

    4 days ago


    Irving, United States Incedo Inc. Full time

    Title- GenAI Data EngineerFulltimeLocation – Irving TX/Piscataway New JerseyNeed 8 Years of experience very strong profile today ASAP Role Description: Data Engineer/GenAI Data Engineer As a GenAI Developer at Incedo, you will play a critical role in shaping the future of AI by developing and deploying cutting-edge GenAI applications, specifically focusing...

  • Lead Data Engineer

    52 minutes ago


    Irving, United States Omega Holdings Full time

    Omega Holdings is a private equity-owned leading distributor of air conditioning and other high demand aftermarket components to a broad range of light-duty and heavy-duty vehicle end markets. Omega has created a unique, market leading platform in the automotive aftermarket with numerous opportunities to apply its repeatable playbook to grow both organically...


  • Irving, TX, United States IDR (Internal Data Resources) Full time

    Oracle Techno-Functional Solutions Architect - Brinker International In this role, you will be leading a team of Business Systems Analyst (BSA) responsible for the management, support, and enhancement of Oracle Fusion applications You will be responsible for designing, implementing, and optimizing applications to meet the specific needs of our business You...


  • Irving, United States OSTechnical Full time

    Job DescriptionJob DescriptionLong term Remote Contract on W2.Can not work corp to corp.PST Time Zone, 100% Remote work.Data Engineer with strong Matillion skills.Experience with Snowflake.Working experience with SSIS in and environment with Snowflake and MatillionSQL ServerExperience with Bitbucket or Git or other code source controlSolid Scrum...

  • Lead Data Engineer

    12 hours ago


    Irving, United States Alcority Full time

    About the Role:The Lead Data Engineer is the senior software engineer in the Business Intelligence and Data Warehousing team. This role develops data ingestion to enable high-value business intelligence products. This is a senior individual contributor role with a focus on hands on development, collaborative problem solving, and mentorship of junior...