Analytics Specialist

Arzen Incorporation is seeking a skilled Data Analytics Engineer to join their team, working remotely with a US-based client. The role requires building robust data pipelines, developing data models, integrating diverse data sources, and delivering actionable business insights. Candidates must have strong technical expertise and excellent English communication skills. Initial screening will be conducted onsite in Lahore, Pakistan, making it essential for applicants to be available locally for this process. The position offers a highly competitive salary paid in USD and demands a minimum of five years of relevant experience.

Key Responsibilities
- Design, build, and maintain reliable data pipelines to support business analytics.
- Develop and optimize dimensional data models and data warehousing solutions.
- Perform data transformation, testing, and documentation using DBT.
- Utilize Python for data processing, API integration, and automation tasks.
- Manage workflow orchestration using Apache Airflow or similar tools.
- Implement data ingestion and replication using Airbyte or equivalent platforms.
- Work with Redshift or comparable data warehouse technologies.
- Collaborate with cross-functional teams and communicate effectively with the US client.
- Ensure data quality, consistency, and security throughout the data lifecycle.

Required Qualifications
- Minimum of 5 years of professional experience in data analytics engineering or a related field.
- Advanced proficiency in SQL, data warehousing, and dimensional modeling.
- Hands-on experience with DBT for data transformation and testing.
- Strong Python programming skills for data manipulation and automation.
- Familiarity with workflow orchestration tools such as Apache Airflow.
- Experience with data ingestion tools like Airbyte or similar.
- Proficiency in Redshift or equivalent cloud-based data warehousing platforms.
- Working knowledge of AWS services, Git/GitHub version control, and containerization technologies like Docker and Kubernetes.
- Fluent spoken and written English with excellent client-facing communication skills.
- Ability to work independently and solve complex problems efficiently.
- Availability to attend an initial in-person screening at the Lahore office.

Preferred Qualifications and Benefits
- Experience with business intelligence (BI) tools and SaaS analytics platforms.
- Knowledge of customer experience (CX) or contact-center data analytics.
- Exposure to AI or large language model (LLM)-based analytics is considered an advantage.
- Competitive compensation paid in USD reflecting the candidate’s expertise and experience.
- Opportunity to work remotely with a US-based client while being part of a dynamic and growing organization.

Candidates who do not meet the minimum experience requirement, lack essential technical skills, or are unable to attend the onsite screening in Lahore are advised not to apply. This role demands a high level of professionalism, technical competence, and effective communication to succeed in a client-facing environment. Only applicants who fulfill all mandatory criteria should submit their applications.