The role of the Data Warehouse Developer requires a background in data warehousing for reporting and dashboards (Business Objects), strong SQL skills (MS SQL Server), ETL (Data Integrator), debugging capabilities, strong team oriented work ethic, and an understanding of business objectives. This role provides access to essential data for multiple reporting and functional applications. This includes Business Objects, JD Edwards and our proprietary applications Acuity, Acuity Connect and Pulse. The analyst will create, maintain and grow products and services that help us achieve our critical strategic initiatives.
Demonstrate a systemic thought process through all phases of software development.
Participate in open discussions during the analysis and design phases of development.
Create and Maintain
Optimize current databases, indexes, and stored procedures.
Create and maintain ETL processes using Data Integrator.
Create and maintain technical documentation when developing solutions.
Maintain and enhance existing software using the SDLC process.
Build a good rapport and maintain positive relationships with other team members, business analysts, outside customer contacts, and users.
Create efficient and scalable code.
Understanding business objectives.
Create well documented code.
Follow and contribute to software development best practices.
Participate in and conduct code reviews.
Supervisory Responsibility: Direct and Indirect
Must maintain confidentiality as this position has access to data used to operate the business.
Must possess the ability to take ownership over a task, demonstrating good organizational and time management skills.
Works independently, but meets with manager weekly to review projects.
Level of Analytical Thinking and Problem Solving Required
Must understand the abilities and limitations of various software platforms used within Best Vendors. This would include limitations with the database, language, device or end user capabilities.
Must be able to suggest solutions or alternatives when faced with complex business requirements or bug fixes.
Level of Judgment and Decision Making Required
Works on a combination of assigned and self-initiated projects, which could include ways to improve current solutions or processes.
Makes recommendations and takes action on improving system operations, performance and data integrity.
Understands usability and the end user experience, so to design a solution that will maximize the user experience.
Education and Experience
Bachelor's degree or combination of job experience and related course work (3-5 years business data experience).
Knowledge, Skills, and Abilities
Word, Excel, and Outlook.
Works with management, analysts, and users to gather requirements and discuss solutions.
Will be required to attend design and planning meetings.
Maintain positive relationship with other sectors and users.
This position has no supervisory responsibilities.
Including adverse and/or potential hazard (representative of that which an Associate encounters performing the essential functions of the job).
General office environment.
Must be able to sit for long periods of time in front of a computer.
Must be able to handle a stressful environment.
Apertus Partners is a Woman Owned Small Business, Professional Services firm headquartered in Northern VA and serving the continental US. With over two decades of industry staffing experience, we hit the ground running with our direct approach to finding success. From general concept through implementation and operational support, Apertus Partners traditional staffing services include Contract, Contract to Hire and Permanent placement to both Government and Commercial clients. At Apertus Partners, we take care of our consultants and clients. You are our business. Our goal is to develop strong relationships with our clients to understand and meet the needs of their unique environments. Our existence relies upon our qualification process which allows us to understand what our consultants' career aspirations and goals are in order to match them to the appropriate position. Our goal is to place our consultants in the right position in the shortest time, consistently, with quality.