Expired job

Just missed a job?

Sign up and never miss an opportunity again!

Data Warehouse Architect/Engineer(Locals only) job

Global Bridge InfoTechBrooklyn, NY
Global Bridge InfoTech jobs

Job Description

RESPONSIBILITIES The Data Warehouse ArchitectEngineer and Big-Data Solutions expert will Manage the design and structuring of DHS Office of Information Technologyrsquos Enterprise Data Warehouse (EDW) Solution. Plan, detail, and develop the appropriate strategy and solution within The Agencyrsquos domains (both per application, program, and or organization). Develop models for application-specific Data Marts that will be merged into the larger EDW dimensional model. Create and maintain agency assets including a Bus Matrix, business glossary, and Star schemas. Maintain and extend a comprehensive agency-wide semantic (dimensional) model based on sound Kimball modeling techniques. Guide, Coach and mentor development of ETL scripts while ensuring integrity of data lineage, audit trail, error correction, etc. Install and configure certain EDW system components, developingupdating scripts, deploy custom code on the new platform, and build production and non-production technical environments. Define and implement management processes for maintaining data governance policies and standards. Utilize data governance framework, technology capabilities, processesprocedures and implementation plans to drive data standards across the initiative and the department. Write clear technical design deliverables to document development work. Ensure integrity and quality of product deliverables through ongoing monitoring, testing and management of data sources, products, and initiatives. Perform other duties as assigned. REQUIRED SKILLS The ideal Candidate will be a seasoned technology professional, with a creative and analytical eye for solution crafting, and possess the following attributes and characteristics Expert-level skills in data warehouse, star-schema design, snowflake schema design, slowly changing dimensions and effective dating of data to be able to analyze data at various points in time. Thorough understanding and experience in the Kimball method Proven working experience as a Data Modeler. Technical expertise regarding data models, database design development, data mining and segmentation techniques. A track record of thought leadership and innovation around Big Data ndash i.e. demonstrated industry leadership in the fields of database, data warehousing or data sciences A deep understanding andor Strong track record of, implementation and tuning experience with SQL (SQL server, Oracle, andor PostgreSQL. SQL Server is preferred) design and maintenance of an Enterprise Data Model data pipeline ETL development experience Operationalizing open source data-analytic tools for enterprise use Cloud-native application architecture Deep expert level knowledge of Authoring technical specifications, user guides, UML, ER-diagrams, and presentations. Providing subject matter expertise in the analysis, and preparation of specifications and plans for, the development of data processes Data governance policies ensuring their appropriateness and that they are followed through implementing or validating Data Lineage, Quality checks, classification, etc. A substantive track record of timely solution delivery, and mitigating roadblocks and risk. A can-do attitude. Fearless-ness when it comes to challenges of any complexity or unfamiliarity ndash consistency in finding the right solution for the right problem and articulating clearly to stakeholders and business developers. Ability to readily achieve buy-in from teams and stakeholders, providing a sense of ownership to a solution. Big Data and machine learning experience strongly preferred AWS and Azure Offerings for real-time ingestion and stream-analytic solutions. Experience with Amazon data services Lambada, Step Functions, Data Pipeline, Redshift, Elastic Compute Cloud (EC2), Aurora, Relational Database Service (RDS) and Kinesis Hadoop, Jupyter notebooks, numpy, scipy, NoSQL data storesdatabases
Similar jobs in the area
Database ArchitectResideoMelville, NY
Resideo is looking for a highly-motivated Database Architect to join the team recognized for leadership, innovation and diversity. As a Database Architect, you will work closely with software development teams and data analysts to create, maintain and...Read more
Net2Source, Inc. is one of the fastest growing IT Consulting company across USA. N2S is headquartered at NJ, USA with its branch offices in Asia Pacific Region. N2S offers a wide gamut of consulting solutions customized to client needs including staffing...Read more
DATA WAREHOUSE ARCHITECT Bed Bath & Beyond Inc. seeks a Data Warehouse Architect in Union, NJ to provide architectural guidance to Data Warehouse work stream. Identify & mitigate existing bus risk or risks associated w/ solution architecture. Conduct...Read more
SQL ArchitectAstir ItNew York City, NY
7 to 9 years of experience in developing database projects using SQL Server 2005/2012/2016 Strong underdressing of SQL Server engine is must Good in performance tuning especially tuning complex queries, procedure and indexing strategies is must Experience...Read more
Hair StylistGlamsquadBrooklyn, NY
WHO WE ARE Glamsquad-Beauty Pro, client and corporate team-is a community of beauty enthusiasts. We deliver on-demand beauty services to clients, empowering them to experience beauty on their own terms. Guided by collaboration, we provide customers with...Read more
Bed Bath & Beyond Inc. seeks a Data Warehouse Architect in Union, NJ to provide architectural guidance to the Data Warehouse work stream. Orchestrate activities for production...Read more
Drive with Uber and earn money anytime it works for you. Driving is an easy way to earn extra, and it’s totally flexible around your schedule. You decide when and how much you drive. What you need to know: Earn great money: The more you drive, the more you...Read more
Data Warehouse ArchitectRJW Technology SolutionsNYC, NY
Architect with 10+ years of experience Data warehouse design and development. Hands on experience in designing Financial Data models. Strong experience in banking domain and knowledge on BASEL III risk reporting Experience in Oracle Financial Services...Read more
Job Description We are currently seeking a Senior DB Engineer/Data Warehouse Architect to join our dynamic team. The Senior DB Engineer/Data Warehouse Architect is a key member of our global technology team. They will be responsible for helping to build a...Read more
Test Data ArchitectBank of AmericaJersey City, NJ
Experience data warehouse back-end testing. Experience in Test data preparation using automated data extraction and data masking / sanitization....Read more
# of Openings 1 Category Consulting Work Site - City Brooklyn Department Consulting Technical Services - Platform Work Site - State NY Security Clearance Level None Required Maximum Expected Travel 20% Type Regular Full-Time Remote/Telecommute Available...Read more
Requisition Number: 72467 We are looking for a Managing Architect with practical, hands-on knowledge of modern data architectures and tools such as data warehousing, ETL/ELT, analytics, and the Microsoft Azure cloud platform. You should be driven to...Read more

Similar jobs

Qlikview ArchitectTechTriad TeamNew York City, NY
Title: QlikView Architect Location: New York City, NY Duration: One Year and ongoing Interview Process: Telephone Screen, Mandatory in-person interview The Qlik Architect will be part of a team that is designing and building the next generation of business...Read more
Net2Source, Inc. is one of the fastest growing IT Consulting company across USA. N2S is headquartered at NJ, USA with its branch offices in Asia Pacific Region. N2S offers a wide gamut of consulting solutions customized to client needs including staffing...Read more
OBIEE Architect Location: New York City, NY (2 Skype Interview) Duration: 12-36 months+ VISA: Citizen, GC, GC-EAD Mus have exp: Configuring OBIEE, ODI, ODQ and other Oracle applications Strong Communication skills The Oracle platform architect will act as...Read more
A software company that produces an all encompassing HR platform is looking for a Data/BI architect for the development team. This person will be responsible for the end-to-end implementation and maintenance of Business Intelligence including system...Read more
Role: ETL ArchitectLocation: Jersey City 07311Emp Type: Permanent JobInterview: Phone/SkypeInformatica Powercenter and Informatica IDQ development expereinceUnix Shell scripting, Autosys or similar Job scheduler expereince, Strong SQL SkillsStrong...Read more
Data ArchitectBlink FitnessNew York, NY
Experience in data mining (SQL, ETL, data warehouse , etc.). Design scalable Python/SQL based ELT/ETL workflows to transform and integrate data into a Redshift...Read more
Data ArchitectCareer TechniquesNew York
The Data Architect is responsible for the overall design of the enterprise-wide datainformation architecture which maps to the enterprise architecture and balances the need for access against ...Read more
Data ArchitectRedStream Technology LLCJersey City
You have five or more years in a Data Architecture role designing data warehouses andor data lakes with big data technologies such as Hadoop, Spark or distributed databases like Redshift and ...Read more
Data ArchitectPRI TechnologyLittle Falls
Senior Data Architect We have a newly created opportunity for a Senior Data Architect to join our ... Experience with Data mining, data warehouse and analytics concepts and systems, preferably ...Read more
Our client, a financial services organization serving a religous organization, seeks a Data Architect. The successful candidate will be responsible for the overall design of the enterprise-wide data/information architecture which maps to the enterprise...Read more