IT Business Analyst (Business Intelligence)
Location: Charlotte, NC (Hybrid)
Duration: 12 Month ContractW2 ONLY, NO C2CDescription:
Design, build, and support business intelligence and low-code solutions using Power BI, Power Apps, SQL, and AWS data services. This role partners with business and technical teams to turn reporting and workflow needs into accurate, user-friendly dashboards, applications, and data products.
Primary Responsibilities:
Build and maintain Power BI reports, dashboards, semantic models, and advanced DAX measures.
Combine data from multiple internal and external sources, with strong controls for data accuracy, validation, and reconciliation.
Develop Power Apps solutions that simplify business processes, data entry, approvals, and operational workflows.
Create and optimize complex SQL queries, scripts, views, and stored procedures used for reporting and analytics.
Use AWS data and analytics services to access, prepare, store, or integrate data for reporting solutions.
Partner with stakeholders to gather requirements, define success measures, and translate business needs into practical solutions.
Create wireframes, prototypes, and mockups to confirm design and usability before development.
Test, document, deploy, maintain, and enhance reports, dashboards, applications, and data solutions.
Troubleshoot data quality, performance, access, and integration issues.
Work with Data Architects, ETL teams, and other technical partners to support data warehouses, data marts, and reusable data products.
Establish reliable daily, weekly, monthly, annual, and ad hoc reporting processes.
Required Qualifications:
Bachelor's degree from an accredited college or university, or 7 years of related experience in lieu of a degree.
At least 3 years of related experience in business intelligence, reporting, analytics, information technology, process improvement, customer service, sales and marketing, e-commerce, or project delivery.
Hands-on experience developing Power BI reports and dashboards, including data modeling, DAX, and validation of results.
Experience writing SQL queries and working with relational databases such as SQL Server or Oracle.
Strong analytical, problem-solving, communication, and documentation skills.
Ability to manage multiple priorities, work independently, and deliver accurate results in a fast-paced environment.
Preferred Qualifications:
Degree in Computer Information Systems, Computer Science, Data Analytics, Business Administration, or a related field.3 to 5+ years of experience as a BI Developer, Reporting Developer, Data Analyst, Data Scientist, or similar role.
Experience building canvas or model-driven applications with Microsoft Power Apps; Power Automate experience is a plus.
Experience with AWS services used for data and analytics, such as Amazon S3, Redshift, Athena, Glue, RDS, or QuickSight.
Experience with Power BI Report Builder, SSRS, Power Pivot, Tableau, SAS, or similar reporting tools.
Knowledge of ETL, SSIS, OLAP, data warehousing, APIs, and cloud-based data integration.
Experience with DAX and one or more additional languages or tools such as Python, R, Visual Basic, or Power Query M.Experience modernizing legacy or departmental reporting into Power BI and the Microsoft Power Platform.
Portfolio or work samples that demonstrate dashboard, application, or data visualization capabilities.
Core Competencies:- Data accuracy and attention to detail
- Stakeholder partnership and communication
- User-centered dashboard and app design
- Ownership and dependable execution
- Creative problem solving
- Continuous learning and adaptability
Technical Skills:- Primary: Power BI, Power Apps, SQL, DAX, data modeling, dashboard development
- Cloud / Data: AWS data services, relational databases, ETL, data warehousing
- Additional: Power Automate, Power Query M, SSRS, Report Builder, SSIS, OLAP, Python, R, Tableau, SAS