Business Intelligence Engineer

5 months ago


Hoboken, United States Stevens Institute of Technology, The Innovation University Full time
Job Description

Business Intelligence Engineer

The Office of Institutional Research and Effectiveness (IRE) at Stevens is inviting applications for the position of Business Intelligence Engineer to join a team of talented colleagues. Under the supervision of the Associate Director, the Business Intelligence Engineer will design, develop, and support Business Intelligence solutions to turn data into actionable insights supporting university decision making, analytics, and research. An ideal candidate should be extremely data-savvy, and should have solid skills in data modeling, data transforming procedure, and overall business intelligence solutions.

Responsibilities
  • Assemble large, complex data sets that meet functional/non-functional business requirements. Work with subject matter experts to design and develop data models, security structures and reports across subject areas and technical domains. Identify, design, delegate and implement internal process improvements: automate manual processes, optimize data delivery, re-design infrastructure for greater scalability, etc.
  • Create and manage complex SQL queries, stored procedures, and other database objects. Transform data in the warehouse using dbt.
  • Perform data analysis, design, and development of new and ongoing business intelligence (BI) tools (such as Power BI, Tableau) involving complex data structures.
  • Build machine-learning algorithms, models, reports, etc., to meet business outcomes and KPIs.
  • Plan and conduct data analysis efforts, facilitate design sessions, and collaborate with technical staff, and critical business sponsors to identify and recommend solutions. Initiate or update designs for models supporting data warehouse functionality. Coordinate reviews of data models and data definitions.
  • Establish and maintain best practices for the design, development and support of BI solutions including self-service analytics, documentation, metadata creation, use and maintenance, and data naming standards.
  • Monitor and take appropriate action to maintain the integrity of the reporting solutions, including security and data quality issues. Respond and resolve operational problems as necessary. Document, troubleshoot, and resolve day to day data issues.
  • Maintain a considerable knowledge base of various types of institutional data stored in Workday (Stevens' student information system), and IRE data repositories, such as student admissions, enrollment, degree data, course data, and faculty data.
  • Assist with data collection and dashboard design for all aspects of external data reporting (IPEDS, state reports, college guidebooks, consortium exchange, etc.), and internal reports for academic and administrative units, such as the weekly enrollment census report, the annual benchmarking report, and other institutional analyses.
  • Process, clean, and validate the integrity of data to be used for analysis.
  • Analyze large amounts of information to find patterns and solutions.
  • Document all aspects of data science procedure, with special attention to data retrieval, programming, workflows, and security.
  • Proactively and continuously pursue professional development and training
  • Perform other duties as assigned.
Breakdown of Essential Duties and Responsibilities
  • 50%: Data warehouse, ETL, and BI development
  • 25%: Data validation and analysis
  • 15%: Support BI Solutions and assist with data collection for internal and external data reporting
  • 10%: Other duties as assigned in support of overall Institutional Research and Effectiveness strategic goals
Qualifications
  • Bachelor's degree in business, computer science, data sciences, information systems, statistics, or similar discipline.
  • 4+ years of Business intelligence development experience. Advanced knowledge and deep expertise in designing data models and developing BI reports.
  • Design, Develop and maintain data models, reports, and dashboards (Power BI/Tableau).
  • Experience collecting business requirements and building reporting solutions to convert raw data into usable information for analysts and business users.
  • Experience with implementing complex row-level and object-level security in Power BI/ Tableau.
  • Solid command of relational and dimensional database concepts and principles, data modeling, data warehouse design, data management, data analytics and business intelligence methods, and data integration techniques.
  • Strong written and documentation skills for communicating specifications, processes, and metadata to both technical and non-technical audiences
  • Familiarity with machine learning concepts.
  • Should be knowledgeable about data quality and governance issues and requirements.
  • Professional experience in higher education preferred.
  • Strong organizational, prioritization, and planning skills with an ability to work on multiple projects simultaneously and collaboratively with cross-functional units.
  • Sound independent judgment and decision-making.
  • Strong analytical and problem-solving skills with high attention to detail.
**This position is predominantly remote. **

Department
Institutional Research

General Submission Guidelines:

Please submit an online application to be considered a candidate for any job at Stevens. Please attach a cover letter and resume with each application. Other requirements for consideration may depend on the job.

Academic Submission Guidelines:

Please submit:
  • Cover letter
  • Curriculum vitae
  • Research statement
  • Teaching statement that includes a) teaching interests, b) teaching philosophy, and c) a plan on how to create an inclusive environment for students of all backgrounds in terms of classroom teaching, student advising, and graduate student mentoring
  • Contact info for at least 2-3 references (school-specific; please refer to job posting)


Still Have Questions?

If you have any questions regarding your application, please contact Jobs@Stevens.edu.

EEO Statement:

Stevens Institute of Technology is an Equal Opportunity Employer. Accordingly, Stevens adheres to an employment policy that prohibits discriminatory practices or harassment against candidates or employees based on legally impermissible factor(s) including, but not necessarily limited to, race, color, religion, creed, sex, national origin, nationality, citizenship status, age, ancestry, marital or domestic partnership or civil union status, familial status, affectional or sexual orientation, gender identity or expression, atypical cellular or blood trait, genetic information, pregnancy or pregnancy-related medical conditions, disability, or any protected military or veteran status.

Stevens is building a diverse faculty, staff, and student body and strongly encourages applications from people of all backgrounds. Stevens is a federal contractor under the Vietnam Era Veterans' Readjustment Assistance Act (VEVRAA) and the Rehabilitation Act of 1973, as well as other federal statutes.

NSF ADVANCE Institution Stevens values diversity and seeks candidates who will contribute to a welcoming and inclusive environment for students, faculty, and staff of all backgrounds. We are an NSF ADVANCE institution committed to equitable practices and policies and strongly encourage applications from women, racial and ethnic minority candidates, veterans, and individuals with disabilities.

Jeanne Clery Disclosure:

In accordance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act (Clery Act), the Department of Public Safety is required to publish an annual security report which includes statistics mandated by the Clery Act. Click here for a copy of this report.

  • Hoboken, New Jersey, United States Wal-Mart Associates, Inc. Full time

    Job Title: Senior Business Intelligence DeveloperAbout the Role:Wal-Mart Associates, Inc. is looking for a highly skilled Senior Business Intelligence Developer to join our team. As a key member of our analytics team, you will be responsible for driving the design, development, and testing of e-commerce datasets, applications, and pipelines using SQL, SAP,...


  • Hoboken, United States System One Full time

    BUSINESS INTELLIGENCE ARCHITECT – Azure Analysis Services AAS Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $75/hr. W2 for the contract period. Benefits available Annual Salary Range: $130,000 to $150,000 annually plus benefits. ALTA IT Services has a contract-to-hire opening for a Business Intelligence Architect with at least...


  • Hoboken, United States ALTA IT Services Full time

    BUSINESS INTELLIGENCE ARCHITECT – Azure Analysis Services AAS Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $75/hr. W2 for the contract period. Benefits available Annual Salary Range: $130,000 to $150,000 annually plus benefits. ALTA IT Services has a contract-to-hire opening for a Business Intelligence Architect with...


  • Hoboken, United States System One Full time

    BUSINESS INTELLIGENCE ARCHITECT – Azure Analysis Services AASContract to HireWork Location: Hybrid work in Jersey City, NJHourly Rate: $75/hr. W2 for the contract period. Benefits availableAnnual Salary Range: $130,000 to $150,000 annually plus benefits.ALTA IT Services has a contract-to-hire opening for a Business Intelligence Architect with at least 12...


  • Hoboken, New Jersey, United States System One Full time

    Job DescriptionWe are seeking an experienced Senior Business Intelligence Developer to join our team at System One. The ideal candidate will have a strong background in data warehousing and business intelligence solutions, with expertise in designing, developing, and supporting large-scale data warehousing and ETL processes.ResponsibilitiesDesign, develop,...


  • Hoboken, United States ALTA IT Services Full time

    BUSINESS INTELLIGENCE ARCHITECT – Azure Analysis Services AASScroll down to find an indepth overview of this job, and what is expected of candidates Make an application by clicking on the Apply button. Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $75/hr. W2 for the contract period. Benefits available Annual Salary Range:...


  • Hoboken, New Jersey, United States System One Full time

    System One is seeking a highly skilled Data Warehouse / ETL Developer with 8+ years of experience in designing, developing, and supporting Data Warehouse and ETL processes. The ideal candidate should have strong skills in SSIS, SSAS, SSRS, and T-SQL, along with experience working with Azure data platforms and business intelligence tools like Power BI or...


  • Hoboken, New Jersey, United States Pan Asia Resources Full time

    Pan Asia Resources is seeking a Business Intelligence Specialist to join our team. The ideal candidate should have 5-7 years of experience in ETL, SQL development, and Power Shell scripting, and should be proficient in ASP.Net, MVC, and SQL Server.The successful candidate will be responsible for writing queries, modifying existing SSIS packages, and...


  • Hoboken, New Jersey, United States System One Full time

    At System One, we're seeking a seasoned Business Intelligence Architect to drive our data-driven decision-making process.This role is an exciting opportunity for a highly skilled professional with expertise in designing and implementing large-scale business intelligence solutions using Azure Analysis Services.We're looking for someone who can lead the...


  • Hoboken, NJ, United States System One Full time

    BUSINESS INTELLIGENCE DEVELOPER – COGNOS Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $60/hr. W2 for the contract period. Benefits available Annual Salary Range: $120,000 to $130,000 annually plus benefits. ALTA IT Services has a contract-to-hire opening for a Business Intelligence Developer with a minimum of 10 years of...


  • Hoboken, NJ, United States ALTA IT Services Full time

    BUSINESS INTELLIGENCE ARCHITECT - Azure Analysis Services AAS Scroll down to find an indepth overview of this job, and what is expected of candidates Make an application by clicking on the Apply button. Contract to Hire Work Location: Hybrid work in Jersey City, NJ Hourly Rate: $75/hr. W2 for the contract period. Benefits available Annual Salary Range:...


  • Hoboken, New Jersey, United States Stevens Institute of Technology, The Innovation University Full time

    About Stevens Institute of TechnologyStevens Institute of Technology is a premier private research university located in Hoboken, New Jersey. With a rich history dating back to 1870, Stevens has evolved into a world-renowned institution for innovation and academic excellence.Job SummaryWe are seeking a highly skilled Business Analyst to join our Data,...


  • Hoboken, New Jersey, United States Wal-Mart Associates, Inc. Full time

    Job OverviewWe are seeking a skilled Data Analytics Lead to join our team at Wal-Mart Associates, Inc. This role involves leading the design, development, and testing of eCommerce datasets, applications, and pipelines using various technologies.About the RoleAs a Data Analytics Lead, you will be responsible for driving business growth by analyzing large...


  • Hoboken, New Jersey, United States Insight Global Full time

    In this role, you will work closely with stakeholders to understand their business needs and provide them with actionable insights through data analysis and visualization.

  • Senior SSIS Engineer

    2 weeks ago


    Hoboken, New Jersey, United States Pan Asia Resources Full time

    Pan Asia Resources is looking for a Senior SSIS Engineer to lead our Business Intelligence team. The ideal candidate should have 5-7 years of experience in ETL, SQL development, and Power Shell scripting, and should be proficient in ASP.Net, MVC, and SQL Server.The successful candidate will be responsible for writing queries, modifying existing SSIS...


  • Hoboken, New Jersey, United States Walmart Full time

    **Company Overview:**    Walmart Connect is a key component of Walmart's growth strategy, driving measurable outcomes for suppliers, sellers, merchants, and advertisers using full-funnel ad solutions that leverage in-store and online data.**Competitive Pay and Benefits:**    We offer competitive pay, performance-based bonus awards, and great benefits...


  • Hoboken, New Jersey, United States Ernst and Young Full time

    Ey is a global leader in assurance, consulting, law, strategy, tax and transactions. Our teams ask better questions to find new answers for the complex issues facing our world today.Key ResponsibilitiesAs an Artificial Intelligence Solutions Architect, you will work with a variety of clients to deliver cutting-edge data science and big data technologies...

  • AI Engineering

    3 weeks ago


    Hoboken, United States Ernst and Young Full time

    At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better. Join us and build an exceptional experience for yourself, and a better working world for all.The...


  • Hoboken, New Jersey, United States Insight Global Full time

    **About Insight Global**We are a leading provider of digital solutions, dedicated to building cutting-edge customer-facing experiences. Our team is on a mission to revolutionize the way customers manage their prescriptions & medications.

  • SSIS Developer

    4 weeks ago


    Hoboken, United States Saxon Global Full time

    Saxon Global is one of the fastest growing Inc 500 Companies in the US, providing enhanced IT consulting and engineering solution services for the past 16 years. Saxon Global specializes in Business Intelligence, Mobility, Big Data & Cloud and provides IT tools and services to help organizations across industry verticals such as Financial Services, Retail,...