Data Conversion Analyst- SQL Expertise (C4-112496)
Lahore, Lahore, Pakistan
Full Time
Mid Level
Position Title: Data Conversion Analyst
Job Timings:
First 6 months: 6pm-3am PKT (to align wit global team)
After 6 months: 9am-6pm PKT
Location: Lahore
About Cloudelligent
Cloudelligent is Cloud-native consultancy and AWS Advanced consulting partner! We specialize in providing bespoke cloud solutions to the SMB & enterprise segments as well as the public sector (Non-Profit Organizations). Being a next-gen cloud service provider, Cloudelligent helps small businesses & medium/large enterprises to break free from hardware lifecycle and capital expenditures, allowing them to make the most out of their cloud investment. We have an international footprint with a diverse team of domain experts, and we are customer obsessed.
We are seeking a proficient Data Conversion Analyst with expertise in SQL, HTML, CSS, VBA, PHP, JavaScript, and Python. In this pivotal role, you will architect comprehensive data conversion strategies, leveraging SQL scripting to streamline extraction, transformation, and loading processes. Collaborating closely with stakeholders, you'll analyze requirements, design efficient solutions, and ensure alignment with business objectives. If you're passionate about SQL, data conversion, data analytics, join us in this exciting opportunity to shape the future of our data infrastructure.
Responsibilities:
Requirements:
Job Timings:
First 6 months: 6pm-3am PKT (to align wit global team)
After 6 months: 9am-6pm PKT
Location: Lahore
About Cloudelligent
Cloudelligent is Cloud-native consultancy and AWS Advanced consulting partner! We specialize in providing bespoke cloud solutions to the SMB & enterprise segments as well as the public sector (Non-Profit Organizations). Being a next-gen cloud service provider, Cloudelligent helps small businesses & medium/large enterprises to break free from hardware lifecycle and capital expenditures, allowing them to make the most out of their cloud investment. We have an international footprint with a diverse team of domain experts, and we are customer obsessed.
Job Objective
We are seeking a proficient Data Conversion Analyst with expertise in SQL, HTML, CSS, VBA, PHP, JavaScript, and Python. In this pivotal role, you will architect comprehensive data conversion strategies, leveraging SQL scripting to streamline extraction, transformation, and loading processes. Collaborating closely with stakeholders, you'll analyze requirements, design efficient solutions, and ensure alignment with business objectives. If you're passionate about SQL, data conversion, data analytics, join us in this exciting opportunity to shape the future of our data infrastructure.
Responsibilities:
- Collaborate with stakeholders to gather and understand data conversion requirements, ensuring alignment with business objectives and technical feasibility.
- Develop comprehensive data conversion strategies and plans based on analyzing source data structures, target systems, and business needs.
- Write and optimize SQL queries for data extraction, manipulation, validation, transformation, and migration across diverse databases and data sources.
- Perform join operations, create and modify database schemas, ensure data integrity, handle errors, and generate analytical reports using SQL.
- Using Python programming to create scripts and tools for data extraction, transformation, and loading (ETL) processes, ensuring accuracy, efficiency, and scalability.
- Design and implement data mapping and transformation rules to convert source data formats to the required schema of target systems, ensuring data integrity and consistency.
- Test and validate data conversion processes to identify and address data discrepancies, errors, and performance bottlenecks.
- Prepare detailed documentation, including technical specifications, data mapping documents, and user guides to facilitate understanding and usage of data conversion solutions.
- Serve as the main point of contact as you work closely with cross-functional teams, including developers, database administrators, and business analysts, to coordinate data conversion activities and ensure seamless integration with existing systems.
- Stay updated with emerging technologies, best practices, and industry trends related to data conversion and integration, and actively contribute to process enhancements and optimization initiatives.
Requirements:
- Bachelor's degree in Accounting, Computer Science, Engineering, Business Administration or a related field.
- 3+ years as a Data Conversion Analyst or in a similar role, with a strong background in developing data conversion solutions using SSMS/SQL.
- Experience working with various data formats and sources, including CSV, JSON, XML, relational databases, and APIs.
- Proficiency in writing and optimizing SQL queries for data extraction, manipulation, validation, transformation, and migration across various databases and data sources.
- Expertise in performing join operations, creating and modifying database schemas, ensuring data integrity, handling errors, and generating analytical reports using SQL.
- Experience with cloud computing platforms (preferably AWS) and related data storage and processing services is desirable.
- Proficiency in Python programming language, with expertise in data manipulation libraries such as Pandas, NumPy, and SciPy is a plus.
- Familiarity with data integration tools and platforms such as Apache Kafka, Apache NiFi, or Talend is a plus.
- Strong analytical skills and attention to detail, with the ability to analyze complex data structures and identify patterns and relationships.
- Excellent communication and interpersonal skills, with the ability to effectively collaborate with diverse teams and stakeholders.
Good to have
- Background in Accounting/Finance to facilitate better understanding of financial data structures and processes.
Apply for this position
Required*