Business Intelligence (BI) Lead

As the BI Lead, you support ACE students, faculty, and staff by providing the technical support and leadership of essential data management and BI systems critical to the enterprise.
This includes building new features and providing maintenance support on all business-essential systems.
You will be responsible for leading and maintaining our production systems, Azure data lakes, and data warehouses.
You will work closely with IA team, ACE Developers, Off-shore team, third Party Developers, Product Owners, Business Owners & the Infrastructure team to ensure integrations and other solutions are operating as designed to meet the needs of our students and staff.
You’ll also ensure technical and support documentation is up to date.
Requirements Who is American College of Education Founded in 2005, American College of Education continues to be a leader in professional development through our online programs.
The mission of ACE is to deliver high-quality, affordable and accessible online programs grounded in evidence-based content and relevant application.
Our graduates are prepared to serve, lead and achieve personal and professional goals in diverse, evolving communities.
As a socially conscious institution, we’re dedicated to making a positive impact and inspiring our students to do the same.
ACE is a premier organization that is continually recognized for its commitment to social responsibility.
In 2016, ACE became a Certified B Corporation.
As a socially conscious institution, we believe we have a responsibility to our students, alumni, employees, local communities, and society.
We strive to make an impact in the world that goes well beyond our bottom line.
Who You Are You are passionate about helping students achieve their educational goals.
You thrive in a competitive and collaborative team environment.
You are comfortable working remotely and have experience collaborating with others in a virtual environment.
You possess a strong attention to detail.
As the BI Lead, you support ACE students, faculty, and staff by providing the technical support and leadership of essential data management and BI systems critical to the enterprise.
This includes building new features and providing maintenance support on all business-essential systems.
You will be responsible for leading and maintaining our production systems, Azure data lakes, and data warehouses.
You will work closely with IA team, ACE Developers, Off-shore team, third Party Developers, Product Owners, Business Owners & the Infrastructure team to ensure integrations and other solutions are operating as designed to meet the needs of our students and staff.
You’ll also ensure technical and support documentation is up to date.
Compensation ACE is committed to paying a competitive wage while staying true to our mission of maintaining high-quality, affordable programs for our students.
The starting salary range for this position is $115,000 plus all full-time employees are eligible for an annual bonus.
Offers vary depending on education, prior experience, and expertise being applied to the role.
What We Look for in the Ideal Candidate Demonstrates positive attitude and motivation, concern for students, teamwork, and excellent time management skills.
Follows established processes as outlined by the organization and leadership.
Completes assigned duties based on daily business needs and individual skill sets.
Consistently produces a high volume of quality work.
Capable, and adapts as needed, to work under pressure and meet tight deadlines.
Proven ability to work independently with limited supervision and with other department personnel.
Must support and embrace the College’s B Corp mission to improve the people and communities we serve through our civic engagement initiatives.
Must have exceptional communication, organization, and time management skills.
Must be "self-motivated" as well as creative and efficient in proposing solutions to complex, time-critical problems.
Must be collaborative in driving decisions and a team-player.
Strong analytical and problem-solving skills with a high attention to detail.
Builds and maintains student satisfaction.
Recognizes and anticipates student needs.
Day to Day Responsibilities In this role you will wear different hats, but your skills will be especially essential in the following areas: Develops BI infrastructure strategy & matrix-leads off-shore BI developers in support of Data Governance and Institutional Analytics and Reporting.
Articulates a vision of future trends for BI infrastructure by staying in-front of innovative technology in marketplace.
Leads effort in support of research, planning, development, implementation, utilization, monitoring, and performance tuning of databases, data warehouses, data lakes, primarily on Microsoft SQL Server, Microsoft Azure, and Microsoft Windows stack.
Accountable for Data Quality from internal and 3rd party SaaS platform.
Responsible for leading BI Development Projects.
Designs and implements data management solutions using Microsoft Azure Synapse Analytics, Azure Data Bricks, Apache Spark, and other data management tools.
Creates and maintains technical documentation for systems, integrations, jobs, automations, and workflows.
Accountable for the triage of Extraction, Loading and Transformation issues for timely resolution.
Collaborates with Product Owner, Business Owner, Development, and infrastructure team to reduce the gap pragmatically and continually between getting things done fast and getting things done right.
Identifies and implements processes and technologies that improve operational efficiency and automation for timely data-driven analytics.
Proactively monitors the health of systems to ensure that data and transaction information have been successfully transferred among systems.
Provides support for all data-intensive systems and data integrations including data lake, data warehouse, data models, OLAP models, and BI/reporting solutions.
Ensures adherence to ACE Software Development Lifecycle (SDLC) policy and procedures.
Ensures adherence to data governance, data compliance, and data security best practices.
Skills and Competencies In this role, the following skills and competencies are desired: Excellent team player able to work with virtual and global cross functional teams.
Solid problem-solving skills, attention to detail, and critical thinking abilities.
Strong analytical and quantitative skills.
Demonstrated ability to maintain composure in the face of challenges and change.
Ability to make complex decisions without procedural guidance.
Exposure to Agile methodology/ Scrum framework.
Thorough understanding of relational data model, dimensional data model and big data.
Skilled in creating data flow diagrams, architecture diagrams, and entity relationship diagrams (ERDs) using Microsoft Visio or equivalent tools.
Qualifications and Education Requirements Bachelor's degree in Computer Science, Engineering, Information Systems or related discipline, or equivalent experience.
6+ years’ experience working with data and BI solutions.
4+ years’ experience with data management solutions using Azure Data Lake, Azure Synapse Analytics, Azure Data Bricks, REST APIs, Apache Spark or other equivalent tools.
Experience with reporting tools Power BI and SSRS.
Experience managing enterprise data warehouses and data lakes.
Experience working with Python language is a plus.
Relevant certification in data management or BI solutions is a strong plus.
Certification in Agile, Scrum or other equivalent delivery frameworks is a plus.
Experience working with enterprise applications and systems in EdTech space (e.
g.
, Anthology SIS, Canvas LMS, etc.
) is a strong plus.
Ability to work during the United States Eastern Time zone.
Our Commitment to Employees Just as we strive to empower our students for success, we also aim to enrich the lives of our employees.
For five years, ACE has received recognition as one of Indiana’s Best Places to Work, winning the #1 spot for medium-sized companies in 2020.
As a virtual first organization, we celebrate diversity and are committed to creating a family-like inclusive work environment.
For our full-time employees, we offer the following benefits: Medical, dental, & vision Insurance HSA and FSA options Paid parental leave Paid volunteer time Tuition reimbursement & reduction programs Generous PTO 401k and employer match Full-service wellness and EAP program Employee recognition and awards programs Employer paid life & AD&D insurance Short-term disability Employer paid long-term disability And more… Physical Demands The physical demand described here are representative of those that must be met by an employee to successfully perform the essential functions of this job.
While performing the duties of this job, the employee is regularly required to communicate with and receive communications from students and ACE employees in real time using online and other electronic media.
Diversity At American College of Education, we believe that the best learning environment for students and staff is one in which we encounter viewpoints and experiences that are different, yet complementary to ours.
This environment is fostered by the presence of persons with diverse backgrounds.
We recognize that acknowledging diversity is a necessary precondition, but sustained effort is necessary to ensure equity and greater inclusion.
Through strategic planning and initiatives, we seek to develop programs that promote equity and inclusion for everyone so that all members of ACE’s community can reach their full potential.
To create and maintain a truly diverse, equitable and inclusive learning community, we strive to make all feel equally valued, and we uphold our Commitment to Freedom of Expression.
We may celebrate diversity, but we “live” inclusion.
Additional Notes This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job.
Duties, responsibilities, and activities may change at any time with or without notice.
Internet bandwidth speeds from an employee's remote work location must be a minimum of 50Mbps download speeds and 5Mbps upload speeds.
Please note if the bandwidth is shared across multiple devices (tablets, computer, streaming, phone, etc.
) you will need higher overall speeds.
You can test the speed of your connection by visiting speedtest.
net Purchase, setup, installation, support, and ongoing maintenance of reliable internet service is the responsibility of the individual.
American College of Education seeks to attract and retain a diverse staff consistent with its diverse student body and surrounding communities.
At this time we cannot consider candidates residing in Alaska, Washington D.
C.
, Hawaii, Massachusetts, New Mexico, South Dakota, or Alabama.
ACE is an Equal Opportunity Employer.