Business Intelligence Analyst Job at Macpower Digital Assets Edge, Irving, TX

  • Macpower Digital Assets Edge
  • Irving, TX

Job Description

Job Summary:

  • The Business Intelligence Analyst is responsible for conducting full lifecycle analysis-including requirements gathering, design, documentation, testing, and validation-to support the implementation of BI analytics solutions for regional or system partners.
  • This role involves developing reporting and analytical capabilities while adhering to best practices in methodology, design, programming, and delivery.
  • The ideal candidate will have strong SQL expertise, experience with OLTP/OLAP/MPP databases, and the ability to design and develop complex reporting solutions using both normalized and denormalized data structures.
Key Responsibilities:
  • nalysis & Reporting:
    • Gather and analyze business/functional requirements to formulate BI solutions.
    • Design, develop, and maintain complex reports and dashboards.
    • Perform data mining using advanced SQL or BI tools (e.g., Power BI, Tableau).
  • Database & SQL Development:
    • Write and optimize SQL queries to extract, transform, and analyze data.
    • Work with OLTP, OLAP, and MPP database environments.
  • Collaboration & Problem-Solving:
    • Partner with cross-functional teams to identify and resolve data-related issues.
    • Recommend and implement efficient technical solutions that balance cost, time, and performance.
  • Documentation & Standards:
    • Ensure adherence to development, testing, and support standards.
    • Maintain clear documentation of report specifications, logic, and processes.
Required Competencies:
  • Technical Skills:
    • dvanced SQL proficiency (complex joins, stored procedures, query optimization).
    • Experience with BI tools (Power BI, Tableau, SSRS, etc.).
    • Knowledge of data warehousing concepts (ETL, star schema, dimensional modeling).
  • nalytical Abilities:
    • Strong problem-solving skills with attention to detail.
    • bility to translate business needs into technical solutions.
  • Leadership & Collaboration:
    • Demonstrates competencies as a Leader of Self (ownership, initiative) and Leader of Others (mentorship, teamwork).
    • Effective communication with technical and non-technical stakeholders.
Preferred Qualifications
  • 3+ years of experience in BI, data analysis, or related roles.
  • Experience with cloud-based analytics platforms (Azure Synapse, Snowflake, Redshift).
  • Familiarity with Agile/Scrum methodologies.
Work Environment
  • Hybrid/remote options may be available.
  • Occasional off-hours support for deployments or critical issues.

Job Tags

Remote work

Similar Jobs

Career Group

Personal & Administrative Assistant Job at Career Group

 ...Personal & Administrative Assistant A prestigious hedge fund in Greenwich is looking for a driven Personal Assistant to join their close-knit administrative team. In this position, you will work directly under an established Lead Executive Assistant to support two... 

Dentistry For Children at Mt. Kisco

Dental Office Manager Job at Dentistry For Children at Mt. Kisco

 ...Dental Office Manager for New Office! We are seeking a dynamic and experienced Dental Office Manager (Practice Administrator) to lead our high-performing dental team. In this vital role, you will oversee the daily operations of our pediatric and orthodontic practice to... 

Tryfacta

Psychiatric Nurse Practitioner (NP) Job at Tryfacta

 ...Psychiatric Nurse Practitioner (NP) Tryfacta is seeking a Psychiatric Nurse Practitioner (NP) for our client in 101 Bodin Circle, Bldg 777, Travis AFB, CA 94535. This is a 12 months assignment. If you meet the qualifications listed below and are interested, please apply... 

BoldAge PACE

RN Care Manager - Exempt Job at BoldAge PACE

 .../Dental ~ Generous PTO ~401K with Match*~ Life Insurance ~ Tuition Reimbursement ~ Flexible Spending Account...  .... Registered Nurse Care Manager SUMMARY: The RN Care Manageris responsibleforassessing the care needs of participants, provides nursing and... 

Clayful

Remote Youth Mental Health Coach - Chat-Based & Flexible Hours Job at Clayful

 ...An innovative startup focused on youth mental health is seeking chat-based mental health coaches to provide support during school hours. The role requires a passion for youth well-being and flexibility as coaching hours can range from 1-3 per week. Compensation is $15...