Business Analyst
Share
Job Location:
Charlotte, VT - USA
Monthly Salary:
USD 80000 - 125000
Posted on:
15 hours ago
Vacancies:
1 Vacancy
Job Summary
Horizon is seeking a detail-oriented and analytically driven Business Analyst to support data-driven decision-making across the organization. This role partners closely with business stakeholders and technical teams to translate business needs into actionable insights through reporting dashboards and advanced analytics.
The ideal candidate is highly proficient in Microsoft Power BI and PostgreSQL with strong experience building data models developing dashboards and validating data accuracy. Experience with Python for analytics and automation is strongly preferred. This role plays a key part in improving reporting efficiency operational insight and overall analytical maturity at Horizon.
Key Responsibilities
- Gather document and translate business requirements into analytical solutions and reporting deliverables.
- Design and develop interactive dashboards reports and data models using Microsoft Power BI to monitor key performance indicators (KPIs) and provide business-wide insights.
- Apply DAX (Data Analysis Expressions) and Power Query M language to build complex metrics calculations and data transformations within Power BI.
- Write complex SQL queries in PostgreSQL to extract transform and analyze data.
- Conduct thorough data validation and testing of reports to ensure accuracy consistency and reliability of all displayed information.
- Build and maintain reusable datasets and data assets to support scalable reporting and analytics.
- Conduct thorough data validation and testing to ensure accuracy consistency and reliability of all outputs.
- Support ad-hoc analytical requests as needed.
- Maintain and support various recurring processes.
Preferred Experience & Qualifications
- Experience using Python for data analysis automation ETL scripting or API integration (e.g. Pandas NumPy Scikit-learn).
- Ability to automate recurring reporting and analytics workflows to improve efficiency and reduce manual effort.
- Experience with advanced statistical analysis predictive modeling or trend and anomaly detection.
- Experience with data warehousing concepts and BI best practices.
- Familiarity with version control tools such as Git.
- Experience working with Salesforce data or reporting environments.
Required Experience and Qualifications
- 13 years of professional experience in business analytics business intelligence data analysis or a related role.
- Bachelors degree in Business Data Analytics Information Systems Computer Science or related field.
- Proficiency in Microsoft Power BI including DAX and Power Query.
- Strong SQL skills with hands-on experience using PostgreSQL.
- Experience working with relational databases and building ETL logic.
- Strong analytical critical thinking and problem-solving skills.
- Ability to clearly communicate insights to both technical and non-technical stakeholders.
- Familiarity with AWS or cloud-based infrastructure.
- Proficiency in Microsoft Excel including the ability to use basic formulas like IF statements and lookup functions to analyze and validate data effectively.
Required Experience:
IC
Key Skills
- SQL
- Agile
- Business Analysis
- Visio
- Waterfall
- Business Process Modeling
- Requirements Gathering
- User Acceptance Testing
- Business requirements
- SDLC
- Systems Analysis
- Data Analysis Skills
About Company
Horizon Investments offers goals based financial strategies, investment management, technology, and consulting–tools for investing and advising clients.
