GitHub Jobs Company Profile

Data Analytics Engineer

Sobre a fonte

Descrição do trabalho

Data Analytics Engineer (Business Intelligence)This position will play an important role in transforming data into actionable information by enabling deeper understanding and improvement of business processes. In this role, the individual will assist in analyzing and implementing business intelligence architecture for the organization. Additionally, identifying conclusions from business intelligence initiatives, interacting with a variety of stakeholders, and communicating critical requirements will be essential to help Cognate achieve its organizational goals.EDUCATION and EXPERIENCEBachelor's degree in IT, Computer Science, Engineering, Finance or related field.3+ years of experience in data management, data engineering, visualization, and/or data warehousingDATA MANAGEMENT AND ANALYTICSExperience with data management and analysis. Skilled in dashboard design and development. Experience in Excel is required. Proficiency in Power BI / Tableau and database technologies such as SQL Server is required. Hands-on experience building, maintaining, and supporting business intelligence data backends, specifically data warehouses.Experience with enterprise (Azure, AWS, etc.) or open-source (Apache Spark, Delta Lake, etc.) cloud services preferred.Specific skills consistent with Microsoft technical architecture preferred, including Microsoft BI stack (SSIS, SSAS, SSRS, Power BI, Azure Data Factory)Ability to write and develop SQL queries requiredProficiency with DAX measures in Power BIData integration, ETL, or ELT experience requiredPython programming experience preferredIdeal candidate possesses strong business acumen, project management, and organizational skillsOTHER SKILLS AND REASONING ABILITYAdvanced skills in Office 365 products, especially Power Platform.Experience leveraging data to drive decisions in professional or extracurricular endeavors.Comfortable working independently and collaboratively.Proven (GitHub, Kaggle, etc.) ability to automate tasks or provide solutions that require a proficiency in programming.Ability to understand and use REST APIsAbility to comprehend, analyze, and interpret complex data sets.Ability to solve problems involving several options and forecast multiple outcomes.Advanced analytical and quantitative aptitude.ESSENTIAL DUTIES AND RESPONSIBILITESDevelops a deep familiarity with a variety of data sources including transactional databases, data warehouses, internal tools, and external integrations.Collaborate in the deployment of reporting and dashboard solutionsParticipate in design, development, and analysis of data architecture and warehousing approachesUse effective data visualization techniques to communicate information clearly and efficientlyWork to ensure the quality, accuracy, and integrity of dataBuild, implement, support BI solutionsTest, monitor, manage, and validate BI activity including data extraction, transformation, movement, loading, cleansing, and updating processesDevelop BI databasesDemonstrate knowledge of enterprise source systems and database schemasBuild and maintain tabular modelsDevelop measures for aggregate analysis of production metricsPerform varying methods of data analysisParticipate in the development of consistent data definitions and useCreation of data / process flow documentationParticipate in developing and upholding data management and governance strategiesDemonstrates a self-directed approach to departmental responsibilitiesDemonstrates the ability to deal with pressure to meet deadlines, to be accurate, and to handle constantly changing situations.Accepts additional projects and responsibilities as assignedDemonstrates capacity to deal with a variety of people and engage others in a cooperative and collaborative workspaceCommitment to continuous education and exposure to modern tools and techniquesContribute project deliverables to business intelligence projects internal groups.Review project deliverables including Power BI dashboards, formal reports, PowerPoint briefings, etc.Assist presentations (both in-person or virtually) of project progress meetings and presentations of results.Problem solve technical issues and answer internal stakeholder questions. Escalate issues to supervisor and dedicated technical resources as needed.Rigorous review and improvement of project processes.Provide subject matter expertise on data-related processes and analyses.Create, maintain and optimize creative data visualizations and dashboards (primarily in Power BI) to derive actionable intelligence.Aggregation and analysis of quantitative data; forecast and trending of performance data.Develop and refine cost models for licensing requirements of the organization “Cognate BioServices provides equal employment opportunities to all employees and qualified applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.”