Job Description
Job Overview:
As a Data Engineer, you will design, deploy and support data acquisition and data integration solutions from source systems to the data warehouse and data marts for business intelligence solutions such as dashboards, scorecards, reports and self-service analytics. Additionally, you will support end-user web-based presentation layers and the underlying technology layers including data models, dimensional databases, cubes and security infrastructure.
Key Responsibilities:
- Design Extract, Transform and Load (ETL) solutions in collaboration with Business Analysts to satisfy the reporting and advanced analytic needs of the business, optimized for reuse of data and interoperability of BI solutions.
- Develop and maintain ETL solutions, database schema and stored procedures in collaboration with the Data Modeler and BI Developer while adhering to technical solution standards and demonstrating flexibility when required.
- Tests ETL solutions collaborating with team members through unit testing and integration testing.
- Document and maintain documentation of ETL solutions including diagrams and flow charts illustrating data flows.
Requirements:
- Bachelor’s Degree in computer science, information systems, health care business, or equivalent experience required; Master’s Degree preferred
- Minimum 6+ years of relevant experience required
- Minimum 3-5 years working with enterprise data sources and ETL tools such as IBM DataStage or Informatica
- Financial and healthcare knowledge
- Experience supporting technical service delivery relationships
- Experience translating business needs into designs and specifications
- Experience managing projects, testing, and quality control
- Experience with metadata management
- Experience with data profiling and data quality analysis
- Experience working with a coordinated data management environment (CDME) preferred
- Experience facilitating requirements definition meetings/sessions using structured approaches such as Joint Application Development (JAD)
- Experience with IBM InfoSphere and IBM data models a plus
- Proficient with dimensional databases, cubes, and columnar data structures
- Proficient with Microsoft Office applications such as Office, Project, Visio, SharePoint
- Maintain application vendor certifications as needed
- Strong listening skills
- Strong verbal and written communication skills, demonstrating proper business use of grammar and punctuation
- Strong presentation skills, clearly conveying information, ideas, concepts, and instructions to a variety of audiences
- Meeting management skills, including agendas, facilitation, minutes, and time management
- Negotiation skills to resolve conflict and build cooperation
Experience with modernizing data integration by streaming data to the cloud, e.g. S3, object buckets
Database design experience
Data modeling, e.g. OLAP, Star Schema
Experience in migrations from on-prem to the cloud
Cloud experience – preferably AWS, but other cloud experience should suffice
Talend (ETL) tool
Snowflake (Database); they have loaded data into Snowflake leveraging Talend
Scripting: Python, Javascript
Jira
Healthcare vertical or provider/payor/pharma