Business Intelligence Developer

87901BR

Campus: Tempe

Business Intelligence Devlpr

Job Description

ASU, a leading innovator in higher education, committed to maintaining the most dynamic and productive learning experience for its students, is looking to fill the position of Business Intelligence (BI) Developer for its Enterprise Technology (ET). The candidate will play a leading role in the development, implementation, and management of data warehouse solutions to support data enrichment initiatives for ASU. This position offers a fast-paced, energetic, and technically rich environment with many opportunities for advancement. 

As with everyone in the Enterprise Technology team, our intentional focus on diversity, equity, inclusion and belonging as well as culture and communications are core responsibilities in this role. With an increased emphasis on authenticity, compassion, and inclusivity, this position strives to embody and advance our Enterprise Technology Positive Core.

ASU offers a total compensation package that includes valuable employee benefits. Click here to explore options.

Job Family

Information Technology

Department Name

Data Management

Full-Time/Part-Time

Full-Time

VP Code

ASU Enterprise Technology

Grant Funded Position

This is not a grant funded position and is not contingent on future grant funding.

Salary Range

$83,013 - $100,000 per year; DOE

Close Date

03-February-2023

Essential Duties

• Work with users and business analysts to translate functional requirements into technical data warehouse solutions in a Cloud Computing environment (AWS Redshift)
• Develop high quality moderate to complex ISO-compliant SQL (analytic functions, advanced joins, effective dating)
• Design and develop SQL to implement destructive and historical loads of Star Schema Type 1 and 2 dimensions
• Design ETL job templates and architect Redshift data structures to integrate a variety of high-volume data stores, capture changes and maintain current and historical information
• Using Matillion, DataStage and other ETL tools, develop and test incremental logic and slowly changing dimensions ETL jobs
• Design and develop Redshift/Spectrum objects (tables, views, stored procedures, functions)
• Demonstrate problem solving and troubleshooting skills in developing and supporting data warehouse and ETL solutions
• Produce data models and database designs, including dimensional models
• Do analysis and provide performance tuning recommendations for data structures, SQL code and ETL design to improve performance
• Learn new technologies quickly and adapt to changing toolsets
• Research, apply and refine best practices for data warehouse architectures, methods and features
• Perform change management and transition objects from DEV to QA to Production environments
• Maintain existing data warehouse objects and code
• Provide production support for ETL jobs on a 24 x 7 recurrent schedule
• Participate and multi-task as an Agile self-starter
• Communicate complex conceptual ideas and technical subjects to a variety of audiences
• Deal well with ambiguity, prioritize needs and complete projects on time and in scope
• Work effectively both independently and collaboratively as part of a team
• Provide technical leadership and coach other team members
• Take responsibility for fostering culture, advancing our values, and championing engagement in all its forms -- collaborating across our teams as well as participating in ET/ASU events and programs. Demonstrates commitment to valuing diversity and contributing to an inclusive working and learning environment.  Advances our Enterprise Technology Affirmative Pledge

Minimum Qualifications

Bachelors degree in a business, information technology or closely related field and three (3) years experience in data modeling or database design using SQL or similar language and use of ETL process analysis and design, BI tool use and administration as well as user training/documentation development experience OR, Any equivalent combination of experience and/or education from which comparable knowledge, skills and abilities have been achieved.

Desired Qualifications

• Experience working in higher education, EdTech or other education-related organization(s)
• Experience working with data from higher education ERP systems (examples include PeopleSoft, Banner, Workday, Salesforce)
• Significant experience (3+ years) designing SQL and ETL jobs to create enriched data
• Experience with database design including dimensional models
• Experience in using SQL or similar procedural language
• Experience working with high volume data sets
• Experience providing data for reporting analysts, statistical modelers, and/or data scientists
• Comfort in learning new technologies, and working with ambiguity and agility
• Ability to model empathy, compassion and emotional intelligence
• Experience working in a values-led organization, emphasizing diversity, equity, inclusion and belonging
• Ability to help foster a safe psychological space for all teammates where everyone can thrive
• Ability to stimulate changes in individual, institutional, and corporate behaviors to create a more sustainable environment
• Ability to lead by example in communicating, participating and encouraging support of the institution’s sustainability programs

Working Environment

• Activities are primarily performed in a regular, climate-controlled office setting subject to extended periods of sitting or standing
• Use office equipment including a desktop or laptop computer
• Communicate to perform essential duties
• Regular review of completed tasks

Department Statement

The Enterprise Technology (ET) embraces its role as both an enabler and catalyst for advancing the vision and work of the New American University.  We are a values-driven organization.  Our commitments are reflected in all of the work we do in pursuit of operational excellence, the experience and delight of our community, and our strategic and innovation initiatives. Applicants must be eligible to work in the United States.
Join the team that sparks human-centered innovation

ET is a rapidly reconfigurable and entrepreneurial organization at ASU that prioritizes and
executes to meet the needs of our community of learners, faculty, researchers and staff. Our
work emphasizes autonomy, flexibility and distributed decision-making to leverage the strengths of individuals. Together, we embrace a culture that nurtures, engages and embraces diverse voices with a shared lens of positive community impact and expanded opportunities for collaboration.

Why join us?

Mission oriented. Everything we do is to advance ASU’s charter -- measuring who we include and how they succeed. We are staunch champions of learner success and put people first.

Flexibility. Our hybrid work environment prioritizes personal autonomy and trust around how work gets done. Staff touch base in person a few times per week with freedom to decide how, when and where.

Culture forward. We embrace a Positive Core culture: Belonging, Relational, Authentic, Visionary and Empowered. The ET fabric weaves together diversity, equity and inclusion applied in our daily work and interactions.  

Scale of impact. Our work changes the world. With 180k+ learners, faculty, researchers and staff, working with ET means you have the capacity to improve many lives and entire communities.

World-class, low cost education. Our professional development is built in! ET encourages staff to seek additional certificates and degrees via ASU’s top ranked programs with major tuition breaks.

Exposure to industry giants. ET partners with Amazon, Apple, Cox, Verizon, Salesforce, Alteryx and a diversity of technology companies to enhance our innovations and deepen their impact.

ASU Statement

Arizona State University is a new model for American higher education, an unprecedented combination of academic excellence, entrepreneurial energy and broad access. This New American University is a single, unified institution comprising four differentiated campuses positively impacting the economic, social, cultural and environmental health of the communities it serves. Its research is inspired by real world application blurring the boundaries that traditionally separate academic disciplines. ASU serves more than 100,000 students in metropolitan Phoenix, Arizona, the nation's fifth largest city. ASU champions intellectual and cultural diversity, and welcomes students from all fifty states and more than one hundred nations across the globe.

ASU is a tobacco-free university. For details visit https://wellness.asu.edu/explore-wellness/body/alcohol-and-drugs/tobacco

Arizona State University is a VEVRAA Federal Contractor and an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other basis protected by law.

Notice of Availability of the ASU Annual Security and Fire Safety Report
In compliance with federal law, ASU prepares an annual report on campus security and fire safety programs and resources. ASU’s Annual Security and Fire Safety Report is available online at https://www.asu.edu/police/PDFs/ASU-Clery-Report.pdf. You may request a hard copy of the report by contacting the ASU Police Department at 480-965-3456.

Relocation Assistance – For information about schools, housing child resources, neighborhoods, hospitals, community events, and taxes, visit https://cfo.asu.edu/az-resources .

Employment Verification Statement

ASU conducts pre-employment screening which may include verification of work history, academic credentials, licenses, and certifications.

Background Check Statement

ASU conducts pre-employment screening for all positions which includes a criminal background check, verification of work history, academic credentials, licenses, and certifications. Employment is contingent upon successful passing of the background check.

Fingerprint Check Statement

This position is considered safety/security sensitive and will include a fingerprint check. Employment is contingent upon successful passing of the fingerprint check.

Instructions to Apply

Application deadline is 3:00PM Arizona time on the date indicated.

Please include all employment information in month/year format (e.g., 6/88 to 8/94), job title, job duties and name of employer for each position.

Resume should clearly illustrate how prior knowledge and experience meets the Minimum and Desired qualifications of this position.

ASU does not pay for travel expenses associated with interviews, unless otherwise indicated.

Only electronic applications are accepted for this position.

IMPORTANT NOTE: What is the meaning of “equivalent combination” in the minimum qualifications? It means one year of higher education or 24 credit hours, is equal to one year of experience. For example, a four year Bachelor’s degree is equal to four years of experience.