Business Intelligence Analyst Job at MDA Edge, Irving, TX

  • MDA Edge
  • Irving, TX

Job Description

Business Intelligence Analyst

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:

  • Analysis & 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:
    • Advanced 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).
  • Analytical Abilities:
    • Strong problem-solving skills with attention to detail.
    • Ability 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

U.S. Fish and Wildlife Service

Fish and Wildlife Biologist Job at U.S. Fish and Wildlife Service

 ...Summary You will serve as a Fish and Wildlife Biologist within the Department of the Interior, U.S. Fish and Wildlife Service, Region...  ...to support both military readiness and natural resource conservation. Coordinate, and participate in field activities related to... 

Sephora

Store Operations Specialist Job at Sephora

 ...Sephora is seeking an Operations Associate at our San Antonio store to support daily operations, inventory management, and promo setup. This role emphasizes accuracy, teamwork, and a strong client focus.Youll help deliver exceptional service, maintain Sephoras standards... 

Sun Auto Service Houston

Senior Automotive Technician Job at Sun Auto Service Houston

 ...Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by applicable law.... 

ADP

Teller Job at ADP

 ...for an accommodation or an alternative application process. Teller 3 days ago Requisition ID: 1271 Job duties are listed below...  ...System. Remove deposits from, and counts and balances cash in, automated teller machines and night depository. Qualifications and... 

Ampac Holdings, LLC

Senior Human Resources Generalist Job at Ampac Holdings, LLC

 .../or sensitive matters. Recruits, interviews, and facilitates hiring of qualified hourly and salaried job applicants for open positions...  ..., and onboarding through the first 90 days. Manages all temp labor while working closely with the temp agencies and department...