Data Architect Data Analytics

4 weeks ago

Knightdale NC, United States ABBTECH Professional Resources Full time

This program requires US Citizenship or Green Card (Lawful Permanent Residents)
Description:
Under general supervision, responsible for product support and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate programs and systems documentation. Assists with metadata repository management. Prepares and implements data verification and testing methods for the data warehouse. Creates index and view scripts. Performs all functional duties independently. Works on high-visibility programs, or mission critical aspects of assigned program(s). Oversees the efforts of direct reporting resources and/or is responsible for the efforts of all staff assigned to a specific job.

Required Skills/Experience:
Specific ability with the following languages, tools and utilities is required:
- Ab Initio ETL Coding in GDE
- Ab Initio Metadata Hub Lineage
- Ab Initio TRMC
- ANSI SQL and Teradata SQL extensions
- Teradata SQL Assistant (a.k.a. QueryMan) for EDS Support

Teradata Utilities for EDS Support:
- BTEQ
- FastLoad
- MultiLoad
- FastExport
- TPump

Azure/Databricks Support:
- Cloud operations
- Cloud Governance
- Data Engineering
- Platform Engineering
- Data Integration
- Data Observability
- AI/ML

In addition, the following UNIX skills are required:
- UNIX commands and concepts in order to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version files
- Linux Shell scripting in order to read and create driver scripts

In addition, the following Ab Initio skills are required:
- A working knowledge of how Ab Initio conducts data extract, transformations, and loading - especially to and from Teradata
- Development of graphs, plans, PSETs and how to develop tests and debug
- PDL scripting

Additional Required Skills/Experience:
• A minimum of ten (10) years experience in software development or related field, with at least 5 years in a data warehouse environment and/or related field ;
• A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred;
• Able to perform all functional duties independently on high-visibility programs, or mission critical aspects of a given program;
• Able to oversee the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job;
• Experience training/mentoring less experienced personnel;
• Extensive experience with data warehouse design, construction, and/or maintenance, to include design and implementation of data strategy methods, coding and documentation of scripts and stored procedures, and creation of index and view scripts;
• Extensive experience with development of data warehouse program and system documentation;
• Able to assist with metadata repository management;
• Extensive experience preparing and implementing data verification and testing methods for data warehouses;
• Able to obtain Postal clearance;
• Excellent communication skills.

Additional Provisions:
• Pass both a client mandated clearance process to include drug screening, criminal history check and credit check.
• Once candidate’s resume is approved and interview passed, the agency is responsible for providing drug screening. Failure to submit the drug screening results will delay the security clearance process.
• If a candidate is given an interim clearance, continuation of employment is then based on the candidate receiving a sensitive clearance.
• All overtime must be pre-approved in writing by the client manager or his/her designated representative.
• Agency will not be reimbursed for overtime charges without previous written authorization. Authorized overtime will be reimbursed at straight time.
• The enforced dress code is business casual, i.e. collared shirt with slacks for men, no skirts above the knee for women. Place and Period of Performance
• Hours of support:
o The standard work week for contract staff will be 5 days a week and 8 hours per day preferable Monday through Friday.
o Contract staff may be required to travel to support business efforts.

Benefits (Regular, Full Time Employees): Medical, Dental, and Vision offerings
Weekly Direct Deposit
Paid Holidays and Personal Time Off
401(k) with match
Voluntary Life and AD&D, Short / Long Term Disability, plus other voluntary coverages
Pre-Paid Legal and Employee Assistance Programs
Northwest Federal Credit Union Membership
BB&T @ Work Program


ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans

  • Data Engineer

    4 weeks ago

    Knightdale, NC, United States ABBTECH Professional Resources Full time

    This program requires US Citizenship or Green Card (Lawful Permanent Residents) Description: Under general supervision, responsible for product support and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate...

  • Data Engineer

    4 weeks ago

    Knightdale, United States ABBTECH Professional Resources Full time

    This program requires US Citizenship or Green Card (Lawful Permanent Residents) Description: Under general supervision, responsible for product support and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate...

  • Data Engineer

    4 weeks ago

    Knightdale, United States Abbtech Professional Resources Full time

    This program requires US Citizenship or Green Card (Lawful Permanent Residents) Description: Under general supervision, responsible for product support and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops...

  • Azure Architect

    4 weeks ago

    Charlotte, NC, United States Global IT Con Full time

    Position Title* Azure Architect Position Responsibilities Visa - US Citizen ,Green card, Holder, TN Visa,EAD,H4-EAD Azure Architect Charlotte, North Carolina (hybrid role) Look candidate within NC Candidate must have real-world Azure architecture experience across a spectrum of Azure services ASE AKS ACA ADF Fabric Purview One Lake ADLS Synapse etc.....

  • Application architect

    3 weeks ago

    Charlotte, NC, United States Collabera Full time

    Looking for a Data Architect for one of the top banking Client in Charlotte, NC or Plano, TX The Data Architect will be responsible for: Performing current state data architecture and tooling assessment across all data domains supported by control functions. Cross-domain reviews to identify synergies and opportunities to eliminate redundancy and...

  • Systems Architect

    1 month ago

    Charlotte, NC, United States Strategic Staffing Solutions Full time

    Systems Architect Charlotte, NC 24 Months **NO C2C** Candidate must have real-world Azure architecture experience across a spectrum of Azure services (ASE, AKS, ACA, ADF, Fabric, Purview, One Lake, ADLS, Synapse, etc.).Candidate must be able to architect systems inclusive of Application Layer, Services Layer, Data Lake/Warehouse, Reporting, Analytics....

  • Application Engineer

    2 hours ago

    Knightdale, United States Hubbell Power Systems Full time

    Application Engineer - Data Centers Apply now Date: May 22, 2024 Location: Knightdale, NC, US, 27545 Company: Hubbell Incorporated Position Overview PCX Corporation is looking for a Sales Engineer to become a part of our rapidly growing company servicing the Data Center market. PCX Corporation is the leading integrator of engineered and pre-fabricated...

  • Application Engineer

    3 weeks ago

    Knightdale, United States Hubbell Full time

    Position Overview PCX Corporation is looking for a Sales Engineer to become a part of our rapidly growing company servicing the Data Center market. PCX Corporation is the leading integrator of engineered and pre-fabricated electrical/mechanical systems for the modular data center, commercial and energy markets. Our product offerings include but are not...

  • Data Managment Consultant

    4 weeks ago

    Salisbury, NC, United States EDI Specialists, Inc. Full time

    Thought leadership skills Retail experience is a huge plus. Working on the technical team that supports the Data Governance side Estimated that 50% of the role is hands-on while 50% is thought leadership side. Microsoft Purview experience would be a plus 2-3+ years' experience in leadership roles at a minimum Must Haves: Exp as a technical lead Agile ways...

  • SQL Server Application Architect

    3 weeks ago

    Charlotte, NC, United States Collabera Full time

    Looking for a Data Architect for one of the top banking Client in Charlotte, NC or Plano, TX The Data Architect will be responsible for: Performing current state data architecture and tooling assessment across all data domains supported by control functions. Cross-domain reviews to identify synergies and opportunities to eliminate redundancy and...

  • Financial Data Scientist

    3 weeks ago

    Durham, NC, United States Food Management Search Full time

    This is a contract job opportunity Position: Financial Data Scientist 8102 Location: Remote role, looking for candidates local to Durham, NC. There will be some onsite meetings. Schedule: 8 am -5 pm , M-F Projected duration: 6 months + potential for perm Job code: CVDJP00028102 benefits are available Financial Data Scientist Position...

  • Financial Data Scientist

    3 weeks ago

    Durham, NC, United States Food Management Search Full time

    This is a contract job opportunity Position: Financial Data Scientist 8102 Location:Remote role, looking for candidates local to Durham, NC. There will be some onsite meetings. Schedule: 8 am -5 pm , M-F Projected duration: 6 months + potential for perm Job code: CVDJP00028102 benefits are available Financial Data Scientist Position Summary: ...

  • Sr. Manager Data Science

    3 weeks ago

    Charlotte, NC, United States INSPYR Solutions Full time

    Job Title: Sr. Manager Data Science Location: Charlotte, NC (Hybrid Schedule) Duration: Direct Hire, Full Time Compensation: 200-215K Sr. Manager Data Science Job Description: Job requires in-person attendance at least 3 days a week (ideally Tuesday-Thursday)* THE POSITION We are looking for a Data Science leader to work on our Analytics who wants to...

  • Manager, Data Modeling and Analysis

    3 weeks ago

    Charlotte, NC, United States Bank of America Full time

    At Bank of America, we are guided by a common purpose to help make financial lives better through the power of every connection. Responsible Growth is how we run our company and how we deliver for our clients, teammates, communities, and shareholders every day. We hire individuals with a broad range of backgrounds and experiences and invest heavily in our...

  • Data Engineer

    4 weeks ago

    Charlotte, NC, United States Synechron Inc. Full time

    We are At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud &...

  • Data Analyst

    3 weeks ago

    Charlotte, NC, United States Collabera Full time

    Position Details: Industry: Banking & Financial Services Title: Data Analyst Location: Charlotte, NC (Hybrid Model) Contract Length: 12 Months (Contract to Hire) Required skills: 7-10 years of strong Business Analysis/ Data Analysis experience. Must have prior financial experience worked previously within banks 3-5 years of Commercial Lending...

  • Data Analyst

    1 month ago

    Charlotte, NC, United States Strategic Staffing Solutions Full time

    STRATEGIC STAFFING SOLUTIONS HAS AN OPENING! Role Title: Data Analyst (ESG Experience Required) Location: Charlotte, NC (On-Site) Duration: 6+ Months Role Type: W2 Contract Engagement RATE: $55-$60/hr Job Description: • Experience with data analysis using SQL and Excel. • Prior experience with ESG (Environment, Social, and Corporate...

  • Data Analyst

    1 month ago

    Charlotte, NC, United States Strategic Staffing Solutions Full time

    STRATEGIC STAFFING SOLUTIONS HAS AN OPENING! Role Title: Data Analyst (ESG Experience Required) Location: Charlotte, NC (On-Site) Duration: 6+ Months Role Type: W2 Contract Engagement RATE: $55-$60/hr Job Description: Experience with data analysis using SQL and Excel.Prior experience with ESG (Environment, Social, and Corporate Governance)...

  • Engineer, Data Engineering

    4 weeks ago

    Raleigh, NC, United States Accentuate Staffing Full time

    Accentuate Staffing is working with a healthcare company that is hiring an AWS Data Engineer to build efficient data pipelines in the cloud to handle complex healthcare information. This organization leverages data to connect people in North Carolina with the proper care and resources, improving health outcomes while reducing costs. The company is located in...

  • AWS Data Engineer

    4 weeks ago

    Raleigh, NC, United States Accentuate Staffing Full time

    Accentuate Staffing is working with a healthcare company that is hiring an AWS Data Engineer to build efficient data pipelines in the cloud to handle complex healthcare information. This organization leverages data to connect people in North Carolina with the proper care and resources, improving health outcomes while reducing costs. The company is located in...