Data Warehouse and Report Developer, Junior

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. 

Note: Current FAU employees must apply as an internal applicant by logging into their existing Workday employee account.

Position Summary:

Florida Atlantic University is seeking a Data Warehouse and Report Developer, Junior – Boca Raton, FL.

The Data Warehouse Developer and Reporting Analyst, Junior supports the Data and Reporting Services (DRS) Team in developing data integrations and reporting solutions to meet operational and strategic needs across the University. This position is ideal for candidates who are technically inclined but also demonstrate strong analytical thinking, problem-solving skills, and the ability to work independently on assigned tasks. The role provides opportunities to grow expertise in data engineering, business intelligence, and enterprise data systems while contributing to meaningful reporting and integration work.

Summary of Responsibilities includes:

Report Development and Analysis:

• Assist in collecting and documenting report requirements. 
• Retrieve, transform, and prepare data for reporting using SQL, Python, Power BI, and other tools.
• Validate data to ensure accuracy and alignment with University reporting standards.   
• Design, develop, and maintain interactive Power BI reports and dashboards that support compliance, operational, and strategic needs for the University.
• Conduct data validation, assist in code implementations, and help prepare data file submissions to the Florida Board of Governors.  
• Build foundational knowledge of student, budget, personnel, and payroll data systems to support reporting needs.

Data Warehouse Operations, Engineering, Integrations, and Governance:

• Monitor scheduled data loads and assist in investigating and resolving data pipeline issues. Participate in documenting data integration logic, data lineage, and system dependencies to support audit, compliance, and operational continuity for the data warehouse.
• Develop and support data integrations for internal and external data sources, ensuring data consistency, accuracy, and security are in line with University policies.
• Assist in managing secure data exchanges with third-party systems, ensuring compliance with data security, privacy, and reporting standards.
• Perform exploratory data analysis on new data sources to assess the quality and readiness of new data sources for integration.

Collaboration and Continuous Improvement:

• Collaborate with cross-functional teams to understand reporting and data integration needs.
• Proactively identify opportunities to improve data processes, documentation, or quality.
• Contribute ideas and provide input on tools, practices, or technologies that may benefit the team’s data workflows, such as recommending tools, technologies, and practices for optimizing data ingestion, integration, and processing workflows, including the adoption of modern cloud-based platforms.
• Actively maintain a learning mindset and take initiative to expand technical and domain knowledge.
• Perform other job-related duties as assigned.

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
• Flexible work arrangement plans 
• 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 the President’s discretion). 
• Paid Community Engagement Volunteer Service Day
• 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 

Explore Living in Palm Beach County 

The goal is to provide local employers and new employees in the area with a comprehensive guide on places to live. 

Minimum Qualifications:

Bachelor’s degree in an appropriate area of specialization OR High School Diploma and four years of appropriate experience required.

Preferred Qualifications/Skills:

Degree in Data Analytics, Computer Science, Information Systems, or a related field.

Experience writing SQL queries to retrieve and manipulate data from relational databases.

Experience with data visualization and dashboarding tools such as Power BI, Tableau, etc.

Strong analytical thinking, problem-solving skills, and attention to detail with an ability to work independently and manage time effectively across multiple projects or tasks.

Effective written and verbal communication skills, including the ability to document technical processes.

A basic understanding of data warehousing and ETL, experience with Python or other scripting languages, and familiarity with tools like SSIS, CData, or cloud-based platforms.

Knowledge of data governance and compliance, especially in higher education, along with experience validating and preparing data for reporting.

Salary:

$63,000 per 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. with some occasional evenings or weekends.

Application Deadline:

2025-08-04

Special Instructions to Applicant:

APPLICATION DOCUMENTS REQUIRED:
Resume

OFFICIAL SEALED TRANSCRIPTS REQUIRED:
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.

PRE-EMPLOYMENT SCREENINGS REQUIRED:
Selected candidates must successfully complete and pass all employment screenings prior to the start of employment. Employment screenings may include a criminal background check (level I and level II), motor vehicle check, credit check, reference checks, alcohol, and drug screening check.

REQUEST FOR ACCOMMODATIONS:
Individuals with disabilities requiring accommodations may contact the Office of Civil Rights and Title IX at 561-297-3004 or send an email at accomodate@fau.edu. To contact Human Resources, please call 561-297-3057. For communication assistance call 7-1-1.