Developer II, Analytics

This job carries with it the obligation to uphold the Mission of Lone Star College (LSC) in carrying out the duties of the position. A commitment to positive interpersonal behaviors, professional communication, integrity, leadership, stewardship, respect and accountability to LSC students and employees is essential.

Cultural Beliefs

• One LSC
• Student Focused
• Own It
• Foster Belonging
• Cultivate Community
• Choose Learning

The Chronicle of Higher Education's "Great Colleges to Work For" is designed to recognize colleges that have been successful in creating great workplaces and to further research and understanding of the factors, dynamics and influences that have the most impact on organizational culture at higher education institutions.

Lone Star College has been recognized in multiple categories.

Lone Star College-System Office

Lone Star College offers high-quality, low-cost academic transfer and career training education to 80,000+ students each semester. LSC has been named a 2023 Great Colleges to Work For institution by the Chronicle of Higher Education.

LSC consists of eight colleges, seven centers, eight Workforce Centers of Excellence and Lone Star Corporate College.

Lone Star College-System Office employees are based at one of two System Office locations; The Woodlands and University Park. Both are the site for multiple administrative departments and system-wide training programs.

Location address is 5000 Research Forest Drive, The Woodlands, TX 77381.

PURPOSE AND SCOPE:

The Developer II, Analytics examines and analyzes the business and technical processes for Office of Analytics & Institutional Reporting (AIR), determines relationships, makes recommendations, and implements reporting automation using Microsoft business intelligence (BI) tools. Develops analyses and dashboards to meet LSC internal and external reporting needs. Under direction of supervisor, provides training, technical support, and research and resolve known problems. Under direction of supervisor, interfaces with OTS personnel to resolve AIR technical and implementation questions and issues. This position is a member of a global 24/7 information technology team.

ESSENTIAL JOB FUNCTIONS:

1. Designs and develops Power BI (PBI) and SSRS analyses and dashboards including graphs and charts
2. Develops and modifies SQL statements for extraction of data
3. Develops automated reports
4. Assists users with building and tuning reports
5. Troubleshoots problems and performs product testing/diagnosis to pinpoint nature of problem
6. Contributes to team strategy for business intelligence development and implementation
7. Plans and conducts report testing and data validation
8. Provides second-level customer support for BI analytics and dashboards
9. Develops and maintains position-related training and succession purposes
10. Responds to analytics or dashboard requests and malfunctions
11. Responsible for other reasonable related duties as assigned

KNOWLEDGE, SKILLS, AND ABILITIES:

• Knowledge of Power BI, Microsoft SSRS or related BI development tools
• Ability to develop analytics and dashboards to meet written specifications
• Ability to communicate with users having diverse technical skills and backgrounds
• Ability to write or modify analytic-related SQL
• Ability to analyze data independently
• Functional knowledge of business process analysis and documentation methodology
• Knowledge of business intelligence development life cycle
• Ability to work in a fast-paced environment and meet deadlines
• Knowledge of software/hardware and service delivery management
• Ability to work on several task simultaneously while delivering quality customer service

PHYSICAL ABILITIES:

The work is sedentary. Typically, the employee sits comfortably to do the work. However, there may be some walking; standing; bending; carrying of light items, such as papers, books, or small parts; or driving an automobile. No special physical demands are required to perform the work.

WORK SCHEDULE AND CONDITIONS:

• Equipment used includes, PC workstation running on a LAN in a Microsoft Windows environment, calculator, phone and other general office equipment
• Interface with internal and external contacts as needed to carry out the functions of the position
• Work is performed in a climate-controlled office with minimal exposure to safety hazards
• Responds to analytics or dashboard requests and malfunctions on call 24/7
• May regularly travel to different LSC locations
• May be fully reassigned to other LSC locations if necessary
• May need to work weekends and outside of core business hours if necessary

REQUIRED QUALIFICATIONS:

• Bachelor's degree and at least 3 years of directly related work experience, or an equivalent combination of education and experience

PREFERRED QUALIFICATIONS:

• At least 2 years using Microsoft Power BI, SSRS, Qlik, Tableau or related software
• At least 2 years writing SQL queries
• At least 2 years analyzing data and business processes
• Experience with higher education data
• Experience with PeopleSoft Campus Solutions
• Experience querying Oracle databases
• Experience using HTML to modify dashboard appearance

Hiring salary range is $69,679 to $80,131.

Lone Star College provides a hiring salary range for all posted full-time non-faculty positions. Where your salary offer would fall in that range is determined by your related experience and education. Should you receive an offer of employment from Lone Star College, the resume submitted in the application process will be utilized to calculate your salary offer. The information outlined below will provide the Office of Human Resources everything needed to determine an accurate starting salary.

Your resume should provide a complete picture of your work experience. The resume should include the following information for each position listed:

1. Length of time (specific months and years) of employment
2. If the position was full time or part time
3. If the position was paid or unpaid
4. Level of degree completed including date earned.
5. Unofficial transcript for highest earned degree

Additionally, any certifications listed as required or preferred in the Lone Star College job description should be included in the resume submitted.

By joining our top-notch institution, you will enjoy being a part of an organization that offers a supportive, collegial work environment and excellent work/life balance. This includes a full comprehensive and competitive benefits package, a generous number of paid holidays and vacation days, wellness programs, tuition waiver, professional development opportunities and more.

Go to the Job Search page, click on 'My Activities' at the top of the page. Under My Cover Letters and Attachments you will click on 'Add Attachment.' Please be sure to put the Job ID# in the title once you name your file for cover letters only, unless you attached your cover letter with your resume.

If you are applying for an Instructional position (i.e. Faculty, Adjunct Faculty, Instructor), please ensure you include the following to be considered: Resume/CV, Cover Letter, Teaching Philosophy, and unofficial transcripts.

You must limit your file name for any attachment to 40 characters or less.

ALL APPLICANTS MUST APPLY ONLINE ONLY

We will not accept application material received via fax, email, mail, or hand delivered.

Postings for part-time and adjunct positions are active for the academic year. By selecting the option to receive notifications on your profile, you will begin receiving electronic communication regarding new opportunities with Lone Star College (LSC).

If selected for an interview, a recruiter will contact you by phone, or email to schedule an interview.

Lone Star College participates in the E-Verify program, under which Lone Star College provides the federal government with information from each new employee's Form I-9 to confirm that the employee is authorized to work in the United States.

More information on the E-Verify program is available at www.dhs.gov/E-Verify.

Lone Star College is an EEO Employer. All positions are subject to a criminal background check.