Business Intelligence Developer
Peoria, IL
Job Description :
The Business Intelligence Developer will be responsible for analyzing business problems and designing analytical reports using data from various data sources to provide insights to decision makers. This position will report to Digital product manager and will work with enterprise teams to deliver analytic solutions.
Job Duties :
- Work with business partners to understand business requirements and translate them into functional specifications for reporting applications
- Utilize programming languages like SAS, Snow SQL to prepare data using ETL (Extract, Transform, Load) framework for building reports
- Build automated reports using Power BI
- Implement Row-level security (RLS) and write DAX expressions suitable for reporting needs
- Prototype, develop, iterate, test, and deploy reports into production
- Present project status and insights to Senior leaders and advisors
Basic Qualifications :
Bachelor's degree and 4 years of business insights and visualization experience, or a Master's degree & 2 years of business insights and visualization experienceStrong working knowledge and experience with Power BI, Power Query, DAX, SQL, Power BI Gateway and administrative tasksExperience performing data analysis, data modeling and database development in support of BI projectsExperience with one or more programming languages and data structures using SQLExperience with Snowflake cloud data warehouse and SnowSQLHighly organized and strong attention to delivering high quality workExcellent verbal and written communication skills for coordinating across teamsPosition's Contributions to Work Group :
The job function includes data collection and analysis; development, validation, application, and refinement of statistical models; application of related digital technologies in processing both the inputs and outputs from the modelsChallenges include meeting expectations in delivering results, learning to refine solutions to better fit complex situations, making timely decisions, and communicating effectively with all project stakeholders.Working directly with business partners to understand their information needs and create reporting solutions that ultimately help drive business decisionsMatching and developing the correct reporting technology such as Power BIWorking with other application support groups on the integration and rationalization of disparate data sourcesPrototyping, developing, and testing of reporting solutions producedDesigning and implementing processes, standards, or improvements, to aid in development and supportTypical task breakdown :
Work with business partners to understand business requirements and translate them into functional specifications for reporting applicationsUtilize programming languages like SAS, Snow SQL to prepare data using ETL (Extract, Transform, Load) framework for building reportsBuild automated reports using Power BIImplement Row-level security (RLS) and write DAX expressions suitable for reporting needsPrototype, develop, iterate, test, and deploy reports into productionPresent project status and insights to Senior leaders and advisorsEducation & Experience Required :
Bachelor's degree and 4 years of business insights and visualization experience, or a Master's degree & 2 years of business insights and visualization experienceTechnical Skills
Required)
Expert level Power BI, SQL and coding skills to perform ETL functions using industry standard coding languageSnowflake experienceMS Office ToolsuiteDesired)
SharepointPowerApps, PowerFlowSoft Skills
Required)
Strong communication and collaboration skillsStrong project management skillsStrong experience delivering high quality workDemonstrated decisions on routine, limited risk issues.Strong concern for customers and a basic knowledge of product, processes, and servicesDemonstrate strong initiative to research and apply new methods to exceed customer expectationsDemonstrated strong problem solving and technical skillsBusiness partner process understanding and the ability to translate business requirementsRequired Skills : Power BI, SQL, ETL
Basic Qualification :
Additional Skills :
Background Check : Yes
Drug Screen : Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee : No
Exclusive to Apex : No
Face to face interview required : No
Candidate must be local : No
Candidate must be authorized to work without sponsorship : : No
Interview times set : : No
Type of project : Other Project Type
Master Job Title : Misc : Non-Technical
Branch Code : Bloomington
