Job Details

  • West Des Moines, IA, US
  • Various locations across US
  • Full Time
  • Bachelor's Degree (+16 Years)
  • Standard
  • Technology
  • None
  • 2019003

Job Description

Business Intelligence Developer

Apply

Job Duties

ePathUSA Inc. in West Des Moines, IA is seeking Business Intelligence Developers to create, maintain and implement warehousing and business intelligence applications and databases. Individuals will apply advanced-level knowledge of computer science and information theories, principles and concepts, as well as experience with business intelligence tools and technologies, in order to perform the following duties:

  • Develop and deploy online analytical processing (OLAP) cubes, monitoring full and incremental loads using Cube Wizard and manual methods.
  • Recommend software solutions and test, monitor and modify software.
  • Create ETL packages and load data into data warehouse by performing transformations using SQL integration services and SSIS/DTS packages.
  • Utilize best practices for package design, dataflow techniques, deployment and management in SQL Server Integration Services
  • Transform data using different transformations, including conditional split, join, merge, lookup, and derived column of SQL server Integration Services.
  • Improve SQL server performance by optimizing the queries using SQL Profiler.
  • Create objects, including tables, views, stored procedures and indexes and handle performance tuning using T-SQL.
  • Build reports in SSRS for errors generated in SSIS packages.
  • Design, develop and deploy reports in MS SQL Server environment using Reporting Services.
  • Format reports into documents using Report services for creation of dashboards.

Requirements

Master's degree in Computer Science, Computer Engineering, Information Technology, Engineering, Business, or a related field and three (3) years of experience in the job offered or in a related position. In lieu of the above-stated primary education and experience requirements, employer will accept a Bachelor's degree in Computer Science, Computer Engineering, Information Technology, Engineering, Business, or a related field and five (5) years of progressive, post-degree experience in the job offered or in a related position. Position also requires demonstrable knowledge and experience in the following:

  • Microsoft Business Intelligence Suite (SSIS and SSRS).
  • SSIS Data Flow items, including Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, and Pivot.
  • SSIS Control Flow items, including For Loop, execute package/SQL tasks, Script task, and Send mail task.
  • SQL Server Integration Services and Reporting Services.
  • Performance tuning using T-SQL.
  • Building EDW, Data Marts and Operational Data Store (ODS).

Any suitable combination of education, training or experience is acceptable. The term suitable, in this context, means substantial compatibility with stated academic requirements, experience and ability to perform job duties.

Additional Information

  • No Travel or telecommuting. Position is project-based at various unanticipated work sites within the U.S., and relocation may be required at the end of each long-term project.
  • Job Site: 1075 Jordancreek Pkwy, Suite 295, West Des Moines, IA 50266
  • Mail Resumes To: ePathUSA, Inc., ATTN: HR, 1075 Jordancreek Pkwy, Suite 295, West Des Moines, IA 50266
  • No calls or emails. EOE.
  • Must be legally authorized to work in the United States without sponsorship.
Apply
Logo Image
Logo Image
Logo Image
Logo Image
Logo Image
Logo Image
Logo Image