Data Warehouse Engineer
Job Type: Full Time / Permanent
Under general direction, primarily responsible for activities related to the development, implementation, and support of the data warehouse.
Essential Duties: – Participates in the design of the technical and information architecture for the data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores). – Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing, and updating processes. – Coordinates with business, operations, and engineering stakeholders to ensure overall requirements, health, and performance of the data warehouse environment. – Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment. – Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products. Additional Duties: – Develops and applies sound fundamental design, analysis, and data administration concepts, practices, and procedures. – Designs and develops BI reporting deliverables. – Performs other duties as required. Qualifications – Bachelor’s degree in computer science or related field; or an equivalent combination of education and relevant business experience. – Five or more years of experience with data warehousing and business intelligence and/or large and complex database management systems. – Hands-on experience using ETL tools. – Strong database schema experience; SQL and DDL with MySQL or Postgres – Working knowledge of data processing using AWS services and best practices. – Experience developing data warehouses using AWS cloud based ETL, storage and analytic services. Athena, Glue, RDS, RedShift, etc. – Working knowledge of data warehouse approaches, architecture, and development. – Highly effective analytical, decision-making, and written/verbal communication skills. – Ability to investigate complex technical problems, develop effective recommendations, and resolve problems in a highly professional and tactful manner. – Highly organized and able to set priorities effectively. Preferred candidate experience – Knowledge of policies and best practices governing the handling of PHI – Experience with X12 5010 healthcare claims transactions – HL7 transaction formats for Admit Discharge Transfer