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

Unclassified - Richmond, VA

Full-time

Richmond, VA

About the position

SLAIT Consulting is currently seeking an ETL/Data Warehouse Developer for a contract to hire position in Richmond, VA. The ideal candidate will have a strong background in SAS Business Intelligence tools, including SAS Web Report Studio, SAS Cube Studio, and SAS Information Map Studio, with at least 3 years of experience. Additionally, the candidate should possess 2-4 years of experience working with data warehouse systems and a solid understanding of the data warehouse life cycle. The role requires demonstrated experience with multi-dimensional data structures and familiarity with traditional Oracle development tools. The candidate should also have experience in developing basic PL/SQL procedures to support data aggregation and at least 2 years of experience working with clients to define and develop BI applications that enhance business decision-making capabilities. The successful candidate will be responsible for interacting with Business Systems Analysts, users, and business leads to understand business needs. They will provide technical guidance to Business Analysts and end users to best address business functional requirements. Understanding the source data components and how they integrate with each other, both relational and dimensional, is crucial. The developer will review and approve the technical specifications provided by the Business Systems Analysts and design and implement BI architectures based on business, data, and functional requirements. They will also deliver high-level design documents for the program and development team to review, and support QA, UAT, and production support when required. The role involves developing, maintaining, documenting, and managing BI solutions using Business Object, SAS, and Spotfire, as well as custom data delivery systems for large-scale business intelligence initiatives. The developer will partner directly with other BI developers, data architects, clients, and database administrators to design and develop high-performing BI solutions while ensuring that solution designs address performance requirements, reusability, availability, integrity, security challenges, and business functional requirements. Good time management techniques and proactive communication regarding scheduling changes are essential. The developer will also prepare the Business Objects system landscape to provide an 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, and create and maintain universes based on user requirements and data sources.

Responsibilities

• Interacted with the Business Systems Analysts, users and business leads to understand business needs.
• Provide technical guidance to Business Analyst and end user to best address business functional requirements.
• Understand the source data components and how they integrate with each other, both relational and dimensional.
• Review and approve the technical specifications provided by the Business Systems Analysts.
• Design and implement BI architectures based on the business, data and functional requirement.
• Deliver the BI high-level design document for program and development team to review.
• Deployment and integration testing of developed components in Development and Test environments.
• Support QA (resolve issues and release fixes), 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.
• Partner directly with other BI developers, data architects, clients, other technical data warehouse team members and database administrators to design and develop high performing BI solutions and maintain consistent development functions.
• Ensure solution designs address performance requirements, reusability, availability, integrity, security challenges, and business functional requirements.
• Provide work estimates and proactively communicate to the relevant parties any changes in scheduling.
• Prepare Business Objects system landscape to provide end-to-end BI architecture solution for the project.
• Design universes to provide 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, Aggregate Awareness.
• Select the appropriate reporting tool (CR 2011, CR for Enterprise, Webi) at the onset of a reporting project and articulate and document the rationale in the decision making.
• Evaluate and review deliverables from peers.
• Perform all other duties assigned by the manager and/or supervisor.

Requirements

• 3+ years experience working with SAS Business Intelligence (BI) tools; SAS Web Report Studio, SAS Cube Studio and SAS Information Map Studio.
• 2-4 years experience working with data warehouse systems and a solid understanding of the data warehouse life cycle.
• Demonstrated experience with multi-dimensional data structures.
• Familiar 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.
• A proven ability to develop a clear understanding of clients' needs and the ability to 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.
• Solid oral, written, and presentation as well as strong interpersonal skills are required.
• A team player with the ability to mentor and provide guidance to junior team members.