Computer Programmer Jobs

About The Position

Requirements

• BE or BS Degree in Computer Science, Information Technology or related field preferred
• 2 years SSIS and SSAS experience
• 2-3 years IT operation with strong understanding of database structures, theories, principles, and practices
• 3-5 years Microsoft SQL Server experience
• Minimum of 4 years working with systems design and support.
• 3 years' experience in complex relational data modeling
• 3 years of experience developing, testing and implementing new technical computer program solutions
• Experience developing new and modifying SSRS reports
• Experience in development and maintenance of T-SQL stored procedures, functions, and views to facilitate reporting
• Experience with data management and data processing flowcharting techniques
• Web API
• JSON
• Entity Framework
• Reporting Writing Microsoft SQL Server
• TSQL
• Store Procedures
• SSRS
• RDL
• Power BI
• SSAS
• Parameterized Reports and Report Designer
• Microsoft SQL Server
• Database Administration
• Database Tuning
• Database Management
• Database Security
• RDBMS
• Knowledge of reporting and query tools and practices
• API architecture
• Relational data modeling
• Experience working in a team-oriented, collaborative environment with ability to present ideas in user-friendly language
• Extensive knowledge and experience with Systems Development Life Cycle methodologies.
• Ability to prioritize and execute tasks in a high-pressure environment
• Self-motivated and directed, with keen attention to detail with ability to plan, organize and work on multiple tasks simultaneously

Nice To Haves

• Business Intelligence Analyst/Developer
• Multi-dimensional and OLAP modeling, star schemas, OLAP cube database design and concepts, and ETL (SSIS).

Responsibilities

• Ensures that applications are scalable, reliable, available and manageable.
• Crafts the correct architecture to solve the problems at hand.
• Provides continuous research and review of current and projected solutions to address the ongoing need for the agency.
• Works with internal and external IT staff to ensure that best practices as identified for the agency are being followed.
• Participates in the hiring of additional contract application developers as needed.
• Provides work direction to external contractor application developers.
• Creates and maintains the technical application architecture use by the BOPD.
• Works with external business partners to establish and or maintain a standardized integration solution/process.
• Provides application support.
• Responds to support tickets for Production Applications as well as ad hoc report requests.
• Design, code and implement computer programs for a variety of data processing needs.
• Creates and deploys new custom applications, databases, computer programs and reports.
• Perform analysis and modification of existing programs and operations to meet changing needs and to provide for system enhancements.
• Write maintenance and user documentation to support programs.
• Test and debug programs for accuracy and reliability.
• Instruct program users in proper operation.
• Provides estimates for additions/changes to Production Application.
• Works on production issues as needed.
• Analyze data and produce reports for a wide variety of applications.
• Develop customized reports from databases to extract and collect data according to end user and or management needs.
• Monitors application performance and provides solution and or recommendations on optimization as needed.
• Responsible for the performance, integrity and security of all agency databases.
• Creates and maintains database documentation, including data standards, procedures and definitions.
• Responsible for managing and testing back-up and recovery plans for agency databases.
• Oversee the development and organization of the databases, assessment and implementation of new technologies, and providing Information Technology with a long-term perspective on the relationship of database technology to the business opportunities facing the agency.
• Works on assigned projects designing and or deploying databases/tables, adding data fields and or tables to accommodate changes in agency needs.