FIND_THE_RIGHTJOB.
Data Specialist – R01556226
Edison, United States
Data Specialist - R01556226
About Brillio:
Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as "Brillians", distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction.
Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.
Data Specialist
Primary Skills
- ETL Fundamentals, SQL, SQL (Basic + Advanced), Alation, Talend, Matillion, Python, Data Warehousing, IICS, Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Specialization
- ETL Specialization: Data Specialist
Job requirements
Job Title: SQL Developer (Data - Extractor framework)
About the Role
We are looking for SQL Developer with strong programming fundamentals and experience in data extraction frameworks. The ideal candidate will design and maintain automated tools for large-scale data scraping, integration, and transformation. You will work across diverse data sources, build reliable pipelines, and ensure high-quality, consistent data delivery. Your work will directly enable data-driven decision-making across the organization.
Key Responsibilities
- Design, develop, and maintain automated data extraction and web scraping tools using Python.
- Powerful in T-SQL, SSIS and SSRS as it is the primary language used to support the tool.
- Extract structured and unstructured data from databases, APIs, and online sources.
- Clean, validate, and transform raw data into usable formats (CSV, JSON, SQL databases).
- Ensure data accuracy, consistency, and completeness through validation and error handling.
- Implement and maintain DB connectivity in Python (Oracle Client, SQL Server). Experience with Python scripting
- Monitor scrapers and integrations for performance; adapt quickly to site/API changes.
- Build and maintain alerts, notifications, and monitoring via Splunk, CyberArk, SMTP/DBMail.
- Develop and manage PowerShell scripting, CMD and WINSCP and experience with similar file processing utilities.
- Experience integrating tools with SPLUNK for monitoring and CyberArk for Password storage and retrieval.
- Manage network and system-level aspects (ports, firewalls, file shares, compression utilities).
- Schedule and orchestrate jobs, event triggers, file polling, and watchers.
- Collaborate with analysts, engineers, and product teams to deliver scalable data solutions.
- Document processes, maintain repositories (GitHub/GitLab), and follow best practices.
Required Skills & Qualifications
- Strong T-SQL, SSIS, SSRS & Python programming fundamentals (data structures, OOP, error handling, code optimization).
- Good knowledge of SQL scripting and database connectivity in Python (Oracle Client, SQL Server).
- Proficiency in SQL query design, schema design, and performance optimization.
- Experience with SQL Server Integration Services (SSIS).
- Hands-on experience with web scraping frameworks and libraries using Python
- Proficiency in working with databases (SQL) and common formats (CSV, JSON, Parquet).
- Familiarity with alerts/monitoring systems (Splunk, CyberArk, SMTP, DBMail).
- Hands-on experience with PowerShell scripting, Cygwin, GNU utilities, and FTP scripting.
- Understanding of networking fundamentals: ports, firewalls, file shares/mounts, compression (gzip).
- Experience in job scheduling, orchestration, event triggers, and file watchers.
- Strong debugging, testing, and documentation skills.
- Knowledge of regular expressions, data normalization, and data quality checks.
Qualifications
- Bachelor’s or Master’s degree in Computer Science, IT, or a related field.
- #L1- AS
Know what it’s like to work and grow at Brillio: Click here
Salary: 120,000-125,000 USD per-month-salary
Similar jobs
No similar jobs found
© 2025 Qureos. All rights reserved.