Job Title: SQL/BI Analyst
Location: Charlotte, NC (Hybrid Schedule: 3 days a week onsite)
Job Type: Contract with potential for conversion
Experience Level: 3-5 years
Candidate Status: U.S. Citizens or Green Card Holders (Can't support H1B candidates)
Job Summary
We are seeking a skilled SQL/BI Analyst to join a leading global investment management firm. In this role, you will be tasked with data and reporting work to the private investments team. Day to day work consists of manipulating data with T-SQL, creating and enhancing clean Power BI reports, and collaborating with teams in both the U.S. and U.K to provide critical insights.
Key Responsibilities
Power BI:
- Design, build, and maintain Power BI and Power BI Paginated Reports from scratch.
- Transition reporting focus from SSRS to Power BI, ensuring reports are detailed, print-ready, and formatted correctly.
- Understand and apply differences between Power BI and paginated reports, including creating fixed-layout reports for operational and compliance needs.
T-SQL:
- Develop and debug SQL code, including queries and stored procedures.
- Troubleshoot and resolve data issues, ensuring accurate reporting and identifying underlying problems with data or reporting systems.
- Enhance and maintain existing stored procedures and resolve issues in current implementations.
DAX:
- Utilize DAX (Data Analysis Expressions) for advanced data modeling and analysis within Power BI and other Microsoft data tools.
- Apply DAX queries effectively for real-time data analysis and complex calculations, with support and training provided as needed.
Desired Skills and Experience
Technical Skills:
- Proficiency in Power BI and Power BI Paginated Reports.
- Strong T-SQL skills with experience in writing and debugging SQL code.
- Competency in DAX for business intelligence and data analysis.
Industry Knowledge:
- Experience in financial services is a plus but not required.
- Familiarity with private asset investments (e.g., bank loans, private debts) is advantageous.
Soft Skills:
- Excellent communication skills, with the ability to present and discuss past projects in detail.
- Strong problem-solving abilities and a proactive approach to addressing issues.