Data Engineer
Baltimore, MD, United States, 21211
Full Time Senior-level / Expert USD 98K - 173K
Johns Hopkins University
Johns Hopkins, founded in 1876, is America's first research university and home to nine world-class academic divisions working together as one universityDevelopment and Alumni Relations (DAR) supports Johns Hopkins’ focus on research, teaching and patient care, and its role as a national and global leader in higher education. We create and foster enduring relationships that result in advocacy and philanthropic support for Johns Hopkins University & Medicine; strengthening the institution through partnerships with donors, alumni, volunteer leaders, faculty, students, staff, and patients.
Johns Hopkins University supports a flexible work model which includes four different work modalities. This role has a modified-hybrid work arrangement with an onsite presence of 1-2 days per week. The manager will confirm the team’s core onsite days where the majority/all team members will work in the office. Employees who travel on university business can count those days towards their onsite days.
The primary responsibility of the Data Engineer is data standards and procedures, warehousing, design and development of logical and physical data models and databases, distributed data management, and information management functions. As Data Architect, you will be responsible for:
- Strategically designing, developing, and implementing data models for an enterprise data warehouse.
- Act as a primary advocate of data modeling methodologies and data processing best practices.
Specific duties and responsibilities:
- Create and maintain documentation and define best practices in support of proper change management, security and operational requirements
- Create the design of physical and logical data warehouse models identifying data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.
- Investigate and understand new technologies and additional capabilities of current platforms that support vision of Big Data, leading to their adoption when appropriate.
- Educate peers and cross-train teammates with Big Data concepts and application of technology to serve DAR needs
- Create and maintain a current and accurate view of the “bigger data picture” by documenting the data architecture and environment
- Creatively develop opportunities for data reuse, migration, or retirement
- Create ETL specification documents
- Develop testing analysis. Lead functional testing, quality assurance testing and end-user validation.
- Troubleshoot, diagnose and resolve problems in the data and reporting environment
- Utilize APIs provided by 3rd party hosted solutions for data collection and interface to data warehouse
- Be on call for data problems that require immediate resolution
- Responsible for developing and maintaining robust, scalable data pipelines capable of ingesting and processing large volumes of structured and unstructured data.
- Oversight of specific projects like implementing a new data warehouse, migrating data to cloud-based storage solutions, or integrating new data sources into existing pipelines.
- Ensuring the integrity and security of data systems in compliance with company policies and regulatory standards.
This is a term-limited position with a length of up to 24 months.
Minimum Qualifications
- Bachelor’s degree required.
- Five years of related work experience focused within database management and design and business requirement gathering.
- Additional experience may be substituted for education to the extent permitted by the JHU equivalency formula.
Preferred Qualifications
- Master's degree preferred.
- Strong and demonstrated experience with data management, high availability, disaster recover, data replication, performance tuning and application integration in data platforms
- Experience in Data Modeling and Data Warehousing
- Knowledge of dimensional modeling and other data warehouse design techniques
- Strong conceptual, problem solving, and analytical skills.
- Strong knowledge of RDBMS (DB2, Oracle, SQL Server) including SQL
- Hands on knowledge of technologies/solutions adopted by DAR including but not limited to:
- Microsoft Power BI
- Salesforce
- Tableau
- MS SharePoint/Teams
- Talend
All applicants are expected to uphold the university’s core values which includes diversity and inclusion. All staff treat people with dignity and respect by being fair and consistent. We demonstrate an open-minded approach to understanding people regardless of their race, gender, age, national origin, religion, ethnicity, disability status or other characteristics. We show respect for the beliefs and traditions of others; encourage and promote practices that support cultural diversity; and discourage behaviors or practices that may be perceived as unfair, biased, or critical toward people with certain backgrounds.
Classified Title: Data Engineer
Job Posting Title (Working Title): Data Engineer
Role/Level/Range: ATP/04/PG
Starting Salary Range: Minimum: $98,800 - Maximum: $173,300 (targeted salary: $133,835; commensurate with experience)
Employee group: Full Time
Schedule: Monday-Friday 8:30 am - 5:00 pm
Exempt Status: Exempt
Location: JH at Keswick
Department name: 10001640-Information Systems
Personnel area: University Administration
Tags: APIs Architecture Big Data Data management Data pipelines Data quality Data warehouse Data Warehousing DB2 ETL Oracle Pipelines Power BI RDBMS Research Salesforce Security SharePoint SQL Tableau Talend Teaching Testing Unstructured data
Perks/benefits: Flex hours
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open MLOps Engineer jobs
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Manager jobs
- Open Data Science Manager jobs
- Open Principal Data Engineer jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Business Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Kubernetes-related jobs
- Open Generative AI-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs