Senior Data Analyst

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.

We are looking for Data Analysts with deep experience translating business requirements into technical data specifications, manipulating large datasets, and supporting various data initiatives for our client. Our Data Analysts will help design and support a set of data services and capabilities for our client's customers. They will work directly with the client's business partners and their Data Engineering and Analytics team to understand the business meaning of data and provide analysis and requirements so that data design is fully understood and the data service initiatives are in line with intended design and standards.

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