Job ID:
Data Architect
Job Description
As a Data Engineer, you will design, develop, test and maintain efficient and sustainable data models to keep data accessible and ready for analysis. Working closely with Analytics Team, you will engage with business teams to understand requirements, design conceptual, logical and physical data models, and perform root-cause analysis and recommend solutions. This will be a hands on role utilizing Extract, Transfer & Load (ETL) tools to deliver source to target mappings, physical and logical data models and related scripts to automate and streamline data processes with the overarching goal of unlocking the value of data for the organization. This is a critical role to help build the foundation of a data-driven culture through implementation of a robust self-service data framework. Essential Job Functions: Engage business teams to understand requirements, document them and deliver robust and scalable solutions in the form of data models that can be leveraged for self-service analytics. Explore ways of modeling the Plans unstructured voice and text data into frameworks fit for analysis. Design conceptual, logical and physical data models, maintain data dictionary and capture metadata. Perform gap analysis as needed for purposes of maintaining, continuously enhancing data models and integrating KPI’s into the analytics platform as and when new KPI and business metrics are adapted by the organization. Work closely with data experts to build and maintain KPI data dictionary, metadata, data standards, and ensure adherence to the Plans Analytics Method and data standards. Work with application development team to deploy analytics data products through such ways as embedding analysis models into business applications and mobile solutions. Establish and maintain provenance, integrity and security of data used for self-service reporting, ad-hoc analysis or other levels of analysis. Utilize ETL tools and other data pipeline automation techniques to develop and maintain source to target mapping that includes extract requirements, derived field logic, domain values and data lineage. Ensure developed data models are easy to use and efficient to access data thus enable transparency of data lineage to business teams and all stakeholders. Knowledge, Skills, and Abilities: Proficient in leading business and internal team discussions to gather requirements, brain-storm and propose robust and scalable solutions; leverage business partner/unit input to enhance data models. Expert knowledge of relational DBMS, specifically Oracle . Expert knowledge in areas of advanced data techniques including unstructured and spatial data. Preferred Qualifications: Previous work experience in the Healthcare industry. Competencies: Customer focus – Gains insight into customer needs; identifies opportunities that benefit the customer; builds and delivers solutions that meet customer expectations; establishes and maintains effective customer relationships. Decision quality – Makes sound decisions, even in the absence of complete information; relies on a mixture of analysis, wisdom, experience, and judgment when making decisions; considers all relevant factors and uses appropriate decision-making criteria and principles; recognizes when a quick 80% solution will suffice. Communicates effectively – Is effective in a variety of communication settings: one-on-one, small and large groups, or among diverse styles and position levels; attentively listens to others; adjusts to fit the audience and the message; provides timely and helpful information to others across the organization; encourages the open expression of diverse ideas and opinions. Ensures accountability – follows through on commitments and makes sure others do the same; acts with a clear sense of ownership; takes personal responsibility for decisions, actions, and failures; establishes clear responsibilities and processes for monitoring work and measuring results; designs feedback loops into work. Instills trust – follows through on commitments; is seen as direct and truthful; keeps confidences; practices what he/she preaches; shows consistency between words and actions. Manages Ambiguity – Operating effectively, even when things are not certain or the way forward is not clear. Qualifications Behaviors Preferred Team Player: Works well as a member of a group Functional Expert: Considered a thought leader on a subject Detail Oriented: Capable of carrying out a given task with all details necessary to get the task done well Dedicated: Devoted to a task or purpose with loyalty or integrity Motivations Preferred Goal Completion: Inspired to perform well by the completion of tasks Self-Starter: Inspired to perform without outside help Ability to Make an Impact: Inspired to perform well by the ability to contribute to the success of a project or the organization Education Required Bachelors or better in Computer Science or related field. Experience Required Experience designing conceptual, logical and physical data models and maintaining data dictionary and capturing metadata. Experience creating and maintaining automated data pipelines, data standards, and best practices to maintain integrity and security of the data; ensure adherence to developed standards. Experience in developing and maintaining source to target mapping that includes extract requirements, derived field logic, domain values and data lineage. Experience in relevant technical languages and tools such as SQL, Python, NoSQL, Airflow, Quartz, ERWIN or equivalent.