Senior Data Analyst
Bulgaria, Georgia, Hungary, Lithuania, Poland, Romania, Spain, Uzbekistan
Exadel
Advance your business through technology and pave the way to becoming a digital leader with Exadel, an enterprise software development and consulting company.We are seeking an individual with strong analytical skills, proficiency in data manipulation and data mapping, and the ability to translate complex data into actionable insights. The role involves collaborating with stakeholders, documenting the business rules and data logic, and communicating findings effectively. Some level of data modeling is beneficial.
As a data analyst on the project, you will play a pivotal role in mapping, analyzing, and ensuring the quality and consistency of data migration from various legacy systems into the new Snowflake platform. This position requires a keen analytical mind, proficiency in SQL and Python, and an in-depth understanding of data warehousing principles.
Work at Exadel - Who We Are
Since 1998, Exadel has been engineering its products and custom software for clients of all sizes. Headquartered in Walnut Creek, California, Exadel has 2,800+ employees in development centers across America, Europe, and Asia. Our people drive Exadel’s success and are at the core of our values.
About the Customer
The Customer is at the forefront of data-driven innovation, focusing on leveraging data to drive business outcomes and customer satisfaction.
They are a major international theater organization with offices in London, New York, Sydney, Mannheim, and Cologne. The company is among the most prolific theater producers in the world, with co-productions in the UK, New York, across North America, Europe, Asia, and Australia. In addition, it is considered a market leader in theater ticketing services.
About the Project
The project is an ambitious initiative aimed at overhauling the Client's legacy data systems with a modern, AWS-based Snowflake platform. This transformation is critical for integrating sales data across the UK and North America, improving data reliability, and supporting dynamic business decisions. The project faces challenges due to the diversity and customization of legacy systems, making data consolidation and analysis complex yet vital for success.
Requirements
- Experience with SQL and familiarity with data warehousing solutions like Snowflake
- Proficient in Python, with a strong preference for candidates with experience in both Python and R
- Solid understanding of data warehousing principles, ETL processes, and data modeling
- Expertise in data quality assurance and validation techniques
- Strong analytical skills, with the ability to derive insights from complex datasets and translate these into actionable business strategies
- Creative problem-solving abilities and a proactive approach to identifying and addressing challenges
- Excellent communication skills, capable of articulating complex concepts to diverse audiences, including revenue managers and senior stakeholders
- Ability to work collaboratively in a fast-paced, team-oriented environment, as well as independently with minimal supervision
Nice to Have
- Experience with data bricks or similar platforms
- Familiarity with AWS services and DBT
- Knowledge of data visualization tools and techniques to effectively communicate insights
- Understanding of the entertainment or ticketing industry
English level
Upper-Intermediate+
Responsibilities
- Conduct comprehensive data analysis to support the mapping of data from 2 old platforms to the new Snowflake-based standard data model for North America
- Work closely with the Data Architect to define and validate data mapping rules, ensuring seamless integration of diverse data sets
- Develop and execute SQL queries for data extraction, transformation, and loading (ETL) processes, ensuring data integrity and alignment with project objectives
- Utilize Python for data preprocessing, cleansing, and automation tasks to enhance data quality and efficiency
- Participate in the testing and validation of data pipelines, employing rigorous analytical methods to identify discrepancies and ensure data accuracy
- Collaborate with the US-based data engineering team to understand the existing data bricks platform and contribute to the migration strategy to Snowflake
- Support the continuous improvement of data models and ETL processes, incorporating feedback from stakeholders to meet evolving business needs
- Analyses ticketing data, investigates of complex and or convoluted data issues
- Documentation of business rules and data logic
- Presentation and playback of data and issues to the data team
- Prepare and present findings and recommendations to both technical and non-technical audiences
- Own the data testing and reconciliation efforts
- Conduct data quality assessments, identify gaps, and implement strategies to enhance data integrity
- Perform exploratory data analysis (EDA) to understand data trends, identify key insights, and recommend actionable strategies
- Collaborate with product teams, and stakeholders to gather requirements and translate business needs into technical solutions
- Monitoring and maintaining data pipelines, ensuring data quality and integrity
Advantages of Working with Exadel
Transparent Career Roadmap
- The HR manager accompanies each employee on their first steps in the company and assists them in achieving future professional goals
- Exadel is a global company with 30+ offices in 15+ countries. Employees have the chance to discover new places to live and work and can transfer to any location that has an Exadel production office. The HR manager and the Global Mobility specialist accompany the employee and assist throughout the relocation process
- Your career growth is in your hands, so each Exadeller decides when to level up and initiate performance assessments. The management team supports career planning and the discovery of new tech stacks and languages
Learning & Development Opportunities
- Each Exadeller is given a $1,000 yearly budget for self-education, which includes certifications, training sessions, meetups, conferences, and educational materials
- Employees participate actively and benefit from the knowledge-sharing environment across seven practice units: Digital Marketing Technologies, Content Marketing, AI, QA, QAA, Agile, and DevOps
- Employees can find recordings from meetups and trainings on Exadel’s Internal Learning System
Work & Life Balance
- Each Exadeller is in charge of managing their workflow independently without being micromanaged at every step; it is, however, important that an employee always attends meetings, logs their time, and meets deadlines
- Operating from the office, or remotely, depends on which mode the employee prefers. Hybrid or remote mode staff will receive the necessary equipment before their first working day. For those who prefer to work in office, the office network offers up-to-date equipment, good facilities, and a warm collaborative environment
- The team meets at two annual team-building events across locations; in addition, there are team events such as Pizza Days, Programmer’s Day, informal meetups, board game parties, and sports initiatives
Employee Perks & Bonuses
- The Exadel referral program covers all regions and involves recognition for hired recommended professionals. Depending on the location and the position, an employee receives a monetary bonus for recommending a candidate to Exadel who ends up being hired
- Employees collect coins for numerous project activities, exchanging them for products or services of their choice available on the Exadel store
- Volunteers for mentoring, interviewing, performing assessments, and participating in community meet-ups, get additional monetary bonuses
- Location-dependent, Exadellers can access benefit platforms with vouchers for online stores, medical insurance reimbursement, sports membership fees, vacations, and childbirth bonuses
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Agile AWS Data analysis Databricks Data pipelines Data quality Data visualization Data Warehousing dbt DevOps EDA Engineering ETL Pipelines Python R Snowflake SQL Testing
Perks/benefits: Career development Conferences Relocation support Salary bonus Team events
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Data Manager jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open Data Engineer II jobs
- Open Power BI Developer jobs
- Open Sr Data Engineer jobs
- Open Data Scientist II jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Junior Data Scientist jobs
- Open Business Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Junior Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open DevOps-related jobs