Analytics Engineer, What is it and What Do They Do

Posted on Aug 24, 2022
All are welcome to learn the skills through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.

 

Analytics Engineer, What is it and What Do They Do

Big congratulations to our alumni, Yu-han Chen, for joining The Estรฉe Lauder Companies Inc.ย Online as Senior Staff Analytics Engineer.

Quoted from Gitlab, "Analytics Engineersย sit at theย intersectionย of business teams,ย Data Analyticsย andย Data Engineeringย and are responsible for bringing robust, efficient, and integrated data models and products to life. Analytics Engineers speak the language of business teams and technical teams, able to translate data insights and analysis needs into models powered by theย Enterprise Data Platform. The successful Analytics Engineer is able to blend business acumen with technical expertise and transition between business strategy and data development.

As a team member responsible for helping to bridge the gap between business and technology, the Analytics Engineer role requires equal amounts business acumen and technical acumen.

  • Collaborate with team members to collect business requirements, define successful analytics outcomes, and design data models
  • Build trust in all interactions and withย Trusted Data Development
  • Serve as theย Directly Responsible Individualย for major sections of theย Enterprise Dimensional Model
  • Design, develop, and extendย dbtย code to extend the Enterprise Dimensional Model
  • Create and maintain architecture and systems documentation in theย Data Team Handbook
  • Maintain theย Data Catalog, a scalable resource to support Self-Service and Single-source-of-truth analytics
  • Document plans and results in either issue, MRs, theย handbook, or READMEs following the GitLab tradition ofย handbook first!
  • Implement theย DataOpsย philosophy in everything you do
  • Craft code that meets our internal standards for style, maintainability, and best practices (such as theย SQL Style Guide) for a high-scale database environment. Maintain and advocate for these standards through code review.
  • Approve data model changes as a Data Team Reviewer andย code ownerย for specific database and data model schemas
  • Provide data modeling expertise to all GitLab teams through code reviews, pairing, and training to help deliver optimal, DRY, and scalable database designs and queries in Snowflake and in Periscope.
  • Ability to use GitLab
  • Ability to thrive in a fully remote organization
  • Positive and solution-oriented mindset
  • Comfort working in a highly agile,ย intensely iterativeย environment
  • Self-motivated and self-managing, with task organizational skills
  • Great communication: Regularly achieveย consensusย amongst technical and business teams
  • Demonstrated capacity to clearly and concisely communicate complex business activities, technical requirements, and recommendations
  • Demonstrated experience with one or more of the following business subject areas: marketing, finance, sales, product, customer success, customer support, engineering, or people
  • 4+ years in the Data space as an analyst, engineer, or equivalent
  • 4+ years experience designing, implementing, operating, and extending commercial Kimball enterprise dimensional models
  • 4+ years working with a large-scale (1B+ Rows) Data Warehouse, preferably in a cloud environment
  • 2+ years experience building reports and dashboards in a data visualization tool
  • 1+ years creating project plans to identify tasks, milestones, and deliverables

The Analytics Engineer reports to theย Manager, Data.

The Analytics Engineer is aย grade 6.

  • The Analytics Engineer Responsibilites are listed above.
  • The Analytics Engineer Requirements are listed above.

The Senior Analytics Engineer reports to theย Manager, Data.

The Senior Analytics Engineer is aย grade 7.

Responsibilites for the Senior Analytics Engineer extend the Analytics Engineer (Intermediate) job. In addition:

  • Own one or more stakeholder relationship in Go To Market, Research & Development, or General & Administrative business functions
  • Serve as Data Model subject matter expert and data model spokesperson, demonstrated by the ability to address questions quickly and accurately
  • Advocate for theย Data Quality Programย andย Trusted Dataย to help ensure all data is profiled, reviewed, and accurate to support critical decisions
  • Guideย Work Breakdownย Sessions
  • Organize and Plan quarter-long development initiatives per theย Data Team Planning Drumbeat

Requirements for the Senior Analytics Engineer extend the Analytics Engineer (Intermediate) job. In addition:

  • 6+ years in the Data space as an analyst, engineer, scientist, or equivalent
  • 2+ years managing the same data model system over time, evolving the model to meet new business requirements
  • Demonstrated experience leading 4 or more analytics projects from beginning to operationalization
  • Demonstrated experience desinging and socializing Entity Relationship Diagrams and reference SQL scripts to scale data acumen and adoption
  • Experience working with multiple commercial data warehouses, ETL tools, and data visualization tools
  • Extenstive experience in 2 or more major data subject areas (marketing, sales, finance, product, people, etc.)

The Staff Analytics Engineer reports to theย Manager, Data.

The Staff Analytics Engineer is aย grade 8.

Market Justification:ย From a survey data perspective 98 companies have this role with an average of 3 employee incumbents in all industries. In tech there are 33 companies reporting an average of 2 employee incumbents. The business justification for Analytics Engineer Staff and Principal job grades is to retain and develop deep technical talent by establishing Individual Contributor focused career paths for our team members who do not want to move intoย Data People Management.

Despite residing in the Finance Division, all Data job families are deeply technical in nature and require knowledge of databases, SQL, and modeling. Education in a technical field, typically Computer Science, Mathematics, Management Information Systems, or Data Analytics is typical for individuals in Data careers.

At GitLab, the Analytics Engineer role is critical to support the growing Data Program because it helps glue together the business-facing Data Analyst roles with the technology-focused Data Engineering roles by creating data solutions for both roles. The Analytics Engineer is a specialized in dbt, which GitLab has chosen as the standard for developing Trusted Data Models.

Responsibilites for the Staff Analytics Engineer extend the Senior Analytics Engineer job. In addition:

  • Help promote data innovation across GitLab with a willingness to experiment and to confront hard and complex problems
  • Identify and resolve impediments to efficiency and enable the entire Data Program to iterate faster
  • Review and improve the data system as a whole, inclusive of data model designs, process flows, and end use cases
  • Research new data engineering and analytics methodologies with minimal guidance and support from other team members
  • Regularly participate in the Data Community/Industry outside of GitLab through writing, speaking, and/or networking
  • Organize and Plan multi-quarter initiatives and develop theย Enterprise Model Roadmap
  • Help create a sense of psychological safety in the department

Requirements for the Staff Analytics Engineer extend the Senior Analytics Engineer job. In addition:

  • Demonstrated experience leading 2 or more multi-department analytics projects from inception to operationalization
  • Demonstrated proficiency with data system design, including databases, schema, marts, aggregates, and views
  • Experience introducing a new tool or technique to a multi-person team, leading to measurable productivity improvement
  • Experience with data access and security techniques, both inside and outside of a data warehouse
  • Experience creating data pipelines in support of near real-time event stream processing
  • Presented multi-quarter development roadmaps to non-technical audiences

Specializations within the Staff Analytics Engineer extend the Senior Analytics Engineer job:

  • Staff Analytics Engineer, Data Architect:
    • Sets data architecture principles, standards and guidelines
    • Continuously reviews current data modelling principles and initiate any improvements to enable the implementation of the intended architecture
    • Creates an inventory of the data and tools needed to implement a scalable data architecture.
  • Staff Analytics Engineer, Technical Lead:
    • Sets the technical direction for data and cross-functional projects
    • Coordinates the technical effort during design and development and resolves technical disagreements
    • Manages the technical quality of team deliverables

The Principal Analytics Engineer reports to theย Manager, Dataย orย Director, Data & Analytics.

The Principal Analytics Engineer is aย grade 9.

Market Justification:ย While there is limited supporting survey data for a grade 9, the same market justification for a Staff Analytics Engineer holds true for a Principal Analytics Engineer. In addition, Analytics Engineering is a relatively new job family in the Data space and is not as mature as the well-established Data Analysis, Data Engineering, and Data Scientist job families. Despite this, the Analytics Engineering job family is growing quickly and there are reasonable analysis to support the addition of new job grades:

  • From a survey data perspective 11 companies have this role with an average of 1 employee incumbent in all industries.
  • a LinkedIn search on 2021-08-16 identified 3 Principal Analytics Engineers within the tech sector.
  • Companies which support the Analytics Engineer job family include: Netifly, Miro, Spotify, Netflix, Frame.io, Slalom, Pluralsight, and dbt.

Responsibilites for the Principal Analytics Engineer extend the Staff Analytics Engineer job. In addition:

  • Lead major strategic data projects and initiatives, spanning 6 months or more
  • Interface with Senior leadership to design, plan, and implement strategic data projects
  • Willingness to experiment and to confront the hardest or most complex problems
  • Attain a measurable positive impact on the performance of multiple team members and teams
  • Regularly participates in the Data Community/Industry outside of GitLab through writing, speaking, and networking
  • Provide mentorship to help team members grow their technical and business capabilities

Requirements for the Principal Analytics Engineer extend the Staff Analytics Engineer job. In addition:

  • Demonstrated experience leading an analytics initiative that significantly improved business performance, acknowledeged by executive staff
  • Ability to work productively as a Contributor in any Data Job, including Data Analysis, Data Engineering, and Data Science
  • Experience with data access and security techniques, both inside and outside of a data warehouse
  • Experience creating data pipelines in support of near real-time event stream processing
  • Recognized in the industry as a result of publications, seminars, presentations, or equivalent
  • Dimensional Model MRs Per Milestone
  • Handbook Update Frequency
  • % of Data Warehouse queries supported by Enterprise Dimensional Model >= 75%

We are evaluating the addition of levels beyond the Senior level. Currently, beyond the Senior Analytics Engineer level the next step is to move to the Manager, Data job family. "

 

Based on Google search result,ย  ย "Senior Analytics Engineer

The Estรฉe Lauder Companies Inc.

Full-time

Job highlights
Identified by Google from the original job post
Qualifications
โ€ข
You are an effective communicator capable of independently driving issues to resolution and communicating insights to non-technical audiences
โ€ข
1+ years of experience (may be substituted with a graduate degree) in Analytics, Data Science, or Software Engineering, including expertise with descriptive statistical analysis and data transformation
โ€ข
Experience with analytics software such as Looker, PowerBI, Tableau, or Apache Superset
โ€ข
Track record of delivering data-driven products and insights
โ€ข
Experience working with large-scale cloud database systems (e.g., BigQuery)
โ€ข
Experience in analyzing, validating, and transforming large datasets
โ€ข
Proficiency in deploying data-intensive solutions
โ€ข
Familiarity with the software development lifecycle
โ€ข
Ability to effectively and concisely communicate technical concepts
โ€ข
Hands-on experience in crafting compelling data visualizations to inform business decisions
โ€ข
Comfortable working with ambiguous and dynamic business requirements
โ€ข
Demonstrated ability to implement analytical and/or algorithmic solutions tailored to particular business needs and tested on large data sets
Responsibilities
โ€ข
As an Analytics Engineer at ELC Online, you will be responsible for transforming complex datasets into actionable insights
โ€ข
Your primary role will be to develop, support, and continually improve reporting and analytics assets in platforms such as Looker, Data Studio and Power BI
โ€ข
You will write efficient, clear code as well as accurate, rigorous technical documents to ensure deliverables meet customer needs and team goals
โ€ข
You will collaborate with an interdisciplinary team of engineers, scientists, and product managers to translate business and functional requirements into concrete deliverables, including the design, development, testing, and deployment of scalable solutions
โ€ข
You will bring engineering maturity and structure to ambiguous business problems and address the challenges of product creation, development, and improvement with an appreciation for the behaviors and needs of our consumers
โ€ข
You will partner with analysts to create compelling data visualizations and dashboards
โ€ข
You will acquire data by building the necessary queries and pipelines
โ€ข
You will automate data transformation, validation, monitoring, and alerting, with emphasis on maintainability, robustness, and scalability
โ€ข
You will develop ETL/ELT processes that comply with the computational demands, accuracy, and reliability of the relevant processes at various stages of production
โ€ข
Develop scalable systems to expand reporting capabilities, facilitate ad hoc analysis, and improve data-driven decision-making at all levels of the business
โ€ข
Utilize code (SQL, python, etc.) and apply engineering, reporting, and visualization expertise to solve business reporting problems
โ€ข
Develop scalable tools to drive automation and optimize business operations
โ€ข
Work with large, complex data sets
โ€ข
Solve difficult data transformation problems with efficiency, applying advanced analytical methods as needed
โ€ข
Conduct analysis that includes data gathering and requirements specification, processing, analysis, ongoing deliverables, and presentations
โ€ข
Build analysis and reporting pipelines iteratively to provide insights at scale
โ€ข
Develop comprehensive knowledge of ELC data structures and metrics, advocating for changes where needed for product development
โ€ข
Maintain standards for writing clean, organized code and documentation to streamline data and analytics workflow
โ€ข
Provide subject matter expertise and mentorship for junior analytics professionals to deliver data-driven solutions in support of established roadmaps
โ€ข
Drive and promote a culture of testing, observability, and scalability with a data-driven mindset and measurable approach
โ€ข
Manage and continuously improve business userโ€™s experience with data and reporting, including KPI development, data visualization, and communication of applicable insights to audiences at varying levels of technical sophistication
โ€ข
Develop partnerships with engineering, data science, and product teams to deliver on cross-functional reporting, measurement, and testing efforts
โ€ข
Solve analytical problems, and effectively communicate methodologies and results both verbally and in writing
โ€ข
Actively participate in ELCโ€™s diversity and inclusion agenda
โ€ข
Act as a champion for inclusivity and the identification of bias in everything we do
Benefits
โ€ข
Shift 1st (Day) Shift

Full description

Position Summary As an Analytics Engineer at ELC Online, you will be responsible for transforming complex datasets into actionable insights. Your primary role will be to develop, support, and continually improve reporting and analytics assets in platforms such as Looker, Data Studio and Power BI. You will write efficient, clear code as well as accurate, rigorous technical documents to ensure deliverables meet customer needs and team goals.
You will collaborate with an interdisciplinary team of engineers, scientists, and product managers to translate business and functional requirements into concrete deliverables, including the design, development, testing, and deployment of scalable solutions. You will bring engineering maturity and structure to ambiguous business problems and address the challenges of product creation, development, and improvement with an appreciation for the behaviors and needs of our consumers.
You will partner with analysts to create compelling data visualizations and dashboards. You will acquire data by building the necessary queries and pipelines. You will automate data transformation, validation, monitoring, and alerting, with emphasis on maintainability, robustness, and scalability.

ETL/ELT

You will develop ETL/ELT processes that comply with the computational demands, accuracy, and reliability of the relevant processes at various stages of production. You are an effective communicator capable of independently driving issues to resolution and communicating insights to non-technical audiences. You tackle intrinsically difficult problems; you are interested in learning and will acquire skills and expertise as needed.

Responsibilities

โ€ข Develop scalable systems to expand reporting capabilities, facilitate ad hoc analysis, and improve data-driven decision-making at all levels of the business
โ€ข Utilize code (SQL, python, etc.) and apply engineering, reporting, and visualization expertise to solve business reporting problems. Develop scalable tools to drive automation and optimize business operations.
โ€ข Work with large, complex data sets. Solve difficult data transformation problems with efficiency, applying advanced analytical methods as needed. Conduct analysis that includes data gathering and requirements specification, processing, analysis, ongoing deliverables, and presentations โ€ข Build analysis and reporting pipelines iteratively to provide insights at scale. Develop comprehensive knowledge of ELC data structures and metrics, advocating for changes where needed for product development
โ€ข Maintain standards for writing clean, organized code and documentation to streamline data and analytics workflow. โ€ข Provide subject matter expertise and mentorship for junior analytics professionals to deliver data-driven solutions in support of established roadmaps.
โ€ข Drive and promote a culture of testing, observability, and scalability with a data-driven mindset and measurable approach.
โ€ข Manage and continuously improve business userโ€™s experience with data and reporting, including KPI development, data visualization, and communication of applicable insights to audiences at varying levels of technical sophistication.
โ€ข Develop partnerships with engineering, data science, and product teams to deliver on cross-functional reporting, measurement, and testing efforts.
โ€ข Solve analytical problems, and effectively communicate methodologies and results both verbally and in writing
โ€ข Actively participate in ELCโ€™s diversity and inclusion agenda. Act as a champion for inclusivity and the identification of bias in everything we do.

Requirements
Qualifications

โ€ข A plus if Masters degree in a quantitative discipline (e.g., Statistics, Operations Research, Bioinformatics, Economics, Computational Biology, Computer Science, Mathematics, Physics, Engineering) or equivalent practical experience.
โ€ข 1+ years of experience (may be substituted with a graduate degree) in Analytics, Data Science, or Software Engineering, including expertise with descriptive statistical analysis and data transformation
โ€ข Experience with analytics software such as Looker, PowerBI, Tableau, or Apache Superset
โ€ข 1+ yearsโ€™ experience with database languages (SQL, etc...). Experience with data scripting languages or statistical/mathematical software (Python, R, Matlab, etc.) is a plus โ€ข Track record of delivering data-driven products and insights.
โ€ข Experience working with large-scale cloud database systems (e.g., BigQuery)
โ€ข Experience in analyzing, validating, and transforming large datasets.
โ€ข Proficiency in deploying data-intensive solutions. Familiarity with the software development lifecycle. โ€ข Ability to effectively and concisely communicate technical concepts
โ€ข Hands-on experience in crafting compelling data visualizations to inform business decisions
โ€ข Comfortable working with ambiguous and dynamic business requirements
โ€ข Demonstrated ability to implement analytical and/or algorithmic solutions tailored to particular business needs and tested on large data sets

Job Online / E-Commerce

Primary Location US-NY-New York Job
Type Standard
Schedule Full-time
Shift 1st (Day) Shift
Job Number 222006
We are an equal opportunity employer. Minorities, women, veterans, and individuals with disabilities are encouraged to apply. It is Company's policy not to discriminate against any employee or applicant for employment on the basis of race, color, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth and related medical conditions), gender identity or gender expression (including transgender status), sexual orientation, marital status, military service and veteran status, physical or mental disability,
protected medical condition as defined by applicable state or local law, genetic information, or any other characteristic protected by applicable federal, state, or local laws and ordinances. The Company will endeavor to provide a reasonable accommodation consistent with the law to otherwise qualified employees and prospective employees with a disability and to employees and prospective employees with needs related to their religious observance or practices.
Should you wish to apply for this position or any other position with the Company and you believe you require assistance to complete an application or participate in an interview, please contact [email protected]"

We also cross-referenced Udemy's opening of Senior Staff Analytics Engineer ( Analytics Engineering) .

About the Role

We are looking for an experienced analytics engineer to join our data team and push us towards a world with cleaner, more efficient data. You will be partnering with our data scientists and business stakeholders to understand our business and ensure that the data is ready for analysis and decision making.
Responsibilities

  • Contribute high quality, documented, tested, and cleanly modeled data to our data warehouse.
  • Help define and improve upon our analytics engineering standards through internal documentation and helpful peer reviews.
  • Collaborate with data scientists, product managers, marketers and other data-driven internal stakeholders to identify opportunities for better data access and usage
  • Develop and maintain data definitions for internally available data sources

Qualifications

  • 6-8 years of experience working in the analytics field as a full-stack data analyst
  • Excellent SQL skills with experience building tables in a production environment
  • Knowledge in ETL performance tuning / query optimization
  • Experience using git and command line within your data development
  • Experience with data processing frameworks and tools such as Redshift, Hadoop, Hive, Spark, and Kafka
  • Self-driven, highly motivated and able to learn quickly
  • Strong communication skills to partner with and understand the needs of every data-consuming team in the company

In the first 30 days, you will...

  • Partner with a teammate on their triage rotations
  • Contribute to the code base by making updates to existing SQL pipelines
  • Start working with all parts of our BI stack

In the first 60 days, you will...

  • Handle your triage rotation without support from teammate
  • Start to influence how the rest of the Business Intelligence team works
  • Lead Decision Science office hours session
  • Provide feedback on the team's onboarding processes based on your experience

In the first 90 days, you will...

  • Work directly with a business stakeholder/data scientist to improve their ability to make decisions using data
  • Build out a new data model from raw data ingestion through self-serve Looker model
  • Be able to onboard new team members to the Business Intelligence team"

About Author

Leave a Comment

No comments found.

View Posts by Categories


Our Recent Popular Posts


View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI