▶Apply
Database Consultant
Trillium Professional is now seeking a Database Consultant for work in Boston. This is a hybrid position.
Responsibilities
1. Design and develop SQL tables, views, stored procedures, functions, and triggers to support reporting,
analytics and business logic.
2. Support ETL processes and automation for integrating internal and external data sources.
3. Design and implement data pipelines to facilitate smooth data transfer and integration across systems.
4. Collaborate with the Data Czar and Data Management Team to establish data validation rules and quality
control measures.
5. Monitor technical metrics to track progress, assess project success, and inform future improvements.
6. Follow established business, technical, and project policies aligned with OSD, A&F, and EOTSS guidelines
for data management best practices.
The ideal candidate may also be expected to:
7. Assist in implementing best practices for indexing, partitioning, and query performance tuning, data
nomenclature, and process standardizations to optimize data organization and system performance.
8. Translate functional requirements into technical design documentation.
9. Manage the project’s relational database models and schemas, ensuring they are aligned with business
needs.
10. Document data models, integration process, and best practices to maintain system transparency and
knowledge sharing.
Pay rate is $75 per hour. Apply now!
Qualifications
1. 8+ years of experience in SQL server database design, administration, and optimization
2. Expertise in SQL programming including writing procedures, functions, and triggers.
3. Strong expertise in SQL for querying, reporting, and data extraction with experience exporting and
importing data from formats such as Excel (.xlsx) and CSV.
4. Proficiency in data modeling, ETL processes, and system integration (including data from both internal and
external systems).
5. Familiarity with data pipeline design and management to facilitate smooth data flow.
Operational Services Division 3 of 3 3/19/2025
6. Strong understanding of data validation controls and ensuring data consistency across systems.
7. Familiarity with public sector data systems (preferred)
8. Familiarity with Qlik and Microsoft PowerBI (preferred)
Skills
• Problem solving with a strong analytical approach to database performance, system integration, and
automation.
• Ability to collaborate effectively with cross-functional teams (e.g., data management, development, and
business teams.)
• Experience with data governance and ensuring alignment with organizational data management standards
Trillium has been recruiting and placing professionals for over 30 years. From Fortune 100 companies to small businesses, our philosophy remains the same: to achieve excellence by providing quality employees and an uncompromising level of service. We believe in honesty, integrity, and a simple philosophy of providing value to our customers and our employees. We strive to be unsurpassed in the recruitment and placement of quality and skilled professionals. Trillium is an Equal Opportunity Employer.
Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for the employers and the California Fair Chance Act.
By applying to this job, I agree to receive electronic communications including SMS text and email regarding future opportunities, referral bonus incentives, and other promotions from Trillium. You may opt out at any time from future communications by responding STOP to any electronic communication.
You may view our full privacy policy at https://trilliumstaffing.com/jobs/privacy/.
Trillium offers a comprehensive benefit package that includes the ability to participate in health insurance and retirement plans, paid holidays, state required leave, and vacation days, if applicable. Trillium’s offerings are dependent on the state in which the assignment is located, length of time worked, and may change depending on assignment. Benefit packages for direct hire placements vary based on the client company.
Contact Us if you have any questions
Our intentions are to fill job vacancies as quickly as possible with qualified candidates. We are always accepting applications if a time sensitive job has an application deadline it is noted in the job description. Click on "Apply" to begin the apply process.
