Senior Database Administrator / Analyst @Fearless
Data and Analytics
Salary unspecified
Remote Location
πŸ‡ΊπŸ‡Έ USA Only
Employment Type other
Posted Today

[Hiring] Senior Database Administrator / Analyst @Fearless

Today - Fearless is hiring a remote Senior Database Administrator / Analyst. πŸ’Έ Salary: unspecified πŸ“Location: USA

Role Description

At Fearless, we are seeking a part time, 20hrs a week, Senior Database Administrator / Analyst to own the cloud data warehouse behind a federal public health program's internal analytics platform. This role is the team's database expert, working closely with a data engineer and dashboard developers within two-week agile sprints.

  • Design, build, and enhance the Azure Synapse Dedicated SQL data warehouse, including tables, views, stored procedures, and data loads for Power BI dashboards.
  • Add new data sources and data elements to the repository as program needs evolve, and run impact analysis before schema changes.
  • Build and maintain the logical data model and data dictionary, and document data requirements for each dashboard view.
  • Define data refresh strategies and schedules, and contribute data items to sprint planning and backlog reviews.
  • Tune warehouse performance through distribution and partitioning strategy, indexing, statistics, and workload management.
  • Implement role-based and row-level security, along with encryption and access logging.
  • Maintain the backup and recovery plan, test restores, and coordinate with the agency's cloud platform team.
  • Validate data quality by identifying duplicates, errors, and inconsistencies, and document validation processes.
  • Prepare test data and support performance, security, beta, and user acceptance testing for each release.
  • Promote database changes from development to test to production following the agency's change and release processes.
  • Store all database code in source control using GitHub and keep technical documentation current.
  • Monitor repository health and usage, and report metrics that inform maintenance and improvements.
  • Follow federal data security, privacy, and governance requirements, including annual confidentiality training for HIV surveillance data.

Qualifications

  • Minimum of 8 years of experience in database administration, database development, or database analysis.
  • Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent work experience.
  • Ability to pass a federal background investigation and obtain public trust clearance.
  • At least 3 years of hands-on experience with Azure SQL data platforms, with Azure Synapse Analytics Dedicated SQL Pool strongly preferred.
  • Advanced T-SQL skills, including stored procedures, views, CTAS, and query performance tuning.
  • Demonstrated ability to design logical and dimensional data models for analytics and reporting, including star schemas and data dictionary maintenance.
  • Proven track record tuning performance in cloud data warehouses through distribution strategy, partitioning, indexing, and workload management.
  • Deep knowledge of database security implementation, including role-based access, row-level security, encryption, and audit logging.
  • Hands-on background managing backup, recovery, and restore testing in cloud environments.
  • Proficiency with Git-based source control and deploying database changes across development, test, and production environments.
  • Experience working on agile delivery teams, including sprint planning, backlog refinement, and user acceptance testing.
  • Clear technical writing for data models, data dictionaries, and other technical documentation.

Requirements

  • Azure Databricks and PySpark for data validation and transformation.
  • Power BI data models and working knowledge of DAX.
  • Azure DevOps for backlogs and CI/CD of database changes.
  • Azure Data Factory or other Azure data integration tools.
  • Azure Monitor and Log Analytics for health and usage monitoring.
  • Background supporting federal health agencies or public health programs, especially CDC enterprise cloud environments or surveillance data systems.
  • Familiarity with federal security and privacy practices, including FISMA, HHS policy, and Section 508 accessibility standards.
  • Microsoft certifications such as Azure Database Administrator Associate (DP-300) or Azure Data Engineer Associate (DP-203).

Benefits

  • Competitive contract rates based on expertise, experience, and market considerations.
  • Opportunity to contribute to mission-driven work that delivers meaningful outcomes.
  • Collaborate alongside experienced professionals across technology, delivery, design, and organizational development.
  • Build relationships with a values-driven organization committed to excellence.
  • Work with a team that values autonomy, accountability, and results.
Before You Apply
️
πŸ‡ΊπŸ‡Έ Be aware of the location restriction for this remote position: USA Only
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
Senior Database Administrator / Analyst @Fearless
Data and Analytics
Salary unspecified
Remote Location
πŸ‡ΊπŸ‡Έ USA Only
Employment Type other
Posted Today
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 140,000+ Remote Jobs
️
πŸ‡ΊπŸ‡Έ Be aware of the location restriction for this remote position: USA Only
β€Ό Beware of scams! When applying for jobs, you should NEVER have to pay anything. Learn more.
Apply for this position
Did not apply βœ“
Applied βœ“
Sent Follow-Up βœ“
Interview Scheduled βœ“
Interview Completed βœ“
Offer Accepted βœ“
Offer Declined βœ“
Application Denied βœ“
Unlock 140,000+ Remote Jobs
Γ—
Apply to the best remote jobs
before everyone else

Access 140,000+ vetted remote jobs and get daily alerts.

4.9 β˜…β˜…β˜…β˜…β˜… from 500+ reviews

⚑ 141,354+ remote jobs, refreshed hourly

πŸ”” Real-time alerts: Apply first, direct to employer

πŸ›‘οΈ Vetted companies, no scams, true remote only

Unlock All Jobs Now

Maybe later