We are looking for a Programmer Analyst candidate who will be working in a highly collaborative environment with the engineering and development team to create high-quality software and seamless release of our client’s code.
Responsibilities:
- Meeting with project managers to determine needs.
- Developing customized solutions.
- Designing, coding, and implementing applications.
- Creating timelines and development goals.
- Testing the stability and functionality of the application.
- Troubleshooting and fixing bugs.
- Writing documents and providing technical training for End Users.
- Maintaining the security and integrity of the application software.
- Responsible for defining, delivering high quality scalable and maintainable Data Warehouse and solutions to meet business objectives.
- Provide expert guidance on the latest Microsoft tools and technologies.
- Develop security and authentication standards.
- Perform performance optimization, maintenance and troubleshooting activities on all aspects of the Azure Data Platform.
- Working with a highly evolved and complex data warehouse which refreshes automatically every day from a large variety of clinical and non-clinical data sources.
- Working on routine maintenance tasks for updates to the data warehouse and other development and documentation tasks.
- Design and develop Global Reports and Analytics using modern data visualization tools.
- Understand and prioritize business requirements while managing the expectations of stakeholders.
- Visualize and present Global Analytics to key stakeholders to identify areas of opportunity.
- Define and advocate analytics best practices in the areas of data modelling, data wrangling, data visualization and data storytelling.
Required Qualifications:
- SQL: you should have advanced skills in T-SQL querying and have a good conceptual understanding of the T-SQL language and its logic.
- Experience in full life cycle Programmer Analyst projects, from consulting and needs analysis gathering through to development and delivery. With proven design, delivery and deployment experience of Programmer Analyst projects.
- Extract Load Transform: Data extraction and transformation is a large part of the role. Strong extract transform and load skills, with the ability to summarize and prepare data to feed Programmer Analyst models using PaaS services on the cloud.
- Data modelling: AAS (Azure Analysis Services) or Power Query in Programmer Analyst experience is essential with a high level of proficiency in Data Analysis Expressions (DAX) with demonstrable capabilities in this area.
- Ideally the candidate would have experience in creating data services such as SQL databases or data warehouses on PaaS offerings
- Programmer Analyst Reports and Gateway: Experience installing, maintaining, and provisioning gateways across multiple geographical regions. Programmer Analyst report building using bookmarks and selection. Knowledge of Programmer Analyst online services including report schedule, endorsement and discovery and data source credentials
- DevOps in Azure: Build and release experience using yaml files and ARM templates
- Code and programming languages: T-SQL, DAX, JSON, and Power Query M formula language
Skills Set:
- 4 years of T-SQL and MS BI Stack (SSIS, SSRS, SSAS) experience
- 4 years of Azure Azure AAS, Power Query and DAX experience
- 3 years of TFS/Azure DevOps
- 3 years of Programmer Analyst experience
- 1-2 Years Data Migration project experience