Sr. Data Analyst

We are looking for a skilled Data Scientist with DBA expertise to join our dynamic team. The ideal candidate will be responsible for building, managing, and optimizing scalable, reliable data pipelines and architectures to ensure seamless data flow and availability for business decision-making. You will work closely with data scientists, analysts, and other stakeholders to ensure that data solutions meet the company's current and future needs.

Responsibilities:

Data Pipeline Development:

• Design, build, and maintain robust and scalable ETL (Extract, Transform, Load) pipelines for collecting, processing, and transforming large datasets.

Database Management:

• Implement, configure, and optimize database architectures, including relational (MySQL, PostgreSQL) and NoSQL (MongoDB, Cassandra) databases.
• Monitor database performance, troubleshoot issues, and tune SQL queries for optimal efficiency.
• Ensure data integrity, accuracy, and consistency across all database systems through regular maintenance and performance checks.

Data Integration:

• Integrate data from various sources (APIs, flat files, streaming, etc.) to create a unified and efficient data ecosystem.
• Automate database backup, restoration, and recovery operations to ensure data availability.

Data Warehousing:

• Develop and maintain data warehouse solutions to support analytics, reporting, and business intelligence needs.

Data Quality & Governance:

• Implement data governance policies to manage data security, privacy, and compliance across all systems.

Collaboration:

• Work closely with data analysts, data scientists, and business stakeholders to understand data requirements and deliver tailored solutions that align with business objectives.

Automation & Optimization:

• Automate manual processes for data extraction and transformation, and optimize data pipelines for performance and scalability.
• Implement database replication, archiving, and table partitioning strategies to enhance performance and manageability.

Documentation:

• Maintain detailed technical documentation on data architectures, data flows, database configurations, and system processes.

Troubleshooting and Support:

• Identify and resolve database-related issues and performance bottlenecks, providing technical support to application developers and users as needed.

Technical Skills:

• Proven experience as a Data Engineer with DBA expertise, including hands-on experience in building and managing ETL processes and data pipelines.
• Familiarity with big data tools such as Hadoop, Spark, or Kafka.
• Experience with cloud platforms (AWS, Azure, or GCP) for data storage and processing.
• Strong knowledge of data visualization tools such as Power BI, Power Apps, or Tableau.
• Proficient in SQL, R, Python, and other data-processing languages.
• Strong knowledge of database management, including relational (MySQL, PostgreSQL, etc.) and NoSQL databases (MongoDB, Cassandra).
• Familiarity with database backup and recovery strategies, security practices, and compliance regulations.
• DB replications, archiving, table partitioning, RDS, Unix, and DBMS
• Experience with data warehousing solutions like Amazon Redshift, Google BigQuery, or Snowflake.
• Knowledge of data modeling, schema design, and data versioning.
• Experience with workflow automation tools like Airflow or Luigi.

Requirements:

• Data analytical tools(Power BI, Power Apps, or Tableau)
• SQL
• Python 
• RETL processes
• Databases(MySQL, PostgreSQL, NoSQL)
• RDS
• Unix 
• DBMS
• APIs
• Flat files
• Streaming
• Hadoop, Spark, or Kafka.
• Workflow automation tools (Airflow or Luigi)

Experience:

•   Min 5-7 Years

About Us:

PureLogics is a full services technology company with having presence in the USA, UAE, and in Lahore. Over the past 18+ years, we have matured from a narrowly-focused five-person team to a well-established technology hub with around employees. We’re CMMI Level 2 and ISO Certified company and highly acclaimed AWS consulting partners.

The success of our business mainly lies in building a team of A-players, who work together and build together, and who crave perfection in everything they produce for our elite clients. We offer the opportunity to young and enthusiastic individuals that are eager to take on tough challenges under our mentorship toward a bright future.

What are we offering?

• Health Insurance
• Provident Fund
• Annual Paid Leaves
• Compensation Plans
• Paid Certifications & Training
• Car Finance Program
• Bike Finance Program
• Child Education Program
• Two Annual Trips
• Stars Of the Month Rewards
• Quarterly Meetups
• Referral Bonuses
• Birthday & Eid Gifts