The SQL Data/Power BI Developer position will interface with internal business clients, technical leadership, and 3rd party vendors, and play a critical role in advising on technical direction and data solutions. The person will be responsible for work in all stages of the development lifecycle, from reviewing business requirements, to design, to development and test, to deployment. This is not strictly a technical role, nor is this need for just heads-down technical role, rather this role is as advisory and analytical as it is technical.
ESSENTIAL FUNCTIONS AND RESPONSIBILITIES
10+ years strong experience as a SQL Developer, MS Power BI Developer, or similar role
Excellent understanding of SQL Server, SQL programming, SSIS, SSRS, and SSAS
Able to write queries for application integrations between the ERP and third-party software
Strong experience with JetReports/or similar BI systems utilizing SSAS, cubes, etc.
Critical thinker and problem solver, experience with NAV ERP a plus, must have strong ERP experience
Team player with strong desire to assist in the professional development of technical skills and capabilities of the team
Developing Custom Power BI reports and dashboards to match stakeholder requirements
Exceptional customer service skills and professionalism interacting with all levels of the organization.
Ability to articulate and meet deadlines and prioritize. Ability to reprioritize as needs change in a dynamic, fast-moving CPG organization
Working with the IT Infrastructure team, maintains database integrity and documentation for all SQL servers and databases
Broad understanding with various database technologies
Works with leadership in selecting methods, techniques and evaluation criteria for obtaining results
Ensure data consistency, integrity, “single-source of the truth”, etc.
End-user training in understanding and consumption of data, reporting cadence, etc.
REQUIRED KNOWLEDGE, SKILLS, AND ABILITIES
These requirements are representative, but not all-inclusive, of the knowledge, skill, and ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Must be able to communicate effectively at all levels of an organization in both written and oral forms and at varying degrees of detail. This includes writing reports, presenting findings, and facilitating group sessions
Strong business acumen. Ability to identify business needs, expectations, and requirements for technology-based solutions in the areas being supported
Knowledge and experience with Dashboard and Visualization best practices
Must possess exceptional analytical and conceptual thinking skills
Demonstrated skills regarding influence, persuasion, communication, and change management.
Competency in Microsoft Office applications and MS Project is required
Requires a good sense of humor and belief in working as a professional cohesive team member
EDUCATION AND EXPERIENCE
Minimum of a bachelor’s degree required
Must have functional understanding of business processes and detailed knowledge of systems and applications
Must demonstrate keen problem-solving skills, ability to deal with complex situations and recommend a course of action in addition to analyzing and interpreting data to arrive at business solutions
Experience in designing mock ups, writing test scripts, and data modeling is required
Experience in CPG, Supply Chain, Software implementations a plus