Title: Data Analyst

Location: Des Moines, IA; Sioux Falls, SD; Fargo,ND or Remote

What to expect:

Data analyst responsibilities include conducting full lifecycle data analysis to include requirements, activities and design.

• 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

Qualifications:

• Strong knowledge of Advanced SQL
• Strong knowledge of and experience with databases, programming (XML, Python, Json, Javascript, or ETL frameworks)
• Previous experience in working with Informatica/other ETL environments preferred
• Previous experience working with Cloud Data Warehouse/Data Lake preferred(Eg: Snowflake)
• Understanding of Data projects and Data Design Documents
• Previous experience with creating data mapping document, data requirements, translating business requirements to transformation rules
• Previous experience with Data Modeling and exposure to at least Dimensional and 3NF modeling preferred(Exposure to Data Vault 2.0 an additional advantage).
• Previous experience in an agile analytics environment preferred.
• Proactive, problem solver and self-motivated.

Qualifications:

• College Degree in the field of computer science, information science, management information systems preferred
• Minimum 8 years' IT development experience or equivalent preferred
• Effective verbal and written communications skills and the ability to communicate with business partners and other IT staff
• Problem solving skills sufficient to perform research and recommend a proposed solution to problems
• Able to work on multiple tasks and meet established deadlines
• Able to effectively direct and coordinate the work of other team members on a project without having HR management responsibility for them
• Knowledge of computer programming languages as required for the system
• $78,672 - $163,899 - Range includes data points from multiple labor markets. Specific range is dependent on the labor market where the incumbent will be hired to perform the position. Starting salary is dependent on candidate qualifications and experience. For a narrower salary range specific to your labor market, please inquire.
• Sammons Financial Group offers incentive programs for defined goals subject to eligibility and performance. Monetary rewards are based on individual and/or overall company performance.
• Our competitive benefit package includes: Health, Dental, Vision, Company Paid Retirement, PTO and Holiday Pay.
• Criminal background check required.