Job SummaryTechnical Developer with a focus on report creation and ETL, this developer will be responsible for the development and maintenance of data sets and reports for the Business Intelligence program. This role is helping to keep the organization at the forefront of efficient data processing and artificial intelligence to enable and support data- driven decision making across the organization.
Duties and Responsibilities- Take in, design, and document business requirements in the context of BI and create data models to transform raw data into relevant insights
- Define key performance indicators (KPIs) with specific objectives and track them regularly
- Use Power BI to run Data Analysis Expression (DAX) queries and functions
- Manage the Extract, Load, Transform (ETL) processes and data pipelines
- Create, manage, and maintain data structures, views etc. needed by the business to support reporting and dashboard requirements
- Manage data set requests via standard request process, collaborating with Business Intelligence functional lead through the request cycling using Jira Service Desk and projects
- Manage data integration between various systems and services using Application Programing Interface (APIs) and custom scripting
- Troubleshoot issues in existing datasets, scripts, load errors etc.
- Develop report visualizations in enterprise reporting applications such as, S4HANA (Analysis for Office), and Power BI
- Prioritize requests and workload across multiple business units based on resource availability
- Partner with Business Intelligence Functional Lead to design and develop complex solutions, perform relational and dimensional data modeling and create reporting and visualizations that enable data driven decision making across the organization
- Other duties as deemed necessary.
Qualification RequirementsMinimum Education: • Bachelor's degree in Information Technology, Computer Science, Business Administration, or a related field
• Extensive experience may be considered in lieu of Four (4) year degree
Minimum Work Experience:- Hands-on experience required in one or more enterprise resource planning systems database (HANA and/or SQL) and specific Business Intelligence tools including
- Microsoft Azure Cloud (SQL)
- SAP HANA Database
- HANA Studios
- Microsoft Power BI
- Hands on development experience with relational Databases (MS SQL Server) as well as complex stored procedures using SQL
- Should be proficient in software development and understanding of the Microsoft BI Stack
- Analytical thinking for converting data into relevant reports and graphics
- Five (5) plus years working in a business environment (Consumer Products Group preferred)
License(s) / Certification(s):- Preferred Power BI Certifications
- Preferred Microsoft Azure Certifications
- Azure Data Factory
- Synapse/Databricks or other Data Intelligence Platform
Preferred Microsoft SQL Server Certifications
Knowledge, Skills and Abilities- Preferred experience with Consumer Products companies, sales, and manufacturing data
- Ability to interact with different levels of management
- Strong problem-solving, troubleshooting, and analytical skills
- Excellent Organizational skills in Microsoft Office 365
- Excellent analytical and decision-making skills
- Strong verbal and written communication skills
- Ability to understand functional business requirements
- Ability to quickly adapt to changes in both technology and business environments
- Must be able to operate independently
- Ability to manage and prioritize multiple assignments
- Ability to maintain regular and predictable attendance.
- Ability to work in a constant state of alertness.
- Ability to maintain regular and predictable attendance.
- Ability to work in a constant state of alertness.
Physical RequirementsRepresents the appropriate physical requirements of the job in the course of the work.
