ETL/ Data Warehouse Developer #2846 (Job #5817)

Unclassified - Richmond, VA

Full-time

Richmond, VA

About the position

SLAIT Consulting is seeking an ETL/Data Warehouse Developer for a contract-to-hire position in Richmond, VA. The role involves working with SAS Business Intelligence tools and data warehouse systems to enhance business decision-making capabilities. The developer will collaborate with business analysts and clients to design and implement BI architectures, ensuring that solutions meet performance and functional requirements.

Responsibilities

• Interact with Business Systems Analysts, users, and business leads to understand business needs.
• Provide technical guidance to Business Analysts and end users to address business functional requirements.
• Understand the source data components and their integration, both relational and dimensional.
• Review and approve technical specifications provided by Business Systems Analysts.
• Design and implement BI architectures based on business, data, and functional requirements.
• Deliver the BI high-level design document for program and development team review.
• Conduct deployment and integration testing of developed components in Development and Test environments.
• Support QA, resolve issues, and release fixes during UAT and production support when required.
• Develop, maintain, document, and manage BI Solutions using Business Object, SAS, and Spotfire.
• Develop, maintain, document, and manage custom data delivery systems for large-scale business intelligence initiatives.
• Collaborate with other BI developers, data architects, clients, and database administrators to design and develop high-performing BI solutions.
• Ensure solution designs address performance requirements, reusability, availability, integrity, security challenges, and business functional requirements.
• Provide work estimates and communicate any changes in scheduling proactively.
• Prepare Business Objects system landscape to provide end-to-end BI architecture solution for the project.
• Design universes to provide a semantic layer between Business Intelligence reporting tools and various data marts.
• Create and maintain Universes based on user requirements and data sources with measures and dimensions objects, join conditions, filters, LOV, cardinality, aliases, contexts, and aggregate awareness.
• Select the appropriate reporting tool at the onset of a reporting project and document the rationale for the decision.
• Evaluate and review deliverables from peers.
• Perform all other duties assigned by the manager or supervisor.

Requirements

• 3+ years of experience working with SAS Business Intelligence (BI) tools; SAS Web Report Studio, SAS Cube Studio, and SAS Information Map Studio.
• 2-4 years of experience working with data warehouse systems and a solid understanding of the data warehouse life cycle.
• Demonstrated experience with multi-dimensional data structures.
• Familiarity with traditional Oracle development tools.
• Experience with development of basic PL/SQL procedures to support data aggregation.
• 2+ years of experience working with clients to define and develop BI applications that enhance business decision-making capabilities.
• Proven ability to develop a clear understanding of client needs and incorporate them into a BI solution.
• Bachelor's degree in Computer Science, Information Systems, or related field or equivalent experience.
• Excellent communication and cross-team coordination skills, including strong oral, written, and presentation skills.

Nice-to-haves

• Ability to mentor and provide guidance to junior team members.