Job Opportunities

Data Analyst / SQL Engineer

Role Overview:
We are seeking a highly skilled Data Analyst / SQL Engineer to join our reports and data team. In this role, you will bridge the gap between complex data engineering and strategic business decisions. You will be responsible for writing advanced SQL queries, and utilizing enterprise data governance tools like Collibra and Ataccama to ensure top-tier data quality.
Pharma experience is highly desirable.
Additionally, we are looking for a forward-thinking professional who actively integrates AI tools and methodologies into their workflow to accelerate data analysis, automate routine tasks, and uncover deeper insights.

Key Responsibilities:

Business Intelligence & Visualization:
Transform complex, disparate data sets into clear, actionable business stories.
Development and maintenance of queries on Snowflake Datawarehouse that query data needed with the correct error logic for business reporting, and Ataccama.

Advanced Data Querying & Integration:
Write complex, efficient, and well-documented SQL queries to extract, manipulate, and generate reports from a data set.
Utilize Common Table Expressions (CTEs), window functions, and advanced joins to build robust data layers for reporting.
Integrate and manage project tracking, operational workflows, and data intake solutions using Smartsheet.
Expertise in connecting various data sources, such as Oracle, Snowflake, ODBC.

Data Quality Management:
Leverage Ataccama for data profiling, data quality monitoring, and master data management to ensure a single source of truth.
Utilize Collibra for data cataloging, lineage tracking, and ensuring compliance with enterprise data governance policies.

AI-Driven Analytics:
Incorporate AI and Machine Learning tools (e.g., ChatGPT/Claude for SQL optimization, Tableau Pulse, predictive analytics, or automated insights) to streamline data workflows and enhance predictive capabilities.
Stay ahead of emerging AI trends in the data analytics space to continuously improve team efficiency.

Required Skills & Qualifications:

Technical Skills:
SQL Mastery: Expert proficiency in SQL, with a deep understanding of CTEs, window functions, indexing, query optimization, and relational database structures. Expertise in SQL, SQL Server, Snowflake, Redshift, PL/SQL, Postgresql and Unix.
Data Quality Tools: Hands-on experience with Collibra (data lineage/catalog) and Ataccama (data quality/profiling).
AI Literacy: Demonstrated experience using AI tools to assist with coding, debugging, automated documentation, or generating predictive data insights.
Hands on experience on reporting tools like SSRS, Dundas and UNEX and on ETL tools as well like Pentaho.
Experience with using ERD diagrams - reading and creating to document and explain query logic.

Soft Skills & Experience:
Experience: 4+ years of experience in a Data Analyst, BI Developer, or Data Engineer role. Working experience in Agile Environments.
Analytical Thinking: Strong problem-solving skills with the ability to translate ambiguous business requests into concrete technical requirements.
Communication: Excellent verbal and written communication skills to present data findings to both technical and non-technical stakeholders.
Pharmaceutical experience/ drug development process domain knowledge preferred.