Occam Solutions is hiring for a Senior Web Programmer with extensive experience in Structured Query Language (SQL), Server Reporting Services (SSRS), and Power Business Intelligence (BI) Stack).
About Occam:
Founded in 2004, Occam Solutions is a leader in Data Science, Software Development, and Mission Support services to the both the civilian and defense sectors of the US government. We provide thought leadership, technical resources, and know-how leveraging in-depth industry experiences to provide simple and effective solutions.
The ideal candidate would have a background in both Technology and business / accounting or finance.
They would have strong experience in database concepts including design, schema, views, tokenization
with any mainstream product such as Oracle etc. Strong expertise in SQL including ability write and tune
complex queries as well as experience in data analysis, reporting, and business intelligence. They
would have the ability to work with large datasets and analyze complex data and experience with data
visualization tools such as Tableau or Power BI.
Responsibilities:
- The Senior Web Developer works collaboratively with NSWC to develop reporting systems that provide accessible information for decision-making. The Senior Software Developer uses the data platform and associated databases to solve organizational problems through reports, analysis, and data visualization.
- The Senior Software Developer will also provide data warehouse expertise with an emphasis on data design, access, usage, security, and quality of information assets.
- They will design and develop technical requirements, deployment documents, and other supporting mechanisms for soliciting and documenting business requirements.
- The candidate works collaboratively on project teams, systems and data analysis, design, development, integration, and enhancement activities, as well as related maintenance and more complex production support.
- The candidate builds and modify database tables and views and optimize SQL queries, indexes.
- The candidate contributes to the creation and maintenance of reporting best practices and standards.
- The candidate monitors and triage report development request queue tickets. The candidate review reporting requests, release plans, and enhancement requests for impact and prioritization.
- Minimum of five years in the development and deployment of distributed relational databases and associated BI systems
- Minimum of five years of experience with the Microsoft SQL server stack, Microsoft SQL, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL SSRS
- Minimum of five years securing a SQL environment in accordance with DISA STIGs
- Minimum of five years SQL Server configuration management, optimization, administration, development in client/server architecture, business object modeling and relational database design using MS SQL Server
- Experience with IBM Cognos and other On-Line Analytical Processing (OLAP) tools of reports / OLAP analysis from WCF funding and cost information
- Experience in Navy Security requirements implementation and their impacts to overall• Experience with Microsoft Power BI software architecture
- Experience leading and designing Service Oriented Architecture (SOA) based application
- Understanding of Navy Working Capital Fund (WCF) accounting principles and generation