Data Intelligence - Sr. Data Engineer

Ampcus, Inc; Columbia (MD); Hybrid; USD 100,000 - 130,000; Full time

Job summary

A global technology consulting company is seeking a Senior Data Engineer to manage and develop data infrastructure, focusing on big data solutions to drive meaningful insights. The ideal candidate will have expertise in SQL, NoSQL, and Python, along with strong analytical and organizational skills. Responsibilities include developing data models, maintaining systems, and providing decision-making support. A Bachelor's degree is required, with 5 years of relevant experience preferred. This is a hybrid position located in Columbia, MD.

Qualifications

• Strong technical and analytical skills for troubleshooting.
• Experience with database design and modeling tools.
• Hands-on experience with ETL/ELT scripts.

Responsibilities

• Orchestrate and maintain cloud/on-premise infrastructure.
• Analyze results using statistical techniques for decision support.
• Develop data models and collection frameworks.

Skills

SQL

NoSQL

Python

Database design

Data exchange formats

Analytical skills

Organizational skills

Communication skills

Education

Bachelor's Degree in Computer Science, Information Technology or Engineering

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: Data Intelligence - Sr. Data Engineer

Location: Columbia, MD (Hybrid)

Purpose

• The Senior Data Engineer is responsible for orchestrating, deploying, maintaining and scaling cloud or on‑premise infrastructure targeting big data and platform data management (Relational and NoSQL, distributed and converged) with emphasis on reliability, automation and performance.
• This role will focus on developing solutions and helping transform the company's platforms to deliver data‑driven, meaningful insights and value to the company.

Essential Functions

• 20% Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs. Prepares and manipulates data using multiple technologies.
• 15% Interprets data, analyzes results using statistical techniques, and provides ongoing reports. Executes quantitative analyses that translate data into actionable insights. Provides analytical and data‑driven decision‑making support for key projects. Designs, manages, and conducts quality control procedures for data sets using data from multiple systems.
• 15% Develops data models by studying existing data warehouse architecture; evaluating alternative logical data models including planning and execution tables; applying metadata and modeling standards, guidelines, conventions, and procedures; planning data classes and sub‑classes, indexes, directories, repositories, messages, sharing, replication, back‑up, retention, and recovery.
• 15% Creates data collection frameworks for structured and unstructured data.
• 15% Improves data delivery engineering job knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state‑of‑the‑art practices; participating in professional societies.
• 10% Applies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.
• 10% Applies and implements best practices for data auditing, scalability, reliability and application performance.

Qualifications

• To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
• The requirements listed below are representative of the knowledge, skill, and/or ability required.
• Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Preferred Qualifications

• Knowledge, Skills and Abilities (KSAs).
• Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python). Expert.
• Knowledge and understanding of database design and implementation concepts. Expert.
• Knowledge and understanding of data exchange formats. Expert.
• Knowledge and understanding of data movement concepts. Expert.
• Strong technical and analytical and problem‑solving skills to troubleshoot and solve a variety of problems. Expert.
• Requires strong organizational and communication skills, written and verbal, with the ability to handle multiple priorities. Advanced.

Nice to have

• Oracle database experience and DBA skills a plus.

Education Level

• Bachelor's Degree.

Education Details

• Computer Science, Information Technology or Engineering or related field.

Experience

• 5 years' experience with database design and developing modeling tools. Experience developing and updating ETL/ELT scripts.
• Hands‑on experience with application development, relational database layout, development, data modeling.

In Lieu of Education

• In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.