Overview We are looking for a Data Analyst who has hands-on experience on Database and Data warehouse technologies with hands on experience in Alteryx is preferable. This role requires a blend of Data Analysis experience and Python programming expertise. If you love to solve difficult problems and deliver results; if you like to learn new things and apply innovative, state-of-the-art methodology, join us at BLEND360.
Key Responsibilities
We are looking for a Data Analyst who has hands-on experience on Database and Data warehouse technologies with hands on experience in Alteryx is preferable.
- Developing, implementing, modifying, and providing ongoing management of business systems, processes, databases, software and tools.
- experience in writing SQL queries against any RDBMS with query optimization.
- Ingestion of Epsilon and Altair Installs.
- Ingestion and conversion of GS Epsilon Install.
- Management of all sFTP and file transfer credentials.
- Data Append request execution (Altair and Epsilon)
- Ingestion of Epsilon ZIP-level data, Zip radius look up process.
- Manage and standardize all data practice requests/processes.
- Standard import Scripts for loading data into Snowflake/R/Python.
- Improve Alteryx data append process and match rates.
- Development of derived variables (Model velocity, customer penetration)
- Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool.
- Prepare technical specifications and documentation for Alteryx workflows supporting BI reports.
- Identify, analyze, and interpret trends or patterns in complex data sets. Requirements Required Skills and experience.
- 2 + Years of hand on experience of developing python-based solutions/applications.
- Strong experience of working with Object Oriented programming in Python.
- Strong experience of working with APIs and integrating multiple applications together.
- experience in using Business Intelligence tools such as: Tableau, Power BI for business applications is a plus.
- experience of working with Data Warehousing Technologies like Big Query, Redshift, or snowflake is a plus.
- Strong analytical, problem solving, and troubleshooting abilities.
- Flexibility to adapt to a variety of engagement types, working hours and work environments and locations.