Job Title: | Programmer Analyst / Software Engineer/SQL PowerBI Developer |
Duration: | 3 Years (High Possibility of Extension) |
Location: | Remote , (Lexington, MA) |
Job Description:
Clearance: | Interim clearance sufficient for start |
Work Location: | This position is REMOTE. The candidate is able to work remotely from any location. They may be asked to take up to 4 trips per calendar year to Lexington if the program/project requires it. |
Interview Process: | 1st round interview will be a Zoom with the hiring manager. 2nd round interview will be a Zoom with additional team members as needed. |
Builds and codes applications and/or modules using a variety of programming languages. Provides patches and upgrades to existing systems. Designs web based, mobile technology, cloud, and security interface to meet the specific needs of users. Prepares operating instructions, compiles documentation of program development, technical specifications, and analyzes system capabilities to resolve questions of program intent, output requirements, input data acquisition, programming techniques, and controls. May build addon modules using application program language and/or be involved in user testing to provide actionable insights that drive future system design improvements. May have vendor management responsibility. May partner and collaborate with cyber security teams to ensure compliance with security standards as well as development operations team while automating process of software delivery and infrastructure changes.
Summary:
Team is leading a journey to advance the use of analytics across the Lab. We aim to make data readily accessible and trusted, accelerate the time to insight, and enable deep dive analysis on an array of information. In collaboration with our Lab partners, our projects aim to uncover the story hidden in the data and to leverage data science techniques to predict outcomes and inform next actions.
This position is responsible for programing complex data workflows & algorithms that provide the backbone to analytic solutions. This individual must be a quick learner to new technology, with experience extracting and importing data via APIs from multiple data sources. The role is responsible for the development, code repositories, and documentation of custom datadriving applications, while supporting the growth of the data analytics environment.
Responsibilities include but are not limited to:
- Develop and maintain complex SQL queries, scripts, and views to integrate, transform, and analyze data from diverse sources.
- Create Advanced Power BI queries using DAX
- Collaborate closely with stakeholders to gather requirements and deliver customized data solutions aligned with business needs.
- Implement robust security measures and access controls within data virtualization platforms to ensure data integrity and
compliance.
- Seamlessly integrate data virtualization platforms with BI tools, ETL workflows, and cloud ecosystems to enable comprehensive
analytics solutions.
- Create and maintain detailed documentation of processes, solutions, and workflows to support effective communication and knowledge
transfer.
Must haves:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Creating SQL database queries
- Databases, schemas and SQL
- Software/Algorithm Development
- Power BI Development
- Software Documentation
- GIT/GITHUB
- HTML, CSS, XML, XSLT, JavaScript, and AJAX
- Power BI Rest API and Integrate Deployments into CI/CD pipelines
- Software Design/Development
- APIs, RESTful services, and integrations
Nice to Have: