Business Intelligence Engineer (Must have CPG industry/ Circana exp.)

BI engineer that will 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. This individual will 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.
• Collaboration with the administrative tenant side of Power BI.

Education and Training Experiences

• 2-4 years of experience as Business Intelligence 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
• Must have CPG Industry knowledge worked with Circana Unify 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) is a plus.
• Experience using Copilot for analytics, research, proofing etc is a plus.
• Experience with Graphic design concepts and UI/UX fundamentals is a plus.

Travel up to 5% for this position.

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

The Company is one of North America's leading sales and marketing agencies specializing in outsourced sales, merchandising, category management, and marketing services to manufacturers, suppliers, and producers of food products and consumer packaged goods. The Company services a variety of trade channels including grocery, mass merchandise, specialty, convenience, drug, dollar, club, hardware, consumer electronics, and home centers. We bridge the gap between manufacturers and retailers, providing consumers access to the best products available in the marketplace today.

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
• Documents designs and writes code that is clear, concise, tested, and easily understood by others. Designs abstract interfaces and constructs modular libraries that are well-tested and bug-free.
• 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 code.
• 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 ADV engineering standards and development best practices
• Learns, understands, and considers the importance of non-functional requirements. Regularly refactors code to improve error handling, security, testability, and maintainability.
• 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.

Education and Training Expreinces

• 3-6 years of experience as software engineers.
• Foundations of engineering, programming, software development
• Foundations of data structures, algorithms, operating systems, networks, languages
• Foundations of concurrent and event-based development.
• Foundations of development and test frameworks
• BSCS...Engineering degrees etc etc...and (optional) MS

Travel up to 5% for this position.

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

Environmental & Physical Requirements

Office / Sedentary Requirements: Incumbent must be able to perform the essential functions of the job. Work is performed primarily in an office environment. Typically, requires the ability to sit for extended periods of time (66%+ each day), ability to hear telephone, ability to enter data on a computer and may require the ability to lift up to 10lbs.

Additional Information Regarding Job Duties and Job Descriptions

Job duties include additional responsibilities as assigned by one's supervisor or other manager related to the position/department. This job description is meant to describe the general nature and level of work being performed; it is not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required for the position. The Company reserves the right at any time with or without notice to alter or change job responsibilities, reassign or transfer job positions, or assign additional job responsibilities, subject to applicable law. The Company shall provide reasonable accommodations of known disabilities to enable a qualified applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by the law.

The above statements are intended to describe the general nature and level of work being performed by people assigned to this position. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of associates so classified.

The Company is committed to providing equal opportunity in all employment practices without regard to age, race, color, national origin, sex, sexual orientation, religion, physical or mental disability, or any other category protected by law. As part of this commitment, the Company shall provide reasonable accommodations of known disabilities to enable an applicant or employee to apply for employment, perform the essential functions of the job, or enjoy the benefits and privileges of employment as required by law.