Data and Reporting SQL Developer
Company Name:
Open Systems Technologies
Security Department Overview
The Security Department is responsible for protecting the company's intellectual property through the use of integrated technology and trained personnel. Security is absolutely mission-critical to our continued effectiveness as a leader in the industry.
The Security Department includes a centralized team that manages enterprise security risk, as well as security teams that are embedded within business critical departments to ensure they are secure.
Position
Summary:
The Data and Reporting Consultant role is part of an analytics team within the Security Operations group. The consultant is responsible for building data feeds, repositories, transformations, reports, and dashboards.
This role focusses on KPIs and auditing within the security operations space. The Data and Reporting Consultant will need to understand and build reports and dashboards according to a vision outlined by the team lead with a high degree of independence, and should use their expertise to call out opportunities to improve designs.
Responsibilities Include:
Create metrics, dashboards, and reports on how security is running and how security risk is managed
Set up and maintain reporting infrastructure; Develop maintenance and support processes
Identify opportunities for better solutions
Document and ensure users understand how to use systems
Act in accordance with security rules and best practices; call out risks
Position Requirements:
Must operate with a high degree of confidentiality and responsibility; Requires a strong emphasis on trustworthiness and ethical conduct
Exceptional problem solving, prioritization, and practicality; Learns fast; Sees multiple paths; Can evaluate the best approach given a goal
Able to understand and work towards an over-arching goal rather than requiring task level supervision; Proactive individual with high energy who seeks to make a difference on every project undertaken
Strong organizational skills, diligence, multi-tasking, professionalism, and attention to detail
Comfortable giving direct feedback as well as receiving criticism; Committed to a high standard of communication and transparency
Proven experience in structuring and transforming data; building reports and dashboards
Exceptional thinking qualities may substitute for length of experience
This candidate could be:
An experienced pro looking for a challenge
A rising star looking to flex their wings
An exceptional recent grad looking to get practical experience
An entrepreneurial type looking for something before starting their next project
Ideally the candidate should already have a strong connection to data. They may be a reporting expert, a data structures architect, an ETL professional, or a jack-of-all-these-trades. The important traits will be:
Understands the value of data in driving business
Understands data structure and relationships
Can relate data to meaning
No specific set of skills is absolutely required, but familiarity with some or all of the concepts and tools below (or equivalent) would be expected:
SQL
SSRS
Qlikview
Business Intelligence / AnalyticsEstimated Salary: $20 to $28 per hour based on qualifications.
Open Systems Technologies
Security Department Overview
The Security Department is responsible for protecting the company's intellectual property through the use of integrated technology and trained personnel. Security is absolutely mission-critical to our continued effectiveness as a leader in the industry.
The Security Department includes a centralized team that manages enterprise security risk, as well as security teams that are embedded within business critical departments to ensure they are secure.
Position
Summary:
The Data and Reporting Consultant role is part of an analytics team within the Security Operations group. The consultant is responsible for building data feeds, repositories, transformations, reports, and dashboards.
This role focusses on KPIs and auditing within the security operations space. The Data and Reporting Consultant will need to understand and build reports and dashboards according to a vision outlined by the team lead with a high degree of independence, and should use their expertise to call out opportunities to improve designs.
Responsibilities Include:
Create metrics, dashboards, and reports on how security is running and how security risk is managed
Set up and maintain reporting infrastructure; Develop maintenance and support processes
Identify opportunities for better solutions
Document and ensure users understand how to use systems
Act in accordance with security rules and best practices; call out risks
Position Requirements:
Must operate with a high degree of confidentiality and responsibility; Requires a strong emphasis on trustworthiness and ethical conduct
Exceptional problem solving, prioritization, and practicality; Learns fast; Sees multiple paths; Can evaluate the best approach given a goal
Able to understand and work towards an over-arching goal rather than requiring task level supervision; Proactive individual with high energy who seeks to make a difference on every project undertaken
Strong organizational skills, diligence, multi-tasking, professionalism, and attention to detail
Comfortable giving direct feedback as well as receiving criticism; Committed to a high standard of communication and transparency
Proven experience in structuring and transforming data; building reports and dashboards
Exceptional thinking qualities may substitute for length of experience
This candidate could be:
An experienced pro looking for a challenge
A rising star looking to flex their wings
An exceptional recent grad looking to get practical experience
An entrepreneurial type looking for something before starting their next project
Ideally the candidate should already have a strong connection to data. They may be a reporting expert, a data structures architect, an ETL professional, or a jack-of-all-these-trades. The important traits will be:
Understands the value of data in driving business
Understands data structure and relationships
Can relate data to meaning
No specific set of skills is absolutely required, but familiarity with some or all of the concepts and tools below (or equivalent) would be expected:
SQL
SSRS
Qlikview
Business Intelligence / AnalyticsEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
