Data Warehouse And Reporting Analyst/Developer

Apply now to join FAU on its race to excellence.
For more information on everything FAU has to offer, please visit www.fau.edu/jobs.
Position Summary:
The Department of OIT: Data and Reporting Services at Florida Atlantic University seeks applicants who are committed to supporting the learning needs of students from diverse backgrounds and to engaging communities underrepresented in higher education. Florida Atlantic University is committed to providing an inclusive and welcoming environment for all who interact in our community. In building this environment, we strive to attract students, faculty and staff from a variety of cultures, backgrounds and life experiences. Florida Atlantic University embodies a culture of strategic and collaborative community engagement that results in mutual benefit to the institution and the diverse internal and external communities that it serves.
Florida Atlantic University is seeking a Data Warehouse and Reporting Analyst/Developer- Boca Raton, FL.
The person in this position will work as a team member on University Data Warehouse and Reporting projects. Duties include the following:
Data warehouse development - develop, validate and maintain Data Warehouse data pipelines

• Gather information from subject matter experts about University data and business rules
• Perform analysis of data from multiple sources
• Map data between source systems and the Data Warehouse
• Provide input on the design of the Data Warehouse & the best methods to develop and deploy reports
• Develop, test, and implement extract, transform, and load processes
• Verify the structure and quality of warehouse data to ensure date and report integrity
• Production support to troubleshoot problems with existing Data Warehouse processes or data
• Develop and maintain documentation for the Data Warehouse, reporting software and reports.

State-mandated reporting - Preparation of University data files for submission to the Florida Board of Governors

• Assist with retrieval, conversion, and integration of data needed for reports. This includes data analysis using SQL and other tools, collecting and documenting requirements, and validation of Data Warehouse data.
• Act as a liaison within the Office of Information Technology and with University administrative units to understand and document current business processes and any changes that affect reporting.
• Validate data files to be submitted to the Board of Governors and work closely with administrative units to resolve data issues prior to submission. Review all changes to the Board of Governors file requirements and manage the effort to implement these changes.
• Develop and maintain documentation of processes used for state-mandated reports.

University reporting

• Develop and validate end-user reports using University-supported tools
• Help administer University business intelligence tools: adding users, securing data and reports, troubleshooting technical issues

FAU Benefits and Perks

• If Benefits & Perks are important to you, then FAU is the place to be! Working at FAU has its perks! In addition to helping drive change and having a positive impact by supporting our students, staff, and faculty, FAU offers:
• Excellent benefit packages including Medical (PPO/HMO $50 per month single & $180 per month family), Dental, Vision, Life Insurance, Flexible Spending plans, Employee Assistance Program (EAP) and much more.
• State retirement options including tax-deferred annuities and Roth 403(b) plans.
• State employees Public Service Loan Forgiveness (PSLF) program - https://studentaid.gov/manage-loans/forgiveness-cancellation/public-service
• Flexible work arrangement plans - https://www.fau.edu/hr/employee_relations/flexwork.php
• Sick Leave Pool Program
• Paid time off (eligible employees) including vacation and sick leave, 1 personal day, 9 paid holidays, and paid winter break (at President's discretion).
• Paid Community Engagement Volunteer Service Day - https://www.fau.edu/hr/files/COMMUNITY_ENGAGEMENT_VOLUNTEER_LEAVE4-2015.pdf
• Employee Educational Scholarship Program (EESP) for eligible Staff/Faculty - Tuition assistance after 6 months of full-time employment. For in-unit faculty, the EESP program may be extended to spouses and dependent children (eligibility rules apply).

For details on FAU's amazing offers visit us at https://www.fau.edu/hr/benefits/index.php
Minimum Qualifications:
Master's degree from an accredited institution in an appropriate area of specialization; or a bachelor's degree from an accredited institution in an appropriate area of specialization and two years of appropriate experience required.
Must have experience with relational databases, such as Oracle, SQL Server, MySQL, or PostgreSQL.
Should have intermediate to advanced knowledge of SQL to create queries and views.
Preferred:
Experience with at least one ETL tool, such as SQL Server Integration Services (SSIS).
Knowledge of Data Warehouse architecture and data modeling.
Experience with reporting/analytical tools, such as Power BI, Tableau, SQL Server Reporting Services.
Salary:
$65,000 - $70,000 a year.
College or Department:
OIT: Data and Reporting Services
Location:
Boca Raton
Work Days and Hours:
Monday - Friday, 8:00 a.m. - 5:00 p.m.
Application Deadline:
2023-05-07
Special Instructions to Applicant:
Individuals with disabilities requiring accommodation, please call 561-297-3057. 711
Final candidate will be required to have official, sealed transcripts and original NACES evaluation, if applicable, sent from their educational institution to Human Resources prior to the start of employment.
Successful completion of a background check, which may include a motor vehicle check, credit check, fingerprinting or additional screening, is required for the selected candidate prior to the start date.
A resume and a cover letter are required for this position. Make sure to attach these required documents in the Attachments section of the application. Any missing required documents will result to disqualification.