AddressData Analyst
Responsibilities:
- Design, develop, and maintain SQL databases using best practices for database design and normalization.
- Write complex SQL queries, stored procedures, and functions to extract, transform, and load data from various sources.
- Optimize database performance by identifying and resolving performance issues and tuning SQL queries.
- Collaborate with stakeholders to gather and understand business requirements and translate them into effective database solutions.
- Create and maintain data models, data dictionaries, and documentation for the SQL databases.
- Work with the data team to perform data cleansing, data integration, and data transformation tasks.
- Develop insightful and interactive dashboards, reports, and visualizations using Power BI.
- Ensure data security and access controls are implemented to protect sensitive data.
- Troubleshoot and resolve data-related issues and provide technical support to users.
- Perform data analysis to identify trends, patterns, and insights from the data.
- Participate in data architecture discussions and contribute to the overall data strategy.
- Stay up-to-date with the latest SQL and Power BI advancements and best practices.
Requirements:
- Bachelor's degree in a relevant field such as Computer Science, statistics, economics or Engineering
- Proven experience as a SQL Developer with a strong understanding of database concepts and SQL programming.
- Experience in database design, data modeling, and performance optimization.
- Proficiency in writing complex SQL queries, stored procedures, and functions.
- Experience working with Power BI to create interactive reports and dashboards.
- Knowledge of data visualization best practices and principles.
- Strong problem-solving skills and the ability to analyze and debug database-related issues.
- Ability to work independently and as part of a team to deliver high-quality solutions.
- Excellent communication and interpersonal skills.
- Familiarity with other BI tools and data visualization technologies is a plus.
Preferred Qualifications: Bachelor's degree in a relevant field such as Computer Science, statistics, economics or engineering
