Senior Data Engineer

Location: Lahore, Karachi

NUMBER OF OPENINGS: 2

Job Summary

Senior Data Engineer will be responsible for designing, mapping, documenting and creating the enterprise data warehouse and managing end-to-end Job mechanisms for data extraction, transformation and loading of data functions. Also, He should be ableto analyze the business requirements and able to transform those requirements into ETL job functions using industry best practices.Technically leading the Data integration and services team will be one of his core responsibilities.

Analytics Overview

Analytics Private Limited (APL) is a leading Artificial Intelligence, Business Analytics, Big Data Analytics and Data Sciences solutions provider. Having customers in the United States, Middle East and Pakistan, the company has accomplished a proven track record of successfully delivering high impact and complex projects. We are the business partners of leading technology companies like; IBM, Teradata, Oracle, Micro Focus (Vertica), Qlik, Informatica, HortonWorks and MicroStrategy.

Description

Enterprise DataWarehouse /ETL

Participates in evaluation and selection of Data Modeling and DI tools.
Participates in documentation and understanding of scoped source systems for identification of key business functions & domain information.
Participates in documenting, designing, developing, testing and deploying the Data Models and Data Marts that comes from various source systems.
Using the data flow design, develops and maintains the ETL scripts that acquire data from various source systems to load information into the Staging Area, the Data Warehouse and Data Marts.
Identifies and develops opportunities to utilize objects and code where appropriate to reduce development effort and enforce consistent business rules.
Identifies opportunities for analysisand reporting solutions within the company.
Providing technical leadership, strategizing effort distributions and supervising team assignments.
Acting as a liaison between Project Management and technical team for successful project deliveries.

Business Intelligence

Supports Business Intelligence team to drive business requirements into data marts responsible for Reporting and Analytical insights.
Supports and work closely with the BI team to translate business requirements into technical Data Models and Data Marts.
Supports Business Intelligence team in establishing business drivers.
Translates business requirements into technical Data Models and Data Marts.
Contributes to the overall technical development of the team within the company.
Provides valuable input and feedback to the vision of the overall department and company’s strategy.
Communicates and promotes healthy, responsible and goal-oriented work culture within the company.

Reporting & Drafting

Clearly documents all development to company standards.
Works in a small/medium sizeteam environment and supports team members where needed.
Assists in establishing new standards and processes for ETL/BI data modeling.
Clearly communicates task status, progress and problems to project lead.

Qualifications	Minimally Required	Preferred or Specialized
Education	BS in Computer Science, BIT, BBIT or related field.	MS in Computer Science
Experience	3-4 Years	4-5 Years
Knowledge	Good understanding of Data Warehousing concepts & DI Methodology	Learning new technologies
Skills	RDBMS SQL
Abilities	Analytical Organizing Problem Solving Team LeaderMotivator
Tools and Implementation Platforms	Talend, IBM Infosphere Datastage, Informatica, SSIS	Big Data methodologies, Hadoop, Cloudera, Talend for big data, Etc.
Databases	MS SQL Server, PostgreSQL, Vertica, IBM DB2, Teradata, MySql, Oracle	Hbase, MongoDb
Modeling Tools	IBM Data Architect/Erwin

News and Events

Women’s Day

We celebrated Women’s Day 2020 at our Karachi and Lahore Offices by recognizing the key role that the ladies of APL have played in our success!

Quarterly Team Building and Entertainment Event

At APL, we love to celebrate our team’s efforts and successes. Our periodic entertainment events are a unique blend of delicious food, fun, laughter, games and team building activities. This provides us an opportunity to revitalize our energies and form lifelong relationships.

Corporate Social Responsibility

At APL, Corporate Social Responsibility is one of our top priorities. APL CSR Team participated in the Children Mela. It was heartening to see the little cancer patients forget their pain and laugh wholeheartedly while playing games and receiving prizes! Hats off to these beautiful souls who are fighting cancer with utmost courage, Alhumdulillah. We are proud of our APL volunteers! A health awareness session on Hepatitis and its preventive measures was hosted at the APL office in partnership with Pakistan Kidney and Liver Institute (PKLI)

Why Join Us?

Strive for Excellence

Believe in Data

Contribute to growth story

"If you are looking for a challenging position that allows you to learn and grow professionally and focus on improving your skills, then APL is the right place for you. Since joining Analytics, I have had the opportunity to work on five different projects all in different domains and have gained valuable experience of learning and executing ETL testing, Application testing, database testing and Mobile testing."

“I always heard that people shape the culture. Joining Analytics was not an easy decision, but staying in Analytics is the easiest. You see, culture cannot be imposed or mandated; it must grow from within. At Analytics, we own the company, at Analytics, we believe that “To win in the marketplace you must first win in the workplace”

“If you wish to have your logical and technical capacity challenged to the limit, then APL is the right place for you! Every day presents a new challenge and you are at the helm, steering the project through; no micro-management!! I have had the opportunity to work alongside our North American client and it has been a roller-coaster ride so far. Your efforts are thoroughly appreciated and that in itself is the highest motivation ever!!”

“Choosing a new workplace is always a risk, I learn the culture of the organization from its hiring process, and it helps in choosing my workplace. I always wanted to work with an organization that fosters a learning culture, Analytics truly understands the importance of supporting and investing in their people which makes Analytics a success. Analytics provides you the liberty to make decisions and mistakes are welcomed with guidance that makes analytics my favorite place because I can always bring my A-game to the company without any fear of making mistakes.”

"I joined Analytics as an apprentice during my last semester of Master's degree and immediately felt welcomed by all my colleagues. As this is my first full-time opportunity, I could not have asked for a better kickstart to my career professionally & personally, where I look forward to each day with new challenges. Empowering its employees and having an open door policy is one of the great ways to bring the best out of its associates."

Let’s talk

Analytics Private Limited (branded as Tenx.ai in North America) is a leading Artificial Intelligence, Business Analytics, Big Data Analytics and Data Sciences solutions provider.

Islamabad | Lahore | Karachi | Toronto | Stamford