Job Location: Baltimore, MD
Job Detail:
Data Engineer
Requisition #: 616793
Location: Johns Hopkins Health System, Baltimore, MD 21201
Category: Information Technology
Work Shift: Day Shift
Work Week: Full Time
Weekend Work Required: No
Date Posted: Jan. 23, 2023
Req#616973 Data Engineer
Remote
JH @ MTW Campus
5801 Smith Ave.
Davis Bldg., 2nd Floor
Baltimore, MD 21209
Position Overview:
This position is responsible for implementation and maintenance of data marts and warehouses by integrating various data sources into a pre-defined data model and/or semantic layer; and support of the development of front-end dashboards and reports.
Primary Responsibilities:
- Collaborate with data engineering and BI teams across the enterprise on the overall enterprise data and BI tools’ architecture
- Provide technical guidance, mentoring and team building; and work closely with EBS functional teams and other IT and business teams in providing business intelligence solutions and support.
- Perform hardware and software evaluations, recommendations and installations; implementation of production systems, applications, and technology platforms; security administration; backup and recovery planning, capacity planning; performance monitoring and tuning; and development of policies, standards, and procedures related to the JHU and JHHS enterprise environment.
- Concurrently support integration with multiple data warehouse landscapes and environments to monitor, detect, diagnose, and correct problems using SAP, Microsoft, Splunk and other 3rd party software to assure the integrity, availability, security, and recovery of data.
- Provide expertise on all support and maintenance for BusinessObjects and related systems.
Secondary Responsibilities:
- Manage enterprise BI environment, partnering with developers across the enterprise – config, administration, support & maintenance
- Scale enterprise BI platforms to reduce cost & improve support & management
- Implement and configure integration and cataloging tools
- Collaborate with other BI and DW Teams (BusinessObjects, Tableau, O365/PowerBI)
- Gain proficiency in Snowflake to build capacity for integrations from various sources
- Provide recommendations and document technological improvements including systems sizing, backup/restore and archiving strategies using a strong working knowledge of very large enterprise scaled SAN, OS, Network and advanced hardware and software concepts.
- Develop and execute project plans, provide technical guidance and support; and create technical documentation
- Work collaboratively with business community and IT colleagues to define enterprise BI practices
- Collaborate & consult w/other IT teams for BI and development, as well as Analytic teams and other project teams to ensure operational support for major initiatives (Reports, Dashboard, Scorecards, Analytics)
Describe the position’s roles & interactions:
- This position works closely with system and data owners across the enterprise, data stewards and administrators of various source systems and applications
- Collaborate closely with other technical teams on architecture, design and integration
Describe the specific systems, applications, projects for which the position is responsible:
- Management of the BusinessObjects Enterprise platform and all related components
- Integration of multiple BI platforms and DW environments for cataloging
- Snowflake another data warehouse and data lake technologies
Describe scale/size of area, project and/or system supported
- Supports 10,000+ users in day-to-day reporting activities
- Supports several IT and BI development teams
List required & preferred skills specific to position:
Required Skills:
- Expert knowledge of BusinessObjects and working knowledge of other BI platforms, such as: PowerBI, Tableau
- Knowledge of relational databases (MS-SQL), ETL tools and practices and data integration techniques
- Familiarity with data quality/profiling tools and practices
- Working understanding of OLTP and OLAP data modeling and normalization concepts
- Ability to establish and document data lineage, metadata
- Familiarity with code versioning tools (GIT) and agile development
- Working knowledge of reference/master data tools and practices
- Demonstrated knowledge of project management, requirements gathering, software development methodologies and project documentation practices
- Excellent written and oral communications
Preferred:
- Experience in design, development and implementation of data visualizations using a variety of tools/platforms; and business intelligence tools including dashboards (such as: PowerBI, Tableau)
- Experience with data analysis, including trending and development/tuning of KPIs
- Experience with using statistical languages and statistical packages in programming languages (e.g., Python, R)
- Experience with Big Data technologies such as Hadoop or MapReduce
- Experience with modern web technologies, protocols & languages (REST, SOAP, JSON, HTML/XHTML, XML, XSLT)
On call requirements (if applicable): Off hours support not expected; only in event of unlikely system events.
Bachelor’s degree in Computer Science or related field of study. Master’s Degree, preferred. May substitute work experience where appropriate. Technical certifications in Epic Clarity and Caboodle, preferred.
Six years of work experience with computer systems and applications. Additional education may substitute for experience. Requires demonstrated experience in developing ER and dimensional models, data architecture and data warehousing.
Submit CV To All Data Science Job Consultants Across United States For Free
