Company Profile:
Since 2007, Graduation Alliance has worked with more than 650 state agencies, school districts, community colleges, and workforce boards around the country to recruit, re-enroll, educate, and mentor students. Graduation Alliance also operates The American Academy, an exemplary online high school that is fully accredited by the Northwest Accreditation Commission, a division of Cognia.
Our full-service diploma completion programs can be delivered in facility-based, blended, or fully online settings. These programs are supported with recruiting, transcript analysis, technology, coaching and mentoring, social emotional learning assessment and intervention, and robust support services.
We also develop and facilitate skill certification packages with tailored support to students of all ages. In coordination with local and national employers, we offer work experience, internship programs and job placement. And we partner with institutions to provide pathways to post-secondary education and career training, complete with preferential enrollment, dual credit opportunities, and early financial aid reviews.
In early 2021, Graduation Alliance became a Certified B Corporation. B Corporations use the power of their businesses to build a more inclusive and sustainable economy, and meet the highest verified standards of social and environmental performance, transparency, and accountability.
Position Title: Data/BI Engineer
Position Reports To: Director of Data Services
Department: IT/Product Development
Position Location: Remote, must be +/- 2 time zones from Utah
Position Summary:
Work as a member of our technology team as a Data/BI Engineer. Maintain and build out our data, reporting, and analytic infrastructure based on our student portal, CRM and phone systems which support thousands of students, teachers and administrators every day. The team is small and tightly integrated - you will have meaningful interaction, influence and impact on our efforts. This role will regularly engage with senior leadership, and will be asked to lead some projects and key initiatives.
What You’ll Do:
- Partner with department leaders and data analysts to understand data needs
- Solicit requirements from all levels of the business and translate them into actionable solutions
- Administer our BI/data platforms in our Azure cloud environment
- Design data models to support various company analytical services
- Design and develop comprehensive dashboards, reports, and visualizations that effectively communicate key performance indicators (KPIs) and business metrics.
- Ensure data accuracy and consistency in reporting to provide reliable insights for stakeholders.
- Improve operational processes around our data ingestion/integration services
What You Need to Have and Know:
- 3-5 years of experience with Microsoft SQL Server and/or Azure SQL Database or similar
- platforms.
- Strong T-SQL and/or SQL development, query analysis and optimization skills.
- 3+ years of experience with ETL/ELT environments using Azure Data Factory, Azure Synapse, or SSIS
- 3+ years of hands-on development experience with Microsoft Power BI
- Demonstrated competence in dimensional data modeling.
- Strong insights into data modeling, report development, and visualization best practices.
- Strong analytical ability and focus on satisfying customer needs
- Familiarity with Azure-based data infrastructures, storage, networking, security access and
- compliance management
- Candidates with prior product ownership or business analysis experience (requirements gathering, writing user stories, testing) are HIGHLY preferred
- Minimum of bachelor's degree in CS or comparable work experience.
This position is eligible for an annual incentive compensation plan based on company goals.
Both Stratus.hr and Graduation Alliance will extend equal employment and advancement opportunities to all qualified individuals regardless of their race, color, religion, creed, age (40 and over), sex, gender, sexual orientation, gender identity, pregnancy, disability, national origin, ethnic background, genetic information (including of a family member), past, current, or prospective military service, and/or citizenship, or any other classification protected by applicable local, state or federal law.
In compliance with the Drug-Free Workplace Act of 1988, Graduation Alliance and Stratus.hr have a longstanding commitment to providing a safe, quality-oriented and productive work environment.
Job Type: Full-time
Pay: $85,000.00 - $110,000.00 per year
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Employee assistance program
- Employee discount
- Flexible schedule
- Flexible spending account
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Parental leave
- Professional development assistance
- Tuition reimbursement
- Vision insurance
Compensation package:
Experience level:
Schedule:
- 8 hour shift
- Monday to Friday
Education:
Experience:
- Microsoft SQL Server and/or Azure SQL Database: 3 years (Preferred)
- ETL/ELT env. using Azure Data Factory, Az. Synapse, SSIS: 3 years (Preferred)
- hands-on development experience with Microsoft Power BI: 3 years (Preferred)
Work Location: Remote