ISD: Power BI & SQL Server Analyst - CO-OP Student
Lexington, MA, US
Full Time Entry-level / Junior Clearance required USD 37K - 70K *
MIT Lincoln Laboratory
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:
- 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.
- 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.
- 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.
- Visualization:
- Building Visualizations
- Customizing Visuals
- Drill through and Bookmarks
- Power BI Services Power BI Service Features and Functionality
- Sharing and Collaboration
- Power BI Apps and Workspaces
- 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.
- 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.
- 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
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Computer Science Data analysis Data Analytics Data quality Engineering ETL Power BI RDBMS Security SQL
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Data Manager jobs
- Open Data Science Manager jobs
- Open Principal Data Engineer jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Power BI Developer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Data Analytics Engineer jobs
- Open Business Data Analyst jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Data Analyst Intern jobs
- Open Big Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Data Product Manager jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open Deep Learning-related jobs
- Open PhD-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open PyTorch-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open CI/CD-related jobs
- Open LLMs-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Data governance-related jobs
- Open Hadoop-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs