MIT Lincoln Laboratory

ISD: Power BI & SQL Server Analyst – CO-OP Student

25 March 2024
Apply Now
Deadline date:
£37000 - £70000 / year

Job Description

 

Position Description:

 

The Power BI & SQL Server Analyst will assist the data analytics team in the design and development of the business applications/dashboards using Power BI & Sql server platform.

 

Responsibilities:

 

  1. Data Analysis and Visualization:
     

    • Develop Power BI reports and dashboards to provide insights into key business metrics.
    • Work closely with business analysts to understand data requirements and translate them into effective visualizations.
    • Analyze data trends, patterns, and anomalies to support data-driven decision-making.
       
  2. SQL Server Database Management:
     

    • Assist in designing, implementing, and maintaining SQL Server databases.
    • Write and optimize SQL queries for data extraction, transformation, and loading (ETL) processes.
    • Ensure data integrity and security within the SQL Server environment.
       
  3. Data Modeling:
     

    • DAX (Data Analysis Expressions)
    • Design and implement data models to support reporting and analytics requirements.
    • Collaborate with the data engineering team to optimize data structures for efficient reporting.
       
  4. Visualization:
     

    • Building Visualizations
    • Customizing Visuals
    • Drill through and Bookmarks
       
  5. Power BI Services Power BI Service Features and Functionality
     

    • Sharing and Collaboration
    • Power BI Apps and Workspaces
       
  6. Collaboration:
     

    • Work closely with cross-functional teams, including business analysts, data scientists, and IT professionals.
    • Collaborate with stakeholders to understand reporting needs and provide timely solutions.
       
  7. Troubleshooting and Performance Optimization:
     

    • Identify and resolve issues related to data quality, performance, and report accuracy.
    • Optimize queries and database performance to ensure efficient data retrieval.
       
  8. Documentation:
     

    • Document data models, ETL processes, and report specifications.
    • Create user guides and documentation for Power BI reports and dashboards.
       

Qualifications:
 

  • Currently pursuing a degree in Computer Science, Information Systems, or a related field.
  • Strong understanding of relational databases and SQL Server.
  • Proficiency in Power BI for creating interactive and insightful reports.
  • Knowledge of data modeling concepts and best practices.
  • Good problem-solving skills and attention to detail.
  • Strong communication and teamwork skills.
     

 

Selected candidate will be subject to a pre-employment background investigation and must be able to obtain and maintain a Secret level DoD security clearance.

 

MIT Lincoln Laboratory is an Equal Employment Opportunity (EEO) employer. All qualified applicants will receive consideration for employment and will not be discriminated against on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, age, veteran status, disability status, or genetic information; U.S. citizenship is required.

 

Requisition ID: 41006