Data Warehouse lead

Data Lead

Location – Remote  

 Exp 15+ years required (below exp won't accept)

JD:

• 4+ years of experience with writing SQL queries and stored procedures with relational databases
• 3+ years of experience in a Data Warehouse/BI environment
• 2+ years of experience in Snowflake, ETL and Database Schemas
• 2+ years of experience in Design and development of well documented source code
• 1+ years of experience using CI/CD pipelines such as GitHub and Jenkins

Responsibilities:

• Design, implement and maintain an enterprise Data Warehouse along with the various ingestion patterns
• Develop, test, deploy and schedule complex ETL/ELT solutions to integrate multiple data assets across the organization
• Research and evaluate alternative approaches, design and code efficient and effective solutions for challenging problems ranging from small to large work efforts
• Ability to act as a lead developer responsible for the planning, completion and coordination of work activity for projects involving more than one developer
• Participate in code reviews and provide constructive feedback to improve code or data quality

Functions may include database architecture, engineering, design, optimization, security, and administration; as well as data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning and other similar roles.  Responsibilities may include Platform-as-a-Service and Cloud solution with a focus on data stores and associated eco systems. Duties may include management of design services, providing sizing and configuration assistance, ensuring strict data quality, and performing needs assessments. Analyzes current business practices, processes and procedures as well as identifying future business opportunities for leveraging data storage and retrieval system capabilities. Manages relationships with software and hardware vendors to understand the potential architectural impact of different vendor strategies and data acquisition.  May design schemas, write SQL or other data markup scripting and helps to support development of Analytics and Applications that build on top of data.  Selects, develops and evaluates personnel to ensure the efficient operation of the function.

Scope and Guidelines:

- Assesses and interprets customer needs and requirements.

- Identifies solutions to non-standard requests and problems.

- Solves moderately complex problems and/or conducts moderately complex analyses.

- Works with minimal guidance; seeks guidance on only the most complex tasks.

- Translates concepts into practice.

- Provides explanations and information to others on difficult issues.

- Coaches, provides feedback, and guides others.

- Acts as a resource for others with less experience.