IT Business Analyst (Business Intelligence)
Location: Charlotte, NC (Hybrid)
Duration: 12 Month Contract
W2 ONLY, NO C2C
Description:
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:
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