senior data engineer

The Senior Data Engineer at Joyce University will design, develop, and implement the key workflows of data throughout the organization. You will build distributed services to support multiple teams, supporting their data consumption needs using Snowflake and DOMO, in an environment of higher education. You will provide cutting-edge, reliable, and easy-to-use systems for ingesting and processing data resulting in a better experience for faculty, students, and administration

You will build and maintain batch and real-time data flows used for business intelligence, analytics, and building up to machine learning within all organizations across Joyce This also involves storing and exposing data via a Database, Data Lake, and other APIs. Joyce espouses values of Service, Learning, Integrity, Caring and Excellence and by contributing at Joyce this role can impact the quality-of-care training for individuals in nursing and occupational therapy around the country.

This position is a hybrid position which requires 3 to 4 days a week in office on our Draper, UT campus and 1 to 2 days from home office. All hybrid remote meetings are conducted on camera.

WHAT'S IN IT FOR YOU:

• A generous self-directed PTO policy
• Paid holidays
• 401k with employer match
• Medical, dental, and vision insurance
• Fully paid short term disability
• Long term disability
• Dedicated professional development
• World-class continuing education assistance

WHAT YOU DO EVERYDAY:

• Build out an Electronic Data Warehouse out of data in the data lake inside Snowflake.
• Combine Nexas, Canvas, and Salesforce data with traditional web visit streams to build a full lifecycle view of students including acquisition channels through graduation.
• Customize and optimize current data flows for consumption in DOMO, PowerBI or Tableau reporting.
• Use existing tools and processes to deploy to integration and production environments.
• Follow and improve the deployment processes.
• Maintain the health of the data ecosystem by configuring monitors, defining alerts on common failure points, and giving feedback on data quality to data owners and business partners.
• Review peer code and submit thorough and actionable feedback based on team standards and industry best practices.
• Triage and resolve production issues. Communicate with individual business partners on status and escalate as needed.
• Design and document data flows to optimize the pathway from source to data lake, to data warehouse to reporting platform for multiple types of data.
• Understand the data at a deep level, apply security appropriately, and escalate as needed.
• Work with business partners to write requirements for and ensure quality in deployed code
• Other duties as assigned

BEHAVIORS AND COMPETENCIES:

Technical and Professional Knowledge, Skills, and Abilities

Achievement of technical and professional knowledge, skills, and abilities is high in position-related areas; demonstrates curiosity and keeps current with trends in areas of expertise.

Enhanced Analytical Proficiency

Employs comprehensive expertise in both qualitative and quantitative methodologies to discern, structure, interpret, and communicate vital data essential for organizational decision-makers, aiming for positive organizational outcomes. Innovates continuous protocols for data collection and monitoring, ensuring a consistent stream of actionable insights to guide decision-making.

Enhanced Communication Skills

Effectively listens, speaks, observes, and empathizes while showing appropriate assertiveness, confidence, and respect. Written communication skills include grammar, punctuation, structure, spelling, tone, proofreading, clarity and organization. Communicates concepts, ideas, needs, and feelings with appropriate tone, clarity, volume and non-verbal cues for each situation. Demonstrates understanding of differences communicating through face-to-face interactions, phone conversations, and written / digital communications. Adjusts communication styles to suit different audiences, including students, peers, managers, executives, and vendors/partners.

Customer Service Mindset

Shows a steadfast dedication to outstanding service by actively interacting with individuals at every stage, including prospective students, current students, faculty, staff, alumni, vendors, and all stakeholders. Maintains a positive demeanor and nurtures an inclusive atmosphere, fostering a culture of mutual support and cooperation throughout the university ecosystem.

Accountability

Sets high standards of performance for self, taking full ownership and responsibility for the timely completion of assignments or tasks. Demonstrates an unwavering commitment to excellence and precision in all work undertaken.

Teamwork and Engagement

Actively contributes to team goals while fostering positive workplace relationships; engages in learning and social functions, demonstrates adaptability, flexibility, and embraces change management. Contributes to a positive workplace culture.

Organizational Alignment

Adheres to the organization's mission, vision, values, core themes, and consistent leadership expectations. Demonstrates high levels of collaboration, mutual respect, emotional maturity, professionalism, and drive for results.

Managing Work

Effectively organizes and prioritizes work, problem solves, uses time and resources effectively, shares information, monitors redundancies in processes; uses appropriate methods and systems thinking to implement solutions and measure impact.

Problem Solving

Displays a strong ability to identify and address challenges within the academic environment. Utilizes critical thinking skills, creativity, and resourcefulness to develop effective solutions. Actively collaborates with stakeholders to implement changes and improve processes, contributing to the continuous enhancement of the university's operations and academic experience.

Creating Collaborative Relationships

Works effectively and cooperatively with others and maintains good working relationships within and outside of own functional area; uses appropriate interpersonal styles to promote openness, establish trust, and build confidence in one's intentions.

WHAT YOU'VE ACCOMPLISHED:

Minimum Qualifications

• 4+ years of relevant experience in the data engineering role, including data warehousing and business intelligence tools, techniques, and technology, or experience in analytics, business analysis or comparable consumer analytics solutions.
• Undergraduate Degree or equivalent combination of education and experience in a related field

Preferred Qualifications

• Bachelor's degree in Computer Science, Engineering, Math, Finance, Statistics or related discipline or equivalent experience in ETL creation and deployment.
• Experience in big data processing and using databases in a business environment with large-scale, complex datasets. (SQL, PostgreSQL, SSRS, Hadoop, Spark, etc.)
• Experience with tying Snowflake to various technologies (Azure Blob, Azure Data Factory, private cloud solutions, APIs, SFTP connections, etc.)
• Knowledge and direct experience using business intelligence reporting tools. (Domo, PowerBI, Tableau, Business Objects)
• Extensive knowledge of SQL query design and optimizing for performance and accuracy
• Prior experience in building ETL around quarter-over-quarter, or semester-over-semester analysis including year-over-year and prior semester combined analysis a plus.
• Demonstrated proficiency with Python, R, or other data-relevant scripting languages.
• Experience with Data Lake design and philosophy
• Experience in an Agile/Sprint working environment preferred.
• Proficient research skills to locate market information using numerous internal and external sources of data.
• Experience in QA policies and procedures around data quality preferred
• Excellent communication (verbal and written) and interpersonal skills and an ability to effectively communicate with both business and technical teams.
• Excellent understanding of the principles of Data Governance with familiarity with the needs specific to Higher Education.
• Strong planning and organizing skills to prioritize numerous projects and ensure data is delivered in an accurate and understandable manner to the end user.

EQUAL EMPLOYMENT OPPORUTNITY POLICY:

Joyce University provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.

PId6be4ad2124f-0331