Senior Database Analyst

$106,250 - $143,750/Yr

GD Information Technology, Inc. - Washington, DC

Full-time - Mid Level

Remote - Washington, DC

10,001+ employees

About the position

The Senior Database Analyst at GDIT will support the Administrative Office of the US Courts (AOUSC) Case Management Systems Office (CMSO) in mission-critical applications utilized by federal courts. This role involves working within an Agile development environment, collaborating with stakeholders to gather and define business requirements, and developing innovative data analysis techniques. The analyst will also be responsible for ensuring data accuracy, developing database management policies, and creating data visualizations to track key performance indicators.

Responsibilities

• Work within an Agile solution development environment with daily scrums and biweekly sprint planning.
• Collaborate with Product Owners and users to gather business requirements and map them to technical requirements.
• Meet with agency leaders and stakeholders to discuss innovative data analysis techniques.
• Develop standard operating procedures and best practices for performance, security, scalability, and maintainability.
• Analyze complex problems requiring in-depth evaluation of multiple factors and contribute to new business strategies.
• Collect, analyze, and interpret large amounts of data to guide business decisions.
• Use advanced statistical analysis, data mining, and predictive modeling techniques.
• Synthesize disparate information and recognize patterns across data.
• Ensure proper definition, control, and coordination of data elements and standards.
• Participate in the development and implementation of database management policies and standards.
• Conduct peer reviews of code from other developers on the team.
• Perform data validation to ensure data accuracy and integrity.
• Develop stored procedures, jobs, views, tables, and other database objects in SQL Server Management Studio.
• Design Data Models in Microsoft Excel Power Query and Dashboards in Power BI.
• Develop and deploy ETL packages using CI/CD pipeline.
• Work with Atlassian Suite of software development management tools.
• Index system and application logs in Splunk and create dashboards, alerts, and reports.

Requirements

• At least seven (7+) years of overall relevant experience.
• Bachelor's degree in Computer Science, Computer Programming, Computer Engineering or relevant computer-based major.
• Proficient experience with Databases like Microsoft SQL Server, Informix, Oracle.
• Experience with Snowflake and exposure to cloud platforms, preferably Azure.
• Demonstrated understanding of standard Data warehouse concepts.
• Adept with data modeling, data mapping, data flow diagrams, and data marts.
• Previous experience architecting and implementing cloud-based database solutions.
• Experience with Data migration from legacy on-premises database to multi-cloud/hybrid cloud platforms.
• Strong analytical, technical, and problem-solving skills.
• Excellent organization and time management skills.

Nice-to-haves

• Able to complete database environment installation and configuration.
• Experience creating and managing database reports, visualizations, and dashboards.
• Knowledge of court operations and law enforcement business data.

Benefits

• Medical plan options, some with Health Savings Accounts.
• Dental plan options.
• Vision plan.
• 401(k) plan with company match.
• Full flex work weeks where possible.
• Paid time off plans including vacation, sick and personal time, holidays, paid parental, military, bereavement, and jury duty leave.
• 15 days of paid leave per calendar year.
• 10 paid holidays per year.
• Paid Family Leave program providing up to 160 hours of paid leave in a rolling 12 month period.
• Short and long-term disability benefits, life insurance, and other insurance options.