Michigan State University
Data Modeler/Report Writer / Information Technologist II
Michigan State University, East Lansing, Michigan, United States, 48823
Data Modeler/Report Writer / Information Technologist II
Job no:
997177Work type:
Support StaffPay Grade:
13Major Administrative Unit / College:
Information Technology ServicesDepartment:
Msu It Office Of The Acio 40000401Sub Area:
AP- ProfessionalsSalary:
Salary Commensurate with ExperienceLocation:
East LansingCategories:
Information Technology, Administrative Professionals- AP, Full Time (90-100%), Union, Remote-Friendly
Working/Functional Title
Data Modeler/Report Writer
Position Summary
This position is an experienced Data Modeler/Report Writer specializing in Power BI to design and maintain data models, reports, and dashboards for Infrastructure, Planning and Facilities. The role will involve collaborating with teams to ensure data is optimized, accurate, and effectively visualized as well as translate complex data into understandable and actionable information.
Data Modeling - 30%:
- Design, develop, and optimize efficient data models in Power BI using Power Query and DAX.
- Ensure data models meet performance requirements and adhere to best practices in data architecture.
- Maintain consistency, accuracy, and reliability in all data models.
Report/Dashboard Development - 30%:
- Create user-friendly, interactive reports and dashboards in Power BI based on business requirements.
- Collaborate with business stakeholders to gather reporting needs and translate them into functional outputs.
- Implement advanced visualizations, calculations, and KPIs to enhance report usability.
Data Analysis and Insights - 20%:
- Conduct in-depth data analysis to identify trends and provide actionable insights.
- Deliver ad-hoc reports and analysis to support various business initiatives and operational strategies.
- Present data-driven recommendations to improve decision-making processes.
Data Governance and Quality Control - 10%:
- Implement data governance practices to ensure data accuracy, integrity, and compliance.
- Regularly audit reports and data models for errors, inconsistencies, and performance issues.
- Collaborate with data and IT teams to troubleshoot and resolve data quality issues.
Documentation and Training - 10%:
- Document all Power BI solutions, data models, and reporting processes.
- Provide training and guidance to end-users on how to utilize reports and interpret data effectively.
- Continuously update documentation based on changing business needs and new Power BI features.
Michigan State University (MSU) is a top 100 global university located in East Lansing, three miles east of the state's capitol. The MSU community includes more than 12,000 faculty, academic and support staff, as well as over 51,000 students. MSU offers an extensive benefits package to its employees including health care, prescription, and dental coverage, and a base retirement program with a University matching contribution, as well as basic life insurance. In addition, MSU offers educational benefits including a course fee courtesy program and educational assistance.
MSU Information Technology provides the primary leadership for strategic, financial, and policy initiatives affecting information technology (IT) across MSU. MSU IT offers technology resources that support MSU's mission of providing education, conducting research, and advancing engagement.
Diversity, Equity and Inclusion (DEI) are essential elements, vital to the culture MSU Information Technology endeavors to cultivate. This includes providing opportunities and access for all people which incorporate differences of race, age, color, ethnicity, gender, sexual orientation, gender identity, gender expression, religion, national origin, migratory status, disability/abilities, political affiliation, veteran status and socioeconomic background.
Minimum Requirements
Knowledge equivalent to that which would be acquired by completing a four-year college degree program; three to five years of related work experience in an information technology area related to the duties to be performed; or an equivalent combination of education and experience
Desired Qualifications
Proficiency in Power Query, DAX, and other Power BI features; strong SQL skills and experience with database technologies like Azure, SQL Server or Oracle; experience with ETL processes and integrating data from various sources; familiarity with data warehousing and business intelligence (BI) best practices; familiarity with cloud platforms and API integrations; ability to communicate complex data concepts to non-technical stakeholders; excellent analytical and problem-solving skills
Equal Employment Opportunity Statement
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, age, disability or protected veteran status.
Required Application Materials
Resume and cover letter
Special Instructions
Three professional references knowledgeable of your work.
Work Hours
STANDARD 8-5
Website
https://tech.msu.edu
Remote Work Statement
MSU strives to provide a flexible work environment and this position has been designated as remote-friendly. Remote-friendly means some or all of the duties can be performed remotely as mutually agreed upon.
Bidding eligibility ends October 22, 2024 at 11:55 P.M.
Advertised:
Oct 16, 2024 Eastern Daylight TimeApplications close:
Oct 29, 2024 Eastern Daylight Time
Job no:
997177Work type:
Support StaffPay Grade:
13Major Administrative Unit / College:
Information Technology ServicesDepartment:
Msu It Office Of The Acio 40000401Sub Area:
AP- ProfessionalsSalary:
Salary Commensurate with ExperienceLocation:
East LansingCategories:
Information Technology, Administrative Professionals- AP, Full Time (90-100%), Union, Remote-Friendly
Working/Functional Title
Data Modeler/Report Writer
Position Summary
This position is an experienced Data Modeler/Report Writer specializing in Power BI to design and maintain data models, reports, and dashboards for Infrastructure, Planning and Facilities. The role will involve collaborating with teams to ensure data is optimized, accurate, and effectively visualized as well as translate complex data into understandable and actionable information.
Data Modeling - 30%:
- Design, develop, and optimize efficient data models in Power BI using Power Query and DAX.
- Ensure data models meet performance requirements and adhere to best practices in data architecture.
- Maintain consistency, accuracy, and reliability in all data models.
Report/Dashboard Development - 30%:
- Create user-friendly, interactive reports and dashboards in Power BI based on business requirements.
- Collaborate with business stakeholders to gather reporting needs and translate them into functional outputs.
- Implement advanced visualizations, calculations, and KPIs to enhance report usability.
Data Analysis and Insights - 20%:
- Conduct in-depth data analysis to identify trends and provide actionable insights.
- Deliver ad-hoc reports and analysis to support various business initiatives and operational strategies.
- Present data-driven recommendations to improve decision-making processes.
Data Governance and Quality Control - 10%:
- Implement data governance practices to ensure data accuracy, integrity, and compliance.
- Regularly audit reports and data models for errors, inconsistencies, and performance issues.
- Collaborate with data and IT teams to troubleshoot and resolve data quality issues.
Documentation and Training - 10%:
- Document all Power BI solutions, data models, and reporting processes.
- Provide training and guidance to end-users on how to utilize reports and interpret data effectively.
- Continuously update documentation based on changing business needs and new Power BI features.
Michigan State University (MSU) is a top 100 global university located in East Lansing, three miles east of the state's capitol. The MSU community includes more than 12,000 faculty, academic and support staff, as well as over 51,000 students. MSU offers an extensive benefits package to its employees including health care, prescription, and dental coverage, and a base retirement program with a University matching contribution, as well as basic life insurance. In addition, MSU offers educational benefits including a course fee courtesy program and educational assistance.
MSU Information Technology provides the primary leadership for strategic, financial, and policy initiatives affecting information technology (IT) across MSU. MSU IT offers technology resources that support MSU's mission of providing education, conducting research, and advancing engagement.
Diversity, Equity and Inclusion (DEI) are essential elements, vital to the culture MSU Information Technology endeavors to cultivate. This includes providing opportunities and access for all people which incorporate differences of race, age, color, ethnicity, gender, sexual orientation, gender identity, gender expression, religion, national origin, migratory status, disability/abilities, political affiliation, veteran status and socioeconomic background.
Minimum Requirements
Knowledge equivalent to that which would be acquired by completing a four-year college degree program; three to five years of related work experience in an information technology area related to the duties to be performed; or an equivalent combination of education and experience
Desired Qualifications
Proficiency in Power Query, DAX, and other Power BI features; strong SQL skills and experience with database technologies like Azure, SQL Server or Oracle; experience with ETL processes and integrating data from various sources; familiarity with data warehousing and business intelligence (BI) best practices; familiarity with cloud platforms and API integrations; ability to communicate complex data concepts to non-technical stakeholders; excellent analytical and problem-solving skills
Equal Employment Opportunity Statement
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, citizenship, age, disability or protected veteran status.
Required Application Materials
Resume and cover letter
Special Instructions
Three professional references knowledgeable of your work.
Work Hours
STANDARD 8-5
Website
https://tech.msu.edu
Remote Work Statement
MSU strives to provide a flexible work environment and this position has been designated as remote-friendly. Remote-friendly means some or all of the duties can be performed remotely as mutually agreed upon.
Bidding eligibility ends October 22, 2024 at 11:55 P.M.
Advertised:
Oct 16, 2024 Eastern Daylight TimeApplications close:
Oct 29, 2024 Eastern Daylight Time