careers

Join our team of experts.

Data Analyst IV

Charlotte, NC 28206

Posted: 02/03/2026 Category: Big Data / Database / BI Job Number: 118592 Work Location: On-Site

Job Description

Data Analyst IV

Duration: 12 months
Location: Hybrid - Charlotte, NC

Primary Responsibilities

Data Engineering & Architecture (35%)
• Design, develop, and maintain scalable data pipelines using Python, Dagster, and modern orchestration tools
• Build robust data architectures that support analytics, reporting, and business intelligence needs
• Develop ETL/ELT processes to integrate data from multiple source systems into our data warehouse
• Optimize data models for performance, reliability, and scalability
• Support AWS Redshift namespace migration efforts, including pipeline migration and validation
• Collaborate with the Data Engineering Pod to establish and maintain best practices

Business Intelligence & Analytics (35%)
• Design and build advanced Power BI reports and dashboards with a focus on performance and user experience
• Develop Power Platform solutions (Power Apps, Power Automate) to enhance self-service analytics and automation
• Analyze data to uncover insights, identify trends, and answer complex business questions
• Ask probing questions, challenge assumptions, and provide data-driven recommendations
• Translate ambiguous business problems into actionable analytical solutions
• Present findings and insights to stakeholders through compelling visualizations and storytelling

Collaboration & Leadership (20%)
• Work across Billing, Accounts Receivable, Metering, and Customer Engagement domains
• Run stakeholder meetings independently-gathering requirements, presenting solutions, and taking detailed notes
• Teach and mentor team members on technical concepts, tools, and best practices
• Present technical deep dives and training sessions to the team
• Participate actively in weekly domain meetings and monthly pod meetings
• Collaborate with team members on code reviews, troubleshooting, and problem-solving

Project Management & Documentation (10%)
• Track all work in JIRA with clear tasks, updates, and status reporting
• Document code, data pipelines, reports, and processes thoroughly for team continuity
• Maintain version control using GitHub with proper branching, commits, and collaboration practices
• Deliver projects on time and communicate proactively about progress, blockers, and risks
• Contribute to technical documentation, runbooks, and knowledge base articles

Must-Have Technical Skills
• 5+ years of professional experience in data engineering, business intelligence, or analytics
• Expert-level SQL skills (complex queries, window functions, CTEs, query optimization, stored procedures)
• Python programming for data engineering, automation, and analytics
• Data orchestration tools (Dagster strongly preferred; Airflow, Prefect, or similar also acceptable)
• AWS experience including S3, Redshift, and cloud data architectures
• Power BI development with advanced DAX, data modeling, and performance optimization
• GitHub for version control, code collaboration, and repository management
• Data pipeline development from source systems to analytics platforms
• Strong understanding of data warehousing concepts, dimensional modeling, and ETL/ELT patterns

Highly Desired Skills (Big Plus!)
• Power Platform (Power Apps, Power Automate) development experience
• Experience with ISU (Industry Solution for Utilities) or utility industry data
• AWS Redshift migration or cloud data migration projects
• Billing, Accounts Receivable, or Metering domain knowledge
• Data quality frameworks and automated validation/testing
• CI/CD pipelines for data and BI deployments
• dbt (data build tool) for transformation workflows

Required Soft Skills & Attributes
• Proactive and self-driven - you identify problems and solve them without waiting for direction
• Exceptional communication skills - perfect English (written and verbal), able to present complex ideas clearly
• Highly organized - manages multiple priorities, tracks work meticulously, meets deadlines consistently
• Team player - collaborates openly, shares knowledge, and supports teammates
• Curious and analytical - loves asking why, digging into data, and uncovering insights
• Comfortable with ambiguity - thrives when given complex, open-ended problems to solve
• Reliable and dependable - delivers on commitments, even under pressure
• Passionate about learning - stays current with new tools, techniques, and industry trends
• High energy and positive attitude - brings enthusiasm and motivation to the team
• Goes above and beyond - consistently exceeds expectations and takes initiative


 
Do you now or in the future require sponsorship (e.g. H-1B)? Y/N
 
Consulting Solutions and its family of companies is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.
If you are a person with a disability needing assistance with the application or at any point in the hiring process, please contact us at:
requests@consultingsolutions.com

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Charlotte, NC

Ready to embark on a new career adventure? Explore our job opportunities in and around Charlotte, North Carolina, where the Queen City's vibrant energy meets Southern charm. Known for its dynamic job market and diverse industries, Charlotte offers endless growth possibilities for professionals seeking new opportunities. Discover the city's rich history at the Levine Museum of the New South, catch a show at the Blumenthal Performing Arts Center, or immerse yourself in nature at the stunning Freedom Park. Indulge in the region's famous barbecue joints, explore the NASCAR Hall of Fame, or cheer on the Carolina Panthers at the Bank of America Stadium. Join us in Charlotte and unlock a world of career possibilities in this bustling city with a small-town feel.