Medical Organization for Latino Advancement ยท 2 months ago
BI Developer & Report Writer
North Chicago, IL, US
Full-time
Hybrid
Mid, Senior Level
$73K/yr - $83K/yr
5+ years expMedical Organization for Latino Advancement is seeking a BI Developer & Report Writer to join their Information Technology Services team. This role is responsible for developing, maintaining, and ensuring the accuracy of BI dashboards and institutional reports, while collaborating closely with various departments to support data-driven decision-making processes.
EducationNon ProfitTraining
Responsibilities
Develop, design, and maintain BI dashboards and institutional reports using tools such as Power BI, SSRS, or similar platforms for various departments, including Admissions, Registrar, Financial Aid, HR, Finance, Sponsored Research, and Student Affairs, ensuring data integrity and user-friendliness
Develop reports for academic departments as requested by IEDS
Provide data extracts from supported systems to IEDS for accreditation, state, and federal reporting
Automate recurring reports for operational and academic units as needed to improve efficiency and reduce manual effort
Ensure technical accuracy of data and availability of reports and dashboards
Serve as a custodian of the technical reporting infrastructure and metadata repository, focusing on data types, lengths, formats, constraints, and physical locations, to ensure data quality and accessibility
Translate business requirements received from IEDS and functional offices into clear and actionable technical specifications
Perform ETL processes to load data into reporting systems and the data lake
Proactively address impacts on reporting due to system upgrades, new modules, and backend integrations, with clear communication to stakeholders
Troubleshoot data, system, and reporting issues, recommending and implementing corrective actions as needed
Ensure the timely availability and secure distribution of standardized reports to operational, academic, and administrative units, with appropriate access controls
Ensure data integrity, consistency, and security in all reporting and data management processes
Partner with Institutional Effectiveness and Decision Support (IEDS) and Student Enrollment Management teams to develop standardized, validated data sets for institutional reporting
Participate in the formal report request process, collaborating with IEDS from intake to development
Mentor and guide junior report writers, including reviewing their work, providing technical and professional feedback, and supporting their continued development in BI tools and methodologies
Establish and promote standards and best practices for report design, visualization, and data governance
Participate in cross-functional project teams and contribute to continuous process improvement initiatives
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field
Minimum of 5+ years of experience in report writing, data warehousing, and Business Intelligence (BI) dashboard development
Proven expertise with Microsoft SQL Server Reporting Services (SSRS) for report creation and management
Strong proficiency in Power BI for dashboard development, data modeling, and visualization
Experience with ETL processes and tools
Familiarity with institutional data definitions and reporting standards in a higher education context to ensure compliance and accurate reporting
Experience with data governance principles and practices
Advanced SQL querying and scripting
Proficiency in database systems and data warehousing concepts
Experience designing dimensional models
Familiarity with version control for reports and dashboards
Excellent analytical and problem-solving skills
Strong SQL and data extraction skills
Strong communication and interpersonal skills, with the ability to effectively collaborate with both technical and non-technical stakeholders
Ability to work independently and as part of a team
Detail-oriented with a strong commitment to data accuracy and quality
Ability to organize, prioritize, and schedule work assignments
Strong documentation skills
Preferred
Knowledge of Ellucian Colleague data structures
Experience working in a Higher Education environment performing the duties shared above
Experience with other BI tools and data visualization platforms is a plus
Benefits
Medical, dental, and vision plans
Paid parental leave
Short term and long term disability plans
Life insurance
Flexible spending accounts
403(b) retirement plan which includes a 8% employer contribution after 2 years of service
3 weeks of vacation/ personal leave
15 sick days
9 paid holidays
Paid winter break
Two floating holidays
Company
Medical Organization for Latino Advancement
Medical Organization for Latino Advancement provides wellness, public health, education, and research programs.
11-50 employees
Funding
Current Stage
Early StageRecent News
2024-12-04
Company data provided by crunchbase