DESCRIPTION:
• *Design, develop, document, test, and assist in implementation of secure medium to complex database solutions and ETL processes. Will be required to work in both relational, non-relational and multi-dimensional environments. • *Perform data development activities, research requests, resolve defects, mange time and planning of project activities for data management projects (new and existing). • Responsible for the development and testing of solutions including creating automated test scripts. Collaborate with other IT colleagues and business users to define developmental requirements.
SKILLS:
• Advanced skills in SQL development and comfortable designing, writing, and maintaining complex SQL based ETL, which includes building large-scale batch and real-time data pipelines Well-versed in designing data models and data management strategies to support analytical and modeling applications as well as Analytical and Data Science teams. Strong background in data warehouse concepts and designs; ETL, Star Schema, Multi-Dimensional databases Cloud computing, ideally Azure or (but not limited to); AWS, Redshift, Lambda, Cassandra Familiar with at least one scripting language (PowerShell, JavaScript, Python, Ruby, Perl, Bash) Strong data management and processing skills, including experience with Relational and Non-relational data stores (NoSQL, S3, Hadoop, etc.) Ability to adjust designs to meet project objective and timelines while maintaining the vision and goals of solid database design principles. Expert in eliciting solid data element descriptions and definitions and with physical data modeling tools and proficient in at least one (e.g., Erwin) Experience with SOA, Service Bus technologies, and other data abstraction tools and access layers. Strong communication skills both in written (technical documents, Jupyter notebooks) and spoken (meetings, presentations) forms Efficiently work and produce results within the structure of project management methodologies (e.g., Agile, Scrum, Waterfall) Demonstrate commitment to meeting organizational, department and team goals and objectives Familiar with the DevOps, data pipeline and sharing code repositories with tools such as GIT
