Business Data Analyst

Position Description and Requirements

• Work with various business units on NASAA’s data initiatives for CRD/IARD, NEMO, NED, and EFD.
• Enhance data collection and practices through NEMO.
• Assume the responsibility for enhancing NED including web scraping and searching functions.
• Assist EFD team members in managing EFD system data and reporting on such data.
• Support and enhance data practices for other operational areas within the corporate office (such as financial data, HR data, website, and social media metrics).
• Collaborate with team members on system compliance (SOC) audits.
• Develop database management procedures, technical documentation, and report query specifications.
• Develop a data governance program, including maintaining and monitoring data integrity and consistency.
• Collaborate with NASAA corporate office teams to recommend and implement solutions for business intelligence.
• Build solutions to automate existing manual workflows and reports.
• Work with securities regulators to analyze trends in securities regulatory activities and the industry.
• Evaluate, recommend, and participate in the selection of data analytics tools and data warehouse components, including database management systems, ETL software, data mining tools, and meta data management tools.
• Gather requirements from end-users and create advanced queries and reports.
• Troubleshoot problems with database vendors and outside consultants as needed.
• Keep abreast of developments and trends in database/CRM management and data analytics and propose improvements and advancements for the organization’s information systems.
• Other duties as assigned.

Essential Skills

• Proficiency in Python and SQL for data management and analysis.
• Strong data visualization skills using Excel, Power BI, Tableau, or similar technologies.
• Understanding ETL processes and the ability to work with statistical software.
• Familiarity with data warehousing architecture, including cloud services such as AWS and Azure.
• Strong written and oral communication skills, with the ability to engage both technical and non- technical audiences.
• Exceptional analytical and problem-solving abilities.

Preferred Skills

• Expertise with Microsoft 365 suite, including Excel and SharePoint.
• Experience with CRM systems, preferably Salesforce, to manage and analyze stakeholder data.
• Proficiency with project management tools like Jira and Confluence to track tasks and workflows.
• An understanding of Data Privacy laws.
• Experience with financial analysis, and operational modeling.

• Bachelor's or Associate’s degree in Business, Computer Science, or Information Systems Management with a minimum of 2 years of relevant experience related to data analytics, data visualizations, and supporting database management in a business environment.

• The position offers a competitive compensation package, including health insurance and retirement plan options.
• All NASAA employees are offered opportunities for professional development.
• As part of the onboarding process, new employees are required to work on site at the Washington, D.C. headquarters for the first 5 days of their employment, 3 days per week for the following three weeks, and then 2 days per week pending successful completion of the onboarding process.