Senior Data Analyst

OneMagnify; United States; On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k) retirement plan

Flexible Time Off

Job summary

OneMagnify is seeking a Data & Analytics professional to leverage data tools and enhance client services. The ideal candidate will possess over 5 years of experience, strong SQL skills, and familiarity with AWS services.

This position provides medical, dental, and vision coverage, a 401(k) retirement plan, and Flexible Time Off. We value diverse perspectives and are committed to equal opportunity in our workplace.

Qualifications

• 5+ years of experience documenting requirements for data solutions.
• Experience in integrated marketing or digital agency environments.
• Knowledge of data governance and metadata management.

Responsibilities

• Leverage data tools to deliver superior service to clients.
• Conduct end-to-end data analysis to improve data quality.
• Develop technical specifications for data ingestion.

Skills

SQL scripting

Data analysis

Problem Solving

Collaboration

Education

University or college degree in Computer Science, Mathematics, Engineering, Statistics

Tools

AWS tools (S3, Redshift, Glue)

Python

Snowflake

Job description

OneMagnify is an AI native, platform-enabled B2B digital agency operating at the intersection of data, technology, and creativity. We help complex organizations drive measurable business outcomes by building smarter customer experiences and delivering highly integrated solutions across digital, media, and technology. By combining deep industry expertise with advanced analytics and artificial intelligence, we enable our clients to make better decisions, move faster, and compete more effectively in dynamic markets.

The impact you’ll have:

You are a data person with solid hands-on technical skills and great attention to detail. You enjoy taking data and turning it into a solution. You are a troubleshooter and passionate about what you do.

• Resourceful and relentless: independently capable of seeking information, corralling resources, and delivering results in challenging situations
• Collaboration and Teamwork: works with others to deliver results, contributing to the team and prioritizing group needs over individual needs
• Problem Solving: uses an organized and logical approach to find solutions to complex problems. Looks beyond the obvious to uncover the root cause of problems
• Open Communication: clearly conveys thoughts, both written and verbally, listening attentively and asking questions for clarification and understanding

What you’ll do:

• Leverage data tools and capabilities to deliver superior service to client's customers and to advance the Data & Analytics Road Map.
• Conduct discovery and end-to-end data analysis to understand customer needs and to help develop plans and activities to improve data quality.
• Elicit, analyze, interpret business and data requirements to develop complete data product solutions, includes review data models ("entity relationship diagrams", "dimensional data models"), ETL and 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 to help inform data quality checks and/or curation rules that need to be developed.
• 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, this includes documentation templates and agile development methodologies.

What you’ll need:

• 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 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.

Benefits

We believe great work happens when people have the support and flexibility they need to thrive. Our benefits include medical, dental, and vision coverage, a 401(k) retirement plan, paid holidays, and Flexible Time Off (FTO) so you can take time away to recharge when you need it. We also offer additional programs focused on wellness, financial security, and professional growth.

We are an equal opportunity employer

We believe that Innovative ideas and solutions start with unique perspectives. That’s why we’re committed to providing every employee a workplace that’s free of discrimination and intolerance. We’re proud to be an equal opportunity employer and actively search for like-minded people to join our team. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform job functions, and to receive benefits and privileges of employment. Please contact us to request accommodation.