Senior Data Analyst-2

Posted 5 Days Ago
Hiring Remotely in Michigan
Remote
5-7 Years Experience
Information Technology • Marketing Tech • Analytics
The Role
Senior Data Analyst will translate business requirements into technical data specifications, manipulate large datasets, and support various data initiatives. Responsibilities include conducting data analysis, developing data product solutions, and collaborating with clients to improve data quality and resolve issues.
Summary Generated by Built In

OneMagnify is a global performance marketing organization working at the intersection of brand marketing, technology, data and analytics. The Company’s core offerings accelerate business, amplify real-time results, and help set their clients apart from their competitors. OneMagnify partners with clients to design, implement and manage marketing and brand strategies using analytical and predictive data models that provide valuable customer insights to drive higher levels of sales conversion.

OneMagnify’s commitment to employee growth and development extends far beyond typical approaches. We take great pride in fostering an environment where each of our 700+ colleagues can thrive and achieve their personal best. OneMagnify has been recognized as a Top Workplace, Best Workplace and Cool Workplace in the United States for 10 consecutive years and recently was recognized as a Top Workplace in India.

We are looking for a Senior Data Analyst with deep experience translating business requirements into technical data specifications, manipulating large datasets, and supporting various data initiatives for our client. Our Senior Data Analysts help design and support a set of data services and capabilities for our client's customers. They 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.

About You:

You are a data person with solid hands-on technical skills and great attention to detail. You enjoy taking data and turning 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 & Python scripting. Airflow & Lambda.
  • Experience with AWS platform and tools associated with analytics and data (S3, Redshift, Glue, DBbeaver). Understanding of Snowflake platform, a plus.
  • Integration, implementation and practice with; Airflow, Airbyte, dbtCloud, Monte Carlo & Atlan preferred.
  • Data governance and metadata management experience (standards, format, definition, structure, tagging, transmission, manipulation, use and management of data). Understanding of Monte Carlo and Atlan.

Benefits

We offer a comprehensive benefits package including medical, dental, 401(k), paid holidays, vacations, and more.

About us

Whether it’s awareness, advocacy, engagement, or efficacy, we move brands forward with work that connects with audiences and delivers results. Through meaningful analytics, engaging communications and innovative technology solutions, we help clients tackle their most ambitious projects and overcome their biggest challenges.

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.

Top Skills

SQL
The Company
Charlotte, NC
610 Employees
On-site Workplace
Year Founded: 1967

What We Do

We are technologists, strategists, and creative minds dedicated to moving brands forward with work that delivers results. Our messaging, communications and design are driven by human insights and fresh ideas because starting a conversation is one thing, but building a lasting relationship is another.

Jobs at Similar Companies

Jobba Trade Technologies, Inc. Logo Jobba Trade Technologies, Inc.

Customer Success Specialist

Cloud • Information Technology • Productivity • Professional Services • Software
Hybrid
Chicago, IL, USA
45 Employees

Effectv Logo Effectv

Product Manager, Advertising Measurement Solutions

AdTech • Digital Media • Marketing Tech
Hybrid
Alpharetta, GA, USA
2157 Employees
Remote
New York, NY, USA
97K-141K Annually

Similar Companies Hiring

Effectv Thumbnail
Marketing Tech • Digital Media • AdTech
New York, NY
2157 Employees
RollWorks Thumbnail
Marketing Tech
US
Jobba Trade Technologies, Inc. Thumbnail
Software • Professional Services • Productivity • Information Technology • Cloud
Chicago, IL
45 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account