ANALYTICS ENGINEER SKILLS, EXPERIENCE, AND JOB REQUIREMENTS

Updated: July 29, 2024 - An Analytics Engineer requires a diverse skill set encompassing knowledge of power systems phenomena and mathematical models, proficiency in programming languages like C/C++, and experience with BI tools such as Looker or Tableau. Strong communication and collaboration skills are essential for effective teamwork, while exceptional coding abilities in SQL and LookML enable the design of robust solutions for processing and analyzing large datasets. Previous exposure to software testing, data warehousing, and ETL pipelines enhances the engineer's analytical capabilities for handling complex data analytics tasks.

Summary of Analytics Engineer Knowledge and Qualifications on Resume

1. BA in Statistics with 5 years of Experience

  • Experience developing business intelligence reporting solutions.
  • Experience applying data analytical techniques within an organization.
  • Experience with MicroStrategy, Architect, Dossier, iCubes, Documents, and Mobile
  • Experience with MicroStrategy Administration, MicroStrategy 2019+
  • Strong relational database knowledge (ERD), and SQL skills, Oracle Exadata
  • Experience with statistical tools, such as R or SAS 
  • Experience with cloud-based solutions 
  • Proficiency in core Microsoft Office applications
  • Strong knowledge of information visualization best practices and strategies
  • Excellent record in process ownership and development
  • Effective and clear communication skills with customers
  • People and results-oriented, detail-oriented
  • Experience working with several levels within an organization, from frontline up to senior management

2. BA in Economics with 2 years of Experience

  • Experience in Metrics, Reporting and Analysis
  • Continuous Improvement, Business Process Improvement, Process Engineering.
  • Relevant knowledge and experience in Quality Assurance, Process Audit, Documented Information Management, Quality Management System (ISO 9001), Lean Methodology, Six Sigma
  • Advanced knowledge in usage of MS Excel, Access, SQL, Tableau
  • Knowledge of basic to intermediate statistics, statistical process control, and quality management theories
  • Strong knowledge of project management
  • Strong knowledge of process mapping, value chain mapping, value stream mapping, and documentation
  • Knowledge of quality tools and techniques (TQM, ISO 9001, CMMI, Six Sigma or similar)
  • Demonstrated systems and process knowledge, able to conduct process audits
  • Strong analytical and reasoning skills
  • Strong communication skills (oral and written)
  • Strong meeting facilitation and presentation skills
  • Demonstrated experience in managing process and/or systems change

3. BA in Mathematics with 3 years of Experience

  • Self-motivated individual with strong problem-solving skills
  • Comfortable and adaptable in a fast-paced and informal environment
  • Excellent verbal and written communication skills with the ability to interact at all levels of the organization
  • Detail-oriented, analytical, methodical
  • Creative thinker committed to driving quality forward
  • Passionate about data and what we can extract from it
  • Strong interest in functional programming
  • Familiar with distributed systems (sharding, lambda arch., streaming arch., etc.)
  • Experience with big data (Bigquery, Cassandra, HBase, Hadoop, Redshift, etc.)
  • Excellent grasp of statistics
  • Comfortable working in a distributed team
  • Experience with distributed streaming architecture
  • Experience building analytics systems, working with Clojure
  • Experience dealing with Apache Kafka, working with Google BigQuery

4. BS in Computer Science with 2 years of Experience

  • Working with a data warehouse/BI tool (Snowflake experience)
  • Experience with self-service BI tools (e.g. Tableau, Looker or Domo)
  • SQL data modeling (debt experience)
  • Curiosity and creative problem-solving skills
  • An experienced full-stack  analyst (a.k.a. analytics engineer), with experience in data science, data analysis, data engineering, or a relevant analytical/quantitative field
  • Advanced SQL skills, experience with Python and/or R 
  • Experience with Snowflake, Stitch, and Looker (or similar tools) 
  • Knowledge of data warehousing best practices
  • Excellent communication skills - being someone who values building relationships with colleagues and enjoys explaining complex topics in simple terms
  • Highly motivated to work autonomously with strong organizational and time management skills
  • Exposure to Airflow and/or DAGs in general
  • Progressive experience in any related occupation performing analysis of data and data modeling using the AWS Suite, SQL, Python, and Excel

5. BS in Data Science with 4 years of Experience

  • A good technical background and professional skills are achieved, in time, by involvement in the team activities and by training.
  • Knowledge of the power systems phenomena and processes and related mathematical models (power flow, state estimator, short-circuit analysis, contingency analyst, voltage control, load-frequency control, power systems optimal regimes, load forecast, stability analysis, transient analysis, modeling of equipment and of automation and protection systems in power plants and power grids, models for the energy market)
  • Real-time systems, C / C ++ programmer skills, or similar.
  • Familiarity or development experience on Windows OS or UNIX OS.
  • Experience in software testing.
  • Great communication and collaboration skills.
  • Previous experience with Looker (or other BI tools such as Tableau, PowerBI, Mode, or Metabase)
  • Exceptional coding and design skills, particularly in SQL and LookML.
  • Previous experience of working with large data volumes, including processing, transforming, and transporting large-scale datasets for analytics and business purposes.
  • Previous experience in data warehousing and ETL pipelines, revenue data experience.

6. BS in Information Technology with 2 years of Experience

  • Have demonstrated excellence in analytical skills
  • Experience with any data analysis tools
  • Be a self-starter with strong technical leadership, analytical skills, and the ability to perform complex assignments with team members
  • Have the ability to communicate technical information effectively with team members and process partners
  • Have good planning and organizing skills
  • Have strong English and Spanish language and writing skills
  • Experience using SQL, Python, and Tableau tools for analysis and visualization of data
  • Experience in machine control development
  • Have on-machine or lab data collection and analysis experience
  • Desire to learn new data science tools and techniques
  • Experience working on upper or lower drivetrain components (transmissions, torque converters, axles, etc.) or engines
  • Ability to work effectively across language and cultural barriers