Our Client, a State Government Agency is looking for someone to join their team as a Data Analyst to join their team out of Everett, MA!
***This is a 9 month initial contract***
Responsibilities
- Collaborate with business research analysts to identify data needs.
- Create and document data marts and queries for business data needs, ensuring that resulting data match existing reports with fidelity.
- Write and review documentation to contribute to a business rules data handbook, capturing data rules in user-friendly language.
- Reverse engineer schemas and queries using available tools and methodologies, with the goal of understanding and documenting business rules that are applied in existing data loading processes.
- Translate complex problems into detailed specifications and design solutions using data processing systems.
- Create and maintain entity-relationship diagrams (ERDs) and perform database modeling, including logical, physical, and presentation tiers.
- Provide technical and database support for in-house applications, ensuring optimal performance and user satisfaction.
- Contribute to the knowledge base, sharing best practices and lessons learned with the Edwin team.
- Maintain code in GitHub, ensuring proper version control and adherence to coding standards.
- Accurately and promptly log all work, including estimates and time spent, in JIRA.
- Facilitate the adoption of efficient coding practices and innovative solutions.
Qualifications
- Understand data warehouse concepts and needs.
- Expert knowledge of databases, Snowflake a plus, also Oracle and SQL Server.
- Excellent communication skills with a demonstrated ability to communicate ideas clearly in both technical and user-friendly language, both in writing and orally.
- Strong attention to detail and troubleshooting skills for QA; able to identify errors/discrepancies, isolate the cause, apply solutions and validate the resulting data.
- Experience with dimensional modeling and knowledge of proper data structures for analytical reporting from an enterprise data warehouse.
