Data Analyst

Mid / Senior

Hybrid

Key Responsibilities:

Play an instrumental role in developing the data warehouse and BI strategy and initiatives.
Analyzes business and technical requirements, translate them to high level design documents.
Design and implement enterprise data marts/warehouse, physical and logical data models (dimensions, schemas, hierarchies, data elements and marts) supporting business needs.
Design and implement ETL tools and processes for data intake from multiple sources.
Establish and maintain data security and compliance, access controls, data governance.
Design and implement user analytical and visualization tools.
Provide support to the BI users on the effective use of reporting tools and data structure
Identify requirements, design, create, deploy, monitor and support BI reports and dashboards, shared object and cubes to empower discovery and information-sharing for business partners.
Utilize expertise in data modeling, ETL, and report design for department initiatives, and produce detailed documentation including data flow diagrams, logical diagrams, and physical diagrams as needed.
With minimal supervision work on a wide range of projects interfacing with development teams, business analysts, IT management and members of the business units

Experience and Qualification:

Bachelor’s Degree in Computer Sciences, Information Systems or related fields.
3+ years of intense technical experience in the areas of data architecture, data modeling, data management, data warehouse environment
Deep understanding of warehouse design, data engineering and/or data governance.
Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation, and optimization.
Deep understanding of relational and dimensional database domains.
Strong experience with data warehouse and ETL technologies.
Advanced query and SQL skills, preferably on MS-SQL Server database.
Software and scripts development experience.
Strong background in master data management, metadata management, information lifecycle design, and development.
Experience with data visualization tools such as Power BI is highly desirable.
Strong analytical and troubleshooting skills.
Highly motivated self-starter, detail and quality oriented and ability to handle multiple competing priorities.
Must be a strong team player with a positive attitude and enthusiasm to get things done.Excellent communication (both written and verbal), interpersonal skills and experience

{"group":"Organization","title":"Data Analyst","zohoId":"557706000004599151","endDate":"2020-10-01T00:00:00.000Z","jobType":"Full Time","job_url":"149-exavalu-data-analyst","agencyId":1,"location":[{"lat":32.2167,"lon":-110.9667,"city":"Tucson","text":"Tucson, AZ 85701, USA","state":"Arizona","country":"","zipCode":"85701","is_state":false,"is_country":false,"state_code":"AZ","countryCode":"","isLocationSet":true,"loc_h3_hex_res4":"8448e85ffffffff","isLocationResolved":false,"is_address_available_from_parser":true}],"maxSalary":null,"minSalary":null,"startDate":"2020-09-21T00:00:00.000Z","onBehalfOf":"62","description":"<p style=\"margin: 14px 0px 0px; padding: 0px; border: none; outline: none; position: relative; line-height: 1.8em; font-style: normal; font-weight: 600; letter-spacing: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px\">Key Responsibilities: <ul><li class=\"align-justify\" style=\"text-align: justify\">Play an instrumental role in developing the data warehouse and BI strategy and initiatives. </li><li class=\"align-justify\" style=\"text-align: justify\">Analyzes business and technical requirements, translate them to high level design documents. </li><li class=\"align-justify\" style=\"text-align: justify\">Design and implement enterprise data marts/warehouse, physical and logical data models (dimensions, schemas, hierarchies, data elements and marts) supporting business needs. </li><li class=\"align-justify\" style=\"text-align: justify\">Design and implement ETL tools and processes for data intake from multiple sources. </li><li class=\"align-justify\" style=\"text-align: justify\">Establish and maintain data security and compliance, access controls, data governance. </li><li class=\"align-justify\" style=\"text-align: justify\">Design and implement user analytical and visualization tools. </li><li class=\"align-justify\" style=\"text-align: justify\">Provide support to the BI users on the effective use of reporting tools and data structure </li><li class=\"align-justify\" style=\"text-align: justify\">Identify requirements, design, create, deploy, monitor and support BI reports and dashboards, shared object and cubes to empower discovery and information-sharing for business partners. </li><li class=\"align-justify\" style=\"text-align: justify\">Utilize expertise in data modeling, ETL, and report design for department initiatives, and produce detailed documentation including data flow diagrams, logical diagrams, and physical diagrams as needed. </li><li class=\"align-justify\" style=\"text-align: justify\">With minimal supervision work on a wide range of projects interfacing with development teams, business analysts, IT management and members of the business units </li></ul><p class=\"align-justify\" style=\"margin: 14px 0px 0px; padding: 0px; border: none; outline: none; position: relative; line-height: 1.8em; font-style: normal; font-weight: 600; letter-spacing: normal; orphans: 2; text-align: justify; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px\">Experience and Qualification: <ul><li style=\"text-align: justify\" class=\"align-justify\">Bachelor’s Degree in Computer Sciences, Information Systems or related fields. </li><li style=\"text-align: justify\" class=\"align-justify\">3+ years of intense technical experience in the areas of data architecture, data modeling, data management, data warehouse environment </li><li style=\"text-align: justify\" class=\"align-justify\">Deep understanding of warehouse design, data engineering and/or data governance. </li><li style=\"text-align: justify\" class=\"align-justify\">Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation, and optimization. </li><li style=\"text-align: justify\" class=\"align-justify\">Deep understanding of relational and dimensional database domains. </li><li style=\"text-align: justify\" class=\"align-justify\">Strong experience with data warehouse and ETL technologies. </li><li style=\"text-align: justify\" class=\"align-justify\">Advanced query and SQL skills, preferably on MS-SQL Server database. </li><li style=\"text-align: justify\" class=\"align-justify\">Software and scripts development experience. </li><li style=\"text-align: justify\" class=\"align-justify\">Strong background in master data management, metadata management, information lifecycle design, and development. </li><li style=\"text-align: justify\" class=\"align-justify\">Experience with data visualization tools such as Power BI is highly desirable. </li><li style=\"text-align: justify\" class=\"align-justify\">Strong analytical and troubleshooting skills. </li><li style=\"text-align: justify\" class=\"align-justify\">Highly motivated self-starter, detail and quality oriented and ability to handle multiple competing priorities. </li><li style=\"text-align: justify\" class=\"align-justify\">Must be a strong team player with a positive attitude and enthusiasm to get things done.Excellent communication (both written and verbal), interpersonal skills and experience </li></ul><div> </div> ","isHybridJob":true,"isRemoteJob":false,"noOfOpenings":1,"maxExperience":"8","minExperience":"5","isOnPremiseJob":false,"onBehalfOfName":"Exavalu","otherlocations":[],"zohoCurrencyIn":"USD","experienceLevel":"Mid / Senior","zohoNoOfOpenings":{"noOfOpenings":1,"fulfillmentIds":["557706000004599151-1"]},"otherJobReference":null,"sharpenedJobTitle":"Data Analyst","job_category_group":3,"portalLocationDisplay":"Tucson AZ","expertise_coreskill_or_product":["Other"],"job_id":"2286"}

Data Analyst

Thank you for your application!