What are the responsibilities and job description for the Data Engineer II position at Advantage Solutions?
Engineer II
Level II engineers, or mid-level software engineers, expand upon their foundational knowledge and develop an understanding of best practices for writing code and developing computer software. These people are familiar with multiple coding languages and are comfortable with software development tools. They can work independently and regularly assist level one or level two engineers with task-related or troubleshooting problems. Develops, ships, and maintains product features with guidance from their manager and senior engineers. Understands and makes well-reasoned design decisions on large or complex product features. The more seniors act as a multiplier on the team. Often prioritizes, and values, unowned or undesirable tasks that enable others to move faster.
Primary Responsibilities
Supervisory Responsibilities
Direct Reports: This position does not have supervisory responsibilities for direct reports
Indirect Reports: Does not have direct reports, but may delegate work of others and provide guidance, direction and mentoring to indirect reports
Job Will Remain Open Until Filled
Level II engineers, or mid-level software engineers, expand upon their foundational knowledge and develop an understanding of best practices for writing code and developing computer software. These people are familiar with multiple coding languages and are comfortable with software development tools. They can work independently and regularly assist level one or level two engineers with task-related or troubleshooting problems. Develops, ships, and maintains product features with guidance from their manager and senior engineers. Understands and makes well-reasoned design decisions on large or complex product features. The more seniors act as a multiplier on the team. Often prioritizes, and values, unowned or undesirable tasks that enable others to move faster.
Primary Responsibilities
- Responsible for the entire lifecycle of small-to-medium-sized projects: engineering design, development, testing, production, and subsequent fixes and improvements
- Capable of providing on-call support for features they or their team are responsible for
- Designs and builds dashboards that are clear, concise, tested, and easily understood by others.
- Regularly refactors code to improve error handling, testability, and maintainability
- Tracks issues and responds if an external contributor or partner raises a ticket/issue related to their Power BI dashboards.
- Improves the development experience for their team by enhancing development tools, test coverage, and/or code structure. Uses and understands systematic tools needed to debug and diagnose issues in a CI/CD pipeline.
- Contributes to code specifications and participates in small-scale code reviews
- Mastered understanding of all components of key features and architecture for one product, with a high-level understanding of several other products, integrations, and capabilities.
- Understands, advocates, and contributes engineering standards and development best practices
- Learns, understands, and considers the importance of non-functional requirements.
- Growing understanding of industry trends and development best practices and is comfortable writing code in an open-source setting.
- Identifies conflicting requirements across the company and flags them to their manager. Identifies risks in code, features, and design, and communicates these to their team to collaborate on solutions. Effectively communicates the impact and tradeoffs of multiple solutions when presenting solutions to problems. Finds solutions to unsolved, loosely-defined, highly-technical problems.
- Manage and maintain existing dashboards and semantic models as required
- Lead client meetings to gather and define business requirements, ensuring alignment with project goals and stakeholder expectations
- 3-6 years of experience as data analyst
- Experience using Databricks and writing Spark Sequel queries into various medallion layers
- Power BI Experience
- Intermediate DAX
- Basic knowledge of M code for Power BI Power Query ETL process
- Understanding of modeling concepts
- Experience connecting to various data sources
- Basic to Intermediate knowledge of analytical concepts
- CPG Industry knowledge working with Circana and /or NIQ data (Syndicated, Panel, Custom databases)
- Basic to Intermediate knowledge of SSMS and writing T-Sequel statements to query data (Joins, aggregates etc.)
- Experience with MS Teams
- Experience with Office 365 (Powerpoint, Excel, Outlook etc.)
- Strong communication skills
- Presentation skills
- Understanding of semantic models as it pertains to Power BI
- Understanding of Tabular models
- SSAS experience is a plus
- Basic to intermediate experience with Python (Pandas)
- Experience using Copilot chat for analytics, research, proofing etc.
- Experience with Graphic design concepts and user interface elements
Supervisory Responsibilities
Direct Reports: This position does not have supervisory responsibilities for direct reports
Indirect Reports: Does not have direct reports, but may delegate work of others and provide guidance, direction and mentoring to indirect reports
Job Will Remain Open Until Filled
Salary : $61,000 - $100,800
