careers
Join our team of experts.
Data Analyst IV
340 East 16th Street Charlotte, NC 28206 US
Job Description
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
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is required to use hands and fingers, reach, climb stairs, walk, sit for prolonged periods of time, talk, and hear. The employee must occasionally lift and/or move up to twenty-five pounds.
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.
Share This Job:
Related Jobs:
About Charlotte, NC
Are you sure you want to apply for this job?
Please take a moment to verify your personal information and resume are up-to-date before you apply.