MPIRE Technology Group, Inc. is seeking a Data Engineer expert responsible for product support and maintenance of the data warehouse.
Responsibilities will include:
- 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.
- 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.
Requirements:
- 10 + years’ experience in software development or related field.
- 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.
- Experience with development of data warehouse program and system documentation
- Experience preparing and implementing data verification and testing methods for data warehouses.
- Experience with the following languages: 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.
- Experience with Teradata Utilities for EDS Support: BTEQ, FastLoad, MultiLoad, FastExport, TPump.
- Experience with Azure/Databricks Support: Cloud operations, Cloud Governance, Data Engineering, Platform Engineering, Data Integration, Data Observability, AI/ML
- Knowledge of UNIX commands and concepts in order to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version files
- Knowledge of Linux Shell scripting in order to read and create driver scripts.
- Knowledge of how Ab Initio conducts data extract, transformations, and loading – especially to and from Teradata .
- Experience in the development of graphs, plans, PSETs and how to develop tests and debug.
- Experience with PDL scripting.
- Experience training/mentoring junior level personnel.
- Must have excellent oral and written communication skills.
- Ability to obtain and maintain Public Trust clearance.
Experience: Senior-Level (10+ years)
Education: BA/BS in University in Software Engineering, Computer Science, or related discipline is preferred.
About Us:
MPIRE Technology Group Inc. (MTG) is Small Business that was founded in Virginia. The company offers information technology services consulting and systems integration. Our core offerings include: Software Development, IT/Engineering Support and Cyber Security. MPIRE Technology Group’s technical staff has extensive experience managing and executing the full life cycle of IT infrastructure and development projects. Our teams work alongside their clients helping them to achieve their specific objectives. Our clients continue to use our services because of our high quality of work and our company values.
Our Benefits:
- Health insurance
- Dental insurance
- Vision insurance
- Retirement plan
- Paid time off
- Professional development assistance
MPIRE Technology Group is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
We are not currently working with 3rdparties.
We are not currently providing sponsorship.
Job Type: Full-time
Pay: From $85,000.00 per year
Benefits:
- 401(k)
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Schedule:
Education:
Experience:
- Software development: 8 years (Preferred)
- Ab Initio: 7 years (Preferred)
- Metadata: 3 years (Preferred)
- Data warehouse: 8 years (Preferred)
- UNIX: 5 years (Preferred)
- Teradata: 5 years (Preferred)
Work Location: Hybrid remote in Raleigh, NC 27609