Technical Data Analyst

A Technical Data Analyst bridges the gap between IT and business by extracting, cleaning, and modeling complex datasets . They build automated pipelines, write complex queries, and design performance dashboards to maintain system health and data integrity. Key Responsibilities Data Extraction & Pipeline Management: Write optimized SQL queries and scripts to extract raw data from primary and secondary sources, building efficient data pipelines. [1, 2, 3] Data Cleansing & Validation: Audit data quality, filter erroneous records, review reports to locate code issues, and correct anomalies to ensure high statistical efficiency and accuracy. [1, 2] System & Database Support: Develop, implement, and maintain databases and data collection systems. Assist with software/system upgrades and patches. [1, 2, 3] Analytics & Visualization: Conduct exploratory data analysis to identify trends and patterns. Translate findings into actionable insights, visually attractive charts, dashboards, and automated reports. [1, 2, 3, 4, 5, 6] Stakeholder Collaboration: Bridge technical and non-technical teams by gathering business requirements and translating them into technical solutions. [1, 2, 3] Qualifications & Skills Education: Bachelors degree in Computer Science, Information Technology, Mathematics, Statistics, or a related quantitative field. [1, 2, 3] Experience: 25+ years of hands-on experience in a data analysis or highly technical support role. [1, 2, 3, 4] Technical Proficiencies: Advanced SQL querying. Programming languages such as Python or R . BI tools (e.g., Tableau , Power BI ). Advanced Excel capabilities (pivot tables, complex formulas). [1, 2, 3, 4] Soft Skills: Strong analytical problem-solving, exceptional cross-functional communication, and project management capabilities. [1, 2, 3] If you would like to customize this, tell me: Is this for an entry-level, mid-level, or senior role Do you need to emphasize a specific industry (e.g., finance, healthcare, e-commerce ) What specific tools or tech stack (like AWS, Snowflake, or specific ETL tools) should be added