Senior Analytics Engineer

Wake Forest University Pre-College Programs; North Carolina; Hybrid; USD 110,000 - 165,000; Full time

Job summary

Wake Forest University Pre-College Programs seeks an experienced Senior Analytics Engineer to design and implement data pipelines and analytics products across campus systems. You will collaborate directly with stakeholders to understand questions, model data, and deliver end-to-end solutions.

The role involves AWS lakehouse architecture, Fabric, and AI-assisted tooling, with hybrid work and campus interaction.

Qualifications

• Five+ years of hands-on experience building a data warehouse, data pipeline, or analytics solutions.
• Strong SQL: write, debug, and optimize complex queries.
• Proficient in Python or able to get there quickly.
• Experience with a cloud data platform (AWS/Azure/GCP).
• Experience building reports/dashboards in Power BI, Tableau, Cognos, Looker or similar.
• Excellent communication to translate between technical and non-technical audiences.
• Self-starter who can handle ambiguous problems and learn new tools.
• Bachelor's degree required.

Responsibilities

• Partner with stakeholders to understand questions and define solutions.
• Design and develop data pipelines, models, and analytic products across source systems (Workday, SIS, Finance, HCM).
• Write efficient SQL and build data layers in AWS Lake Formation/Athena and Microsoft Fabric; deliver reporting via BI tools.
• Guide the modernization of integration work toward Python/spec-driven development with AI-assisted tooling.

Job description

## Senior Analytics EngineerApply: Winston Salem, NC: Full time: Posted Today: R0009196****External Applicants:****Please ensure all required documents are ready to upload before beginning your application, including your resume, cover letter, and any additional materials specified in the job description.Cover Letter and Supporting Documents:* Navigate to the \"My Experience\" application page.* Locate the \"Resume/CV\" document upload section at the bottom of the page.* Use the \"Select Files\" button to upload your cover letter, resume, and any other required supporting documents. You can select multiple files.**Important Note: The \"My Experience\" page is the *only* opportunity to attach your cover letter, resume, and supporting documents. *You will not be able to modify your application or add attachments after submission.*******Current Employees:****Apply from your existing Workday account in the Jobs Hub. *Do not apply from this website.***A *cover letter is required for all positions;* optional for facilities, campus services, and hospitality roles unless otherwise specified.****Job Description Summary**We are a small team of analytic practitioners inside Information Systems, and we serve the entire university — academic units, enrollment, advancement, finance, HR, and student life. Some weeks that means sitting with a stakeholder to shape how their data should be structured. Other weeks it means building the pipeline, the model, and the dashboard end to end. Nobody on this team hands work over a wall. You will meet the stakeholder, understand the problem, design the solution, build it, and stay with it through adoption. If that scope sounds like a lot, it is — and it's the reason the work is interesting. We are also in the middle of a genuine platform shift. We're moving from a legacy reporting estate toward a modern lakehouse architecture on AWS and Microsoft Fabric, and replacing low-code integration with spec-driven development in Python. Alongside that, we're early in our AI journey — deliberately so. We have projects scoped and moving forward now, and we're working out what AI actually changes about this craft, from AI-assisted engineering through to agentic analytics for our stakeholders. We're not promising you a mature AI practice to plug into. We're offering something better: a chance to help build one. What we offer ● A small team where your work is visible and your judgment matters ● Room to shape a platform migration rather than maintain a finished one ● Real support for learning — training, certification, and time to explore new tools ● Flexibility in how you work: hybrid by default, with roughly one day a week on campus ● The breadth of a university: no two stakeholder problems look alike**Job Description****Partner with the institution**● Work directly with stakeholders across campus to understand their questions before defining a solution — requirements gathering is a conversation, not a ticket.● Advise on data architecture, data management, and governance practices for units building their own capability.● Coach and support customers through implementation and adoption. Service is a core part of this job, not an afterthought. **Build the solutions**● Design and develop data pipelines, models, and analytic products spanning our source systems — Workday (SIS, Finance, HCM) among them.● Write the SQL that does the heavy lifting: complex, performant, and readable enough that the next person can maintain it.● Build and tune curated data layers in AWS Lake Formation/Athena and Microsoft Fabric, and deliver reporting through Power BI and other analytic tools. ● Own solutions through the full lifecycle — discovery, design, build, test, deploy, support, iterate. **Modernize the platform**● Help move our integration work from SnapLogic toward spec-driven development in Python using AI-assisted tooling.● Contribute to decisions on our future warehouse direction, including evaluation of Redshift and Snowflake.● Help retire legacy reporting (Cognos) responsibly, without disrupting the people who depend on it today.● Take on AI projects as we scope them, and help us separate what genuinely improves our work from what only looks like it does.**Additional Job Description****Required Education, Knowledge, Skills, Abilities:**● Five or more years of hands-on experience building a data warehouse, data pipeline, or analytics solutions in a professional setting.● Strong SQL. This is the non-negotiable one — the ability to write, debug, and optimize complex queries against large datasets.● Working proficiency in Python, or clear evidence you can get there quickly.● Experience with a cloud data platform (AWS, Azure, or GCP) and modern warehouse or lakehouse patterns.● Experience building reports and dashboards in a modern BI tool (Power BI, Tableau, Cognos, Looker, or similar).● The ability to translate between technical and non-technical audiences — and the patience to do it well with people who are not data professionals.● A self-starter's instinct: you can pick up an ambiguous problem, ask good questions, and make progress without being handed a task list. ● Genuine interest in learning technologies you haven't used yet.● A bachelor's degree. We're open on the field of study — we've seen strong analytics people come from music, philosophy, and biology as often as from computer science. **Preferred Education, Knowledge, Skills, Abilities:**● Experience with Workday, particularly Prism or Reports● Higher education experience, or experience with student, finance, or HR data domains ● Microsoft Fabric, AWS Lake Formation, or Athena● Integration platform experience (SnapLogic, Informatica, Fivetran, dbt, Airflow) ● Practical experience applying LLMs or AI agents to engineering or analytics work● Data governance, data quality, or master data management experience **Accountabilities:**Individual contributor who works as part of a team, applying established standards and developing their skills. Receives guidance and direction from senior team members and management on more complex tasks \\*This position is not eligible for sponsorship of non-immigrant or immigrant visa status through Wake Forest University. All eligible applicants are encouraged to apply.**Time Type Requirement**Full time