BI Engineer

About ETS:

For more than 75 years, we have amplified products and services based rigorous research and our belief in the power of learning. Driven by our mission to advance quality and equity in education, ETS provides learning solutions, pioneering research and trusted assessments that help guide learners around the world on their path to new possibilities.

Our portfolio of trusted measures include TOEFL®, TOEIC®, GRE® and Praxis® . Along with research, development and innovation that explores new frontiers in learning and measurement our educational measurement solutions and research contribute to the development of new methods and tools, inform important dialogue with education policymakers, and shed light on critical issues and potential solutions - all with the aim of creating a world where all learners can improve their lives through education.

With new senior leadership at the helm, ETS aims to continue changing the lives of all learners as we expand our organization's global footprint. Our goal is to remain at the forefront of assessment and measurement efficacy within the education and ed tech space as it continues to grow and evolve.

The BI Engineer has two primary functions 1. solves complex business problems and issues mining data from internal and external sources by providing visually driven insights to decision-makers using both generative and predictive AI techniques. 2. responsible for defining, designing, building, and testing business intelligence dashboard visualizations using the latest technology, incorporating generative AI for innovative data presentation and predictive AI for forecasting and trend analysis. Our ideal candidate should be comfortable sitting at the intersection of data integration engineering, data science, and business analysis, and will be asked to deliver across all three vectors. They should be passionate about working with disparate datasets and be someone who loves to bring data together to answer business questions. They will need to collaborate effectively with internal stakeholders, cross-functional teams to solve problems, and deliver information about our leaders that we might never have considered. This position represents an exciting opportunity to be a part of a dynamic and high-paced environment, leveraging cutting-edge AI technologies to drive business intelligence.

Responsibilities

• Own the BI landscape - design, build, document, and maintain a single source of truth for KPIs and dashboards using front-end BI tools such as Tableau or Power BI

• Own development of visualizations and assembly of analytics “story” indicating trends, patterns and outliers

• Manipulate/mine data from database tables, log files using scripting languges .

• Develop analytical tools: deep-dive tools, UIs, metrics, and dashboards

• Perform deep-dives and root cause analysis to answer business questions

• Effectively communicate solutions and methodologies to leadership

• Work closely and be hands on with the Data Engineering team to ensure the availability and accessibility of relevant data for reporting purposes.

• Analyze existing reports and optimize them for standardization

• Ensure data accuracy by validating data for new and existing tools.

• Participate in the preparation of cost and resource estimates needed to complete sections of complex data analysis proposals. Develop estimates on smaller data analysis projects.

• Implement full technical documentation of data analysis systems, solutions and results.

• Develop professional contacts through association memberships, and attending seminars, to provide continuing awareness of recent advances in numerical analysis, computer science and statistical technologies.

• Defines acceptance criteria, test plans and provide feedback on solutions as and when necessary

• Apply industry standard UI design, data lake needs, to assist in providing optimum solutions

• Follows Agile development processes(via JIRA) and uses Confluence to document everything as requested

• Develop and implement algorithms to on-demand visuals that answer specific business questions.

• Create models using tools that help Predict future trends and evaluates potential risks based on historical data (e.g., demand forecasting).

• Develop self service capabilities within the BI tools for users to be able to slice and dice information as needed.

• Provide insights and recommendations to support decision-making processes.

• Identify unusual patterns or behaviors that could influence business outcomes and suggest preventive measures.

• Adhere to ethical standards and comply with the laws and regulations applicable to your job function.

Skills

• Experience designing & building intuitive and actionable dashboards and data visualizations , reports, filters, metrics that drive business decisions

• Strong storytelling skills and clear communication / writing skill

• Fluent in talking to both data analyst and functional teams

• Adept at adjusting visualizations based on applied business context

• Understand Agile process to create the needed user stories and specifications

• Strong SQL and programming skills like Python.

• Proven expertise with Tableau & Advanced PBI Skills. Microsoft Onelake experience a big plus

• Faciliates and explores clear business requirements. Understands the unspoken needs and ability to clearly articulate the same via a business data story

• Clearly articulates data lake needs via visio

• Creates What-If senarios via PBI and Excel, Product mix similar models and ability to provide deep insights with every dashboard built consistently every week.

• Prepares Acceptance test for all requirements

• Produces Status reports, production planning reports and other project-related documentation

• Experience with natural language processing (NLP) and generative models (e.g., GPT, BERT).

• Proficiency in using tools and frameworks for content generation and text analysis.

• Experience in developing applications that leverage generative AI for business use cases.

• Experience with time series analysis, regression models, and classification algorithms.

• Proficiency in using predictive analytics tools and platforms (e.g., TensorFlow, Scikit-learn).

• Expertise in advanced predictive modeling techniques, including ensemble methods and deep learning.

• Experience in deploying predictive models in production environments and monitoring their performance.

Educataion/Experience

• A Bachelor's degree in Computer Science, Mathematics or Statistics, or a closely related field or an equivalent combination of education and experience from which comparable knowledge and abilities can be acquired is necessary

• Expert Experience using Python, Power BI, Visio, ETL (Apache NiFi, Talend, Informatica), R, MSBI Stack (SSIS, SSAS, SSRS, MSQL)

• Knowledge of trending and effective charting packages for PBI

• Familiarity with AI frameworks like TensorFlow, PyTorch, and Keras

• Microsoft Onelake and Amazon Redshift experience is a plus

• 3+ yrs Experience with Agile, Python, AWS 2.0 platform, Datawarehouse (Azure Data warehousing)

• 3+ yrs Experience with Data ingestion, Data processing and Data publishing methodologies

• Fluent in statistics, datasets, and scripting.

• Understanding data modeling, data schemas (normalized, flat, star, snowflake, etc.).

• Prior Agile process experience is required.

ETS believes in a Total Rewards philosophy for our employees, and they include:

• Health, Vision, Dental insurance plans to choose from

• Generous continuous learning support, from individual learning grants to up to 6 classes a year for tuition reimbursement as well as on-line learning access

• Generous PTO and vacation time to balance your work and life

• Additional 8 hours of PTO for volunteer work

• Retirement plan (401(a)) and traditional Roth (403b) with company contribution

• Commuter Benefits, Pet Insurance, 1 year subscription to Calm App

ETS is mission driven and action oriented

• Diversity, equity, inclusion, and belonging is at the forefront of the ETS employee's daily work. To further foster an inclusive environment ETS is home to a wide variety of Affinity groups that celebrate the diversity of our talented employees.

• How about cultivating growth, innovation, and continuous transformation for the next generation of rising professionals as leaders? ETS offers multiple Business Resource Groups (BRG) for you

• Are you passionate about volunteering and being active in your career and community? ETS offers our Center for Advocacy & Philanthropy (CAAP) where we encourage ETS employees to become active volunteers in their communities and schools through the ETS Cares Giving Campaign. Our employees can support any 501c3 or eligible charity of their choice.

ETS is an Equal Opportunity Employer comprised of people with different experiences, strengths, and backgrounds who share a passion for advancing quality and equity in education. We are dedicated to building teams that reflect the various backgrounds, experiences, and identities of those we serve. The Talent Acquisition team strives to ensure candidates enjoy a fair and equitable hiring process. We believe our differences empower us to be a better team, making better decisions and delivering better results.