Sr. Snowflake Data Engineer

Senior Snowflake Data Engineer

Charlotte, NC or Clemmons, NC

Full-Time/Direct Hire

Hybrid Role-3 days onsite with rest remotely

Ideal candidate has excellent communication skills and hands-on Senior Snowflake Data Engineer experience. Snowflake development (including admin and modeling). Looking for experience with using Talend, NIFI, Azure, Snowflake to help streamline data pipelines for higher quality reporting and data analytics.

Preferred: Kafka, dbt, Unix, Aws EC2/S3, Nifi, Talend Cloud Java, Scala, Groovy, JavaScript, and/or Python.

*Please no 3rd parties and we cannot provide sponsorship*

The Global Data and Analytics organization uses cloud-base technology for data integration and data warehouse using Talend and Snowflake. This role will be supporting the senior executive team globally with their Data and Analytics data ingestion and transformation needs utilizing the existing technologies. This role is full- time midlevel role focusing on analyzing, building, and designing business intelligence models and solutions.

The role is key in synthesizing and distilling meaningful and accurate data for the decision makers. Responsibilities include building and supporting BI solutions using Talend, Matillion, Snowflake, and other exciting technologies of data integration. This role also provides accurate level-of-effort estimates for data integration, creates data integration solutions, develops documentation to support production deployments, and supports data solutions maintenance.

Responsibilities

• Design, develop, implement, and support new and existing data integration jobs using modern technologies.
• Provide accurate level of effort estimates for data integration development to management.
• Troubleshoot, diagnose, and resolve data quality and performance issues related to data integration and transformation.
• Ingest data from multiple sources including transactional and operational databases, implement complex business logic, and produce 3 rd normal form and dimensional model database objects in Snowflake.
• Migrate datasets between existing and future database platforms.
• Develop technology documentation to support production deployments as well as ongoing maintenance of reporting and data solutions.
• Understand and implement best practice solutions per development standards.
• Present and participate in Architecture Review Board meetings. Review solutions presented by other IT architects and provide constructive feedback.
• Collaborate with Project Managers, IT Architecture, Business Analysts, and Report Developers to achieve business objectives.
• Produce ad-hoc data extracts to answer business questions quickly and thoroughly.
• Communicate complex topics and analyses to non-technical business personnel.

Qualifications

• 5+ years advanced hands-on experience building data integration, ingestion and transformation solutions using tools such as Matillion, Nifi, Kafka (Confluent Cloud), Talend, dbt and Airflow.
• Experience in implementing CI/CD (e.g., GitHub Pipelines, AWS cloud build)
• Extensive experience in multiple operating systems: Unix, Windows, Linux
• Experience developing production solutions with distributed architectures and processing technologies.
• Equivalent working experience in-lieu of a bachelor’s degree would be considered.
• 1+ year experience with AWS and related products (such as Lambda, ECS, EC2, App Gateway and similar)
• Strong problem solving and collaboration skills.
• Hands on experience working in a public cloud environment and on-prem infrastructure.
• 3+ years hands-on experience in data warehousing, and particularly in star-schema architecture
• 3+ years working in a DevOps environment. Assist with production support issues by acting as a subject matter expert in resolving incidents and problem tickets.
• 2+ years object-oriented programming language development (Python, Shell scripting, Scala/Java)
• Commitment, technical curiosity, and relentless pursuit of practical knowledge
• 4+ years advanced SQL skills, preferably in Snowflake or similar cloud data warehouse
• Bachelor’s degree in computer science, information technology, or related field.
• 2+ years API and Web Services integration (REST/SOAP/Bulk)
• Ability to analyze and apply critical thinking to resolve complex issues.

Preferred Qualifications:

• Familiarity with Agile development methodologies such as Scrum and Kanban
• Experience in global company
• Experience with containerized environments (Kubernetes and Docker) for database pipeline applications
• Understanding of statistical concepts and intuition
• Experience in manufacturing environment
• Comprehension of data science concepts including Machine Learning and Artificial Intelligence
• Experience with observability tools and frameworks such as Grafana, Prometheus, and CloudWatch
• Exposure to leading BI reporting tools, preferably cloud based, such as Tableau, Power BI, and Cognos
• Certification in Snowflake or similar Cloud Data Warehouse platform
• Technical writing skills
• Experience building data software in microservices-oriented architecture and extensible REST APIs

Location:

• Charlotte, NC area with the ability to work remotely part of the time
• Clemmons, NC (Piedmont Triad Area - Winston Salem, Greensboro, High Point) area with the ability to work remotely part of the time.