Senior Database Developer

This position is exempt and offers a remote work model. This position does not qualify for sponsorships now or in the future. As the Senior Database Developer, you will serve as the hub of all database services activity in the Association, including database design, development, performance tuning, administration, ETL, and support, by providing technical expertise and leadership. Job Description General Responsibilities Assists other database team members in executing all data services operations. Ensures database architectures address business requirements, system scalability, performance, governance, and reliability. Leads development of database applications, interfaces, data transfer mechanisms, and business intelligence platforms. Develops methods for data ETL and reporting to meet business requirements and goals. Develops, implements, and enforces data security controls and procedures. Develops, implements, and supports data integrity processes and infrastructure. Integrates new systems with existing DataMart structure. Provides technology leadership on specialized software efforts. Executes discovery and initial estimation phases of a software request. Works with project teams to ensure that data retrieval and reporting methods meet business requirements for project completion. Identifies opportunities for efficiency improvements and optimizes performance. Assists with research and development of new database tools, languages, and platforms and provides a valid recommendation to senior management. Manages and provides guidance, training, and mentoring for new team members. Performs peer reviews of programming and changes of other team members. Acts as project leader on certain system development projects. Develops project scope and plan, and coordinates tasks to ensure deliverables meet time and cost expectations. Documents database procedures to improve repeatability within the team. Works with development team to ensure consistency in processes and completion of deliverables among team members. Performs design and code. Exhibits leadership in cross-functional development practices. Job Requirements Bachelor’s degree in Computer Science, related technical degree, or the equivalent in work experience. 8 years of full SDLC experience utilizing SQL Server, Microsoft BI, Data Warehouse, Data Marts, and Reporting solutions deployed in AWS infrastructure. Advanced MS SQL Server knowledge, Microsoft BI stack, SSIS, SSRS, SSAS, Data Warehousing, Data Modeling, Meta-Data Management, Data Governance, Data Marts, OLTP, and ODS skills and abilities. AWS Redshift exposure for data marts and data warehouse preferred. Advanced expertise to understand and analyze business requirements Designs, develops, implements, and manages databases, packages, jobs, and gateways and handles environment specific deployments for scheduled releases. Ability to work both independently and within a team to build good working relationships, effectively manage multiple tasks, and promote interdisciplinary problem solving. Excellent customer service and communication skills as well as strong analytic and problem-solving skills. Experience in automating data ingestion, processing, and reporting/monitoring. Experience in AWS Data infrastructure (S3, Glue, Aurora MySQL, DMS) will be a strong plus. Proficiency in Python, SQL, Spark, and related Cloud ETL skills will be a strong plus. Job Type: Full-time Pay: $140,000.00 - $160,000.00 per year Benefits: 401(k) 401(k) matching Dental insurance Health insurance Life insurance Paid time off Professional development assistance Retirement plan Tuition reimbursement Vision insurance Compensation Package: Performance bonus Schedule: Monday to Friday Experience: AWS: 8 years (Preferred) Redshift: 5 years (Required) Metadata: 5 years (Preferred) Work Location: Remote