What are the responsibilities and job description for the Data Engineer with SQL position at Triunity Software?
Location: Phoenix, AZ
Duration: 18 months
Experience: 8 to 9 years
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 required for the technical data analyst:
- 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.
Compensation: $100,000.00 - $110,000.00 per year
About Us
Triunity is a Product Development, Staff Augmentation, and Consulting Services company providing solutions and services in North America. We provide IT services and technology solutions to various business verticals like Healthcare, Pharma, Banking, Finance, etc. Our goal is to develop a long-term partnership with businesses and help them get a competitive advantage by providing IT infrastructure and software platforms.
Lead by experts in the IT industry with a proven record of delivering software solutions, consulting, and staffing services, we have expertise in fulfilling client needs in terms of customized business solutions as well as IT consulting. At Triunity, we always try to bring the right mix of skills, technologies, and experts together which helps our clients to stay ahead in the competition. Our goal is to make our clients empower with cutting-edge technologies and take care of all their IT needs so they can focus more on their core business.
Triunity Culture
Our core value is our people and our teams . We believe the real mantra of success is like minded people with right mix of technical and analytical skills. Our strength lies in bringing right set of people and delivering work as a team. Be it expert or intern Triunity always always value its own people and give them platform to excel in their career.
At Triunity you can expect
- Challenging & Friendly
- Work on new edge technologies & tools
- Work with industry experts
- Solving complex client problems and delivering solutions
- Working on projects lasting from six months to several years
Careers & Growth Model
At Triunity people are motivated by the complexity and challenges they face when working on client projects . We always motivate our people to keep learning new technologies and also give them platform where they can get chance to show their technical and analytical skills . We help our people in adding latest technologies ,tools, methodologies and certifications to their resume by arranging trainings , seminars and knowledge sharing sessions.
Salary : $100,000 - $110,000
