About this role
Job Requirements
Senior Database Administrator/Analyst (1099 Contractor)
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. The platform brings together surveillance, program performance, and funding data in a single repository and serves it to leadership and program staff through interactive Power BI dashboards. This role is the team's database expert: designing and enhancing the Azure Synapse warehouse, keeping the data model and data dictionary current, tuning performance, and ensuring the data remains secure, backed up, and reliable. You'll work closely with a data engineer who builds the pipelines that load your warehouse and with dashboard developers who depend on your data model, all within two-week agile sprints covering both new development and ongoing operations and maintenance. This is a fully remote role.
Your Responsibilities in this Role:
● Design, build, and enhance the Azure Synapse Dedicated SQL data warehouse, including tables, views, stored procedures, and the data loads that feed 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 so users see only the data their role allows, 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.
Work Experience
PROJECT SPECIFIC SKILL AND EXPERIENCE REQUIREMENTS
Required Experience
● 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.
Preferred Experience
● 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).
Physical Requirements:
- Ability to sit for extended periods while working on a computer or during meetings.
- Must be able to travel occasionally to client sites or company meetings, which may involve driving or flying.
- Ability to communicate effectively via phone, email, and in-person, requiring clear speech, listening, and written communication skills.
- Ability to move within an office environment, including reaching for files, using office equipment, and occasional light lifting (up to 10 pounds).
Benefits
Life at Fearless
We're a digital integration consultancy on a mission to build a better tomorrow. At Fearless, we combine technology, people, and organizational development to solve meaningful problems. Through iterative development, we deliver smart, user-friendly solutions that make technology work better—for everyone.
But great technology is only part of the story. What truly sets Fearless apart is our Purple Culture and our commitment to building meaningful partnerships with the people who help us deliver exceptional results.
What Makes Us Purple?
Whether you're a team member, contractor, or partner, our Purple Culture influences how we collaborate, communicate, and solve problems together.
Being Purple means you:
- Contribute to work that creates meaningful impact
- Collaborate with people who value curiosity, innovation, and continuous improvement
- Bring your expertise to challenging and rewarding projects
- Work with transparency, trust, and mutual respect
- Help create solutions that improve the lives of the people who use them
- Join a community committed to equity, inclusion, and belonging
We're proud to be an equal opportunity organization. We believe diverse perspectives make us stronger, and we welcome individuals from all backgrounds, experiences, and identities.
Compensation & Engagement Details
Fearless is committed to offering competitive contract rates that reflect the expertise, experience, and value our independent contractors bring to client engagements. Final rates are determined based on experience, qualifications, project requirements, and market considerations.
This position is structured as an independent contractor (1099) engagement and is not eligible for employee compensation programs or benefits.
Why Partner with Fearless?
When you partner with Fearless, you'll have the opportunity to:
- Contribute to mission-driven work that delivers meaningful outcomes
- Collaborate alongside experienced professionals across technology, delivery, design, and organizational development
- Apply your expertise to impactful client engagements
- Build relationships with a values-driven organization committed to excellence
- Work with a team that values autonomy, accountability, and results
- While independent contractors are not eligible for employee benefits, we strive to create strong partnerships that support successful outcomes for both our clients and our contractor community.
Independent Contractor Requirements
To engage with Fearless as an independent contractor, the following documentation must be provided prior to the start of work:
- Completed Form W-9
- Proof of General Liability Insurance
- Certificate of Insurance (COI)
- Compliance with any project-specific customer requirements, including background checks or security clearances, when applicable
Additional documentation may be required depending on the nature of the engagement.
Reasonable Accommodations
Fearless is committed to providing reasonable accommodations for applicants and candidates with disabilities. If a reasonable accommodation is needed to participate in the application or interview process, please contact the Human Resources Department at [email protected] .
So, What's Next?
We've refined our engagement process to ensure alignment between Fearless, our clients, and our contractor partners.
If there's mutual alignment, we'll reach out to begin the interview and evaluation process. Depending on the role or project, the process may vary slightly, but typically includes:
1. Introductory Conversation
We'll connect to:
- Learn more about your experience and expertise
- Discuss project requirements and expectations
- Review rate expectations and engagement details
- Answer any questions about Fearless and the opportunity
2. Skills Assessment (If Applicable)
For some engagements, we'll ask you to complete a role-specific assessment or work sample to better understand your capabilities and approach.
3. Skills & Business Fit Conversation
This conversation allows us to:
- Discuss relevant experience and project examples
- Explore your approach to problem-solving and collaboration
- Ensure alignment between your expertise and the engagement's needs
- Some engagements may also require customer interviews, background checks, or security clearance verification based on project requirements.
Where You Can Partner with Fearless
At Fearless, we’re proud to partner with talented independent contractors across the United States. We are currently able to engage 1099 contractors residing in all 50 states. For contractors who may be interested in future full-time employment opportunities with Fearless, please note that our current W-2 employment footprint includes the following states:
Alabama, Delaware, District of Columbia, Florida, Georgia, Maryland, New Jersey, New York, North Carolina, Ohio, Pennsylvania, South Carolina, Tennessee, Texas, and Virginia.
While contractor engagements are available nationwide, eligibility for future W-2 opportunities is contingent upon residing in one of our approved employment states at the time of consideration.
#LI-Remote