The Government Health and Safety Operation has an opening for a Data Engineer/Analyst to support a large healthcare contract in Baltimore.
Collaborate with Solution & Enterprise Architects, Business analysts, DBAs and others to understand business requirements
Able to work independently with BA and PM to gather requirements, perform data discovery, come up with data model, work with data engineers to build data pipeline, and work with developers to answer their questions.
Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution.
Expertise in Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, DataMart Design, Metadata, Data Quality, Master Data Management and Master Data/Data Governance using Erwin
Technical experience in information architecture, data architecture, data modeling, data governance, ETL design, data quality and BI-analytics.
Ability to understand complex business processes to derive conceptual and logical data models.
Lead complex discussions and engagements that may involve multiple project teams from client.
Experience designing relational data models, analytical data models and non-relational data models for OLTP and advanced analytic applications.
Expert in designing complex and semantically rich data structures.
Worked with OLTP/data warehouse modeling, and play key role in multiple projects and act as knowledge expert (Technical, Functional).
Ability to optimize and performance tune SQL queries
Good data analysis, problem solving and SQL skills.
BS and 4 - 8 years of prior relevant experience or Masters with 2 - 6 years of prior relevant experience. Experience may be substituted in lieu of degree.
Expertise on NoSQL data modeling using Hackolade tool for databases like MongoDB, HBASE, Hive and JSON Schema.
Familiar with machine learning and advanced analytic application development.
Experience working in large-scale cloud database environments is a plus.
Ability to create dashboards in Tableau or Webfocus using various sources like database, CSV files, XL spreadsheets etc.
Experience in PostGreSQL / Greenplum database is good to have
Provide suggestions and guidance to different MI/BI projects, based on best practices, optimal solutions, and project standards
Excellent communication skills and ability to convey complex topics through effective documentation as well as presentation.
External Referral Bonus:
Potential for Telework:
Clearance Level Required:
Scheduled Weekly Hours:
Business Systems Analysis