Senior Database Developer

Job Description

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