Senior Data Analyst in Intetics

Intetics Inc. is a leading American technology company providing custom software application development, distributed professional teams creation, software product quality assessment, and “all-things-digital” solutions, is looking for a Senior Data Analyst to enrich its team with a skilled professional.

The project aims to migrate data, currently housed on a Databricks platform, to Client’s modern Snowflake environment, aligning with Client’s broader vision of leveraging AWS cloud services for enhanced data analytics and business intelligence.

Responsibilities:

o Conduct comprehensive data analysis to support the mapping of data from 2 old platforms to the new Snowflake-based common data model for North America.

o Work closely with the Data Architect to define and validate data mapping rules, ensuring seamless integration of diverse data sets.

o Develop and execute SQL queries for data extraction, transformation, and loading (ETL) processes, ensuring data integrity and alignment with project objectives.

o Utilize Python for data preprocessing, cleansing, and automation tasks to enhance data quality and efficiency.

o Participate in the testing and validation of data pipelines, employing rigorous analytical methods to identify discrepancies and ensure data accuracy.

o Collaborate with the US-based data engineering team to understand the existing data bricks platform and contribute to the migration strategy to Snowflake.

o Support the continuous improvement of data models and ETL processes, incorporating feedback from stakeholders to meet evolving business needs.

o Analyses ticketing data, investigation of complex and or convoluted data issues. o Documentation of business rules and data logic.

o Presentation and playback of data and issues to data team.

o Prepare and present findings and recommendations to both technical and non-technical audiences.

o Own the data testing and reconciliation efforts.

o Conduct data quality assessments, identify gaps, and implement strategies to enhance data integrity.

o Perform exploratory data analysis (EDA) to understand data trends, identify key insights, and recommend actionable strategies.

o Collaborate with product teams, and stakeholders to gather requirements and translate business needs into technical solutions.

o Monitoring and maintaining data pipelines, ensuring data quality and integrity.

Requirements:

• Must to have working on on MAC
• Must to have relevant and highly experienced as Senior Data Analyst
• Must to have at least 5 years of experiences as Data Analyst
• Must to have relevant experience with experience with SnowFlake and RedShift
• Must to have relevant experiences with JJ Data Integgration, Data Platform (JDP)
• Must to have relevant experiences AWS-based Snowflake platform
• Must to have relevant experiences with SQL, Python, R
• Must to have relevant experience with Data migrating from various legacy systems into the new Snowflake platform
• Must to have relevant experiences with data warehousing, data-driven, Data Modeling, data visualization, data manipulation, data mapping, data preprocessing, data quality assessments, Data quality assurance, data integrity, data pipeline, data accuracy, data bricks platform, data logic, Data Testing, Business Intelligence, ETL processes, EDТ
• Good to have experience with entertainment or ticketing industry