Data Analyst III

Job Role :: Data Analyst III

Job Location :: Charlotte, NC

Position Type :: Hybrid

The successful candidate must:

1) Independently assess complex situations, identify root causes, and develop effective solutions with minimal guidance.

2) Be eager to learn new concepts quickly

3) Have a strong command of SQL, Power BI, Power Automate, Power Apps, Power Point, Excel

4) Create efficient and effective data models in Power BI

5) Excel in clearly communicating with stakeholders and partnering with cross-functional teams to define Power BI reporting requirements to achieve strategic goals

6) Be comfortable presenting reporting and analyses with leaders

7) Have AWS Redshift, A3S experience

The consultant is responsible for business activities for the Customer Experience & Operations Analytics Team within various business units as the primary interface with Information Technology and the Business in order to:

Serve as an expert in translating complex data into key strategic insights and valuable actions.

Business Intelligence Data Visualization Lead Analysts develop and test heuristics, create and run models, perform data exploration and data mining to present valuable data trends and discoveries to other data scientists, business stakeholders and managers at various levels. They create business intelligence, dashboards, visualizations, other advanced analytics reports, and presentations to adequately tell the business narrative and offer recommendations that are practiced, actionable, prioritized based on material impact, in addition to being well-supported by analytical models and data.

Responsibilities:

- As a Data Visualization developer and analyst, you will be responsible for building the Customer Service and Experience, Operations teams visual analytics using MS Power BI.

- Support the rebuild of PBI reporting to support Piedmont Natural Gas (PNG) and their launch of their cloud-based contact center platform (Genesys / Elevate 360)

- Work with stakeholders to understand requirements, plan and deliver dashboards/reports that delight users

- Create user-friendly and dynamic dashboards and reports.

- Identify trends and outliers and come up with data discovery using solutions developed.

- Identify pain points faced by stakeholders and develop the data visualization solutions that addresses their needs

- Create reports with KPIs, heat maps, scatterplots, bar charts, slicers, drill down, drill up etc. features and possess understanding of when to use them.

- Collaborate with stakeholders, business partners, colleagues, developers, and business analysts to deliver high quality value-adding analytics solutions

- Effectively present work to users and business leaders

- Install, setup, test, demo Power BI workspaces, datasets, dataflows, dashboards, reports, schedules, APIs.

- Ability to use SQL for data wrangling and effectively transform the data to be consumed into Power BI.

- Champion user trust of reporting and ad hoc information by upholding accuracy and integrity of all datasets through exploration, validation, and correction

- Contribute as a lead team member for special projects

Required Qualifications:

- Graduation from a four-year college or university with a degree in statistics, mathematics, physics, engineering, computer science, or management of information systems.

Work experience in addition to degree: 6+ years

• Experience designing, developing, and testing data visualization solutions, with an emphasis on data modeling and dashboards
• 4+ years of experience developing Power BI reports
• Expertise in DAX and SQL
• Command of Power App and Power Automate

Job-specific knowledge, skills or abilities:

• Working knowledge of statistics, programming and predictive modeling.
• Working knowledge of code writing.
• Excellent verbal and written communication skills as well as the ability to bridge the gap between data science and business management
• Exceptional organizational skills and detail orientation
• Focus on data integrity and accuracy

Preferred Qualifications:

• 6+ years of experiencing designing, developing, and testing data visualization solutions, with an emphasis on dashboards
• 4+ years of experience developing Power BI reports, web service, data flows, DAX.
• Understanding of and ability to use programming languages like Python, SQL (Structured Query Language)
• Power Automate and Power App experience
• Desire to present analyses and recommendations to key stakeholders
• Strong critical thinking skills and the ability to relate them to the strategies, processes, products or services the company is focused on
• Data mining knowledge that spans a range of disciplines
• Strong exploratory analysis skills
• Knowledge of basic and advanced prediction models

Dexian is a leading provider of staffing, IT, and workforce solutions with over 12,000 employees and 70 locations worldwide. As one of the largest IT staffing companies and the 2nd largest minority-owned staffing company in the U.S., Dexian was formed in 2023 through the merger of DISYS and Signature Consultants. Combining the best elements of its core companies, Dexian's platform connects talent, technology, and organizations to produce game-changing results that help everyone achieve their ambitions and goals.

Dexian's brands include Dexian DISYS, Dexian Signature Consultants, Dexian Government Solutions, Dexian Talent Development and Dexian IT Solutions. Visit https://dexian.com/ to learn more.

Dexian is an Equal Opportunity Employer that recruits and hires qualified candidates without regard to race, religion, sex, sexual orientation, gender identity, age, national origin, ancestry, citizenship, disability, or veteran status.