Data Intelligence Engineer

Ampcus, Inc
United States, Maryland, Baltimore
Oct 24, 2024
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 Engineer Location(s): Baltimore, MD Develops and executes ETL code and ensures that the data loading processes are reliable and data quality remains high. Develop reports, dashboards, and tools for business-users. Develop technical solutions to improve access to data and data usage. Aggregate and analyze various data sets to provide actionable insight. Essential Functions: 30% Writes and executes ETL code, primarily complex SQL script, but with a strong ability to leverage other technologies. 15% Analyzes and validates existing routines and communicates impacts. Assists with data transformation, manipulation, and presentation to users. 15% Works with Business Analysts, Business Intelligence Developers, Infrastructure Architects, and key business users to review, design, and develop data models and ETL processes. 10% Supports the Software Engineering team with data analysis and validation with extensive SQL queries. 10% Designs, configures, implements, monitors, and manages all aspects of Data Integration Framework. 10% Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud OR on-premise. Understands Dimensional Modeling, Denormalized Data Structures, OLAP, and Data Warehousing concepts. 10% Defines Data Integration best practices for the data management environment. 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. Education Level: Bachelor's Degree Education Details: Information Technology or Computer Science or Engineering Experience: 3 years Hands-on experience with database management systems, ELT/ETL systems, business intelligence tools, defect management and system testing. 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. Preferred Qualifications Knowledge, Skills and Abilities: Knowledge and understanding of at least one programming language (i.e., SQL, Python). Knowledge and understanding of data exchange formats. Knowledge and understanding of database design and implementation concepts. Ability to recognize, analyze, and solve a variety of problems. Knowledge and understanding of data movement concepts Excellent communication skills both written and verbal. Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identify, national origin, age, protected veterans or individuals with disabilities.