Description

Design and develop ETL processes and interactive reporting solutions to support data-driven decision making.

Responsibilities

  • Design and develop SSIS packages to import and export data from SQL Server, MS Excel, Access, and flat files.
  • Architect table structures and build ETL processes, including the creation, enhancement, and modification of existing packages.
  • Develop application schemas using databases, tables, views, indexes, stored procedures, and user-defined functions.
  • Build, test, and deploy Power BI dashboards and interactive visual reports.
  • Optimize Power BI report distribution, execution, and scalability to ensure autonomous and dynamic reporting.

Required Skills

  • 5+ years of experience in ETL development and SQL Server management.
  • Proficiency in writing SQL and Transact-SQL statements.
  • Hands-on experience building and deploying Power BI reports.
  • Experience performing DAX queries and functions within Power BI.
  • Ability to architect database schemas, including tables, views, and indexes.
  • Experience providing production support for existing ETL processes.
  • Bachelor's degree in Computer Science, CIS, Computer Applications, IT-related Engineering, or a related field.
  • Willingness to undertake extended travel and/or relocation throughout the U.S.

Key Skills
Education

Bachelor's degree in Computer Science

Back To Jobs