Bentley University is looking for a strong technical, creative, and motivated individual to join a motivated team in the IT enterprise reporting and analytics group. The Senior Data Engineer will report to the Director, Data and Analytics Operations and will be responsible for supporting ongoing mission critical efforts to develop a modern integrations and analytics environment as well as supporting day-to-day operations.
The ideal candidate will have excellent analytical skills and extensive experience in a modern enterprise data warehouse (DWH) environment. They will have solid hands-on experience with extract, transform and load (ETL) processes and tools. They will also have strong communications skills and the ability to work collaboratively with technical and non-technical staff in multiple business areas.
5-7+ years of experience working in data warehouse, ETL and data integrations environment
Proven experience with a commercial ETL product, for example, Informatica, Fivetran or other ETL tools.
Solid command of current data warehouse, reporting and analytics concepts and technologies.
Proven ability to troubleshoot ETL data mappings, data flows, and data transformations within the data warehouse environment.
Strong interpersonal and teamwork skills with both IT colleagues, business analysts, analytics staff and other report users at Bentley.
Ability to understand and synthesize data and transformation requirements working with business users.
Ability to work with IT development staff to understand (data) source applications and associated environments.
Ability to write, troubleshoot, and resolve issues with SQL.
Ability to document and communicate designs, analyses, and other plans both verbally and in writing.
Hands-on experience with at least one commercial relational database (for example, Oracle, SQL Server).
Experience with data reporting and analytical tools, e.g. Tableau, Power BI, etc.
Experience with cloud-based systems - SaaS, PaaS and understanding of industry-standard enterprise data management practices.
Knowledge of the impact of source system data management practices on the data warehouse environment.
Knowledge of modern, SaaS based integration tools such as Fivetran.
Knowledge of cloud based and SaaS data warehouse solutions (for example Snowflake or Microsoft Synapse).
Knowledge of Microsoft data management tools (for example, Azure Data Factory, Logic Apps).
Knowledge of analytics tools (for example Tableau, Power BI, or other similar toolsets).
Practical experience working in data management or data governance frameworks, and using tools to develop them in a small to medium sized environment (higher education experience preferred but not required).
Typical office setting with extensive sitting and computer work
Ability to travel around campus for meetings and other work related events
Bentley University requires references checks and may conduct other pre-employment screening.
Bentley University is an Equal Opportunity Employer, building strength through diversity. The University is committed to building a community of talented students, faculty and staff who reflect the diversity of global business. We strongly encourage applications from persons from underrepresented groups, individuals with disabilities, covered veterans and those with diverse experiences and backgrounds.
Internal Number: 133715061
About Bentley University
Bentley University is one of the nation's leading business schools, dedicated to preparing a new kind of business leader and one with the deep technical skills, the broad global perspective and the high ethical standards required to make a difference in an ever-changing world. To achieve our goal, we infuse our advanced business curriculum with the richness of a liberal arts education. The results are graduates who are making an impact in their chosen fields and turning their passions into success stories. Located on a classic New England campus just minutes from Boston, Bentley is a dynamic community of leaders, scholars and creative thinkers.