Senior Database Analyst

o  Create, maintain, and tune quality SQL Server reporting deliverables using PowerBI and SSRS
o  Create, maintain, and tune complex T-SLQ SQL Server based custom reports and stored procedures
o  Create, maintain, and tune interfaces with SSIS based interfaces and stored procedures
o  Accurately develop MS SQL Server T-SQL database queries, reports, data loads/extracts in a logical manner from scratch.
seeking a Senior Database Analyst/Architect who has a deep experience with Oracle databases, data warehouses, retrieving and manipulating the housed data using ETL processing and complex SQL. The candidate should be able to quickly come up to speed on a complex database model, a database star schema architecture, and immediately contribute to development and/or support of Cognos reporting, complex SQL needs, business-requested reporting, extracts, loads, stored procedures, interfaces, ETL work, and an upcoming effort to upgrade our Oracle platform from Windows to Linux.
This individual will be working with one of our government partners who is in the process of modernizing their platform. The current database platform will remain and be heavily used. The candidate will primarily support our current platform with the intent to eventually move to expand support to our Azure based environment, where MS SQL Server is the current database platform. The candidate should also have experience with PowerBI, SSRS (SQL Server Report Services), and SSIS (SQL Server Integration Services).
Working in a very dynamic and fast-moving environment, the candidate will need to leverage strong problem-solving and analytical skills, organizational abilities, and attention to detail. The candidate will work with the client and team members to gather and validate requirements, validate designs, and develop database application solutions. Specific responsibilities may include:
Specific responsibilities may include:
Create, maintain, and tune complex PL/SQL queries and stored procedures
Create and maintain existing SQL based custom reports
Maintain complex data models
Create and maintain interfaces between on-premise Oracle environment and MS SQL Server on the Azure based platform
Review and interpret ongoing business report and interface requirements
Strong analytical and troubleshooting skills. Analyze existing data structures and queries and develop/update reports, queries, data loads, and interfaces.
Accurately develop database queries, reports, data loads/extracts in a logical manner from scratch.