Data Warehouse Developer

  • Full-time

Company Description

Webtellect operates with the zeal of a start-up, to provide expert software design and development services to a suite of clients. We are not the firm where folks can put the feet up, enjoy a paycheck, and mill around the water cooler.  We are the firm that is passionate about technology, and utilizing such in the pursuit of solving business and real-world challenges.  Work hard, play harder.  Our clients have defined budgets and we are held to higher expectations.  We have various vertical markets we attack offering relevant solutions, and therefore we do not live and breathe in only a "single technology" or "one-technology-fits-all mindset."  Each project potentially offers something new.  We have a driving passion for software excellence.  Feathers in our cap includes the development of interactive exhibits for the Visitor Center of the world’s largest philanthropic organization, custom enterprise platform development for the largest drilling company in the U.S. Oil and Gas industry, Medical Record solutions, and giving back to our community through various programs.

Job Description

  • Design, build, ship, and maintain Data Models to create new analytics capabilities for the business.
  • Serve as a subject matter expert spanning multiple business domains and data models.
  • Design and implement ETL code to source data into the Cloud Data Warehouse.
  • Work with project managers and business analyst leads to define and document requirements.
  • Participate in on-call rotation to monitor system activity and aid Operations Staff with break/fix issues.

Qualifications

  • Experience or exposure to Extract/Transform/Load (ETL) and/or Business Intelligence
  • Strong SQL skills
  • Skilled at completing technical design via iterative mockups
  • Openness to learning new skills and software as necessary
  • Demonstrated ability to manage simultaneous work flows while maintaining quality output and meeting deadlines
  • Demonstrated ability to learn new and exciting technologies with little assistance
  • Experience with ETL tools and procedures * Pentaho PDI
  • Experience with Unified Modeling Language (UML), including Entity-Relationship Diagrams (ERD), Sequence Diagrams, and Data Flow Diagrams (DFD)
  • Understanding of XML, SQL, Data Modeling Language (DML), and Data Definition Language (DDL)
  • Experience with creating Data Marts/ Enterprise Data warehouse
  • Experience with Pentaho BI Suite
  • Strong verbal and written communication skills with demonstrated ability to communicate at different levels of the organization
  • Ability to perform ad-hoc analysis and maintain clear and comprehensive documentation of decision-making, data preparation, and processes

Additional Information

Notes:

  • No 3rd parties.
  • Some travel required