What are the responsibilities and job description for the Database Analyst position at Brilliant Infotech Inc.?
Job Description
We are looking for a Database Analyst to implement and maintain data architecture solutions supporting research and enforcement initiatives.
Must have Skills: PostgreSQL, AWS, AWS QuickSight Experience
- Develop ETL routines within the silver layer of the research data lake
- Collaborate with research scientists to align business use cases in the gold layer
- Ensure data hygiene across all layers and document data flows
- Integrate new data sources and maintain transparency in data transformations
- Support business compliance tools and strategic enforcement initiatives
- Create pipelines for tracking wage theft violations and WALL implementation
- Implement validation protocols for data accuracy
- Develop predictive models and BI tools
- Standardize data flows and enforce data quality controls
Required
- 5 years of experience with SQL and relational DBMS
- Strong experience in ETL and data warehousing
- Proficiency in Python for data manipulation and automation
- Experience with AWS database ecosystem (Glue, Lambda, S3, Athena, Redshift)
- Working knowledge of BI tools and dashboard creation
- Ability to communicate technical concepts to non-technical stakeholders
- Strong documentation and collaboration skills
- Experience with data dictionary systems and electronic data processing platforms
Preferred
- PostgreSQL and AWS QuickSight experience
- Experience in government or regulatory environments
- Familiarity with Git and vendor-built database solutions
- Experience building or improving data pipelines