OneMagnify
Senior Data Analyst-2
OneMagnify, Michigan Center, Michigan, United States, 49254
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 situationsCollaboration and Teamwork: works with others to deliver results, contributing to the team and prioritizing group needs over individual needsProblem Solving: uses an organized and logical approach to find solutions to complex problems. Looks beyond the obvious to uncover the root cause of problemsOpen Communication: clearly conveys thoughts, both written and verbally, listening attentively and asking questions for clarification and understandingWhat 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.
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 situationsCollaboration and Teamwork: works with others to deliver results, contributing to the team and prioritizing group needs over individual needsProblem Solving: uses an organized and logical approach to find solutions to complex problems. Looks beyond the obvious to uncover the root cause of problemsOpen Communication: clearly conveys thoughts, both written and verbally, listening attentively and asking questions for clarification and understandingWhat 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.