Data Analyst/Data Administrator

Job Description

As a Data Analyst and Tools Administrator at Celestica, you will play a crucial role in bridging the gap between development operations and business intelligence. Your primary focus will be on generating actionable analytics and managing key ALM (Application Lifecycle Management) tools. Here is a breakdown of your responsibilities:- **Analytics & Reporting**: - Lead the design, development, and maintenance of impactful dashboards and reports using business intelligence platforms like Power BI to offer real-time insights into engineering and operational performance.- **Data Integration & Querying**: - Extract, transform, and load (ETL) operational data into reporting tools, utilizing SQL to perform complex data extraction, manipulation, and integrity checks across various data sources.- **Tools Administration**: - Configure, maintain, and manage user access for ALM or DevOps tools within the organization. - Write and maintain low complexity code/scripts in Python/batch to automate routine administrative tasks, handle tool configurations, and facilitate seamless data integration/cleanup.- **Documentation & Training**: - Develop and update comprehensive documentation for data models, tool configurations, and reporting standards. - Offer necessary training and support to end-users.- **Stakeholder Collaboration**: - Collaborate closely with engineering, project management, and operational teams to comprehend data requirements and deliver effective data-driven reporting solutions.- **Business Intelligence Mastery**: - Showcase hands-on expertise in building robust reports, dashboards, and data models using Power BI or similar platforms, with a focus on data visualization for informed decision-making.- **Scripting/Coding**: - Demonstrate the ability to write and troubleshoot low complexity code for automation, data manipulation, and tool integration.- **Tools Administration Experience**: - Previous experience in managing user permissions, workflows, and configurations in tools like Jira or other enterprise-level platforms.In addition to the responsibilities outlined above, please note that the duties for this position will be carried out in a standard office environment. The role may involve prolonged periods of sitting and concentration on computer screens or detailed data. Occasional travel might be necessary.**Qualifications Required**:- 7 to 10 years of relevant work experience.- Bachelors degree or equivalent combination of education and experience.- Strong analytical and problem-solving skills with a focus on data accuracy, process efficiency, and measurement fidelity.- Proficiency in SQL for querying, joining, and manipulating large datasets.- Experience in designing scalable and efficient data models for BI reporting purposes.- Familiarity with major application security tools like Blackduck or Coverity.Celestica (NYSE, TSX: CLS) is a global leader in design, manufacturing, hardware platform, and supply chain solutions. They provide expertise and insights throughout all stages of product development, from conceptualization to full-scale production and beyond, catering to industries ranging from advanced medical devices to cutting-edge aviation systems and Cloud-based hardware platforms. As a Data Analyst and Tools Administrator at Celestica, you will play a crucial role in bridging the gap between development operations and business intelligence. Your primary focus will be on generating actionable analytics and managing key ALM (Application Lifecycle Management) tools. Here is a breakdown of your responsibilities:- **Analytics & Reporting**: - Lead the design, development, and maintenance of impactful dashboards and reports using business intelligence platforms like Power BI to offer real-time insights into engineering and operational performance.- **Data Integration & Querying**: - Extract, transform, and load (ETL) operational data into reporting tools, utilizing SQL to perform complex data extraction, manipulation, and integrity checks across various data sources.- **Tools Administration**: - Configure, maintain, and manage user access for ALM or DevOps tools within the organization. - Write and maintain low complexity code/scripts in Python/batch to automate routine administrative tasks, handle tool configurations, and facilitate seamless data integration/cleanup.- **Documentation & Training**: - Develop and update comprehensive documentation for data models, tool configurations, and reporting standards. - Offer necessary training and support to end-users.- **Stakeholder Collaboration**: - Collaborate closely with engineering, project management, and operational teams to comprehend data requirements and deliver effective data-driven reporting solutions.- **Business Intelligence Mastery**: - Showcase hands-on expertise in building robust reports, dashboards, and data models using Power BI or similar platforms, with a focus on d

Keyskills :
SQLPythonBashPower BIJiraData ModelingData IntegrationData ManipulationData Visualization