Senior Data/BI Programmer/Analyst

Job Title: Power BI/SQL Developer Programmer/Analyst
Duration: 3+ years
Client: Defense Research Lab
Location: Lexington, MA (100% Remote)

Description: 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 add-on 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.

Background need:

Our 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.

Other information relevant to the job requirement?

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 data-driving 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:

• Python
• Microsoft Fabric

Others:

• 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.
• Clearance: An interim clearance is sufficient to start with for this position.
• 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.