Job Description
Insight Global is looking to directly hire a Data Analyst in a permanent, remote role to join a large, growing financial company located in West Des Moines, IA. This person will be working closely with an Enterprise IT Data Operations team who supports the Enterprise-wide Data Analytics, Data Security, Data Modeling, and Data Warehousing of a large financial services provider. Data Analyst responsibilities on these team include conducting full lifecycle data analysis to include requirements, activities, and design. Applicants should have strong interpersonal skills and proven ability to work and communicate with a variety of personalities, across locations and varying organizational levels. Data Analysts will research, analyze, and resolve problems using strong judgment and high-level decision-making skills. Additional job responsibilities and expectations include: Complete data profiling and define data transformations for use by the ETL Developers Acquire data from primary or secondary data sources and maintain databases/data systems Identify, analyze, and interpret trends or patterns in complex data sets Locate and define new process improvement opportunities Lead offshore team members
Required Skills & Experience
* 8+ yrs experience in IT development
* Strong knowledge of Advanced SQL and ability to create strong SQL queries
* Experience with databases, programming (XML, Json, Javascript, or ETL frameworks)
* Understanding of Data projects and Data Design Documents
* Previous experience creating data mapping document, data requirements, translating business requirements to transformation rules
* Experience working with Data Lake (Eg: Snowflake)
* Strong Microsoft Excel skills and familiarity with other Microsoft tools such as Word and Access
* Proactive, problem solver and self-motivated.
Nice to Have Skills & Experience
* Proven experience with test automation tools
* Experience using Python
* Experience in an Agile environment
* Hands on exposure to Informatica or other ETL environments
* Cloud Data Warehouse
* Previous experience with Data Modeling and exposure to at least Dimensional and 3NF modeling preferred (Exposure to Data Vault 2.0 an additional advantage)
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.