The Role
The Senior Data Specialist is responsible for designing and maintaining data pipelines, developing ETL processes, and writing complex SQL queries. The role requires strong skills in Python, SQL, and Unix scripting, along with experience in data warehousing and analytics. The specialist will also support QA processes and define standards for data extraction and transformation.
Summary Generated by Built In
Senior Data Specialist
Primary Skills
- ETL Fundamentals, SQL, SQL (Basic + Advanced), Alation, Talend, Python, Data Warehousing, IICS, Modern Data Platform Fundamentals, PLSQL, Data Modelling Fundamentals
Specialization
- ETL Specialization: Senior Data Engineer
Job requirements
- 6 plus years of overall IT experience. Strong Python experience mandatory. Write effective, scalable code in Python. Hands on experiance with Python - Pandas library in detail & Numpy. Advanced SQL skills are mandatory. Ability to write complex SQL queries to query large amounts of data Hands on DBT development experiance. Design, develop, and maintain DBT models, transformations, and SQL code to build efficient data pipelines for analytics and reporting. Mandatory hands on coding experience in Unix Shell scripting. Develop back-end components to improve responsiveness and overall performance. Hands-on-experience in designing and building data pipelines in data analytics implementations such as Data Lake and Data Warehouse and development. Salesforce CDP knowledge and Snowflake implementation will be a plus. Integrate user-facing elements into applications Writing Snowflake SQL queries against Snowflake Developing scripts like Unix, Python, etc. to do Extract, Load, and Transform data. Good to have working experiance with Airflow. Good to have exposure to AWS eco systems. Test and debug programs, Improve functionality of existing systems. Implement security and data protection solutions Coordinate with internal teams to understand user requirements and provide technical solutions Support QA, UAT and performance testing phases of the development cycle. Understand and incorporate the required security framework in the developed data model and ETL objects. Define standards and procedures; refine methods and techniques for data extraction, transformation and loading (ETL) both in batch and “near real time” modes. Design Data Integration, Data Warehousing, Analytics, Reporting & Data science strategies.
Top Skills
Python
SQL
The Company
What We Do
Brillio is the leader in global digital business transformation, applying technology with a human touch. We help businesses define internal and external transformation objectives, and translate those objectives into actionable market strategies using proprietary technologies. With 2600+ experts and 13 offices worldwide, Brillio is the ideal partner for enterprises that want to quickly increase their core business productivity, and achieve a competitive edge, with the latest digital solutions.
