What are the responsibilities and job description for the Business Intelligence Developer position at DSMH LLC?
Title: Business Intelligence Developer
Location: Peoria, IL
Duration: 12 Months
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 experience
· Strong working knowledge and experience with Power BI, Power Query, DAX, SQL, Power BI Gateway and administrative tasks
· Experience performing data analysis, data modeling and database development in support of BI projects
· Experience with one or more programming languages and data structures using SQL
· Experience with Snowflake cloud data warehouse and SnowSQL
· Highly organized and strong attention to delivering high quality work
· Excellent verbal and written communication skills for coordinating across teams
Technical Skills
(Required)
- Expert level Power BI, SQL and coding skills to perform ETL functions using industry standard coding language
- Snowflake experience
- MS Office Toolsuite
(Desired)
- Sharepoint
- PowerApps, PowerFlow
- SAS
Soft Skills
(Required)
- Strong communication and collaboration skills
- Strong project management skills
- Strong experience delivering high quality work
- Demonstrated decisions on routine, limited risk issues.
- Demonstrate strong initiative to research and apply new methods to exceed customer expectations
- Demonstrated strong problem solving and technical skills
- Business partner process understanding and the ability to translate business requirements
Job Type: Contract
Pay: $40.00 - $44.00 per hour
Experience level:
- 6 years
Schedule:
- Monday to Friday
Experience:
- Power BI: 4 years (Required)
- SQL: 4 years (Required)
- Snowflake: 4 years (Required)
- MS Office Toolsuite: 4 years (Required)
Work Location: In person
Salary : $40 - $44