| Need - Technical Systems Analyst (SQL Developer + Snowflake) - Local Only at Phoenix, Arizona, USA |
| Email: [email protected] |
| From: Nikhil, CCIT INC [email protected] Reply to: [email protected] Role: Technical Systems Analyst (SQL Developer + Snowflake) Work Location - Phoenix, AZ - Hybrid - Local Only Long term contract Visa Independent Only Key Note: Very strong SQL and data management experience. Snowflake experience is required. Job Description: To provide some additional details: I have been working with a resource from your team through my partnership with Bharath and have loved the engagement so far. I would love to explore how you might be able to help us over the next 6 months. I am looking for support as we begin to implement our foundational data management strategy for contact data in our CRM and I am looking for 2 resources to help us fast track numerous foundational data quality initiatives. I would classify both roles as Data Analyst, however we require at least one to be highly technical. Job Skills: Advanced SQL Proficiency: They should have a strong command of SQL to query, manipulate, and join datasets efficiently. This skill is crucial for unifying the current contact data with 3rd party vendor data. Data Validation: Ability to clean and standardize data, identify duplicates, and resolve inconsistencies is crucial for maintaining data quality. Problem-Solving Skills: Strong problem-solving skills are necessary for optimizing processes and resolving technical challenges encountered during the project. Data Skills: Investigate data problems and perform deep-dive analyses. Ability to identify trends and interpret data. Should be able to summarize their findings in simple yet consumable structure (via slides/tables). Additional Skills: Database Management: Understanding of database management principles, including indexing, performance optimization, and data security, is essential for managing the unified dataset efficiently. Data Integration and ETL (Extract, Transform, Load): Experience with ETL processes is necessary for merging and transforming datasets from various sources. The consultant should be capable of designing and implementing data integration pipelines to enrich existing contact data. (most relevant for TAU expansion) Python Programming: Proficiency in Python is essential for developing scripts and automation tools to streamline the data enrichment process. Knowledge of Regular Expression (Regex) to identify and manipulate text strings such as Job titles, names, and email domains is advantageous. Job Responsibilities: Data Integration and Enrichment: Collaborate with the project team to integrate vendor data with existing contact data using SQL and Python scripts, ensuring accuracy and consistency. Automation Mindset: Partner closely with the Data Engineering team to design an automated solution to refresh data and validate contacts. Integrate error handling, data quality checks, and monitoring mechanisms to ensure accuracy and reliability. Performance Monitoring and Optimization: Monitor the performance of data integration and enrichment processes, identify bottlenecks and drops in coverage. Analysis: Investigate data problems and perform deep-dive analyses to help guide recommendations. This includes having the ability to analyze third-party data against internal data to determine the potential success of data enhancement projects. You must be able to identify areas where data is helpful vs not and be able to summarize trends and the root cause of any issues. Documentation and Reporting: Document processes, methodologies, and solutions. Provide knowledge transfer to enable internal teams to consume data for their analysis & data science models. Thanks & Regards Nikhil Pathania [email protected] Keywords: access management Arizona |
| [email protected] View all |
| Wed Feb 21 00:30:00 UTC 2024 |