Company:
Mindlance
Location: Everett
Closing Date: 19/10/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Duties and Responsibilities:
This person will assist in expanding equitable access to data by facilitating the accessibility and understanding of Edwin, the state s education data warehouse, to education agencies and researchers. In addition to technical and troubleshooting expertise the role will require a strong desire to investigate, understand, and communicate findings to a variety of audiences. Collaboration with data architects and BI developers is a must as work progresses to expand Edwin and optimize the performance of reporting tools.
Responsibilities:
1. Collaborate with business research analysts to identify data needs.
2. Create and document data marts and queries for business data needs, ensuring that resulting data match existing reports with fidelity.
3. Write and review documentation to contribute to a business rules data handbook, capturing data rules in user-friendly language.
4. 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.
5. Translate complex problems into detailed specifications and design solutions using data processing systems.
6. Create and maintain entity-relationship diagrams (ERDs) and perform database modeling, including logical, physical, and presentation tiers.
7. Provide technical and database support for in-house applications, ensuring optimal performance and user satisfaction.
8. Contribute to the knowledge base, sharing best practices and lessons learned with the Edwin team.
9. Maintain code in GitHub, ensuring proper version control and adherence to coding standards.
10. Accurately and promptly log all work, including estimates and time spent, in JIRA.
11. Facilitate the adoption of efficient coding practices and innovative solutions.
Required qualifications:
1. Understand data warehouse concepts and needs.
2. Expert knowledge of databases, Snowflake a plus, also Oracle and SQL Server.
3. Excellent communication skills with a demonstrated ability to communicate ideas clearly in both technical and user-friendly language, both in writing and orally.
4. Strong attention to detail and troubleshooting skills for QA; able to identify errors/discrepancies, isolate the cause, apply solutions and validate the resulting data.
5. Experience with dimensional modeling and knowledge of proper data structures for analytical reporting from an enterprise data warehouse.
6. Good knowledge of applicable data privacy when handling sensitive personal information.
7. Team player who enjoys being part of a supportive team, with a willingness to learn and share knowledge among team members.
Preferred qualifications:
1. Experience using database reporting tools such as PowerBI and Tableau.
2. Experience using data cataloging tools such as Alation and Socrata.
3. Experience mentoring other analysts and teaching SQL.
4. Confidence recommending policies and procedures to improve database operations and overall computer systems efficiency.
5. Ability to diagram complex data structures.
6. Ability to perform tasks such as analyzing, moving, and loading data, as well as developing T-SQL, PL/SQL, ANSI SQL, or other proprietary SQL languages.
EEO:
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.
This person will assist in expanding equitable access to data by facilitating the accessibility and understanding of Edwin, the state s education data warehouse, to education agencies and researchers. In addition to technical and troubleshooting expertise the role will require a strong desire to investigate, understand, and communicate findings to a variety of audiences. Collaboration with data architects and BI developers is a must as work progresses to expand Edwin and optimize the performance of reporting tools.
Responsibilities:
1. Collaborate with business research analysts to identify data needs.
2. Create and document data marts and queries for business data needs, ensuring that resulting data match existing reports with fidelity.
3. Write and review documentation to contribute to a business rules data handbook, capturing data rules in user-friendly language.
4. 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.
5. Translate complex problems into detailed specifications and design solutions using data processing systems.
6. Create and maintain entity-relationship diagrams (ERDs) and perform database modeling, including logical, physical, and presentation tiers.
7. Provide technical and database support for in-house applications, ensuring optimal performance and user satisfaction.
8. Contribute to the knowledge base, sharing best practices and lessons learned with the Edwin team.
9. Maintain code in GitHub, ensuring proper version control and adherence to coding standards.
10. Accurately and promptly log all work, including estimates and time spent, in JIRA.
11. Facilitate the adoption of efficient coding practices and innovative solutions.
Required qualifications:
1. Understand data warehouse concepts and needs.
2. Expert knowledge of databases, Snowflake a plus, also Oracle and SQL Server.
3. Excellent communication skills with a demonstrated ability to communicate ideas clearly in both technical and user-friendly language, both in writing and orally.
4. Strong attention to detail and troubleshooting skills for QA; able to identify errors/discrepancies, isolate the cause, apply solutions and validate the resulting data.
5. Experience with dimensional modeling and knowledge of proper data structures for analytical reporting from an enterprise data warehouse.
6. Good knowledge of applicable data privacy when handling sensitive personal information.
7. Team player who enjoys being part of a supportive team, with a willingness to learn and share knowledge among team members.
Preferred qualifications:
1. Experience using database reporting tools such as PowerBI and Tableau.
2. Experience using data cataloging tools such as Alation and Socrata.
3. Experience mentoring other analysts and teaching SQL.
4. Confidence recommending policies and procedures to improve database operations and overall computer systems efficiency.
5. Ability to diagram complex data structures.
6. Ability to perform tasks such as analyzing, moving, and loading data, as well as developing T-SQL, PL/SQL, ANSI SQL, or other proprietary SQL languages.
EEO:
Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.
Share this job
Useful Links