Database Programmer/Analyst

17 Aug 2024

Vacancy expired!

Our client, a leading provider of computing, applications management, IT procurement, network, and telecommunications services to public organizations, is looking to hire a Database Programmer/Analyst.

Key Responsibilities. The Contractor shall provide documentation to the Project Manager. This documentation must provide details on the work provided and at a level a client employee can use the information to support the work at the end of the contract The Contractor shall submit detailed status reports or participate in weekly status meetings as required by the client during the engagement The Contractor shall attend required meetings with the required project stakeholders as directed by the client. These meetings will be scheduled by a client employee. All questions and communication should go through the Project Manager. If the Project Manager is not available, he will designate a client employee for the communication Contractor shall retain all work papers generated for reference through the duration of the project and project acceptance Contractor shall respond to all telephone calls, voicemail, and e-mail inquiries from the client within one business day.

Requirements and Skills. Strong requirements gathering skills: ability to work with customers to gather reporting requirements and translate into a data model for reporting using Tableau, Power BI, and Ad-hoc queries Strong administrative skills including repository management and knowledge of best practices regarding aggregate tables and data marts Azure and Data Warehouse ETL Skills. Experience working on Azure and implementing reporting layer tables using ETL logic which pulls data from an Oracle or SQL Server database Experience working with star schemas and loading reporting layer table Preferred experience with Informatica or IICS or similar ETL tool Business Intelligence Skills. Experience creating dashboards using Tableau or Power BI. Experience working with the creation of data sources and actual implementation of visualization dashboards Strong oral and written communication skills working with both business users and technical staff. The contractor shall demonstrate their understanding of the overall project goals and the specific goals as pertains to the contractor s assignment for this project to the satisfaction of the Project Manager The contractor be able to advise and provide guidance on the requested work The contractor shall develop, maintain, and support Extract Transform and Load processes which are written using Informatica and SQL The contractor shall use Informatica and SQL to load the client Data Warehouse tables and generate Ed Facts files for federal reporting The contractor shall thoroughly test and document each step taken and perform knowledge transfer to the client staff.

Who is Calance?Calance is a global IT company with operations in the United States, Canada and India. Over the years, Calance has grown organically and has acquired numerous successful IT Services firms along the way. As a result, the company today is a mix of diverse cultures, talents and expertise that collaborate globally to bring our best capabilities and thinking to clients. Calance also offers benefits which includes Medical, Dental, Vision care and 401K.

Calance - the place to grow.www.calance.com

  • ID: #44947449
  • State: Colorado Denver 80203 Denver USA
  • City: Denver
  • Salary: USD TBD TBD
  • Job type: Contract
  • Showed: 2022-08-17
  • Deadline: 2022-10-15
  • Category: Et cetera