Senior Data Analyst

Job Summary

OneMagnify is seeking Data Analysts with a strong background in translating business requirements into technical data specifications, manipulating large datasets, and supporting various data initiatives. This role involves designing and supporting data services and capabilities for clients' customers, working closely with business partners and Data Engineering and Analytics teams.

Responsibilities

• Leverage data tools and capabilities to deliver superior service to client's customers and advance the Data & Analytics Road Map.
• Conduct discovery and end-to-end data analysis to understand customer needs and develop plans and activities to improve data quality.
• Elicit, analyze, interpret business and data requirements to develop complete data product solutions, including review data models, ETL, business rules, data management, governance, lineage, metadata, and reporting elements.
• Manipulate large data sets using SQL to understand patterns in the data. Perform data profiling using various tools to learn the shape of the data and inform data quality checks and/or curation rules.
• Partner with customers in interpreting data and remediating issues when required.
• Collaborate with data owners, stewards to implement, maintain, enhance data governance, quality, security, and privacy requirements, and related policies and standards.
• Prepare technical specifications for data ingestion and transformation rules. Partner with data architects to build data models for efficient consumption of data.
• Support the development of standards and best practices within the Data Analysis team, including documentation templates and agile development methodologies.

Requirements

• University or college degree in Computer Science, Mathematics, Engineering, Statistics, or related field of study.
• 5+ years of relevant experience gathering and documenting requirements as well as technical specifications for data solutions.
• Advanced SQL scripting skills. Python knowledge is a plus.
• Experience with AWS platform and tools associated with analytics and data (S3, Redshift, Glue).
• Understanding of Snowflake platform a plus.
• Data governance and metadata management experience (standards, format, definition, structure, tagging, transmission, manipulation, use and management of data).
• Understanding of Monte Carlo and Atlan.
• Experience in integrated marketing, digital agency, marketing services, or consulting environments preferred.

Qualifications

• Excellent communication and collaboration skills.
• Resourceful and relentless problem-solving abilities.
• Open communication style, clear and attentive.

Skills

• Data analysis and interpretation.
• Data modeling and design.
• Data manipulation and SQL scripting.
• AWS and Snowflake platform proficiency.
• Data governance and metadata management.
• Monte Carlo and Atlan understanding.

Benefits

• Medical, dental, and vision coverage.
• 401(k) retirement plan.
• Paid holidays.
• Flexible Time Off (FTO).
• Additional wellness, financial security, and professional growth programs.

Company Culture

We are an equal opportunity employer committed to fostering a diverse and inclusive workplace where everyone feels valued and respected. We strive to provide a supportive environment that encourages innovation, creativity, and collaboration.